public static void MultiSet() { var statement = new InsertStatement(ObjectName.Parse("t1"), new[] { "first_name", "last_name", "age" }, new[] { new SqlExpression[] { SqlExpression.Constant("Antonello"), SqlExpression.Constant("Provenzano"), SqlExpression.Constant(34) }, new SqlExpression[] { SqlExpression.Constant("Sebastiano"), SqlExpression.Constant("Provenzano"), SqlExpression.Constant(33) }, }); var sql = statement.ToString(); var expected = new StringBuilder(); expected.AppendLine("INSERT INTO t1(first_name, last_name, age)"); expected.AppendLine(" VALUES"); expected.AppendLine(" ('Antonello', 'Provenzano', 34),"); expected.Append(" ('Sebastiano', 'Provenzano', 33)"); Assert.AreEqual(expected.ToString(), sql); }
public void InsertTwoValues() { var tableName = ObjectName.Parse("APP.test_table"); var columns = new [] { "first_name", "last_name", "active"}; var values = new List<SqlExpression[]> { new[] { SqlExpression.Constant("Antonello"), SqlExpression.Constant("Provenzano"), SqlExpression.Constant(true) }, new [] { SqlExpression.Constant("Mart"), SqlExpression.Constant("Roosmaa"), SqlExpression.Constant(false) } }; var statement = new InsertStatement(tableName, columns, values); Query.ExecuteStatement(statement); var table = Query.GetTable(tableName); Assert.IsNotNull(table); Assert.AreEqual(2, table.RowCount); }
public void InsertTwoValues() { var tableName = ObjectName.Parse("APP.test_table"); var columns = new [] { "first_name", "last_name", "active" }; var values = new List <SqlExpression[]> { new[] { SqlExpression.Constant("Antonello"), SqlExpression.Constant("Provenzano"), SqlExpression.Constant(true) }, new [] { SqlExpression.Constant("Mart"), SqlExpression.Constant("Roosmaa"), SqlExpression.Constant(false) } }; var statement = new InsertStatement(tableName, columns, values); Query.ExecuteStatement(statement); var table = Query.GetTable(tableName); Assert.IsNotNull(table); Assert.AreEqual(2, table.RowCount); }
public static void WithNoColumns() { var statement = new InsertStatement(ObjectName.Parse("t1"), new[] { new SqlExpression[] { SqlExpression.Constant("Antonello"), SqlExpression.Constant("Provenzano"), SqlExpression.Constant(34) }, }); var sql = statement.ToString(); var expected = new StringBuilder(); expected.Append("INSERT INTO t1 "); expected.Append("VALUES ('Antonello', 'Provenzano', 34)"); Assert.AreEqual(expected.ToString(), sql); }
protected virtual SqlStatement VisitInsert(InsertStatement statement) { return new InsertStatement(statement.TableName, statement.ColumnNames, statement.Values); }
public void InsertWithColumns() { var columnNames = new string[] {"id", "text"}; var values = new SqlExpression[][] { new SqlExpression[] { SqlExpression.Constant(22), SqlExpression.Constant("test"), }, }; var tableName = ObjectName.Parse("APP.test_table"); var statement = new InsertStatement(tableName, columnNames, values); SerializeAndAssert(statement, (serialized, deserialized) => { Assert.IsNotNull(deserialized); Assert.IsNotNull(deserialized.TableName); Assert.IsNotNull(deserialized.ColumnNames); Assert.IsNotEmpty(deserialized.ColumnNames); Assert.IsNotNull(deserialized.Values); Assert.IsNotEmpty(deserialized.Values); }); }
protected virtual SqlStatement VisitInsert(InsertStatement statement) { return(new InsertStatement(statement.TableName, statement.ColumnNames, statement.Values)); }