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); }
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); }
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); }
protected override SqlStatement VisitInsertSelect(InsertSelectStatement statement) { return(base.VisitInsertSelect(statement)); }
protected virtual SqlStatement VisitInsertSelect(InsertSelectStatement statement) { return new InsertSelectStatement(statement.TableName, statement.ColumnNames, statement.QueryExpression); }
protected override SqlStatement VisitInsertSelect(InsertSelectStatement statement) { return base.VisitInsertSelect(statement); }
protected virtual SqlStatement VisitInsertSelect(InsertSelectStatement statement) { return(new InsertSelectStatement(statement.TableName, statement.ColumnNames, statement.QueryExpression)); }