Working with MySQL via SQLAlchemy

# Installing PIP3 Install SQLAlchemy

Import SQLAlchemy

From SQLAlchemy import Create_engine
From sqlalchemy.ext.declarative import declarative_base
From SQLAlchemy import column,integer,string
From Sqlalchemy.orm import Sessionmaker

# Create a connection
Engine = Create_engine ("Mysql+pymysql://root:[email protected]/testdb", encoding= "Utf-8", Echo=true)

# Generate ORM Base class
Base = Declarative_base ()

Class User (Base):
    __tablename__ = ' user '
    id = Column (integer,primary_key=true)
    Name = Column (String (32))
    Password = Column (String (64))

Base.metadata.create_all (Engine)  # CREATE TABLE structure

Session_class = Sessionmaker (bind=engine)  # Create a class with a database connection session
Session = Session_class ()  # generates session instance    #cursor

User_obj = User (name= "Dennis", password= "abc123")    #生成要创建的数据对象
User_obj2 = User (name= "Alex", password= "ABCD")
Print (user_obj.name,user_obj.id)
Session.add (User_obj)
Session.add (USER_OBJ2)

Session.commit ()

Working with MySQL via SQLAlchemy