I have been using the sqlalchemy for FastAPI. I will be using MySQL in XAMPP.
from sqlalchemy import create_engine, MetaData
import mysql.connector
SQLALCHEMY_DATABASE_URL = "mysql+mysqlconnector://root@localhost/fastapi"
db = mysql.connector.connect(
host='localhost',
username='root',
password='',
database='fastapi'
)
engine = create_engine(
SQLALCHEMY_DATABASE_URL
)
meta= MetaData()
conn = engine.connect()
Should I add the port or not?
from sqlalchemy import MetaData, create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
# engine = create_engine('mysql+pymysql://root:password@localhost:3005/doctors_appoinment')
SQLALCHEMY_DATABASE_URL = "mysql+mysqlconnector://root:@localhost:3306/doctors_appoinment"
engine = create_engine(
SQLALCHEMY_DATABASE_URL,
)
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)
meta = MetaData()
conn = engine.connect()
Base = declarative_base()
You can use this code for connection. And you can mention your port using this.