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]