Changeset 2108 for trunk/loreality/loreality/model/databases.py

Timestamp:

07/06/10 20:14:11 (23 months ago)

Author:

dart

Message:

LoReality?:
o Begin messager

File:

• trunk/loreality/loreality/model/databases.py (modified) (2 diffs)

trunk/loreality/loreality/model/databases.py

@@ -90 +90 @@
         self.name = name
 #----------------------------------------------------------------
+class Message(Base):
+    __tablename__ = 'messages'
+    id = sa.Column(UUID(), primary_key=True,default=uuid.uuid4)
+    title = sa.Column(sa.types.String, nullable=False)
+    from_ = sa.Column(sa.types.String)
+    text = sa.Column(sa.types.String)
+    date = sa.Column(sa.types.String)
+    pilot_id = sa.Column(UUID(), ForeignKey('pilots.id'))
+#----------------------------------------------------------------
 class Pilot(Base):
     __tablename__ = 'pilots'
@@ -97 +106 @@
     squadron_id = sa.Column(UUID(), ForeignKey('squadrons.id'))
 
+    messages = orm.relation("Message", backref="pilot")
 
     def __init__( self, name, login ):