python web页面增删改查_python web 增删改查教你快速入门

1 导入需要的扩展和包from sqlalchemy import create_engine, Column, Integer, String

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy.orm import sessionmaker

2 连接数据库HOSTNAME = '127.0.0.1'

PORT = '3306'

DATABASE = 'movie_cat'

USERNAME = 'root'

PASSWORD = '123456'

DB_URI = 'mysql+pymysql://{}:{}@{}:{}/{}'.format(USERNAME, PASSWORD, HOSTNAME, PORT, DATABASE)

engine = create_engine(DB_URI)

# 所有的类都要继承自`declarative_base`这个函数生成的基类

Base = declarative_base(engine)

3 创建一个表class Person(Base):

# 定义表名为users

__tablename__ = 'person'

id = Column(Integer, primary_key=True)

name = Column(String(50))

age = Column(Integer)

country = Column(String(50))

# 让打印出来的数据更好看&