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 add_status(uid, status): try: db = MySQL() time = get_time(datetime.now()) sql = "INSERT INTO status(status,uid,pub_time) VALUES('%s', %d, '%s')" % (quote_sql(status), int(uid), time) db.update(sql) return True except Exception as e: return str(e)
def add_comment(status_id, uid, comment): try: db = MySQL() time = get_time(datetime.now()) sql = "INSERT INTO comments(post_id, uid, comment, pub_time) VALUES(%d, %d, '%s', '%s')" % ( status_id, uid, quote_sql(comment), time, ) db.update(sql) return True except Exception as e: return str(e)