Deveel.Data.DeleteTests.InsertTestData C# (CSharp) Method

        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);
            }
        }