public void CanCreateTableWithIdentity() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); var sql = generator.Generate(expression); sql.ShouldBe( "CREATE TABLE [TestTable1] ([TestColumn1] INT NOT NULL IDENTITY(1,1), [TestColumn2] INT NOT NULL)"); }
public override void CanCreateTableWithIdentityWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 NUMBER(10,0) GENERATED ALWAYS AS IDENTITY , TestColumn2 NUMBER(10,0) NOT NULL)"); }
public override void CanCreateTableWithIdentityWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); expression.SchemaName = "TestSchema"; Assert.Throws <DatabaseOperationNotSupportedException>(() => Generator.Generate(expression)); }
public override void CanCreateTableWithIdentityWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE COLUMN TABLE \"TestTable1\" (\"TestColumn1\" INTEGER GENERATED ALWAYS AS IDENTITY, \"TestColumn2\" INTEGER);"); }
public override void CanCreateTableWithIdentityWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"public\".\"TestTable1\" (\"TestColumn1\" serial NOT NULL, \"TestColumn2\" integer NOT NULL);"); }
public override void CanCreateTableWithIdentityWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE `TestTable1` (`TestColumn1` INTEGER NOT NULL AUTO_INCREMENT, `TestColumn2` INTEGER NOT NULL) ENGINE = INNODB"); }
public override void CanCreateTableWithIdentityWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE [TestTable1] ([TestColumn1] COUNTER NOT NULL, [TestColumn2] INTEGER NOT NULL)"); }
public override void CanCreateTableWithIdentityWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE [TestTable1] ([TestColumn1] INT NOT NULL IDENTITY(1,1), [TestColumn2] INT NOT NULL)"); }
public void CanCreateAutoIncrementColumnForInt64() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); expression.Columns[0].Type = DbType.Int64; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 BIGINT NOT NULL AS IDENTITY, TestColumn2 INTEGER NOT NULL)"); }
public void CanCreateAutoIncrementColumnForInt64() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); expression.Columns[0].Type = DbType.Int64; var result = Generator.Generate(expression); result.ShouldBe("CREATE COLUMN TABLE \"TestTable1\" (\"TestColumn1\" BIGINT GENERATED ALWAYS AS IDENTITY, \"TestColumn2\" INTEGER);"); }
public void CanCreateAutoIncrementColumnForInt64() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); expression.Columns[0].Type = DbType.Int64; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"public\".\"TestTable1\" (\"TestColumn1\" bigserial NOT NULL, \"TestColumn2\" integer NOT NULL);"); }
public override void CanCreateTableWithIdentityWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE [TestSchema].[TestTable1] ([TestColumn1] INTEGER NOT NULL DEFAULT AUTOINCREMENT, [TestColumn2] INTEGER NOT NULL)"); }
public override void CanCreateTableWithIdentityWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); expression.SchemaName = "TestSchema"; var result = _generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestSchema\".\"TestTable1\" (\"TestColumn1\" integer NOT NULL, \"TestColumn2\" integer NOT NULL);"); }
public override void CanCreateTableWithIdentityWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestSchema.TestTable1 (TestColumn1 INTEGER NOT NULL AS IDENTITY, TestColumn2 INTEGER NOT NULL)"); }
public override void CanCreateTableWithIdentity() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); //Have to force it to primary key for SQLite expression.Columns[0].IsPrimaryKey = true; var sql = generator.Generate(expression); sql.ShouldBe("CREATE TABLE 'TestTable1' ('TestColumn1' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'TestColumn2' INTEGER NOT NULL)"); }
public void CanCreateTableWithSeededIdentityWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); expression.Columns[0].AdditionalFeatures.Add(SqlServerExtensions.IdentitySeed, 45); expression.Columns[0].AdditionalFeatures.Add(SqlServerExtensions.IdentityIncrement, 23); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE [dbo].[TestTable1] ([TestColumn1] INT NOT NULL IDENTITY(45,23), [TestColumn2] INT NOT NULL)"); }
public override void CanCreateTableWithIdentityWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); //Have to force it to primary key for SQLite expression.Columns[0].IsPrimaryKey = true; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, \"TestColumn2\" INTEGER NOT NULL)"); }
public void CanNotCreateTableWithSeededIdentityAndStrictCompatibility() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); expression.Columns[0].IsPrimaryKey = true; expression.Columns[0].AdditionalFeatures.Add(SqlServerExtensions.IdentitySeed, 3); expression.Columns[0].AdditionalFeatures.Add(SqlServerExtensions.IdentityIncrement, 3); Generator.compatabilityMode = CompatabilityMode.STRICT; Assert.Throws <DatabaseOperationNotSupportedException>(() => Generator.Generate(expression)); }
public override void CanCreateTableWithIdentityWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE COLUMN TABLE \"TestSchema\".\"TestTable1\" (\"TestColumn1\" serial NOT NULL, \"TestColumn2\" integer NOT NULL)"); }
public void CanCreateTableWithSeededIdentityAndLooseCompatibility() { var expression = GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression(); expression.Columns[0].IsPrimaryKey = true; expression.Columns[0].AdditionalFeatures.Add(SqlServerExtensions.IdentitySeed, 3); expression.Columns[0].AdditionalFeatures.Add(SqlServerExtensions.IdentityIncrement, 3); _generator.compatabilityMode = CompatabilityMode.LOOSE; var sql = _generator.Generate(expression); sql.ShouldBe("CREATE TABLE 'TestTable1' ('TestColumn1' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'TestColumn2' INTEGER NOT NULL)"); }
public override void CanCreateTableWithIdentityWithDefaultSchema() { Assert.Throws <DatabaseOperationNotSupportedException>(() => Generator.Generate(GeneratorTestHelper.GetCreateTableWithAutoIncrementExpression())); }