Ignore:
Timestamp:
07/01/10 14:51:22 (23 months ago)
Author:
dart
Message:

LoReality?:
o Update: manage database for campaign, missions, pilots...

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/loreality/loreality/model/__init__.py

    r2098 r2099  
    11"""The application's model objects""" 
    2 import sqlalchemy as sa 
    3 from sqlalchemy import orm 
    4  
     2from sqlalchemy import orm, schema, types 
    53from loreality.model import meta 
     4from loreality.model.databases import * 
    65 
    76def init_model(engine): 
    … …  
    1615    meta.engine = engine 
    1716 
    18  
    19 # Non-reflected tables may be defined and mapped at module level 
    20 users_table = sa.Table("Pilots", meta.metadata, 
    21     sa.Column("id", sa.types.Integer, primary_key=True), 
    22     sa.Column("login", sa.types.String(255), nullable=False), 
    23     sa.Column("squadron", sa.types.String(255), nullable=False), 
    24     ) 
    25 mission_table = sa.Table("Missions", meta.metadata, 
    26     sa.Column("id", sa.types.Integer, primary_key=True), 
    27     sa.Column("name", sa.types.String(255), nullable=False), 
    28     ) 
    29  
    30 class User(object): 
    31     pass 
    32  
    33 class Mission(object): 
    34     pass 
     17    metadata = schema.MetaData() 
     18    Base.metadata.create_all(engine) 
    3519 
    3620 
    37 orm.mapper(User, users_table) 
    38 orm.mapper(Mission, mission_table) 
    39  
    40  
    41 ## Classes for reflected tables may be defined here, but the table and 
    42 ## mapping itself must be done in the init_model function 
    43 #reflected_table = None 
    44 # 
    45 #class Reflected(object): 
    46 #    pass 
Note: See TracChangeset for help on using the changeset viewer.