public override void CanCreateSequenceWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateSequenceExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE SEQUENCE [dbo].[Sequence] INCREMENT BY 2 MINVALUE 0 MAXVALUE 100 START WITH 2 CACHE 10 CYCLE"); }
public override void CanCreateSequenceWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateSequenceExpression(); var result = _generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateSequenceWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateSequenceExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE SEQUENCE \"Sequence\""); }
public void CanCreateSequenceWithNocache() { var expression = GeneratorTestHelper.GetCreateSequenceExpression(); expression.Sequence.Cache = null; var result = Generator.Generate(expression); result.ShouldBe("CREATE SEQUENCE [dbo].[Sequence] INCREMENT BY 2 MINVALUE 0 MAXVALUE 100 START WITH 2 NO CACHE CYCLE"); }
public override void CanCreateSequenceWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateSequenceExpression(); expression.Sequence.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE SEQUENCE \"TestSchema\".\"Sequence\" INCREMENT BY 2 MINVALUE 0 MAXVALUE 100 START WITH 2 CACHE 10 CYCLE;"); }
public override void CanCreateSequenceWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateSequenceExpression(); expression.Sequence.SchemaName = "TestSchema"; var result = _generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateSequenceWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateSequenceExpression(); expression.Sequence.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE SEQUENCE \"Sequence\""); }
public void CanNotCreateSequenceWithCacheOne() { var expression = GeneratorTestHelper.GetCreateSequenceExpression(); expression.Sequence.Cache = 1; Should.Throw <DatabaseOperationNotSupportedException>( () => Generator.Generate(expression), "Cache size must be greater than 1; if you intended to disable caching, set Cache to null." ); }
public void CanNotCreateSequenceWithCacheOneSchema() { var expression = GeneratorTestHelper.GetCreateSequenceExpression(); expression.Sequence.Cache = 1; Should.Throw <DatabaseOperationNotSupportedException>( () => Generator.Generate(expression), "Oracle does not support Cache value equal to 1; if you intended to disable caching, set Cache to null. For information on Oracle limitations, see: https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/CREATE-SEQUENCE.html#GUID-E9C78A8C-615A-4757-B2A8-5E6EFB130571__GUID-7E390BE1-2F6C-4E5A-9D5C-5A2567D636FB" ); }
public override void CanCreateSequenceWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateSequenceExpression(); expression.Sequence.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE SEQUENCE \"TestSchema\".\"Sequence\" INCREMENT 2 MINVALUE 0 MAXVALUE 100 START WITH 2 CACHE 10 CYCLE"); }