python3 使用sqlalchemy 连接 mysql 数据库

pip3 install PyMySQL

from sqlalchemy import create_engine

from config import get_config
from sqlalchemy import text

if __name__ == '__main__':
    database = 'mysql'
    host = get_config(f'{database}', 'host')
    port = int(get_config(f'{database}', 'port'))
    username = get_config(f'{database}', 'username')
    password = get_config(f'{database}', 'password')
    database_name = get_config(f'{database}', 'database')

    engine = create_engine('mysql+pymysql://' + f'{username}:{password}@{host}:3306/{database_name}', echo=True)
    sql = 'select clue_url,hbbq_users_id,hbbq_works_id ,id from hbbq_works_doubtful_clue where txt_status = 0 and status = 0'
    conn = engine.connect()
    result = conn.execute(text(sql))
    for row in result:
        print(row)