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

        private void AddTestData(IQuery query)
        {
            var table = query.Access().GetMutableTable(new ObjectName(new ObjectName("APP"), "persons"));

            var row = table.NewRow();
            row["person_id"] = Field.Integer(1);
            row["name"] = Field.String("Antonello Provenzano");
            row["age"] = Field.Integer(34);
            table.AddRow(row);

            row = table.NewRow();
            row["person_id"] = Field.Integer(3);
            row["name"] = Field.String("John Doe");
            row["age"] = Field.Integer(56);
            table.AddRow(row);

            row = table.NewRow();
            row["person_id"] = Field.Integer(5);
            row["name"] = Field.String("Charles Down");
            row["age"] = Field.Integer(22);
            table.AddRow(row);

            table = query.Access().GetMutableTable(new ObjectName(new ObjectName("APP"), "codes"));
            row = table.NewRow();
            row["person_id"] = Field.Integer(1);
            row["code"] = Field.String("123456");
            row["registered"] = Field.Date(new SqlDateTime(2014, 01, 12));
            table.AddRow(row);

            row = table.NewRow();
            row["person_id"] = Field.Integer(5);
            row["code"] = Field.String("9901009");
            row["registered"] = Field.Date(new SqlDateTime(2015, 04, 22));
            table.AddRow(row);
        }