def before_request():
#print(mysql_conn.__file__)
g.db = get_connection()
query = '''select concat('admin/',table_name) as id,table_name as console_shortname from information_schema.tables
where table_schema='games' and table_name <> 'video_game_and_characters' order by table_name;'''
g.menu = g.db.select_no_params(query)
d = {}
d['id'] = 'admin/logout'
d['console_shortname']='logout'
g.menu[1].append(d)
#list comprehension
res = [ i for i in g.menu[1] if not (i['id'] == 'admin/video_game_comments') ]
#filer lambda
#res = list(filter(lambda i: i['id'] != 'admin/video_game_comments', g.menu[1]))
g.menu = (g.menu[0],res)
g.menu_title = 'Admin Sections'
g.console_query = g.db.select_no_params('select id,console_shortname from games.game_console;')
update_header_image = '''update games.video_games set header_image = %s where id = %s;'''
def stop_me():
print("Planned exit Program did not finish!")
sys.exit()
return ''
def db_response(col,msg):
print("\t{} {}".format(col,msg))
return ''
script_name = os.path.abspath(__file__)
#path = '/var/www/blue_print_app/static/images'
path = '/var/www/public/images'
mysql_db = get_connection()
video_game_query = mysql_db.select_query(select_statement)
video_game_data = video_game_query.fetchall()
mysql_db.close_connection()
mysql_db = get_connection()
console_query = mysql_db.select_query(select_consoles)
console_data = console_query.fetchall()
mysql_db.close_connection()
sub_dir=['small','large','header']
nested_dict = {}
d = {}
for row in console_data:
parent_dir = row[0]
if isinstance(row[0], bytes):
parent_dir = row[0].decode()
def before_request():
g.db = get_connection()
def _insert(_query, _params):
mysql_db = get_connection()
r = mysql_db.insert_statement(_query, _params)
mysql_db.close_connection()
print(r)
return ''
def _sql(_query, _param):
mysql_db = get_connection()
query_data = mysql_db.select_params(_query, _param)
mysql_db.close_connection()
return query_data
def before_request():
g.db = get_connection()
query = '''select id,console_name,console_shortname,coalesce(twitter,'') as twitter,coalesce(facebook,'') as facebook from games.game_console;'''
g.menu = g.db.select_no_params(query)
def update_videogame(params): mysql_db = get_connection() mysql_db.update_statement(update_query,params) mysql_db.close_connection() #print(s) return ""
def before_request():
g.db = get_connection()
g.menu_title = 'Game Consoles'
