#!/user/bin/python
# -*- encoding:utf-8 -*-
from sqlalchemy import *
from sqlalchemy.orm import *
engine=create_engine("sqlite:///./test.db")
metadata=MetaData()
party=Table('party',metadata,
Column('id',Integer,primary_key=True),
Column('name',String(32),nullable=False),
Column('type',String(32),nullable=False),
)
person=Table('person',metadata,
Column('id',Integer,ForeignKey('party.id'),primary_key=True),
Column('sex',String(15),nullable=False),
Column('email'......
阅读全文