C# (CSharp) Deveel.Data.Sql.Statements InsertSelectStatement Examples

Example #1

File: InsertSelectStatementTests.cs Project: ArsenShnurkov/deveeldb

        public void WithNoColumns()
        {
            var tableName = ObjectName.Parse("APP.test_table");
            var query = (SqlQueryExpression)SqlExpression.Parse("SELECT 3, 'Antonello', 'Provenzano', NULL, NULL");

            var statement = new InsertSelectStatement(tableName, query);

            Query.ExecuteStatement(statement);

            var table = Query.GetTable(tableName);

            Assert.AreEqual(1, table.RowCount);
        }

Example #2

        public void WithNoColumns()
        {
            var tableName = ObjectName.Parse("APP.test_table");
            var query     = (SqlQueryExpression)SqlExpression.Parse("SELECT 3, 'Antonello', 'Provenzano', NULL, NULL");

            var statement = new InsertSelectStatement(tableName, query);

            Query.ExecuteStatement(statement);

            var table = Query.GetTable(tableName);

            Assert.AreEqual(1, table.RowCount);
        }

Example #3

File: InsertSelectStatementTests.cs Project: ArsenShnurkov/deveeldb

        public void WithColumns()
        {
            var tableName = ObjectName.Parse("APP.test_table");
            var query = (SqlQueryExpression) SqlExpression.Parse("SELECT 'Antonello', 'Provenzano', NULL, NULL");
            var columns = new[] {"first_name", "last_name", "birth_date", "active"};

            var statement = new InsertSelectStatement(tableName, columns, query);

            Query.ExecuteStatement(statement);

            var table = Query.GetTable(tableName);

            Assert.AreEqual(1, table.RowCount);
        }

Example #4

        public void WithColumns()
        {
            var tableName = ObjectName.Parse("APP.test_table");
            var query     = (SqlQueryExpression)SqlExpression.Parse("SELECT 'Antonello', 'Provenzano', NULL, NULL");
            var columns   = new[] { "first_name", "last_name", "birth_date", "active" };

            var statement = new InsertSelectStatement(tableName, columns, query);

            Query.ExecuteStatement(statement);

            var table = Query.GetTable(tableName);

            Assert.AreEqual(1, table.RowCount);
        }

Example #5

 protected override SqlStatement VisitInsertSelect(InsertSelectStatement statement)
 {
     return(base.VisitInsertSelect(statement));
 }

Example #6

File: StatementVisitor.cs Project: deveel/deveeldb

 protected virtual SqlStatement VisitInsertSelect(InsertSelectStatement statement)
 {
     return new InsertSelectStatement(statement.TableName, statement.ColumnNames, statement.QueryExpression);
 }

Example #7

File: StringFormatterVisitor.cs Project: deveel/deveeldb

 protected override SqlStatement VisitInsertSelect(InsertSelectStatement statement)
 {
     return base.VisitInsertSelect(statement);
 }

Example #8

 protected virtual SqlStatement VisitInsertSelect(InsertSelectStatement statement)
 {
     return(new InsertSelectStatement(statement.TableName, statement.ColumnNames, statement.QueryExpression));
 }