connect_string: str=""ifself.DB_TYPE =="mysql":self.DB_PORT = self.DB_PORTifself.DB_PORT > 0else3306connect_string= f"mysql+aiomysql://{self.DB_USER}:{self.DB_PASSWORD}@{self.DB_HOST}:{self.DB_PORT}/{self.DB_NAME}"elifself.DB_TYPE =="mssql": self.DB_PORT= self.DB_PORTif...
connect_string = f"mssql+aioodbc://{self.DB_USER}:{self.DB_PASSWORD}@{self.DB_HOST}{portString}/{self.DB_NAME}?driver=ODBC+Driver+17+for+SQL+Server" elif self.DB_TYPE == "sqlite": # 文件放在sqlitedb目录下 connect_string = f"sqlite+aiosqlite:///app//sqlitedb//{self.DB_NAME}....
from sqlalchemy import create_engine, event, text from azure.identity import DefaultAzureCredential import struct import pyodbc try: azure_credentials = DefaultAzureCredential() TOKEN_URL = "https://database.windows.net/" SQL_COPT_SS_ACCESS_TOKEN = 1256 server = 'azsql-mi-xyz.database.windows...
connect_string: str=""ifself.DB_TYPE =="mysql":self.DB_PORT = self.DB_PORTifself.DB_PORT > 0else3306connect_string= f"mysql+aiomysql://{self.DB_USER}:{self.DB_PASSWORD}@{self.DB_HOST}:{self.DB_PORT}/{self.DB_NAME}"elifself.DB_TYPE =="mssql": self.DB_PORT= self.DB_PORTif...