db_quick.java

package accessory;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.Map.Entry;

//Use the methods in this class very carefully! Low-to-no checks are performed.
public abstract class db_quick 
{		
	static String[] _cols = new String[0];
		
	public static boolean is_ok(String source_) { return (is_quicker(source_) ? db_quicker.is_ok() : db.is_ok(source_)); }
	
	public static String get_select_count_col(String source_, String type_) { return (is_quicker(source_) ? db_quicker.get_select_count_col(type_) : db.get_select_count_col(source_)); }
	
	public static boolean is_quicker(String source_) { return db_quicker.is_ok(source_); }
	
	public static boolean is_quicker_mysql(String source_) { return db_quicker.is_mysql(source_); }
	
	public static void update_conn_info(String source_)
	{
		if (is_quicker(source_)) db_quicker.update_conn_info(source_);
	}
	
	public static void update_conn_info(String source_, String username_, String password_, String db_name_, String host_, String user_, String max_pool_)
	{
		if (is_quicker(source_)) db_quicker.update_conn_info(username_, password_, db_name_, host_, user_, max_pool_);
	}
	
	public static boolean change_db_name_queries(String source_, String name_) 
	{ 
		boolean output = db.change_db_name_queries(source_, name_); 
		
		if (output) update_conn_info(source_);
		
		return output;
	}
	
	public static boolean change_table_name_queries(String source_, String name_)
	{	
		boolean output = db.change_table_name_queries(source_, name_); 

		if (output && is_quicker(source_)) db_quicker.update_table(source_, name_);
		
		return output;
	}
	
	public static boolean change_col_name_queries(String source_, String field_, String name_)
	{	
		boolean output = db.change_col_name_queries(source_, field_, name_); 

		if (output) db_quick.populate_col(source_, field_);
		
		return output;
	}
	
	public static String get_table(String source_) { return (is_quicker(source_) ? db_quicker.get_table(source_) : db.get_table(source_)); }
	
	public static String get_col(String source_, String field_) 
	{ 
		int i = db.get_field_i(source_, field_);
		
		return (i > arrays.WRONG_I ? _cols[i] : db.get_col(source_, field_)); 
	}

	public static String[] get_cols(String source_) 
	{ 
		String[] output = null;
		
		int[] min_max = db.get_source_min_max(source_);
		if (min_max == null) return output;
		
		output = new String[db.get_source_fields_tot(min_max)];

		int i2 = -1;

		for (int i = min_max[0]; i <= min_max[1]; i++) 
		{
			i2++;
			
			output[i2] = _cols[i];
		}
		
		return output;
	}

	public static String[] get_cols(String source_, String[] fields_) 
	{ 
		int tot = arrays.get_size(fields_);
		if (tot == 0) return null;
				
		String[] cols = new String[tot];
		
		for (int i = 0; i < tot; i++) 
		{ 
			String col = get_col(source_, fields_[i]);
			if (!strings.is_ok(col)) continue;
			
			cols[i] = col;
		}
		
		return cols;
	}
	
	public static void update_cols(String source_) { populate_cols(source_, db.get_source_fields(source_)); }
	
	public static boolean input_is_ok(Object input_) { return (db.input_is_ok(input_) && !arrays.hashmap_is_xy(input_)); }

	public static boolean exists(String source_, String where_cols_) 
	{
		boolean output = db.WRONG_BOOLEAN;
		
		if (is_quicker_mysql(source_)) output = db_quicker_mysql.exists(source_, where_cols_);
		else output = db.exists(source_, where_cols_);
		
		return output; 
	}

	public static String select_one_string(String source_, String col_, String where_cols_, String order_cols_) 
	{ 
		String output = db.WRONG_STRING;
		
		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_one_string(source_, col_, where_cols_, order_cols_);
		else output = db.select_one_string_quick(source_, col_, where_cols_, order_cols_);
	
		return output;
	}

	public static double select_one_decimal(String source_, String col_, String where_cols_, String order_cols_) 
	{ 
		double output = db.WRONG_DECIMAL;
		
		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_one_decimal(source_, col_, where_cols_, order_cols_);
		else output = db.select_one_decimal_quick(source_, col_, where_cols_, order_cols_);
	
		return output;
	}
	
	public static long select_one_long(String source_, String col_, String where_cols_, String order_cols_) 
	{ 
		long output = db.WRONG_LONG;
		
		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_one_long(source_, col_, where_cols_, order_cols_);
		else output = db.select_one_long_quick(source_, col_, where_cols_, order_cols_);
	
		return output;
	}
	
	public static int select_one_int(String source_, String col_, String where_cols_, String order_cols_) 
	{ 
		int output = db.WRONG_INT;
		
		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_one_int(source_, col_, where_cols_, order_cols_);
		else output = db.select_one_int_quick(source_, col_, where_cols_, order_cols_);
	
		return output;
	}
	
	public static boolean select_one_boolean(String source_, String col_, String where_cols_, String order_cols_) 
	{ 
		boolean output = db.WRONG_BOOLEAN;
		
		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_one_boolean(source_, col_, where_cols_, order_cols_);
		else output = db.select_one_boolean_quick(source_, col_, where_cols_, order_cols_);
	
		return output;
	}
	
	public static HashMap<String, String> select_one(String source_, String[] cols_, String where_cols_, String order_cols_) 
	{ 
		HashMap<String, String> output = new HashMap<String, String>();

		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_one(source_, cols_, where_cols_, order_cols_);
		else output = db.select_one_quick(source_, cols_, where_cols_, order_cols_);

		return output;
	}

