codegenmain mysql_sqlacodegen 的使用

from sqlalchemy importcreate_engine, MetaDatafrom sqlalchemy.orm importsessionmaker, scoped_sessionfrom sqlalchemy.ext.declarative importdeclarative_basefrom sqlalchemy.pool importQueuePool

HOSTNAME = '127.0.0.1'PORT= '5432'DATABASE= '**'USERNAME= '**'PASSWORD= '**'

#mysqldialect+driver://username:password@host:port/database#DB_URI = "mysql+pymysql://{username}:{password}@{host}:{port}/{db}?charset=utf8".format(username=USERNAME,password=PASSWORD,host=HOSTNAME,port=PORT,db=DATABASE)#postgresql

DB_URI =postgresql://user:password@ip:port/db#1 创建引擎

engine = create_engine(DB_URI, echo=True, pool_size=100, pool_recycle=3600, poolclass=QueuePool, max_overflow=10)#2判断是否连接成功conn = engine.connect()

result = conn.execute('select 1')print(result.fetchone())

# 3创建会话

pass

成功打印：

2020-02-22 21:45:21,353 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES LIKE ''

2020-02-22 21:45:21,353 INFO sqlalchemy.engine.base.Engine {}

2020-02-22 21:45:21,368 INFO sqlalchemy.engine.base.Engine SHOW VARIABLES LIKE 'lower_case_table_names'

2020-02-22 21:45:21,368 INFO sqlalchemy.engine.base.Engine {}

2020-02-22 21:45:21,372 INFO sqlalchemy.engine.base.Engine SELECT DATABASE()

2020-02-22 21:45:21,372 INFO sqlalchemy.engine.base.Engine {}

2020-02-22 21:45:21,374 INFO sqlalchemy.engine.base.Engine show collation where `Charset` = 'utf8mb4' and `Collation` = 'utf8mb4_bin'

2020-02-22 21:45:21,374 INFO sqlalchemy.engine.base.Engine {}

2020-02-22 21:45:21,386 INFO sqlalchemy.engine.base.Engine SELECT CAST('test plain returns' AS CHAR(60)) AS anon_1

2020-02-22 21:45:21,386 INFO sqlalchemy.engine.base.Engine {}

2020-02-22 21:45:21,394 INFO sqlalchemy.engine.base.Engine SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1

2020-02-22 21:45:21,395 INFO sqlalchemy.engine.base.Engine {}

2020-02-22 21:45:21,395 INFO sqlalchemy.engine.base.Engine SELECT CAST('test collated returns' AS CHAR CHARACTER SET utf8mb4) COLLATE utf8mb4_bin AS anon_1

2020-02-22 21:45:21,395 INFO sqlalchemy.engine.base.Engine {}

2020-02-22 21:45:21,400 INFO sqlalchemy.engine.base.Engine select 1

2020-02-22 21:45:21,400 INFO sqlalchemy.engine.base.Engine {}

(1,)

链接失败报错