001package csheets.ext.database.core;
002
003import java.io.FileNotFoundException;
004import java.sql.SQLException;
005import java.util.ArrayList;
006import java.util.logging.Level;
007import java.util.logging.Logger;
008
009/**
010 * A console-based test class
011 * @author João Carreira
012 */
013public class Console 
014{
015    public static void main(String []args) throws FileNotFoundException
016    {
017        ArrayList<Database> array = new ArrayList<Database>();
018        DBCsvReader test = new DBCsvReader();
019        array = test.getDBList();
020        for(int i = 0; i < array.size(); i++)
021        {
022//            System.out.println(array.get(i).getName());
023//            System.out.println(array.get(i).getUrl());
024//            System.out.println(array.get(i).getAdapteeName());
025        }
026        
027//        System.out.println("CONSOLE: Trying to connect");
028//        DatabaseFacade df = new DatabaseFacade();
029//        try 
030//        {
031//            df.createConnection("jdbc:hsqldb:file:/Users/joaocarreira/Desktop/hsqltest", "joao", "pass", "HSQL");
032//           
033//           
034//        } catch (Exception ex) {
035//          
036//        }
037        
038        
039        HsqlDBConnection hsql = new HsqlDBConnection();
040        try {
041            hsql.createConnection("jdbc:hsqldb:file:/Users/joaocarreira/Desktop/hsqltest/hsql", "joao", "pass");
042            //hsql.createTable(null, null, null);
043        } catch (ClassNotFoundException ex) {
044            System.out.println("class not found");
045        } catch (SQLException ex) {
046           System.out.println("sql exception");
047        }
048        
049        
050    }
051}