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()
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()
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()