def project_table(client_table):
client_column = Column(u"client", MetaData())
client_column.foreign_keys = [ForeignKey(client_table.columns[u"id"])]
project_table = Table(u"project", MetaData(), Column(u"id", Integer()),
Column(u"name", String(50)), client_column)
client_foreign = ForeignKey(client_table.columns[u"id"])
client_foreign.parent = project_table.columns[u"client"]
project_table.foreign_keys = [client_foreign]
return project_table
def client_table():
client_table = Table(u"client", MetaData(), Column(u"id", Integer()),
Column(u"name", String(50)))
client_table.foreign_keys = []
return client_table
