SQLAlchemy + PyMySQLでのデータ取得方法

fetch_with_sqlalchemy.py

#!/usr/bin/env python

import sys 
import sqlalchemy as sa

if __name__ == "__main__":
    engine = sa.create_engine(
        "mysql+pymysql://{USER}:{PASS}@{HOST}/{DB}?charset=utf8".format(
            USER=sys.argv[1], PASS=sys.argv[2], HOST=sys.argv[3], DB=sys.argv[4]))

    ret = engine.execute("select account.id, account.name_, ability.detail from account inner join ability on account.id = ability.user_id where ability.detail regexp '.*子.*';")
    dat = ret.fetchall()

    print(dat[:5])