diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2012-07-28 17:05:50 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2012-07-28 17:05:50 -0400 |
| commit | 22ba1c43b792953ae6f791512d276739c8c09eae (patch) | |
| tree | bdf9f639b01426a8a2e1c8c61d35533026dd4265 /examples/inheritance | |
| parent | 27913554a85c308d81e6c018669d0246ceecc639 (diff) | |
| download | sqlalchemy-22ba1c43b792953ae6f791512d276739c8c09eae.tar.gz | |
-whitespace bonanza, contd
Diffstat (limited to 'examples/inheritance')
| -rw-r--r-- | examples/inheritance/concrete.py | 4 | ||||
| -rw-r--r-- | examples/inheritance/joined.py | 20 | ||||
| -rw-r--r-- | examples/inheritance/single.py | 6 |
3 files changed, 15 insertions, 15 deletions
diff --git a/examples/inheritance/concrete.py b/examples/inheritance/concrete.py index 84fc79cd5..75741df6d 100644 --- a/examples/inheritance/concrete.py +++ b/examples/inheritance/concrete.py @@ -4,13 +4,13 @@ from sqlalchemy.orm import mapper, sessionmaker, polymorphic_union metadata = MetaData() -managers_table = Table('managers', metadata, +managers_table = Table('managers', metadata, Column('employee_id', Integer, primary_key=True), Column('name', String(50)), Column('manager_data', String(40)) ) -engineers_table = Table('engineers', metadata, +engineers_table = Table('engineers', metadata, Column('employee_id', Integer, primary_key=True), Column('name', String(50)), Column('engineer_info', String(40)) diff --git a/examples/inheritance/joined.py b/examples/inheritance/joined.py index aa4c18518..4d3dc08d0 100644 --- a/examples/inheritance/joined.py +++ b/examples/inheritance/joined.py @@ -12,7 +12,7 @@ class Company(Base): id = Column(Integer, primary_key=True) name = Column(String(50)) - employees = relationship("Person", + employees = relationship("Person", backref='company', cascade='all, delete-orphan') @@ -46,7 +46,7 @@ class Engineer(Person): def __repr__(self): return "Engineer %s, status %s, engineer_name %s, "\ "primary_language %s" % \ - (self.name, self.status, + (self.name, self.status, self.engineer_name, self.primary_language) class Manager(Person): @@ -70,19 +70,19 @@ session = Session(engine) c = Company(name='company1', employees=[ Manager( - name='pointy haired boss', + name='pointy haired boss', status='AAB', manager_name='manager1'), - Engineer(name='dilbert', + Engineer(name='dilbert', status='BBA', - engineer_name='engineer1', + engineer_name='engineer1', primary_language='java'), Person(name='joesmith'), - Engineer(name='wally', + Engineer(name='wally', status='CGG', - engineer_name='engineer2', + engineer_name='engineer2', primary_language='python'), - Manager(name='jsmith', + Manager(name='jsmith', status='ABA', manager_name='manager2') ]) @@ -109,7 +109,7 @@ c = session.query(Company).get(1) for e in c.employees: print e -# query using with_polymorphic. +# query using with_polymorphic. eng_manager = with_polymorphic(Person, [Engineer, Manager], aliased=True) print session.query(eng_manager).\ filter( @@ -127,7 +127,7 @@ print session.query(Company).\ eng_manager, Company.employees ).filter( - or_(eng_manager.Engineer.engineer_name=='engineer1', + or_(eng_manager.Engineer.engineer_name=='engineer1', eng_manager.Manager.manager_name=='manager2') ).all() diff --git a/examples/inheritance/single.py b/examples/inheritance/single.py index a7883fcbf..b2f934120 100644 --- a/examples/inheritance/single.py +++ b/examples/inheritance/single.py @@ -5,11 +5,11 @@ from sqlalchemy.orm import mapper, relationship, sessionmaker metadata = MetaData() # a table to store companies -companies = Table('companies', metadata, +companies = Table('companies', metadata, Column('company_id', Integer, primary_key=True), Column('name', String(50))) -employees_table = Table('employees', metadata, +employees_table = Table('employees', metadata, Column('employee_id', Integer, primary_key=True), Column('company_id', Integer, ForeignKey('companies.company_id')), Column('name', String(50)), @@ -31,7 +31,7 @@ class Engineer(Person): def __repr__(self): return "Engineer %s, status %s, engineer_name %s, "\ "primary_language %s" % \ - (self.name, self.status, + (self.name, self.status, self.engineer_name, self.primary_language) class Manager(Person): def __repr__(self): |
