class Conversation(db.Model):
__tablename__ = 'conversation'
id = db.Column(db.Integer, primary_key=True)
messages = db.relationship('Message', lazy=True, backref='conversation')
users = db.relationship('User',
secondary=user_conversation,
lazy='subquery',
back_populates='conversations')
group = db.relationship('Group',
lazy=True,
backref='conversation',
uselist=False)
platform_id = db.Column(db.Integer,
db.ForeignKey('platform.id'),
default=1)
external_id = db.Column(db.Integer, default=1)
def __init__(self, users=[], group=None, platform_id=1, external_id=1):
self.users = users
self.group = group
self.platform_id = platform_id
self.external_id = external_id
def __repr__(self):
return '<Conversation %r>' % (self.id)
def obtainUsersInConversation(self):
if not self.group:
return self.users
else:
return self.group.users
class Message(db.Model):
__tablename__ = 'message'
id = db.Column(db.Integer, primary_key=True)
message = db.Column(db.String(128), nullable=False)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
conversation_id = db.Column(db.Integer, db.ForeignKey('conversation.id'))
type = db.Column(db.String(128), default='text')
def __init__(self, message, user_id, conversation_id, type):
self.message = message
self.user_id = user_id
self.conversation_id = conversation_id
self.type = type
def __repr__(self):
return '<Message %r>' % (self.message)
class Group(db.Model):
__tablename__ = 'group'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(128), nullable=False)
users = db.relationship('User',
secondary=user_group,
lazy='subquery',
back_populates='groups')
conversation_id = db.Column(db.Integer, db.ForeignKey('conversation.id'))
def __init__(self, name, users):
self.name = name
self.users = users
def __repr__(self):
return '<Group %r>' % (self.name)
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(128), nullable=False)
conversations = db.relationship('Conversation',
secondary=user_conversation,
lazy='subquery',
back_populates='users')
platform_id = db.Column(db.Integer,
db.ForeignKey('platform.id'),
default=1)
external_id = db.Column(db.String(128), default=1)
groups = db.relationship('Group',
secondary=user_group,
lazy='subquery',
back_populates='users')
# Identification Data: email & password
email = db.Column(db.String(128), nullable=False, unique=True)
password = db.Column(db.String(192), nullable=False)
# New instance instantiation procedure
def __init__(self, name, email, password, platform_id, external_id):
self.name = name
self.email = email
self.password = password
self.platform_id = platform_id
self.external_id = external_id
def addConversation(self, conversation):
self.conversations.append(conversation)
def __repr__(self):
return '<User %r>' % (self.name)
from app.mod_database import db
from sqlalchemy.sql import *
# esta tabla es necesaria para las relaciones muchos a muchos
user_group = db.Table(
'user_group',
db.Column('user_id',
db.Integer,
db.ForeignKey('user.id'),
primary_key=True),
db.Column('group_id',
db.Integer,
db.ForeignKey('group.id'),
primary_key=True))
user_conversation = db.Table(
'user_conversation',
db.Column('user_id',
db.Integer,
db.ForeignKey('user.id'),
primary_key=True),
db.Column('conversation_id',
db.Integer,
db.ForeignKey('conversation.id'),
primary_key=True))
# Define a platform model
class Platform(db.Model):
__tablename__ = 'platform'