package be.zokola.main;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;

import org.eclipse.ease.modules.WrapToScript;

public class MysqlTableQueries {
	private String driver = "com.mysql.jdbc.Driver";
	private String dburl = "jdbc:mysql://localhost:3306/";
	private String dbName = "zokoladblabeltest";
	private String credname = "<myDBUsername>";
	private String cred = "<myDBPassword>";
	private String tableName = null;
	private Connection conn;

	public MysqlTableQueries() {
	}
	
	@WrapToScript
	public String test() {
		return "Helllooowwww....";
	}
	/**
	 * Make a connection to the database. If dbName is ommitted, zokoladblabelstest is used
	 * @param dbName
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	@WrapToScript
	public void connect2db() throws ClassNotFoundException, SQLException {
		if(dbName != null) {
			this.dbName = dbName;
		}
		
		Class.forName(driver);
		this.conn = DriverManager.getConnection(dburl+dbName, credname, cred);
	}
	
	public Boolean doesTableExist(String tableName) throws SQLException {
		Integer result = 0;
		this.tableName = tableName;
		String q = "SELECT COUNT(*) "
				+ "FROM information_schema.tables  "
				+ "WHERE table_schema = \"" + dbName + "\" "
				+ "AND table_name = \"" + tableName + "\";";

		Statement st = null;
		ResultSet rs = null;
		try {
			st = conn.createStatement();
		      rs = st.executeQuery(q);
		      if(rs.next()) {
		    	  result = rs.getInt(1);
		      }
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			st.close();
		}
		if(result == 1) {
			return true;
		} else {
			return false;
		}
	}

/**
 * Compares a given entity with a table in the database
 * name: DiffTableEntity
 * popup: enableFor(org.eclipse.jface.text.ITextSelection)
 * image: ../icns/MySQL-Logo2.png
 */
loadModule('/System/UI');
loadModule("/System/JVM", false);
module = createInstance("workspace://EASEscript/src/be/zokola/main/MysqlTableQueries.java");
wrap(module);


var question1 = "Databasename:";
var defaultvalue1 = "zokoladblabeltest";
var title1 = "Enter the databasename to query";
 
var question2 = "Tablename:";
var defaultvalue2 = "";
var title2 = "Enter the table to query";
 
var dbname = showInputDialog(question1, defaultvalue1, title1);
if(dbname != null & dbname != ""){
	var table = showInputDialog(question2, defaultvalue2, title2);
	if(table != null && table != ""){
		print("============>>>>>>>>>>" + test());
		connect2db();
		print("============>>>>>>>>>>" + doesTableExist(table));
		print(dbname + " - " + table);
		closeConnection();
	}
}

print("============>>>>>>>>>>" + test());

print("============>>>>>>>>>>" + doesTableExist(table));

============>>>>>>>>>>Helllooowwww....
org.eclipse.ease.ScriptExecutionException: JavaError: com.mysql.jdbc.Driver
	at DiffTableEntity.js,workspace://EASEproject/livescripts/DiffTableEntity.js

Java Stacktrace:
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:476)
	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:589)
	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)
	at java.base/java.lang.Class.forName0(Native Method)
	at java.base/java.lang.Class.forName(Class.java:315)
	at be.zokola.main.MysqlTableQueries.connect2db(MysqlTableQueries.java:48)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)
	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225)
	at org.mozilla.javascript.gen.c_17._c_connect2db_4(Unknown Source)
	at org.mozilla.javascript.gen.c_17.call(Unknown Source)
	at org.mozilla.javascript.optimizer.OptRuntime.callName0(OptRuntime.java:74)
	at org.mozilla.javascript.gen.workspace___EASEproject_livescripts_DiffTableEntity_js_13._c_script_0(Unknown Source)
	at org.mozilla.javascript.gen.workspace___EASEproject_livescripts_DiffTableEntity_js_13.call(Unknown Source)
	at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:405)
	at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3508)
	at org.mozilla.javascript.gen.workspace___EASEproject_livescripts_DiffTableEntity_js_13.call(Unknown Source)
	at org.mozilla.javascript.gen.workspace___EASEproject_livescripts_DiffTableEntity_js_13.exec(Unknown Source)
	at org.mozilla.javascript.Context.evaluateReader(Context.java:1293)
	at org.eclipse.ease.lang.javascript.rhino.RhinoScriptEngine.internalExecute(RhinoScriptEngine.java:223)
	at org.eclipse.ease.lang.javascript.rhino.RhinoScriptEngine.execute(RhinoScriptEngine.java:202)
	at org.eclipse.ease.AbstractScriptEngine.inject(AbstractScriptEngine.java:190)
	at org.eclipse.ease.AbstractScriptEngine.run(AbstractScriptEngine.java:243)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)