python中mysql数据库框架sqlalchemy的使用

结构：

 

基础链接：

test.py:

# 导入:
from sqlalchemy.orm import sessionmaker, relationship
from sqlalchemy import create_engine
from model.book import book

if __name__ == '__main__':
    Book = book()
    Book.BookAuto = "aaaa"
    print(Book.BookAuto)

    # 初始化数据库连接:
    engine = create_engine('mysql+pymysql://username:password!@hostIp:3306/nover')
    # 创建DBSession类型:
    DBSession = sessionmaker(bind=engine)
    # 创建Session:
    session = DBSession()
    # 创建Query查询，filter是where条件，最后调用one()返回唯一行，如果调用all()则返回所有行:
    user = session.query(book).filter(book.BookName == '汉乡').one()
    # 打印类型和对象的name属性:
    print(user.introduc)
    # 关闭Session:
    session.close()

model中：book.py:

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

# 创建对象的基类:
Base = declarative_base()


class book(Base):
    # 表的名字:
    __tablename__ = 'book'
    # 表的结构:
    bookid = Column(Integer, primary_key=True)
    BookName = Column(String(20))
    CreateDate = Column(String(20))
    BookAuto = Column(String(20))
    statu = Column(Integer)
    zhoudianji = Column(Integer)
    yuedianji = Column(Integer)
    introduc = Column(String(20))
    classifi = Column(String(1000))

 

更多数据库内容参考：

https://www.cnblogs.com/JayeHe/p/7518222.html

-----------------------------------------------------------------------------------------------------------------

为自己视频网站打个小广告：

https://www.wa-pian.com