使用SQLALchemy 连接数据库

sqlalchemy
连接 SQLALCHEMY 连接数据
使用一些配置信息，然后将他们组合成满足条件
的字符串
from sqlalchemy import create_engine

HOSTNAME = ‘127.0.0.1’
PORT = ‘3306’
DATABASE = ‘books’
USERNAME = ‘root’
PASSWORD = ‘mis0120’

DB_URL = ‘mysql+pymysql://{username}:{password}@{host}:{port}/{’
‘db}?charset=utf8’.format(username=USERNAME,
password=PASSWORD,
host=HOSTNAME,port=PORT,db=DATABASE)
engine = create_engine(DB_URL)

判断是否连接成功

conn = engine.connect()
result = conn.execute(“select 1 + 3”)
print(result.fetchone())