SQLAlchemy创建各种数据库连接的

向右看齐 2024-04-01 17:35 74阅读 0赞

#### 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')

####     ####