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

ゝ一纸荒年。 2022-05-10 09:34 227阅读 0赞

结构：

![70][]

基础链接：

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.cnblogs.com_JayeHe_p_7518222.html]

\-----------------------------------------------------------------------------------------------------------------

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

[https://www.wa-pian.com][https_www.wa-pian.com]

[70]: /images/20220510/411c157104eb47b99aadd8a2abb2b7bf.png
[https_www.cnblogs.com_JayeHe_p_7518222.html]: https://www.cnblogs.com/JayeHe/p/7518222.html
[https_www.wa-pian.com]: https://www.wa-pian.com