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))
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))
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))