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
