package org.homelinux.largo.app;

import java.util.List;
import java.sql.SQLException;
import org.homelinux.largo.sql.client.DBClient;

public class App {
	public static void main (String args[]) {
		DBClient db = null;
		int i = 0;

		try {
			db = new DBClient ();
			List<String> list = db.getTables ();

			System.out.println ("TABLES IN THE CURRENT DATABASE");
			for (String s : list) {
				System.out.printf ("[%04d] %s%n", i++, s);
			}
			System.out.println ();

			list = db.getColumns("EUROLEAGUE");
			System.out.println ("COLUMN NAMES IN THIS TABLE");
			for (String s : list) {
				System.out.printf ("%s ", s);
			}
			System.out.printf ("%n%n");

			i = db.update ("delete from euroleague where bonus>0");
			System.out.printf ("Deleted: %3d lines%n", i);
			db.query ("select * from euroleague order by team");

			while (db.hasNext ()) {
				System.out.println (db.getColumn ("team"));
			}
		} catch (SQLException sqle) {
			System.out.println ("SQLException: " + sqle.getMessage());
		} catch (Exception e) {
			e.printStackTrace ();
		} finally {
			try {
				if (db != null) {
					System.out.println ("Disconnecting from database...");
					db.disconnect();
				}
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
	}
}