ManyColumnsRecords2.java

package tests;

import catg.CATG;
import database.table.SymbolicTable;
import database.table.commands.SelectCommand;
import database.table.from.From;
import database.table.groupby.DefaultGroupBy;
import database.table.having.HavingTrue;
import database.table.internals.ForeignKey;
import database.table.internals.Row;
import database.table.internals.Table;
import database.table.internals.TableFactory;
import database.table.operations.IdentityOperation;
import database.table.operations.Operations;
import database.table.select.Select;
import database.table.where.Where;

public class ManyColumnsRecords2 {
    public static int l_c1;
    public static final int RECORD_COUNT = 4;
    public static final int COLUMN_COUNT = 5;

    public  static void testme(Table customers, int c1){
        int result;

        CATG.BeginScope();

        l_c1 = c1;

        Table t = (new SelectCommand(
                new Select() {
                    public String[] selectAs() {
                        return new String[]{"Id"};
                    }

                    public Operations[] select() {
                        return new Operations[]{new IdentityOperation("Id")};
                    }
                },
                new From(new Table[]{customers}),
                new Where() {
                    @Override
                    public boolean where(Row[] rows) {
                        CATG.BeginScope();
                        boolean ret = true;

                        for(int i = 1;i < COLUMN_COUNT; i++){
                            Integer c = (Integer) rows[0].get("C"+i);
                            if (c == null || c != l_c1) {
                                ret = false;
                                break;
                            }
                        }
                        CATG.EndScope();
                        ret = CATG.abstractBool("test", ret);
                        return ret;
                    }

                },
                new DefaultGroupBy(),
                new HavingTrue(),
                null, false
        )).execute();

        result = t.size();

        CATG.EndScope();
        result = CATG.abstractInt(result);

        System.out.println(result + " record(s) are selected.");

        if(result >= RECORD_COUNT){
            System.out.println("reached goal!");
        }
        else{
            System.out.println("failed to reach goal...");
        }
    }

    public static void main(String[] args){
        int c1= CATG.readInt(20);

        String[] names = new String[COLUMN_COUNT];
        int[] types = new int[COLUMN_COUNT];
        int[] constraints = new int[COLUMN_COUNT];
        ForeignKey[] foreignKeys = new ForeignKey[COLUMN_COUNT];

        names[0]="Id";
        types[0] = Table.INT;
        constraints[0] = Table.PRIMARY;
        foreignKeys[0] = null;

        for(int i=1;i<COLUMN_COUNT;i++){
            names[i] = "C"+ i;
            types[i] = Table.INT;
            constraints[i] = Table.NONE;
            foreignKeys[i] = null;
        }

        Table customers = TableFactory.create("Customers",
                names,
                types,
                constraints,
                foreignKeys
        );

        SymbolicTable.insertSymbolicRows(customers, RECORD_COUNT);

        testme(customers, c1);
    }

}