Main.java

import java.util.Arrays;
import java.util.List;

public class Main {

    public static void main(String[] args) {

        Database db = new Database();

        List<String> fields = Arrays.asList("id", "name", "address");
        List<String> types  = Arrays.asList("LONG", "STRING", "STRING");
        List<String> pKeys  = Arrays.asList("id");

        Table people = db.createTable("people", fields, types, pKeys);

        Row r1 = new Row();
        r1.setLong("id", 1L);
        r1.setString("name", "Alice");
        r1.setString("address", "123 Main St");
        people.insert(r1);

        Row r2 = new Row();
        r2.setLong("id", 2L);
        r2.setString("name", "Bob");
        r2.setString("address", "456 Oak Ave");
        people.insert(r2);

        people.printAll();

        System.out.println("\nLooking up id=1:");
        Row found = people.getByLongKey("id", 1L);
        System.out.println("  Found: " + found);

        System.out.println("\nUpdating address for id=1:");
        people.updateField("id", 1L, "address", "789 Elm Rd");

        people.printAll();

        System.out.println("\nDeleting id=2:");
        people.deleteByLongKey("id", 2L);
        people.printAll();

        System.out.println("\nSelecting 'people' table from db:");
        Table same = db.selectTable("people");
        System.out.println("  Table name: " + same.getTableName()
                           + ", rows: " + same.size());

        db.deleteTable("people");
        db.listTables();
    }
}