### 使用SqlAlchemy连接mysql数据库
"'python
HOST = '127.0.0.1'
PORT = '3306'
DATABASE = 'database_name'
USERNAME = 'root'
PASSWORD = 'root'
'''
连接格式:dialect + driver ://username:password@host:port/database
eg
DB_URL = "mysql + pymysql://{username}:{password}@{host}:{port}/{db}?charset = utf8".format
username = USERNAME,password = PASSWORD,host = HOST,port = PORT,db = DATABASE
然后使用"create_engine"创建一个引擎"engine",然后再调用这个引擎的"connect"方法,就可以得到这个对象,然后就可以通过这个对象对数据库进行操作了。
"'python
engine = create_engine(DB_URL)
"'
判断是否连接成功
'''conn = engine.connect()
result = conn.execute('select 1')
print(result.fetchone())
'''