public override void CanCreateTable() { var expression = GeneratorTestHelper.GetCreateTableExpression(); string sql = _generator.Generate(expression); sql.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 NVARCHAR2(255) NOT NULL, TestColumn2 NUMBER(10,0) NOT NULL)"); }
public override void CanCreateTable() { var expression = GeneratorTestHelper.GetCreateTableExpression(); var sql = generator.Generate(expression); sql.ShouldBe("CREATE TABLE [TestTable1] ([TestColumn1] NVARCHAR(255) NOT NULL, [TestColumn2] INT NOT NULL)"); }
public override void CanCreateTableWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" NVARCHAR2(255) NOT NULL, \"TestColumn2\" NUMBER(10,0) NOT NULL)"); }
public override void CanCreateTable() { var expression = GeneratorTestHelper.GetCreateTableExpression(); string sql = generator.Generate(expression); sql.ShouldBe("CREATE TABLE 'TestTable1' ('TestColumn1' TEXT NOT NULL, 'TestColumn2' INTEGER NOT NULL)"); }
public override void CanCreateTable() { var expression = GeneratorTestHelper.GetCreateTableExpression(); var sql = generator.Generate(expression); sql.ShouldBe("CREATE TABLE `TestTable1` (`TestColumn1` VARCHAR(255) NOT NULL, `TestColumn2` INTEGER NOT NULL) ENGINE = INNODB"); }
public void CanCreateTableWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE `TestTable1` (`TestColumn1` NVARCHAR(255) NOT NULL, `TestColumn2` INTEGER NOT NULL) ENGINE = INNODB"); }
public override void CanCreateTableWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" BLOB SUB_TYPE TEXT NOT NULL, \"TestColumn2\" INTEGER NOT NULL)"); }
public override void CanCreateTableWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE [TestTable1] ([TestColumn1] NVARCHAR(255) NOT NULL, [TestColumn2] INT NOT NULL)"); }
public override void CanCreateTableWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 DBCLOB(1048576) CCSID 1200 NOT NULL, TestColumn2 INTEGER NOT NULL)"); }
public override void CanCreateTableWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); var result = _generator.Generate(expression); result.ShouldBe("CREATE TABLE \"public\".\"TestTable1\" (\"TestColumn1\" text NOT NULL, \"TestColumn2\" integer NOT NULL);"); }
public void CanCreateTableWithoutAnyDescriptions() { var expression = GeneratorTestHelper.GetCreateTableExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 NVARCHAR2(255) NOT NULL, TestColumn2 NUMBER(10,0) NOT NULL)"); }
public override void CanCreateTableWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE COLUMN TABLE \"TestTable1\" (\"TestColumn1\" NVARCHAR(255), \"TestColumn2\" INTEGER);"); }
public void CanCreateTableWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.SchemaName = "TestSchema"; var sql = generator.Generate(expression); sql.ShouldBe("CREATE TABLE [TestSchema].[TestTable1] ([TestColumn1] NVARCHAR(255) NOT NULL, [TestColumn2] INT NOT NULL)"); }
public override void CanCreateTableWithDefaultValueExplicitlySetToNullWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].DefaultValue = null; expression.Columns[0].TableName = expression.TableName; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" NVARCHAR2(255) DEFAULT NULL NOT NULL, \"TestColumn2\" NUMBER(10,0) NOT NULL)"); }
public void CanCreateTableWithBoolDefaultValue() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].DefaultValue = true; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"public\".\"TestTable1\" (\"TestColumn1\" text NOT NULL DEFAULT true, \"TestColumn2\" integer NOT NULL);"); }
public override void CanCreateTableWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestSchema.TestTable1 (TestColumn1 NVARCHAR2(255) NOT NULL, TestColumn2 NUMBER(10,0) NOT NULL)"); }
public override void CanCreateTableWithDefaultValue() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].DefaultValue = "abc"; string sql = _generator.Generate(expression); // Oracle requires the DEFAULT clause to appear before the NOT NULL clause sql.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 NVARCHAR2(255) DEFAULT 'abc' NOT NULL, TestColumn2 NUMBER(10,0) NOT NULL)"); }
public void CanCreateTableWithNvarcharMax() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].Type = DbType.String; expression.Columns[0].Size = Int32.MaxValue; var sql = generator.Generate(expression); sql.ShouldBe("CREATE TABLE [TestTable1] ([TestColumn1] NTEXT NOT NULL, [TestColumn2] INT NOT NULL)"); }
public void CanCreateTableWithBlobColumnWithObjectType() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].Type = DbType.Object; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"public\".\"TestTable1\" (\"TestColumn1\" json NOT NULL, \"TestColumn2\" integer NOT NULL);"); }
public override void CanCreateTableWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" TEXT NOT NULL, \"TestColumn2\" INTEGER NOT NULL)"); }
public void CanCreateTableWithBlobColumnWithObjectType() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].Type = DbType.Object; var result = Generator.Generate(expression); result.ShouldBe("CREATE COLUMN TABLE \"TestTable1\" (\"TestColumn1\" BLOB, \"TestColumn2\" INTEGER);"); }
public override void CanCreateTableWithNullableFieldWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].IsNullable = true; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE [dbo].[TestTable1] ([TestColumn1] NVARCHAR(255) NULL, [TestColumn2] INTEGER NOT NULL)"); }
public override void CanCreateTableWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE `TestTable1` (`TestColumn1` VARCHAR(255) NOT NULL, `TestColumn2` INTEGER NOT NULL) ENGINE = INNODB"); }
public override void CanCreateTableWithNullableFieldWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].IsNullable = true; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE `TestTable1` (`TestColumn1` VARCHAR(255), `TestColumn2` INTEGER NOT NULL) ENGINE = INNODB"); }
public void CanCreateTableWithBoolDefaultValue() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].DefaultValue = true; var result = Generator.Generate(expression); result.ShouldBe("CREATE COLUMN TABLE \"TestTable1\" (\"TestColumn1\" NVARCHAR(255) DEFAULT 1, \"TestColumn2\" INTEGER);"); }
public override void CanCreateTableWithCustomColumnTypeWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].IsPrimaryKey = true; expression.Columns[1].Type = null; expression.Columns[1].CustomType = "BINARY_DOUBLE"; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" NVARCHAR2(255) NOT NULL, \"TestColumn2\" BINARY_DOUBLE NOT NULL, PRIMARY KEY (\"TestColumn1\"))"); }
public override void CanCreateTableWithNullableField() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].IsNullable = true; var sql = generator.Generate(expression); sql.ShouldBe( "CREATE TABLE [TestTable1] ([TestColumn1] NVARCHAR(255), [TestColumn2] INT NOT NULL)"); }
public void CanCreateTableWithBoolDefaultValue() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].Type = DbType.Boolean; expression.Columns[0].DefaultValue = 'T'; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 CHAR(1) NOT NULL DEFAULT 'T', TestColumn2 INTEGER NOT NULL)"); }
public void CanCreateTableWithBinaryColumnWithSize() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].Type = DbType.Binary; expression.Columns[0].Size = 10000; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 VARBINARY(10000) NOT NULL, TestColumn2 INTEGER NOT NULL)"); }
public override void CanCreateTableWithDefaultValueExplicitlySetToNull() { var expression = GeneratorTestHelper.GetCreateTableExpression(); expression.Columns[0].DefaultValue = null; expression.Columns[0].TableName = expression.TableName; var sql = generator.Generate(expression); sql.ShouldBe( "CREATE TABLE [TestTable1] ([TestColumn1] NVARCHAR(255) NOT NULL CONSTRAINT DF_TestTable1_TestColumn1 DEFAULT NULL, [TestColumn2] INT NOT NULL)"); }