day11：SqlAlchemy ORM
一.外键关联，relationship()
| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123 | #!/usr/bin/python#coding=utf-8__author__ = 'yaobin' '''使用 ORM/Schema Type/SQL Expression Language/Engine/ConnectionPooling/Dialect 所有组件对数据进行操作。根据类创建对象，对象转换成SQL，执行SQL。''' '''relationship() 一对多relationship(backred)|relationship(back_populates) 双向一对多''' from sqlalchemy import Table,Column,Integer,ForeignKey,String,create_engine,and_,or_,func,tablefrom sqlalchemy.orm import relationship,sessionmakerfrom sqlalchemy.ext.declarative import declarative_base Base=declarative_base() engine = create_engine("mysql+来自为知笔记(Wiz) |