def update_user_info(uid, screen_name, access_key, expires): try: db = MySQL() sql = "SELECT uid FROM users WHERE uid=%d" % uid ret = db.query(sql) if not ret: # 新增用户 sql = "INSERT INTO users(uid,screen_name,access_key,expires) VALUES(%d,'%s','%s',%d)" % ( uid, quote_sql(screen_name), str(access_key), expires, ) else: # 更新用户 sql = "UPDATE users SET screen_name='%s',access_key='%s',expires=%s WHERE uid=%d" % ( quote_sql(screen_name), access_key, expires, uid, ) db.update(sql) return True except Exception as e: return str(e)
def get_status_comments(status_id): try: db = MySQL() sql = "SELECT * FROM comments WHERE post_id=%d ORDER BY pub_time" % status_id ret = db.query(sql) return ret except Exception as e: return str(e)
def show_status(page=0, count=20): ret = [] try: db = MySQL() sql = "SELECT * FROM status ORDER BY pub_time DESC LIMIT %d,%d" % (page * count, count) status = db.query(sql) for s in status: tmp = [] tmp.extend(s) status_id = s[0] comments = get_status_comments(status_id) tmp.append(comments) ret.append(tmp) return ret except Exception as e: return str(e)
def test_db(): db = MySQL() sql = "SELECT * FROM users" ret = db.query(sql) return ret