DBDateSelectTest.java

package tests;

import database.table.SymbolicTable;
import database.table.internals.ForeignKey;
import database.table.internals.Row;
import database.table.internals.Table;
import database.table.internals.TableFactory;
import database.table.where.Where;

import java.sql.Date;
import java.sql.ResultSet;

public class DBDateSelectTest {

	public  static void testme(Table customers){

		ResultSet rs = customers.select(new Where() {
			public boolean where(Row[] rows) {
				Date i = (Date) rows[0].get("DOB");
				if (i != null && i.before(Date.valueOf("1980-11-24")))
					return true;
				return false;
			}
		}, new String[][] { { "Id" } }, null).getResultSet();

		int selectedCount = 0;

		try{
			while (rs.next()) {
				selectedCount++;
			}
		}
		catch(Exception e){
			e.printStackTrace();
		}

		System.out.println(selectedCount + " records are selected.");
		if(selectedCount == 0){
			System.out.println("reached goal!!.");
		}
		else{
			System.out.println("failed to reach goal...");
		}
    }

    public static void main(String[] args){
        Table customers = TableFactory.create("Customers", new String[]{"Id",
                "Name", "DOB", "Age"}, new int[]{Table.INT,
                Table.STRING, Table.DATE, Table.INT}, new int[]{Table.PRIMARY,
                Table.PRIMARY, Table.NONE, Table.NONE}, new ForeignKey[]{null, null, null,
                null});
        SymbolicTable.insertSymbolicRows(customers, 4);

        testme(customers);
    }
}