from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
import urllib

username = "int"
password = urllib.parse.quote_plus("zyMVac)6@_+")  # encoded password
server_ip = "192.168.0.42"  # replace with your actual server IP
database = "ln"

DATABASE_URL = f"mssql+pyodbc://{username}:{password}@{server_ip}/{database}?driver=ODBC+Driver+17+for+SQL+Server"

engine = create_engine(DATABASE_URL, echo=True)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
