/*
    * 
    * 
    */
   package example.filestorage;
   
   import java.sql.*;
   
   /***
   * 
   * @author Sean C. Sullivan
   *
   */
  public class DerbyDBSetup
  {
  
  	private DerbyDBSetup()
  	{
  		// empty
  	}
  	
  	public static void dropAll()
  	{
  		String dropTable = "DROP TABLE " + Constants.TABLE_NAME;
  		
  		try
  		{
  			executeSQL(dropTable);
  		}
  		catch (Exception ignored)
  		{
  			// ignore
  		}
  
  	}
  	
  	private static void executeSQL(String sql)
  	{
  		Connection conn = null;
  		Statement st = null;
  		
  		try
  		{
  			conn = DBUtil.getConnection();
  			st = conn.createStatement();
  			st.executeUpdate(sql);
  		}
  		catch (SQLException ex)
  		{
  			throw new DataAccessException(sql, ex);
  		}
  		finally 
  		{
  			DBUtil.close(conn, st, null);
  		}
  	}
  	
  	public static void create()
  	{
  		String createTable = "CREATE TABLE "
  						+ Constants.TABLE_NAME
  						+ " ( "
  						+ Constants.COLUMN_FILE_ID
  						+ " INTEGER PRIMARY KEY NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), "
  						+ Constants.COLUMN_FILENAME
  						+ " VARCHAR( "
  						+ Constants.MAX_LENGTH_FILENAME
  						+ " ) NOT NULL, "
  						+ Constants.COLUMN_FILESIZE
  						+ " INTEGER NOT NULL, "
  						+ Constants.COLUMN_FILEDATA 
  						+ " BLOB (250M)"
  						+ " ) ";
  
  		executeSQL(createTable);
  		System.out.println("Created table: " + Constants.TABLE_NAME);
  		
  	}
  	
  	public static void main(String[] args)
  	{
  		dropAll();
  		create();
  		System.out.println("Done");
  	}
  }