def get_target(count):
db = db_query.db()
level_table = db.select(table='level', column='*')
for i in level_table:
if int(i['max_counts']) >= count >= int(i['min_counts']):
level = i['content_level']
return level
def select_test(cid):
table = "contents"
columns = "filename"
where = "cid = %s" % cid
db_conn = db.db()
rows = db_conn.select(table, columns, where)
return rows
def update_db_level(post_id, final_level):
db = db_query.db()
rowcount = db.update_level(post_id, final_level)
#affected row 반환
return rowcount
def get_level_from_db(post_id):
db = db_query.db()
table = "contents"
column = "filename, content_level"
where_clause = "cid=%s" % (post_id)
return db.select(table, column, where_clause)[0]