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

Timestamp:

07/05/10 12:56:53 (23 months ago)

Author:

dart

Message:

LoReality?:
o Add squadrons, pilots.
o Lot of fix
o Some cosmetics

File:

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

trunk/loreality/loreality/model/databases.py

@@ -45 +45 @@
     id = sa.Column(UUID(), primary_key=True,default=uuid.uuid4)
     name = sa.Column(sa.types.String, nullable=False)
+    description = sa.Column(sa.types.String)
 
     missions = orm.relation("Mission", backref="campaign")
@@ -69 +70 @@
         self.name = name
 #----------------------------------------------------------------
+class Squadron(Base):
+    __tablename__ = 'squadrons'
+    id = sa.Column(UUID(), primary_key=True,default=uuid.uuid4)
+    name = sa.Column(sa.types.String, nullable=False)
+    plane = sa.Column(sa.types.String)
+
+    pilots = orm.relation("Pilot", backref="squadron")
+
+
+    def __init__( self, name ):
+        self.name = name
+#----------------------------------------------------------------
 class Pilot(Base):
     __tablename__ = 'pilots'
     id = sa.Column(UUID(), primary_key=True,default=uuid.uuid4)
     name = sa.Column(sa.types.String, nullable=False)
+    login = sa.Column(sa.types.String, nullable=False)
+    squadron_id = sa.Column(UUID(), ForeignKey('squadrons.id'))
 
 
-    def __init__( self, name ):
+    def __init__( self, name, login ):
         self.name = name
+        self.login = login