Changeset 980

Timestamp:

06/18/10 23:38:24 (2 years ago)

Author:

winfried

Message:

Adding chat_Invitation table and ORM object, refs #103

Files:

• HelpIM3/HelpIM/chat/db/classes.py (modified) (1 diff)
• HelpIM3/HelpIM/chat/db/databaseMetadata.py (modified) (3 diffs)
• stable/HelpIM/revision.py (modified) (1 diff)

HelpIM3/HelpIM/chat/db/classes.py

@@ -209 +209 @@
 class ChatMessageComment(object):
     pass
+
+class ChatInvitation(object):
+    pass

HelpIM3/HelpIM/chat/db/databaseMetadata.py

@@ -4 +4 @@
 from sqlalchemy.orm import  mapper, relation
 import datetime
-from HelpIM.chat.db.classes import ChatShift, IPBlock, ChatServerProperties, Conversation, ConversationEvent, ConversationParticipant, ConversationCareSeeker, ConversationCareWorker, ConversationalMessage, ChatConversation, ChatMessage, ConversationQuestion, ConversationFixedChoiceAnswer, ChatQueue, ChatMessageComment
+from HelpIM.chat.db.classes import ChatShift, IPBlock, ChatServerProperties, Conversation, ConversationEvent, ConversationParticipant, ConversationCareSeeker, ConversationCareWorker, ConversationalMessage, ChatConversation, ChatMessage, ConversationQuestion, ConversationFixedChoiceAnswer, ChatQueue, ChatMessageComment, ChatInvitation
 
 
@@ -34 +34 @@
     
     get_ChatMessageComment_MetaData(metadata)
+
+    get_ChatInvitation_Metadata(metadata)
     
     return metadata
@@ -500 +502 @@
     mapper(ChatMessageComment, chat_MessageComment_table)
     return metadata
+
+def get_ChatInvitation_Metadata(metadata):
+    chat_Invitation_table = Table(
+        'chat_Invitation',
+        metadata,
+        Column('chat_Invitation_id',
+               Integer,
+               primary_key=True,
+               autoincrement=True),
+        Column('chat_Invitation_inviter_id',
+               None,
+               ForeignKey('auth_User.user_id'),
+               nullable=False
+               ),
+        Column('chat_Invitation_invitee_id',
+               None,
+               ForeignKey('auth_User.user_id'),
+               nullable=False
+               ),
+        Column('chat_Invitation_invitation_time',
+               DateTime,
+               default=func.now(),
+               nullable=False
+               ),
+        Column('chat_Invitation_invitation_validityStart',
+               DateTime,
+               default=None,
+               ),
+        Column('chat_Invitation_invitation_validityEnd',
+               DateTime,
+               default=None,
+               ),
+        Column('chat_Invitation_invitation_open',
+               Boolean,
+               default=True,
+               )
+        )
+    mapper(ChatInvitation, chat_Invitation_table)
+    return metadata

stable/HelpIM/revision.py

@@ -1 @@
-revision = '956'
+revision = '961'