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");
}
