关系型数据库进阶2020.9.25

最新推荐文章于 2024-03-03 10:34:58 发布

dadadadaadadadad

最新推荐文章于 2024-03-03 10:34:58 发布

阅读量74

点赞数

本文链接：https://blog.csdn.net/dadadadaadadadad/article/details/108787054

版权

在这里插入图片描述
关系型数据库进阶


from sqlalchemy import create_engine,MetaData,Table
from sqlalchemy import String,Column,Integer,select,ForeignKey
from sqlalchemy.orm import sessionmaker,relationship
from sqlalchemy.ext.declarative import declarative_base

Base=declarative_base()

engine=create_engine(
    "mysql+pymysql://root:root@127.0.0.1:3306/test?charset=UTF8MB4",
    max_overflow=5,
    pool_size=10,
    echo=True,
)

class User12(Base):
    __tablename__='user12'
    id=Column(Integer,primary_key=True,autoincrement=True)
    name=Column(String(125),nullable=True)
    gender=Column(String(10),nullable=True,default="保密")
    town=Column(String(125))
    language2=relationship('Language2',backref='user12',cascade="all,delete")

class Language2(Base):
    __tablename__='language2'
    id=Column(Integer,primary_key=True,autoincrement=True)
    name=Column(String(125),nullable=True)
    adavantage=Column(String(125),nullable=True)
    disadvantag=Column(String(125),nullable=True)
    user_id=Column(Integer,ForeignKey('user12.id'))

Base.metadata.create_all(engine)
if __name__=='__main__':
    Session=sessionmaker(bind=engine)
    sess=Session()

###  language->user
    u1=User12(name='张三',gender="男",town="北京")
    u2=User12(name='李四',gender="女",town="天津")
    sess.add_all([u1,u2])
    sess.commit()

    l2=Language2(name="python",adavantage="开发快",disadvantag="运行慢")
    l2.user12=u1
    sess.add(l2)
    sess.commit()
#    user->language
#     u1=User11(name='王五',gender="男",town="北京")
#     u1.language=[Language1(name='c',adavantage="稳定",disadvantag="上手慢"),
#                  Language1(name='c++',adavantage="比c更强大",disadvantag="较难")]
#     sess.add(u1)
#     sess.commit()
#######       查找
    # u=sess.query(User11).filter_by(id=9).first()
    # print("name",u.name)
    #
    # lan=sess.query(Language1).filter_by(user_id=u.id)
    # for l in lan:
    #     print("language",l.name)
#######       删除
    # u=sess.query(User11).filter(User11.id==9).first()
    # sess.delete(u)
    # sess.commit()