python orm模式连接数据库

最新推荐文章于 2024-08-17 23:12:08 发布

原创最新推荐文章于 2024-08-17 23:12:08 发布 · 432 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#python #orm

python 专栏收录该内容

3 篇文章

订阅专栏

from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
from sqlalchemy import Column, Integer, String, DateTime, Boolean
connect_string = 'mysql+pymysql://root:APTX4869KID1412@localhost:3306/news_test?charset=utf8'
Base = declarative_base()
conn = create_engine(connect_string, echo=True)
Session = sessionmaker(bind=conn)
session = Session()

class News(Base):
    __tablename__ = 'ssss'
    id = Column(Integer, primary_key=True)
    title = Column(String(200), nullable=False)
    content = Column(String(2000), nullable=False)
    types = Column(String(10), nullable=False)
    image = Column(String(300))
    author = Column(String(20))
    view_count = Column(Integer)
    created_at = Column(DateTime)



if __name__ == '__main__':
    Base.metadata.create_all(conn)
    insert = News(
        title='标题',
        content='内容',
        types='百家'
    )
    session.add(insert)
    session.commit()