def get_user(uid):
select_sql = 'select su_screen_name,su_province,su_city,su_description,su_headimg_url,su_blog_url,su_domain_name,' \
'su_gender, su_followers_count,su_friends_count,su_statuses_count,su_birthday,su_verifytype,' \
'su_verifyinfo,su_register_time from weibo_sina_users where su_id = :suid'
con = db_connect.get_con()
rs = db_connect.db_queryone_params(con, select_sql, {'suid': uid})
return rs
def update_weibo_repost(mid, reposts_count):
sql = 'select se_repost_count from weibo_search_data where se_mid = :mid'
args = {'mid': str(mid)}
con = db_connect.get_con()
rs = db_connect.db_queryone_params(con, sql, args)
if reposts_count != rs[0]:
update_sql = 'update weibo_search_data set se_repost_count = :reposts_count where se_mid = :mid'
update_args = {'mid': mid, 'reposts_count': reposts_count}
db_connect.db_dml_parms(con, update_sql, update_args)
db_connect.db_close(con)
def update_weibo_repost(mid, reposts_count):
sql = 'select se_repost_count from weibo_search_data where se_mid = :mid'
args = {'mid': str(mid)}
con = db_connect.get_con()
rs = db_connect.db_queryone_params(con, sql, args)
if reposts_count != rs[0]:
update_sql = 'update weibo_search_data set se_repost_count = :reposts_count where se_mid = :mid'
update_args = {'mid': mid, 'reposts_count': reposts_count}
db_connect.db_dml_parms(con, update_sql, update_args)
db_connect.db_close(con)
def update_repost_comment(**kwargs):
mid = kwargs.get('mid')
reposts = kwargs.get('reposts')
comments = kwargs.get('comments')
sql = 'select se_repost_count, se_comment_count from weibo_search_data where se_mid = :mid'
args = dict(mid=mid)
with db_connect.db_execute() as conn:
rs = db_connect.db_queryone_params(conn, sql, args)
if reposts != rs[0] or comments != rs[1]:
update_sql = (
'update weibo_search_data set se_repost_count = :reposts, se_comment_count = :comments '
'where se_mid = :mid')
update_args = dict(mid=mid, reposts=reposts, comments=comments)
db_connect.db_dml_parms(conn, update_sql, update_args)
def get_repost_comment(mid):
sql = 'select se_repost_count, se_comment_count from weibo_search_data where se_mid = :mid'
args = dict(mid=mid)
with db_connect.db_execute() as con:
rs = db_connect.db_queryone_params(con, sql, args)
return rs