def get_login(token): db = db_connect.ohMysql(ip='192.168.1.10', user='******', password="", current_db='myPomidoro') login = db.read('users', {'key': 'token', 'if': '=', 'value': token}) if login == []: return False else: return login[0][1]
def create_user(login, password): db = db_connect.ohMysql( ip='192.168.1.10', user='******', password="", current_db='myPomidoro' ) dat = db.create( 'users', (login, password, '', 0) )
def get_tasks(token): db = db_connect.ohMysql(ip='192.168.1.10', user='******', password="", current_db='myPomidoro') login = get_login(token) if (login == False): return False tasks = db.read('tasks', {'key': 'user', 'if': '=', 'value': login}) tmp = [] for w in tasks: if w[7] != 2: tmp.append(w) return tmp
def add_task(data): db = db_connect.ohMysql(ip='192.168.1.10', user='******', password="", current_db='myPomidoro') login = get_login(data['token']) print(data) ## (task, description, interval, count/repeat, timer, user) dat = db.create('tasks', (data['task'], data['description'], int(data['intervall']), int(data['repeat']), 0, login, 0, data['group'])) if dat == None: return {'status': 'ok'} else: return {'status': 'error'}
def get_groups(token): login = get_login(token) if login == False: return "Error" db = db_connect.ohMysql(ip='192.168.1.10', user='******', password="", current_db='myPomidoro') tasks = get_tasks(token) groups = [] for w in tasks: groups.append(w[-1]) groups = list(set(groups)) return groups
def get_password(login): db = db_connect.ohMysql( ip='192.168.1.10', user='******', password="", current_db='myPomidoro' ) dat = db.read( 'users', { 'key':'login', 'if':'=', 'value':login } ) if dat: return dat[0][2] else: return False
def change_status(data): login = get_login(data['token']) if login == False: return "Error" db = db_connect.ohMysql(ip='192.168.1.10', user='******', password="", current_db='myPomidoro') res = db.update( 'tasks', { 'set': { 'key': 'status', 'value': data['status'] }, 'if': { 'key': 'id', 'value': data['id'] } })
def check_login(login): db = db_connect.ohMysql( ip='192.168.1.10', user='******', password="", current_db='myPomidoro' ) dat = db.read( 'users', { 'key':'login', 'if':'=', 'value':login } ) if dat != []: return "conflict" else: return 'ok'
def add_session(login, token): db = db_connect.ohMysql( ip='192.168.1.10', user='******', password="", current_db='myPomidoro' ) db.update( 'users', { 'set': { 'key': 'token', 'value': token }, 'if': { 'key': 'login', 'value': login } } )
def update_task(data): login = get_login(data['token']) if login == False: return "Error" db = db_connect.ohMysql(ip='192.168.1.10', user='******', password="", current_db='myPomidoro') for key in ('task', 'description', 'intervall', 'count', 'timer'): res = db.update( 'tasks', { 'set': { 'key': key, 'value': data[key] }, 'if': { 'key': 'id', 'value': data['id'] } })