SQLAlchemy创建各种数据库连接的

SQLite 

1. 相对路径

   engine = create_engine('sqlite:///foo.db')

2. 绝对路径

   #Unix/Mac - 4 initial slashes in total
   engine = create_engine('sqlite:absolute/path/to/foo.db')
   #Windows
   engine = create_engine('sqlite:///C:\\path\\to\\foo.db')
   #Windows alternative using raw string
   engine = create_engine(r'sqlite:///C:\path\to\foo.db')

3. 动态定位绝对路劲
   Sqlite连接的相对地址，指的是相对于最外层调用的文件的相对位置，而不是此文件的相对位置。这里我们可以使用动态定位绝对路径的写法。

   # 获取当前文件的绝对路径
   path = __file__.replace(fr"\{os.path.basename(__file__)}", "").replace("\\\\", "\\")
   SQLITE_URI = fr'sqlite:///{path}\foo.db'

4. 内存数据库

   # format 1
   engine = create_engine('sqlite://')
   # format 2
   engine = create_engine('sqlite:///:memory:', echo=True)

PostgreSQL
 

# default
engine = create_engine('postgresql://scott:tiger@localhost/mydatabase')
# psycopg2
engine = create_engine('postgresql+psycopg2://scott:tiger@localhost/mydatabase')
# pg8000
engine = create_engine('postgresql+pg8000://scott:tiger@localhost/mydatabase')

MySQL

# default
engine = create_engine('mysql://scott:tiger@localhost/foo')
# mysql-python
engine = create_engine('mysql+mysqldb://scott:tiger@localhost/foo')
# MySQL-connector-python
engine = create_engine('mysql+mysqlconnector://scott:tiger@localhost/foo')
# OurSQL
engine = create_engine('mysql+oursql://scott:tiger@localhost/foo')

Oracle

engine = create_engine('oracle://scott:tiger@127.0.0.1:1521/sidname')
engine = create_engine('oracle+cx_oracle://scott:tiger@tnsname')

MSSQL

# pyodbc
engine = create_engine('mssql+pyodbc://scott:tiger@mydsn')
# pymssql
engine = create_engine('mssql+pymssql://scott:tiger@hostname:port/dbname')