public override void CanCreateTableWithNullableFieldWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNullableColumn(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" NVARCHAR2(255), \"TestColumn2\" NUMBER(10,0) NOT NULL)"); }
public override void CanCreateTableWithNullableFieldWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNullableColumn(); var result = _generator.Generate(expression); result.ShouldBe("CREATE TABLE \"public\".\"TestTable1\" (\"TestColumn1\" text, \"TestColumn2\" integer NOT NULL);"); }
public override void CanCreateTableWithNullableFieldWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNullableColumn(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 VARCHAR(255), TestColumn2 INTEGER NOT NULL)"); }
public override void CanCreateTableWithNullableFieldWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNullableColumn(); var result = Generator.Generate(expression); result.ShouldBe("CREATE COLUMN TABLE \"TestTable1\" (\"TestColumn1\" NVARCHAR(255) NULL, \"TestColumn2\" INTEGER);"); }
public override void CanCreateTableWithNullableFieldWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNullableColumn(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" BLOB SUB_TYPE TEXT, \"TestColumn2\" INTEGER NOT NULL)"); }
public override void CanCreateTableWithNullableField() { var expression = GeneratorTestHelper.GetCreateTableWithNullableColumn(); var result = _generator.Generate(expression); result.ShouldBe( "CREATE TABLE TestTable1 (TestColumn1 NVARCHAR2(255), TestColumn2 NUMBER(10,0) NOT NULL)"); }
public override void CanCreateTableWithNullableField() { var expression = GeneratorTestHelper.GetCreateTableWithNullableColumn(); var result = _generator.Generate(expression); result.ShouldBe( "CREATE TABLE [TestTable1] ([TestColumn1] VARCHAR(255), [TestColumn2] INTEGER NOT NULL)"); }
public override void CanCreateTableWithNullableField() { var expression = GeneratorTestHelper.GetCreateTableWithNullableColumn(); var result = _generator.Generate(expression); result.ShouldBe( "CREATE TABLE 'TestTable1' ('TestColumn1' TEXT, 'TestColumn2' INTEGER NOT NULL)"); }
public override void CanCreateTableWithNullableFieldWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNullableColumn(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" TEXT, \"TestColumn2\" INTEGER NOT NULL)"); }
public override void CanCreateTableWithNullableFieldWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNullableColumn(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestSchema.TestTable1 (TestColumn1 DBCLOB(1048576) CCSID 1200, TestColumn2 INTEGER NOT NULL)"); }
public override void CanCreateTableWithNullableFieldWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateTableWithNullableColumn(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE COLUMN TABLE \"TestSchema\".\"TestTable1\" (\"TestColumn1\" text, \"TestColumn2\" integer NOT NULL)"); }