sqlalchemy 连接数据库

安装sqlachemy

pip install sqlalchemy
如果安装较慢可以使用 豆瓣的 https://pypi.douban.com/simple
pip install -i https://pypi.douban.com/simple sqlalchemy

mysql

需要下载 pymysql
pip install pymysql

from sqlalchemy import create_engine
engine = create_engine('mysql+pymysql://cookiemonster:chocolatechip'
                       '@mysql01.monster.internal/cookies', pool_recycle=3600)

pgsql

需要下载 psycopg2
pip install psycopg2

from sqlalchemy import create_engine
engine_pg = create_engine('postgresql+psycopg2://username:password@localhost:5432/mydb')

sqlite

from sqlalchemy import create_engine
engine_sql = create_engine('sqlite:///cookies.db')
engine2 = create_engine('sqlite:///:memory:')
engine3 = create_engine('sqlite:home/cookiemonster/cookies.db')
engine4 = create_engine('sqlite:///c:\\Users\\cookiemonster\\cookies.db')

添加小编微信 372787553 进入程序员技术交流群