sqlalchemy

sqlalchemy_tutorial.md

Install sql alchemy

Create and use a virtual environment to avoid libraries conflict between projects:

Install alchemy library:

Import libraries:

from sqlalchemy import *
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import relation, sessionmaker

Connect:

engine = create_engine('mysql+pymysql://maria:123@localhost/brlabs?host=localhost?port=3306')
Base.metadata.create_all(engine)

Map tables to classes:

class Filme(Base):
    __tablename__ = 'filmes'
...
class Diretor(Base):
    __tablename__ = 'diretores'
...

run the script, and you'll see in mysql console: