def update_title_board(board_id, new_title): try: query = "update board set title = '{new_title}' where id = '{board_id}';".format( new_title=new_title, board_id=board_id) connection.execute_select(query) except: return True
def delete_board(board_id): try: query = "delete from board where id = '{board_id}'".format( board_id=board_id) connection.execute_select(query) except: return True
def edit(id, name, email, phone): try: query = "UPDATE data SET name='{name}',email='{email}',phone='{phone}' WHERE id='{id}'".format( name=name, email=email, phone=phone, id=id) connection.execute_select(query) except: return True
def add_new_board(board_title): try: query = "insert into board (id, title) values (DEFAULT, '{board_title}');".format( board_title=board_title) connection.execute_select(query) except: print('true')
def insert(name, email, phone): try: query = "INSERT INTO data (name, email, phone) VALUES ('{name}','{email}','{phone}')".format( name=name, email=email, phone=phone) connection.execute_select(query) except: return True
def insert_user(username, password): try: ids = connection.execute_select('SELECT id FROM users ') id_list = [x['id'] for x in ids] if len(id_list) < 1: user_id = 1 else: user_id = max(id_list) + 1 query = "INSERT INTO users VALUES('{user_id}','{username}', '{password}')".format( user_id=user_id, username=username, password=password) connection.execute_select(query) except: print('wtf')
def create_user(new_data): return connection.execute_select( 'INSERT INTO registration VALUES (DEFAULT, %(username)s,%(password)s) RETURNING id', { 'username': new_data["username"], 'password': new_data["password"] })
def modify_card_status_by_card_title(card_id, status_id): return connection.execute_select( '''UPDATE cards SET status_id = %(status_id)s WHERE id = %(card_id)s''', { 'status_id': status_id, 'card_id': card_id })
def get_statuses(boardId): query = "select distinct status.title , status.id as status_id, board.id as board_id from status " \ "join card on status.id = card.status_id " \ "join board on card.board_id = board.id " \ "where board_id = '{boardId}' "\ "order by status_id asc; ".format(boardId=boardId) return connection.execute_select(query)
def update_title(new_title, board_id): return connection.execute_select( 'UPDATE boards SET title = %(new_title)s' 'WHERE id= %(board_id)s', { 'new_title': new_title, 'board_id': board_id })
def update_card_title(new_title, card_id): return connection.execute_select( 'UPDATE cards SET title = %(new_title)s' 'WHERE id= %(card_id)s', { 'new_title': new_title, 'card_id': card_id })
def get_password(username): query = "SELECT password FROM users WHERE username = '******'".format( user=username) password = connection.execute_select(query) if password: return password[0]['password'] else: return False
def create_new_card(board_id): return connection.execute_select( '''INSERT INTO cards VALUES (DEFAULT, %(board_id)s,'Sample card',0, 0) RETURNING id''', {'board_id': board_id})
def get_cards_by_board_id(board_id): return connection.execute_select( ''' SELECT * FROM cards WHERE board_id = %(board_id)s''', {'board_id': board_id})
def data(): query = 'SELECT * FROM data ORDER BY id' return connection.execute_select(query)
def get_by_id(id): query = "SELECT * FROM data WHERE id = '{id}'".format(id=id) return connection.execute_select(query)
def delete_card(card_id): return connection.execute_select( '''DELETE FROM cards WHERE cards.id = %(card_id)s''', {'card_id': card_id})
def return_new_board_data(new_id): return connection.execute_select( 'SELECT * FROM boards WHERE id = %(new_id)s', {'new_id': new_id})
def get_all_cards(): query = "SELECT * FROM card" return connection.execute_select(query)
def get_cards_for_board(board_id): query = "SELECT * FROM card WHERE board_id='{id}'".format(id=board_id) data = connection.execute_select(query) _cache['cards'] = data return connection.execute_select(query)
def get_statuses(): query = "SELECT * FROM status" data = connection.execute_select(query) _cache['all-statuses'] = data return connection.execute_select(query)
def get_all_boards(): query = "SELECT * FROM board" data = connection.execute_select(query) _cache['all-boards'] = data return connection.execute_select(query)
def new_board(new_title): return connection.execute_select( 'INSERT INTO boards VALUES(DEFAULT, %(new_title)s) RETURNING id', {'new_title': new_title})
def get_boards(): return connection.execute_select('SELECT * FROM boards ORDER BY id;')
def delete_board(board_id): return connection.execute_select( '''DELETE FROM boards WHERE id = %(board_id)s''', {'board_id': board_id})
def check_username(): return connection.execute_select(''' SELECT username FROM registration''')
def get_boards(): query = 'select * from board order by id desc;' return connection.execute_select(query)
def login(): return connection.execute_select( ''' SELECT username,password FROM registration''')
def get_cards_for_bords(board_id, status_id): query = "SELECT card.* from card WHERE card.status_id = '{status_id}' and card.board_id ='{board_id}'order by position asc".format( status_id=status_id, board_id=board_id) return connection.execute_select(query)
def get_userid(username): return connection.execute_select( "SELECT id FROM users WHERE username = '******'".format( user=username))[0]