Example #1
0
 def get_user_id(cls, field_name, field_value):
     db_conf, tb_shard = models.get_db_table(field_value)
     cnn = Connection(*db_conf)
     try:
         tb_name = '%s_%d' % (cls.__tablename__, tb_shard,)
         sql = 'SELECT `user_id` FROM `%s` WHERE `field_name`=%%s AND `field_value`=%%s' % (tb_name,)
         row = cnn.get(sql, field_name, field_value)
         return row.user_id
     finally:
         cnn.close()
Example #2
0
 def get_friends(cls, user_id):
     """返回好友列表"""
     db_conf, tb_shard = models.get_db_table(user_id)
     cnn = Connection(*db_conf)
     try:
         tb_name = '%s_%d' % (cls.__tablename__, tb_shard,)
         sql = 'SELECT `id`, `user_id`, `friend_id`, `created_at` FROM `%s` WHERE `user_id`=%%s' % (tb_name,)
         iter = cnn.iter(sql, user_id)
         return [cls(**row) for row in iter]
     finally:
         cnn.close()
Example #3
0
 def get_user_id(cls, field_name, field_value):
     db_conf, tb_shard = models.get_db_table(field_value)
     cnn = Connection(*db_conf)
     try:
         tb_name = '%s_%d' % (
             cls.__tablename__,
             tb_shard,
         )
         sql = 'SELECT `user_id` FROM `%s` WHERE `field_name`=%%s AND `field_value`=%%s' % (
             tb_name, )
         row = cnn.get(sql, field_name, field_value)
         return row.user_id
     finally:
         cnn.close()