import devinfalgoust.sqlquerygenerator.QueryException;
import devinfalgoust.sqlquerygenerator.insert.InsertQueryFieldType;
import devinfalgoust.sqlquerygenerator.insert.InsertQueryGenerator;
import devinfalgoust.sqlquerygenerator.select.SelectQueryFieldOperator;
import devinfalgoust.sqlquerygenerator.select.SelectQueryGenerator;

/**
 * This is the Driver class, containing the main function
 * and sample code for how each Query Generator is used.
 * 
 * @author Devin Falgoust
 */
public class Driver {

	public static void main(String args[]) {
		//demoInsertQueryGenerator();
		demoSelectQueryGenerator();
	}

	/**
	 * This function provides sample code for the InsertQueryGenerator
	 */
	public static void demoInsertQueryGenerator() {
		/*
		 * Create a new InsertQueryGenerator with these parameters:
		 * tableName = "TEST_TABLE"
		 * start = 1
		 * end = 5
		 * 
		 * The tableName is the table that you wish to insert a record into.
		 * The start and end variables are used to calculate 1) the IDs of each
		 * record and 2) the number of records to generate.
		 */
		InsertQueryGenerator generator = new InsertQueryGenerator("TEST_TABLE", 1, 5);

		/*
		 * The addField function takes these parameters:
		 * 1) the name of the field
		 * 2) the type of field
		 * 3...) any options for the field
		 * 
		 * The valid types are:
		 * ID - generates an ID starting at "start" and ending at "end"
		 * NAME - generates a random string of 8 characters where the first is capitalized
		 * EMAIL - generates a random email address. This is created using 8 random
		 *    characters, then the ID, then @test.com
		 * TEXT - adds a random text of the options given
		 *    If there are no options, it generates a random string of 8 characters
		 *    If one option is provided, it adds that text to every record
		 *    If more than one option is provided, it chooses a random option from these
		 */

		// First add the ID
		generator.addField("ID", InsertQueryFieldType.ID);

		// Then add first and last name
		generator.addField("FIRST_NAME", InsertQueryFieldType.NAME);
		generator.addField("LAST_NAME", InsertQueryFieldType.NAME);

		// Then add the email
		generator.addField("EMAIL", InsertQueryFieldType.EMAIL);

		// Then add a boolean variable
		generator.addField("BOOLEAN", InsertQueryFieldType.TEXT, "true", "false");

		// Then add a date
		generator.addField("DATE", InsertQueryFieldType.TEXT, "10032014");

		// Then add a string with two options
		generator.addField("SOURCE", InsertQueryFieldType.TEXT, "WEB", "STORE");

		// Then add a string with no options (randomly generates)
		generator.addField("DATA", InsertQueryFieldType.TEXT);

		// Then print the list of queries
		System.out.println(generator.generate());
	}

	/**
	 * This function provides sample code for the SelectQueryGenerator
	 */
	public static void demoSelectQueryGenerator() {
		try {
			// Generate Simple Select Query
			System.out.println("-- Generate Simple Select Query");
			SelectQueryGenerator generator = new SelectQueryGenerator("TEST_TABLE");
			System.out.println(generator.generate());

			// Generate Query with One Select Field
			System.out.println("\n-- Generate Query with One Select Field");
			generator = new SelectQueryGenerator("TEST_TABLE");
			generator.addSelectField("orderId");
			System.out.println(generator.generate());

			// Generate Query with Three Select Field
			System.out.println("\n-- Generate Query with Three Select Field");
			generator = new SelectQueryGenerator("TEST_TABLE");
			generator.addSelectField("orderId");
			generator.addSelectField("firstName");
			generator.addSelectField("lastName");
			System.out.println(generator.generate());

			// Generate Distinct Query
			System.out.println("\n-- Generate Distinct Query");
			generator = new SelectQueryGenerator("TEST_TABLE");
			generator.addSelectField("lastName");
			generator.makeDistinct();
			System.out.println(generator.generate());

			// Generate Query with One Where Clause
			System.out.println("\n-- Generate Query with One Where Clause");
			generator = new SelectQueryGenerator("TEST_TABLE");
			generator.addWhereField("orderId", SelectQueryFieldOperator.EQUAL, "4815162342");
			System.out.println(generator.generate());

			// Generate Query with Three Where Clauses
			System.out.println("\n-- Generate Query with Three Where Clauses");
			generator = new SelectQueryGenerator("TEST_TABLE");
			generator.addWhereField("firstName", SelectQueryFieldOperator.EQUAL, "John");
			generator.addWhereField("lastName", SelectQueryFieldOperator.EQUAL, "Doe");
			generator.addWhereField("birthday", SelectQueryFieldOperator.EQUAL, "0424");
			System.out.println(generator.generate());

			// Generate Query with One OrderBy
			System.out.println("\n-- Generate Query with One OrderBy");
			generator = new SelectQueryGenerator("TEST_TABLE");
			generator.addOrderByField("lastName");
			System.out.println(generator.generate());

			// Generate Query with Three OrderBys
			System.out.println("\n-- Generate Query with Three OrderBys");
			generator = new SelectQueryGenerator("TEST_TABLE");
			generator.addOrderByField("lastName");
			generator.addOrderByField("firstName");
			generator.addOrderByField("email");
			System.out.println(generator.generate());

			// Generate Query with One OrderBy Ascending
			System.out.println("\n-- Generate Query with One OrderBy");
			generator = new SelectQueryGenerator("TEST_TABLE");
			generator.addOrderByField("lastName");
			generator.makeOrderByAscending();
			System.out.println(generator.generate());

			// Generate Query with One OrderBy Descending
			System.out.println("\n-- Generate Query with One OrderBy");
			generator = new SelectQueryGenerator("TEST_TABLE");
			generator.addOrderByField("lastName");
			generator.makeOrderByDescending();
			System.out.println(generator.generate());
		} catch (QueryException e) {
			System.err.println("-- I Should not get here");
		}

		try {
			// Try to Generate Distinct Query without Select Fields
			System.out.println("\n-- Try to Generate Distinct Query without Select Fields");
			SelectQueryGenerator generator = new SelectQueryGenerator("TEST_TABLE");
			generator.makeDistinct();
			System.out.println(generator.generate());
			System.err.println("-- I Should not get here");

		} catch (QueryException e) {
			System.err.println("-- This failed because Distinct was selected without any Select Fields");
		}
	}

}