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

Timestamp:

07/12/10 14:48:12 (23 months ago)

Author:

dart

Message:

LoReality?:
o Messager is working

File:

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

trunk/loreality/loreality/model/databases.py

@@ -9 +9 @@
 
 from loreality.model import meta
-import uuid
+import uuid, datetime
 metadata = schema.MetaData()
 
@@ -93 +93 @@
     __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)
+    subject = sa.Column(sa.types.String, nullable=False)
+    from_ = sa.Column(UUID())
     text = sa.Column(sa.types.String)
-    date = sa.Column(sa.types.String)
+    date = sa.Column(sa.types.DateTime)
+    unread = sa.Column( sa.types.Boolean )
     pilot_id = sa.Column(UUID(), ForeignKey('pilots.id'))
+
+    def __init__(self):
+        self.unread = True
+
+    def copy(self):
+        msg = Message()
+        msg.subject = self.subject
+        msg.from_ = self.from_
+        msg.text = self.text
+        msg.date = self.date
+
+        meta.Session.add(msg)
+        return msg
 #----------------------------------------------------------------
 class Pilot(Base):
@@ -107 +121 @@
 
     messages = orm.relation("Message", backref="pilot")
+    messages_unread = sa.Column(sa.types.Integer, nullable=False)
 
     def __init__( self, name, login ):
         self.name = name
         self.login = login
+        self.messages_unread = 0
+
+    def send_message( self, message ):
+        message.date = datetime.datetime.now()
+        self.messages.append( message )
+        if message.unread:
+            self.messages_unread += 1