def apps_new(form):
app_key = _hash_app_key(form.app_name.data)
app_secret = _hash_app_secret(app_key)
app_name = set_default(form.app_name.data)
support_android = set_support(form.support_android.data)
support_ios = set_support(form.support_ios.data)
support_playstore = set_support(form.support_playstore.data)
support_appstore = set_support(form.support_appstore.data)
support_gameflier = set_support(form.support_gameflier.data)
playstore_url = set_default(form.playstore_url.data)
appstore_url = set_default(form.appstore_url.data)
gameflier_url = set_default(form.gameflier_url.data)
gcm_sender_id = set_default(form.gcm_sender_id.data)
gcm_server_api_key = set_default(form.gcm_server_api_key.data)
gcm_config_path = ''
if form.gcm_config_path.data:
gcm_config_path = to_utf8(form.gcm_config_path.data.filename)
facebook_app_name = set_default(form.facebook_app_name.data)
facebook_app_id = set_default(form.facebook_app_id.data)
facebook_app_secret = set_default(form.facebook_app_secret.data)
facebook_api_version = facebook_api_version_value(form.facebook_api_version.data)
status = form.status.data
con, cur = sqlrelay_client_cursor()
cur.prepareQuery('CALL create_app(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)')
cur.inputBind("1", app_key)
cur.inputBind("2", app_secret)
cur.inputBind("3", app_name)
cur.inputBind("4", support_android)
cur.inputBind("5", support_ios)
cur.inputBind("6", support_playstore)
cur.inputBind("7", support_appstore)
cur.inputBind("8", support_gameflier)
cur.inputBind("9", playstore_url)
cur.inputBind("10", appstore_url)
cur.inputBind("11", gameflier_url)
cur.inputBind("12", gcm_sender_id)
cur.inputBind("13", gcm_server_api_key)
cur.inputBind("14", gcm_config_path)
cur.inputBind("15", facebook_app_id)
cur.inputBind("16", facebook_app_name)
cur.inputBind("17", facebook_app_secret)
cur.inputBind("18", facebook_api_version)
cur.inputBind("19", status)
cur.executeQuery()
app_id = cur.getField(0,0)
sqlrelay_client_close(cur, con)
if form.gcm_config_path.data:
# GCM Config 파일저장
_app_save_file(form.gcm_config_path.data, app_id)
def apps_edit(form):
app_id = form.app_id.data
app_name = set_default(form.app_name.data)
support_android = set_support(form.support_android.data)
support_ios = set_support(form.support_ios.data)
support_playstore = set_support(form.support_playstore.data)
support_appstore = set_support(form.support_appstore.data)
support_gameflier = set_support(form.support_gameflier.data)
playstore_url = set_default(form.playstore_url.data)
appstore_url = set_default(form.appstore_url.data)
gameflier_url = set_default(form.gameflier_url.data)
gcm_sender_id = set_default(form.gcm_sender_id.data)
gcm_server_api_key = set_default(form.gcm_server_api_key.data)
gcm_config_path = _app_save_file(form.gcm_config_path.data, app_id)
facebook_app_name = set_default(form.facebook_app_name.data)
facebook_app_id = set_default(form.facebook_app_id.data)
facebook_app_secret = set_default(form.facebook_app_secret.data)
facebook_api_version = facebook_api_version_value(form.facebook_api_version.data)
status = form.status.data
con, cur = sqlrelay_client_cursor()
cur.prepareQuery('CALL update_app(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)')
cur.inputBind("1", app_id)
cur.inputBind("2", app_name)
cur.inputBind("3", support_android)
cur.inputBind("4", support_ios)
cur.inputBind("5", support_playstore)
cur.inputBind("6", support_appstore)
cur.inputBind("7", support_gameflier)
cur.inputBind("8", playstore_url)
cur.inputBind("9", appstore_url)
cur.inputBind("10", gameflier_url)
cur.inputBind("11", gcm_sender_id)
cur.inputBind("12", gcm_server_api_key)
cur.inputBind("13", gcm_config_path)
cur.inputBind("14", facebook_app_id)
cur.inputBind("15", facebook_app_name)
cur.inputBind("16", facebook_app_secret)
cur.inputBind("17", facebook_api_version)
cur.inputBind("18", status)
cur.executeQuery()
sqlrelay_client_close(cur, con)
