1.连接数据库
engine = create_engine('DB+DBAPI://用户名:密码@主机名:端口号/数据库名称?charset=字符编码', max_overflow=5)
Session = sessionmaker(bind=engine)
session = Session()
2.创建表
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, relationship
from sqlalchemy import create_engine
from sqlalchemy import Column, String, Interger, Foreignkey
from sqlalchemt import join, outerjoin, or_, union, union_all
Base = declarative_base()
class UserType(Base):
__tablename__ = 'usertype'
id = Column(Integer, primary_key=True, autoincrement=True)
title = Column(String(10), nullable=True)
integral = Column(Integer)
class User(Base):
__tablename__ = 'user'
id = Column(Integer, primary_key=True, autoincrement=True)
name = Column(String(10), nullable=True)
gender = Column(String(1), nullable=True)
email = Column(string(30), nullable=True, unique=True)
user_type_id = Column(Interger, primary('usertype.id')
user_type = relationship(UserType, backref='usertype_back')
3.创建表到数据库
Base