import pymysql as sql
from flask import jsonify

class Config(object):
	DATABASE_NAME = "epytodo"
	DATABASE_HOST = "127.0.0.1"
	DATABASE_SOCK = "/var/lib/mysql/mysql.sock"
	DATABASE_USER = "root"
	DATABASE_PASS = "toor"
	logged_username = None

class API(object):
	LOG_ERR = { "error" : "you must be logged in" }
	INTERNAL_ERR = { "error" : "internal error" }
	REGISTER_POST = {"username" : "_username",
					 "password" : "_password"}
	REGISTER_RES = { "result" : "account created" }
	REGISTER_ERR = { "error" : "account already exists" }
	SIGNIN_POST = ""
	SIGNIN_RES = { "result" : "signin successful" }
	SIGNIN_ERR = { "result" : "login or password does not match" }
	SIGNOUT_RES = { "result" : "signout successful" }
	USER_RES = {}
	USER_ERR = {}
	TASK_ID_RES = {}
	TASK_ID_ERR = { "error" : "task id not found" }
	USER_TASK_RES = {}
	USER_TASK_ERR = {}
	TASK_ID_MOD_POST = {}
	TASK_ID_MOD_RES = { "result" : "task updated" }
	TASK_ID_MOD_ERR = {}
	TASK_ID_ADD_POST = {}
	TASK_ID_ADD_RES = { "result" : "task added" }
	TASK_ID_ADD_ERR = {}
	TASK_ID_DEL_POST = {}
	TASK_ID_DEL_RES = { "result" : "task deleted" }
	TASK_ID_DEL_ERR = {}

def config_data_base():
	connect = sql.connect(host=Glob.DATABASE_HOST,
						  unix_socket=Glob.DATABASE_SOCK,
						  user=Glob.DATABASE_USER,
						  passwd=Glob.DATABASE_PASS,
						  db=Glob.DATABASE_NAME)
	cursor = connect.cursor()
	cursor.execute("""
	CREATE TABLE IF NOT EXISTS user(
	user_id INT NOT NULL AUTO_INCREMENT,
	username CHAR(30),
	password CHAR(30),
	PRIMARY KEY (user_id)
	);
	""")
	cursor.execute("""
	CREATE TABLE IF NOT EXISTS task(
	task_id INT NOT NULL AUTO_INCREMENT,
	title CHAR(30),
	begin CHAR(30),
	end CHAR(30),
	status CHAR(30),
	PRIMARY KEY (task_id)
	);
	""")
	cursor.execute("""
	CREATE TABLE IF NOT EXISTS user_has_task(
	fk_user_id INT,
	fk_task_id INT
	);
	""")
	connect.commit()
	cursor.close()
	connect.close()