public override void CanCreateTableNamedPrimaryKey() { var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); string sql = _generator.Generate(expression); sql.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 NVARCHAR2(255) NOT NULL, TestColumn2 NUMBER(10,0) NOT NULL, CONSTRAINT TestKey PRIMARY KEY (TestColumn1))"); }
public override void CanCreateTableNamedPrimaryKey() { var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); string sql = generator.Generate(expression); sql.ShouldBe("CREATE TABLE [TestTable1] ([TestColumn1] NVARCHAR(255) NOT NULL, [TestColumn2] INT NOT NULL, CONSTRAINT [TestKey] PRIMARY KEY ([TestColumn1]))"); }
public override void CanCreateTableWithNamedPrimaryKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" NVARCHAR2(255) NOT NULL, \"TestColumn2\" NUMBER(10,0) NOT NULL, CONSTRAINT \"TestKey\" PRIMARY KEY (\"TestColumn1\"))"); }
public override void CanCreateTableWithNamedPrimaryKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE `TestTable1` (`TestColumn1` VARCHAR(255) NOT NULL, `TestColumn2` INTEGER NOT NULL, CONSTRAINT `TestKey` PRIMARY KEY (`TestColumn1`)) ENGINE = INNODB"); }
public override void CanCreateTableNamedPrimaryKey() { //Should work. I think from the docs var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); string sql = generator.Generate(expression); sql.ShouldBe("CREATE TABLE 'TestTable1' ('TestColumn1' TEXT NOT NULL, 'TestColumn2' INTEGER NOT NULL, CONSTRAINT 'TestKey' PRIMARY KEY ('TestColumn1'))"); }
public override void CanCreateTableWithNamedPrimaryKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); var result = _generator.Generate(expression); result.ShouldBe("CREATE TABLE \"public\".\"TestTable1\" (\"TestColumn1\" text NOT NULL, \"TestColumn2\" integer NOT NULL, CONSTRAINT \"TestKey\" PRIMARY KEY (\"TestColumn1\"));"); }
public override void CanCreateTableWithNamedPrimaryKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE [dbo].[TestTable1] ([TestColumn1] NVARCHAR(255) NOT NULL, [TestColumn2] INTEGER NOT NULL, CONSTRAINT [TestKey] PRIMARY KEY ([TestColumn1]))"); }
public override void CanCreateTableWithNamedPrimaryKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 DBCLOB(1048576) CCSID 1200 NOT NULL, TestColumn2 INTEGER NOT NULL, CONSTRAINT TestKey PRIMARY KEY (TestColumn1))"); }
public override void CanCreateTableNamedPrimaryKey() { var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); string sql = _generator.Generate(expression); sql.ShouldBe("CREATE TABLE `TestTable1` (`TestColumn1` VARCHAR(255) NOT NULL, `TestColumn2` INTEGER NOT NULL, CONSTRAINT `TestKey` PRIMARY KEY (`TestColumn1`)) ENGINE = INNODB;"); }
public override void CanCreateTableWithNamedPrimaryKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE \"TestTable1\" (\"TestColumn1\" BLOB SUB_TYPE TEXT NOT NULL, \"TestColumn2\" INTEGER NOT NULL, CONSTRAINT \"TestKey\" PRIMARY KEY (\"TestColumn1\"))"); }
public override void CanCreateTableWithNamedPrimaryKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE COLUMN TABLE \"TestTable1\" (\"TestColumn1\" NVARCHAR(255), \"TestColumn2\" INTEGER, PRIMARY KEY (\"TestColumn1\"));"); // HANA doesn't support a contraint name for a primary key }
public override void CanCreateTableWithNamedPrimaryKeyWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE TABLE TestTable1 (TestColumn1 VARCHAR(255) NOT NULL, TestColumn2 INTEGER NOT NULL, CONSTRAINT TestKey PRIMARY KEY (TestColumn1))"); }
public override void CanCreateTableWithNamedPrimaryKeyWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateTableWithNamedPrimaryKeyExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE COLUMN TABLE \"TestSchema\".\"TestTable1\" (\"TestColumn1\" text NOT NULL, \"TestColumn2\" integer NOT NULL, CONSTRAINT \"TestKey\" PRIMARY KEY (\"TestColumn1\"))"); }