Exemplos de Deveel.Data.Sql.Statements CreateSequenceStatement.Execute em C# (CSharp)

Exemplo n.º 1

        public void CreateWithDefaultValues()
        {
            var seqName   = ObjectName.Parse("APP.test_seq1");
            var statement = new CreateSequenceStatement(seqName);

            statement.Execute(Query);

            var exists = Query.ObjectExists(DbObjectType.Sequence, seqName);

            Assert.IsTrue(exists);
        }

Exemplo n.º 2

Arquivo: CreateSequenceStatementTests.cs Projeto: ArsenShnurkov/deveeldb

        public void CreateWithDefaultValues()
        {
            var seqName = ObjectName.Parse("APP.test_seq1");
            var statement = new CreateSequenceStatement(seqName);

            statement.Execute(Query);

            var exists = Query.ObjectExists(DbObjectType.Sequence, seqName);

            Assert.IsTrue(exists);
        }

Exemplo n.º 3

Arquivo: CreateSequenceStatementTests.cs Projeto: ArsenShnurkov/deveeldb

        public void CreateWithStartValue()
        {
            var seqName = ObjectName.Parse("APP.test_seq1");
            var statement = new CreateSequenceStatement(seqName) {
                StartWith = SqlExpression.Constant(2)
            };

            statement.Execute(Query);

            var exists = Query.ObjectExists(DbObjectType.Sequence, seqName);

            Assert.IsTrue(exists);
        }

Exemplo n.º 4

        public void CreateWithStartValue()
        {
            var seqName   = ObjectName.Parse("APP.test_seq1");
            var statement = new CreateSequenceStatement(seqName)
            {
                StartWith = SqlExpression.Constant(2)
            };

            statement.Execute(Query);

            var exists = Query.ObjectExists(DbObjectType.Sequence, seqName);

            Assert.IsTrue(exists);
        }