private void InsertTestData(string testName, IQuery query)
{
var tableName = ObjectName.Parse("APP.test_table");
var table = query.Access().GetMutableTable(tableName);
var row = table.NewRow();
row.SetValue("first_name", Field.String("Antonello"));
row.SetValue("last_name", Field.String("Provenzano"));
row.SetValue("birth_date", Field.Date(new SqlDateTime(1980, 06, 04)));
row.SetValue("active", Field.BooleanTrue);
if (testName.EndsWith("WithLob"))
row.SetValue("bio", Field.Clob(CreateClobData(query)));
row.SetDefault(query);
table.AddRow(row);
row = table.NewRow();
row.SetValue("first_name", Field.String("Sebastiano"));
row.SetValue("last_name", Field.String("Provenzano"));
row.SetValue("birth_date", Field.Date(new SqlDateTime(1981, 08, 26)));
row.SetValue("active", Field.BooleanFalse);
row.SetDefault(query);
table.AddRow(row);
if (testName.EndsWith("Violation") ||
testName.EndsWith("ConstraintCheck")) {
table = query.Access().GetMutableTable(ObjectName.Parse("APP.test_table2"));
row = table.NewRow();
row.SetValue("person_id", Field.Integer(2));
row.SetValue("dept_no", Field.Integer(45));
row.SetDefault(query);
table.AddRow(row);
}
}