def update_item_saved_info(item): engine = get_onitsuka_db_engine() item_owner_id = item['owner_id'] item_id = item['item_id'] user_following = Table('user_following', metaData, autoload=True, autoload_with = engine) s = select([user_following.c.user_id], (user_following.c.following_id==item_owner_id)) result = engine.execute(s) user_feed_update_list = list() for follower in result: item_owner_follower_id = follower['user_id'] print item_owner_follower_id user_feed_update_item = {} user_feed_update_item['user_id'] = item_owner_follower_id user_feed_update_item['owner_id'] = item_owner_id user_feed_update_item['item_id'] = item_id user_feed_update_list.append(user_feed_update_item) result.close() user_feed_table = Table('user_feed', metaData, autoload=True, autoload_with = engine) ins = user_feed_table.insert().values(user_id=bindparam('user_id'), owner_id=bindparam('owner_id'), item_id=bindparam('item_id')) engine.execute(ins, user_feed_update_list)
def get_mq_client_id(): engine = get_onitsuka_db_engine() sql = "SELECT mq_client_id FROM allow_user WHERE allow_user = USER()" result = engine.execute(sql) result_first_row = result.fetchone() print result_first_row mq_client_id = result_first_row['mq_client_id'] return mq_client_id