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)
