from sqlalchemy.ext.activemapper import (ActiveMapper, column,
one_to_many, one_to_one,
objectstore)
from sqlalchemy import ForeignKey, String, Integer
import sqlalchemy.ext.activemapper as activemapper
class Person(ActiveMapper):
class mapping:
personIdentifier = column(Integer, primary_key=True)
personName = column(String)
cars = one_to_many('Car',
colname='personIdentifier',
backref='person')
class Dealership(ActiveMapper):
class mapping:
dealershipIdentifier = column(Integer, primary_key=True)
dealershipName = column(String)
class Car(ActiveMapper):
class mapping:
carIdentifier = column(Integer, primary_key=True)
carName = column(String)
personIdentifier = column(Integer,
foreign_key=ForeignKey(
'person.personIdentifier'
)
)
dealershipIdentifier = column(Integer,
foreign_key=ForeignKey(
'dealership.dealershipIdentifier'
)
)
dealership = one_to_one('Dealership',
colname='dealershipIdentifier'
)
