Deveel.Data.UpdateTests.AddTestData C# (CSharp) Method

AddTestData() private static method

private static AddTestData ( string testName, IQuery context ) : void
testName string
context IQuery
return void
        private static void AddTestData(string testName, IQuery context)
        {
            var table = context.Access().GetMutableTable(ObjectName.Parse("APP.test_table"));
            var row = table.NewRow();
            row.SetValue("id", Field.Integer(0));
            row.SetValue("first_name", Field.String("John"));
            row.SetValue("last_name", Field.String("Doe"));
            row.SetValue("birth_date", Field.Date(new SqlDateTime(1977, 01, 01)));
            row.SetValue("active", Field.Boolean(false));
            table.AddRow(row);

            row = table.NewRow();
            row.SetValue("id", Field.Integer(1));
            row.SetValue("first_name", Field.String("Jane"));
            row.SetValue("last_name", Field.String("Doe"));
            row.SetValue("birth_date", Field.Date(new SqlDateTime(1978, 11, 01)));
            row.SetValue("active", Field.Boolean(true));
            table.AddRow(row);

            row = table.NewRow();
            row.SetValue("id", Field.Integer(2));
            row.SetValue("first_name", Field.String("Roger"));
            row.SetValue("last_name", Field.String("Rabbit"));
            row.SetValue("birth_date", Field.Date(new SqlDateTime(1985, 05, 05)));
            row.SetValue("active", Field.Boolean(true));
            table.AddRow(row);

            if (testName.EndsWith("Violation") ||
                testName.EndsWith("ConstraintCheck")) {
                table = context.Access().GetMutableTable(ObjectName.Parse("APP.test_table2"));
                row = table.NewRow();
                row.SetValue("person_id", Field.Integer(1));
                row.SetValue("dept_no", Field.Integer(45));
                row.SetDefault(context);
                table.AddRow(row);
            }
        }