def save_to_db(conn, date, platform, revenue):
logging.info("=" * 40)
logging.info([date, platform, revenue])
now_string = toolkit.mysql_now()
update_sql = " UPDATE revenue SET \t"
update_sql += " `revenue` = '%s' ,\t" % revenue
update_sql += " `updated_at` = '%s'\t" % now_string
update_sql += ' WHERE\t'
update_sql += " `platform` = '%s' AND\t" % platform
update_sql += " `date` = '%s' ;" % date
stat = toolkit.mysql_execute(conn, update_sql)
if stat > 0:
logging.info("saveToDb:SUCCESS:UPDATE_SQL:[%s][%s]" %
(update_sql, stat))
return True
else:
insert_sql = "INSERT INTO revenue (`date`, `platform`, `revenue`)" \
" VALUES('%s','%s','%s');" \
% (date, platform, revenue)
stat = toolkit.mysql_execute(conn, insert_sql)
if stat > 0:
logging.info("saveToDb:SUCCESS:INSERT_SQL:[%s][%s]" %
(insert_sql, stat))
return True
else:
logging.error("saveToDb:FAIL:INSERT_SQL:[%s][%s]" %
(insert_sql, stat))
return False
def save_to_db(conn, date, appname, country, placement, field_name, value):
logging.info("=" * 40)
logging.info((date, appname, country, placement, field_name, value))
now_string = toolkit.mysql_now()
UPDATE_SQL = "UPDATE ad_summary SET %s = %s ,updated_at = '%s' " \
"WHERE date = '%s' AND platform = '%s' AND app = '%s'" \
" AND country = '%s' ;" % \
(field_name, value, now_string, date, 'facebook', appname, country)
# logging.info("saveToDb:INFO:UPDATE_SQL:[%s]" % (UPDATE_SQL))
stat = toolkit.mysql_execute(conn, UPDATE_SQL)
if stat > 0:
logging.info("saveToDb:SUCCESS:UPDATE_SQL:[%s][%s]" %
(UPDATE_SQL, stat))
return True
elif field_name == 'revenue':
INSERT_SQL = "INSERT INTO ad_summary (date,app,platform,country,%s)" \
" VALUES('%s','%s','facebook','%s',%s);" \
% (field_name, date, appname, country, value)
stat = toolkit.mysql_execute(conn, INSERT_SQL)
if stat > 0:
logging.info("saveToDb:SUCCESS:INSERT_SQL:[%s][%s]" %
(INSERT_SQL, stat))
return True
else:
logging.error("saveToDb:FAIL:INSERT_SQL:[%s][%s]" %
(INSERT_SQL, stat))
return False
else:
logging.info("saveToDb:FAIL:UPDATE_SQL:[%s][%s]" % (UPDATE_SQL, stat))
return False
def save_to_db(conn, mydata):
logging.info("=" * 40)
logging.info(mydata)
now_string = toolkit.mysql_now()
platform = 'googleplay'
update_sql = "UPDATE ad_summary SET\t"
update_sql += "`revenue` = '%s' ,\t" % mydata['revenue']
update_sql += "`updated_at` = '%s' \t" % now_string
update_sql += "WHERE\t"
update_sql += "`date` = '%s' AND \t" % mydata['date']
update_sql += "`app` = '%s' AND \t" % mydata['app']
update_sql += "`country` = '%s' AND\t" % mydata['country']
update_sql += "`platform` = '%s' ;" % platform
stat = toolkit.mysql_execute(conn, update_sql)
if stat > 0:
logging.info("saveToDb:SUCCESS:UPDATE_SQL:[%s][%s]" %
(update_sql, stat))
return True
else:
logging.info("saveToDb:FAIL:UPDATE_SQL:[%s]" % update_sql)
insert_sql = "INSERT INTO ad_summary (`platform`,`country`,`app`,`date`,`revenue`)" \
" VALUES('%s','%s','%s','%s','%s');" \
% (platform, mydata['country'], mydata['app'], mydata['date'], mydata['revenue'])
stat = toolkit.mysql_execute(conn, insert_sql)
if stat > 0:
logging.info("saveToDb:SUCCESS:INSERT_SQL:[%s][%s]" %
(insert_sql, stat))
return True
else:
logging.error("saveToDb:FAIL:INSERT_SQL:[%s][%s]" %
(insert_sql, stat))
return False
def save_to_db_new(conn, model):
table_name = config.googleplay_task["table_name"]
field_list = ["date", "platform", "revenue"]
unique_key = [
"date",
"platform",
]
sql = toolkit.gen_save_sql(table_name, model, field_list, unique_key)
status = False
try:
toolkit.mysql_execute(conn, sql)
status = True
except Exception as e:
logging.error("save_to_db_new():FAIL:[%s][%s]" % (sql, e))
status = False
finally:
return status
def save_to_db(conn, date, request, filled, impression, click, filled_rate,
ctr, ecpm, revenue):
logging.info("=" * 40)
logging.info([
date, request, filled, impression, click, filled_rate, ctr, ecpm,
revenue
])
now_string = toolkit.mysql_now()
UPDATE_SQL = "UPDATE ad_summary " \
"SET request = %s , " \
"filled = %s ," \
"impression = %s ," \
"click = %s ," \
"filled_rate = %s ," \
"ctr = %s ," \
"ecpm = %s ," \
"revenue = %s ," \
"updated_at = '%s' " \
"WHERE date = '%s' AND platform = '%s' AND app = '%s' AND country = '%s';" % (
request, filled, impression, click,
filled_rate, ctr, ecpm, revenue, now_string, date, 'baidu', '99', '99')
stat = toolkit.mysql_execute(conn, UPDATE_SQL)
if stat > 0:
logging.info("saveToDb:SUCCESS:UPDATE_SQL:[%s][%s]" %
(UPDATE_SQL, stat))
return True
else:
logging.info("saveToDb:error:UPDATE_SQL:[%s]" % (UPDATE_SQL))
INSERT_SQL = "INSERT INTO ad_summary (platform,country,app,date," \
"request,filled,impression,click,filled_rate,ctr,ecpm,revenue,updated_at)" \
" VALUES('baidu','99','99','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s');" \
% (date, request, filled, impression, click, filled_rate, ctr, ecpm, revenue, now_string)
stat = toolkit.mysql_execute(conn, INSERT_SQL)
if stat > 0:
logging.info("saveToDb:SUCCESS:INSERT_SQL:[%s][%s]" %
(INSERT_SQL, stat))
return True
else:
logging.error("saveToDb:FAIL:INSERT_SQL:[%s][%s]" %
(INSERT_SQL, stat))
return False
def save_to_db(conn, data):
logging.info("=" * 40)
logging.info(data)
my_data = repack_data(data)
update_sql = get_update_sql(my_data)
# logging.info("saveToDb:INFO:UPDATE_SQL:[%s]" % (update_sql))
stat = toolkit.mysql_execute(conn, update_sql)
if stat > 0:
logging.info("saveToDb:SUCCESS:UPDATE_SQL:[%s][%s]" % (update_sql, stat))
return True
else:
logging.error("saveToDb:FAIL:UPDATE_SQL:[%s][%s]" % (update_sql, stat))
insert_sql = get_insert_sql(my_data)
stat = toolkit.mysql_execute(conn, insert_sql)
if stat > 0:
logging.info("saveToDb:SUCCESS:INSERT_SQL:[%s][%s]" % (insert_sql, stat))
return True
else:
logging.error("saveToDb:FAIL:INSERT_SQL:[%s][%s]" % (insert_sql, stat))
return False