Spaces:
Sleeping
Sleeping
File size: 1,372 Bytes
1f55012 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
from sqlalchemy import create_engine, URL
from sqlalchemy.orm import DeclarativeBase
Base = DeclarativeBase()
from sqlalchemy.engine import create_engine, URL
from dotenv import load_dotenv
import os
load_dotenv()
MYSQL_USER_NAME=os.getenv('MYSQL_USER_NAME')
MYSQL_PASSWORD=os.getenv('MYSQL_PASSWOR')
MYSQL_PORT=os.getenv('MYSQL_PORT')
MYSQL_DATABASE=os.getenv('MYSQL_DATABASE')
MYSQL_HOST=os.getenv('MYSQL_HOST')
#IF USE DOCKER HOST = host.docker.internal
def get_db_engine():
dsn = URL.create(
drivername="mysql+pymysql",
username=MYSQL_USER_NAME,
password=MYSQL_PASSWORD,
host=MYSQL_HOST,
port=MYSQL_PORT,
database=MYSQL_DATABASE
)
connect_args = {
"ssl_verify_cert": True,
"ssl_verify_identity": True,
"ssl_ca": 'cert.pem',
}
return create_engine(
dsn,
connect_args=connect_args,
)
def get_db_engine1():
dsn = URL.create(
drivername="mysql+pymysql",
username=MYSQL_USER_NAME,
password=MYSQL_PASSWORD,
host=MYSQL_HOST,
port=MYSQL_PORT,
database=MYSQL_DATABASE
)
connect_args = {
"ssl_verify_cert": True,
"ssl_verify_identity": True,
"ssl_ca": 'cert.pem',
}
return create_engine(
dsn,
connect_args=connect_args,
)
|