def insert_trade_cards(trade_id, card_id, from_id, desired):
raw = "INSERT INTO `trade_cards` (`trade_id` ,`card_id` ,`from_id` ,`desired`) VALUES ({0}, {1}, {2}, {3})"
return raw.format(ei(trade_id), ei(card_id), ei(from_id), e(desired))
def register_user(email, full_name, password):
# We give them 10 points to start off with, for the lols
return """INSERT INTO `users` (`email`, `full_name`, `password`) VALUES ("{0}", "{1}", MD5("{2}"));""".format(e(email), e(full_name), e(password))
def check_registered(email):
return """SELECT id FROM users WHERE email="{0}";""".format(e(email))
def insert_pack(pack_name, points):
return "INSERT INTO packs VALUES (NULL, {0}, {1});".format(e(pack_name), ei(points))
def login(email, password):
return "SELECT * FROM users WHERE email='{0}' AND password=MD5('{1}');".format(e(email), e(password))
def check_registered(email):
return """SELECT id FROM users WHERE email="{0}";""".format(e(email))
from MySQLdb import escape_string as e
# This makes sure the value looks like an int to start with.
ei = lambda val: e(str(int(val)))
# A decorator so we don't always have to do `print stmt; return stmt` at the end
def print_and_return(func):
def pr_wrapper(*arg, **kwargs):
res = func(*arg, **kwargs)
print res
return res
return pr_wrapper
@print_and_return
def login(email, password):
return "SELECT * FROM users WHERE email='{0}' AND password=MD5('{1}');".format(e(email), e(password))
@print_and_return
def get_user(user_id):
return "SELECT * FROM users WHERE id={0} LIMIT 1;".format(ei(user_id))
@print_and_return
def get_other_users(user_id):
return "SELECT id, full_name FROM users WHERE id != {0}".format(ei(user_id))
@print_and_return
def after_login(user_id, extra_points):
return "UPDATE users SET points = points + {1} WHERE id = {0};".format(ei(user_id), ei(extra_points))
@print_and_return
def populate_card(player_id):
def register_user(email, full_name, password):
# We give them 10 points to start off with, for the lols
return """INSERT INTO `users` (`email`, `full_name`, `password`) VALUES ("{0}", "{1}", MD5("{2}"));""".format(
e(email), e(full_name), e(password))
def login(email, password):
return "SELECT * FROM users WHERE email='{0}' AND password=MD5('{1}');".format(
e(email), e(password))
def insert_pack(pack_name, points):
return "INSERT INTO packs VALUES (NULL, {0}, {1});".format(
e(pack_name), ei(points))
def insert_trade_cards(trade_id, card_id, from_id, desired):
raw = "INSERT INTO `trade_cards` (`trade_id` ,`card_id` ,`from_id` ,`desired`) VALUES ({0}, {1}, {2}, {3})"
return raw.format(ei(trade_id), ei(card_id), ei(from_id), e(desired))
from MySQLdb import escape_string as e
# This makes sure the value looks like an int to start with.
ei = lambda val: e(str(int(val)))
# A decorator so we don't always have to do `print stmt; return stmt` at the end
def print_and_return(func):
def pr_wrapper(*arg, **kwargs):
res = func(*arg, **kwargs)
print res
return res
return pr_wrapper
@print_and_return
def login(email, password):
return "SELECT * FROM users WHERE email='{0}' AND password=MD5('{1}');".format(
e(email), e(password))
@print_and_return
def get_user(user_id):
return "SELECT * FROM users WHERE id={0} LIMIT 1;".format(ei(user_id))
@print_and_return
def get_other_users(user_id):
return "SELECT id, full_name FROM users WHERE id != {0}".format(
ei(user_id))