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]
