from sqlalchemy import Column, Integer, String
from untils.conn import Base
class Student(Base):
id = Column(Integer, primary_key=True, autoincrement=True)
s_name = Column(String(10), unique = True, nullable = False)
s_age = Column(Integer, default = 18)
__tablename__ = 'student'
#连接数据库
#mysqp+pymysql://root:12345@127.0.0.1:3306/tornado9
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
db_url = 'mysql+pymysql://root:DENG5rong2hua0!@127.0.0.1:3306/tornado9'
#创建连接
engine = create_engine(db_url)
#模型与数据库关联的基类，模型必须继承Base
Base = declarative_base()
#创建会话（session）
DbSession = sessionmaker(bind = engine)
session = DbSession
1.模型定义：必须继承Base= declarative_base(bind=engine)
2.数据库连接配置：db_url = 'mysql+pymysql://root:DENG5rong2hua0!@127.0.0.1:3306/database'
3.创建连接,：create_engine(连接地址)
4.创建会话对象： DbSession = sessionmaker(bind = engine)
session = DbSession()
增session.add(对象) session.commit()
sessio.add_all().session.commit()
删session.delete() .session.commit()
查filter(模型名，字段==值)
，filter（字段=值）
改filter（条件）.update（{'字段1'：值，‘字段2’：值...}）