	public static ArrayList<String> select_some_strings(String source_, String col_, String where_cols_, int max_rows_, String order_cols_) 
	{ 
		ArrayList<String> output = new ArrayList<String>();

		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_some_strings(source_, col_, where_cols_, max_rows_, order_cols_);
		else output = db.select_some_strings_quick(source_, col_, where_cols_, max_rows_, order_cols_);

		return output;
	}

	public static ArrayList<Double> select_some_decimals(String source_, String col_, String where_cols_, int max_rows_, String order_cols_) 
	{ 
		ArrayList<Double> output = new ArrayList<Double>();

		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_some_decimals(source_, col_, where_cols_, max_rows_, order_cols_);
		else output = db.select_some_decimals_quick(source_, col_, where_cols_, max_rows_, order_cols_);

		return output;
	}

	public static ArrayList<Long> select_some_longs(String source_, String col_, String where_cols_, int max_rows_, String order_cols_) 
	{ 
		ArrayList<Long> output = new ArrayList<Long>();

		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_some_longs(source_, col_, where_cols_, max_rows_, order_cols_);
		else output = db.select_some_longs_quick(source_, col_, where_cols_, max_rows_, order_cols_);

		return output;
	}

	public static ArrayList<Integer> select_some_ints(String source_, String col_, String where_cols_, int max_rows_, String order_cols_) 
	{ 
		ArrayList<Integer> output = new ArrayList<Integer>();

		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_some_ints(source_, col_, where_cols_, max_rows_, order_cols_);
		else output = db.select_some_ints_quick(source_, col_, where_cols_, max_rows_, order_cols_);

		return output;
	}

	public static ArrayList<Boolean> select_some_booleans(String source_, String col_, String where_cols_, int max_rows_, String order_cols_) 
	{ 
		ArrayList<Boolean> output = new ArrayList<Boolean>();

		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_some_booleans(source_, col_, where_cols_, max_rows_, order_cols_);
		else output = db.select_some_booleans_quick(source_, col_, where_cols_, max_rows_, order_cols_);

		return output;
	}

	public static ArrayList<HashMap<String, String>> select(String source_, String[] cols_, String where_cols_, int max_rows_, String order_cols_) 
	{	
		ArrayList<HashMap<String, String>> output = new ArrayList<HashMap<String, String>>();

		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select(source_, cols_, where_cols_, max_rows_, order_cols_);
		else output = db.select_quick(source_, cols_, where_cols_, max_rows_, order_cols_);

		return output;
	}
	
	public static int select_count(String source_, String where_cols_) 
	{
		int output = 0;
		
		if (is_quicker_mysql(source_)) output = db_quicker_mysql.select_count(source_, where_cols_);
		else output = db.select_count(source_, where_cols_);

		return output;
	}
	
	public static void insert_update(String source_, String any_col_, HashMap<String, String> vals_, String where_cols_) 
	{
		if (is_quicker_mysql(source_)) db_quicker_mysql.insert_update(source_, any_col_, vals_, where_cols_); 
		else db.insert_update_quick(source_, vals_, where_cols_);
	}
	
	public static void insert(String source_, HashMap<String, String> vals_) 
	{
		if (is_quicker_mysql(source_)) db_quicker_mysql.insert(source_, vals_); 
		else db.insert_quick(source_, vals_);		
	}
	
	public static void update(String source_, HashMap<String, String> vals_, String where_cols_) 
	{
		if (is_quicker_mysql(source_)) db_quicker_mysql.update(source_, vals_, where_cols_); 
		else db.update_quick(source_, vals_, where_cols_);		
	}
	
	static void populate_cols_ini()
	{
		int tot = db.SOURCES.length;
		if (tot == 0) return;
 
		for (String source: db.SOURCES) populate_cols(source, db.get_source_fields(source));
	}
	
	static ArrayList<HashMap<String, String>> execute(String source_, String query_type_, String[] cols_, HashMap<String, String> vals_, String where_, int max_rows_, String order_, HashMap<String, db_field> cols_info_) 
	{ 
		ArrayList<HashMap<String, String>> output = null;
	
		if (is_quicker_mysql(source_)) output = db_quicker_mysql.execute(source_, query_type_, cols_, vals_, where_, max_rows_, order_, cols_info_); 
		else db.execute(source_, query_type_, cols_, vals_, where_, max_rows_, order_, cols_info_);
		
		return output;
	}
	
	static ArrayList<HashMap<String, String>> execute_query(String type_, String source_, String query_, boolean return_data_, String[] cols_) 
	{ 
		ArrayList<HashMap<String, String>> output = null;
		
		if (is_quicker(source_)) 
		{
			db_quicker.initialise();
			
			output = db_quicker.execute_query(type_, source_, query_, return_data_, cols_);
		}
		else output = db.execute_query(type_, source_, query_, return_data_, cols_);
	
		return output;
	}
	
	private static void populate_cols(String source_, HashMap<String, db_field> fields_)
	{
		if (!arrays.is_ok(fields_)) return;
		
		for (Entry<String, db_field> item: fields_.entrySet()) { populate_col(source_, item.getKey()); }
	}
	
	private static void populate_col(String source_, String field_)
	{
		int i = db.get_field_i(source_, field_);
		String col = db.get_col(source_, field_);
		
		if (i > arrays.WRONG_I && strings.is_ok(col)) _cols = arrays_quick.add(_cols, i, col);
	}
}