# @ Time : 2020/4/21 15:40
# @ Author : Ellen
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column,Integer,String
from sqlalchemy.orm import sessionmaker
# localhost
HOSTNAME = '127.0.0.1'
DATABASE = 'demo0419'
PORT = 3306
USERNAME = 'root'
PASSWORD = 'root'
DB_URL = 'mysql+mysqlconnector://{}:{}@{}:{}/{}?charset=utf8'.format(USERNAME, PASSWORD, HOSTNAME, PORT, DATABASE)
engine = create_engine(DB_URL)
Base = declarative_base(engine)
class Article(Base):
__tablename__ = 'article'
id = Column(Integer,primary_key=True,autoincrement=True)
name = Column(String(50), nullable=False)
# Base.metadata.create_all()
article = Article(
Flask-ORM数据增删改查
最新推荐文章于 2024-08-07 09:00:00 发布
本文介绍了如何在Flask应用中利用ORM进行数据库的增删改查操作,包括模型定义、数据库初始化、session使用及各种CRUD操作实例。
摘要由CSDN通过智能技术生成