Flask连接数据库(ORM操作)

Flask连接数据库

from sqlalchemy import create_engine

HOSTNAME = '127.0.0.1'
DATABASE = 'student'
PORT = 3306
USERNAME = 'root'
PASSWORD = 'root'

# 创建数据库引擎
DB_URL = 'mysql+pymysql://{}:{}@{}:{}/{}'.format(USERNAME, PASSWORD,
			HOSTNAME, PORT, DATABASE)
engine = create_engine(DB_URL)

# 创建连接
with engine.connect() as conn:
    # SQL语句
    result = conn.execute('select * from stu')
    print(result.fetchone())
    

ORM操作数据库

from sqlalchemy import create_engine
from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base

HOSTNAME = "127.0.0.1"
DATABASE = 'student'
PORT = 3306
USERNAME = 'root'
PASSWORD = 'root'

# 创建数据库引擎
DB_URL = 'mysql+mysqlconnector://{}:{}@{}:{}/{}'.format(USERNAME,
		PASSWORD, HOSTNAME, PORT, DATABASE)

engine = create_engine(DB_URL)

# 继承这个函数生成的基类
Base = declarative_base(engine)

# ORM操作数据库
class Test(Base):
    # 定义表的名字
    __tablename__ = 'test'

    # 给一些字段 id name age gender
    # Column 数据类型, 数据的约束 主键 自增  1 2 3
    id = Column(Integer, primary_key=True, autoincrement=True)
    name = Column(String(50), nullable=False)
    gender = Column(Integer, default=1, comment="1为男,2为女")


# 模型映射到数据库中
Base.metadata.create_all()