// *****************************************************
// Copyright (c) 2006-2010 iAnywhere Solutions, Inc.
// Portions copyright (c) 2006-2010 Sybase, Inc.
// All rights reserved. All unpublished rights reserved.
// *****************************************************
// This sample code is provided AS IS, without warranty or liability
// of any kind.
//
// You may use, reproduce, modify and distribute this sample code
// without limitation, on the condition that you retain the foregoing
// copyright notice and disclaimer as to the original iAnywhere code.
//
// *********************************************************************
package com.ianywhere.ultralitej.demo;

import com.ianywhere.ultralitej12.*;

/**
 * CreateDb: sample program to demonstrate Database creation.
 */
public class CreateDb
{
    /**
     * mainline for program.
     *
     * @param args command-line arguments
     *
     */
     
    public static void main
	( String[] args )
    {
	try {
	    Configuration config = DatabaseManager.createConfigurationFile( "Demo1.ulj" );
	    Connection conn = DatabaseManager.createDatabase( config );

	    executeSql( conn
		      , "CREATE TABLE department\n"
		       +"( dept_no INT NOT NULL PRIMARY KEY\n"
		       +", name VARCHAR(50)\n"
		       +")"
		      );

	    executeSql( conn
		      , "CREATE TABLE Employee\n"
		       +"( number INT NOT NULL PRIMARY KEY\n"
		       +", last_name VARCHAR(32)\n"
		       +", first_name VARCHAR(32)\n"
		       +", age INT\n"
		       +", dept_no INT\n"
		       +", FOREIGN KEY fk_emp_to_dept( dept_no ) REFERENCES department( dept_no )"
		       +")"
		      );

	    Demo.display( "\nCreateDb completed successfully" );

	} catch( ULjException exc ) {
	    Demo.displayException( exc );
	}
    }

    /** Execute a SQL statement.
     * @param conn connection to current database
     * @param stmt SQL statement to be executed
     */
    private static void executeSql( Connection conn, String stmt )
    	throws ULjException
    {
	Demo.display( "\nExecuting:\n", stmt );
	PreparedStatement ps = conn.prepareStatement( stmt );
	ps.execute();
	ps.close();
    }
}