データベース上のUserのLINEプロフィール情報を表示するスクリプト

from linebot import LineBotApi

from smart_schedule.settings import line_env, MySession
from smart_schedule.models import Personal

line_bot_api = LineBotApi(line_env['channel_access_token'])


def main():
    session = MySession()
    with session.begin():
        personals = session.query(Personal).filter(Personal.user_id.startswith('U')).all()
        for personal in personals:
            profile = line_bot_api.get_profile(personal.user_id)
            print(profile)

if __name__ == '__main__':
    main()