3t2Eujrr

1import pymysql as sql
2from flask import jsonify
3
4class Config(object):
5	DATABASE_NAME = "epytodo"
6	DATABASE_HOST = "127.0.0.1"
7	DATABASE_SOCK = "/var/lib/mysql/mysql.sock"
8	DATABASE_USER = "root"
9	DATABASE_PASS = "toor"
10	logged_username = None
11
12class API(object):
13	LOG_ERR = { "error" : "you must be logged in" }
14	INTERNAL_ERR = { "error" : "internal error" }
15	REGISTER_POST = {"username" : "_username",
16					 "password" : "_password"}
17	REGISTER_RES = { "result" : "account created" }
18	REGISTER_ERR = { "error" : "account already exists" }
19	SIGNIN_POST = ""
20	SIGNIN_RES = { "result" : "signin successful" }
21	SIGNIN_ERR = { "result" : "login or password does not match" }
22	SIGNOUT_RES = { "result" : "signout successful" }
23	USER_RES = {}
24	USER_ERR = {}
25	TASK_ID_RES = {}
26	TASK_ID_ERR = { "error" : "task id not found" }
27	USER_TASK_RES = {}
28	USER_TASK_ERR = {}
29	TASK_ID_MOD_POST = {}
30	TASK_ID_MOD_RES = { "result" : "task updated" }
31	TASK_ID_MOD_ERR = {}
32	TASK_ID_ADD_POST = {}
33	TASK_ID_ADD_RES = { "result" : "task added" }
34	TASK_ID_ADD_ERR = {}
35	TASK_ID_DEL_POST = {}
36	TASK_ID_DEL_RES = { "result" : "task deleted" }
37	TASK_ID_DEL_ERR = {}
38
39def config_data_base():
40	connect = sql.connect(host=Glob.DATABASE_HOST,
41						  unix_socket=Glob.DATABASE_SOCK,
42						  user=Glob.DATABASE_USER,
43						  passwd=Glob.DATABASE_PASS,
44						  db=Glob.DATABASE_NAME)
45	cursor = connect.cursor()
46	cursor.execute("""
47	CREATE TABLE IF NOT EXISTS user(
48	user_id INT NOT NULL AUTO_INCREMENT,
49	username CHAR(30),
50	password CHAR(30),
51	PRIMARY KEY (user_id)
52	);
53	""")
54	cursor.execute("""
55	CREATE TABLE IF NOT EXISTS task(
56	task_id INT NOT NULL AUTO_INCREMENT,
57	title CHAR(30),
58	begin CHAR(30),
59	end CHAR(30),
60	status CHAR(30),
61	PRIMARY KEY (task_id)
62	);
63	""")
64	cursor.execute("""
65	CREATE TABLE IF NOT EXISTS user_has_task(
66	fk_user_id INT,
67	fk_task_id INT
68	);
69	""")
70	connect.commit()
71	cursor.close()
72	connect.close()