Ejemplo n.º 1
0
            return True
        else:
            return False

    def get_id(self):
        return self.id

    def __repr__(self):
        return '<User %r>' % self.username


tags = db.Table(
    'category_product',
    db.Column('product_id', db.Integer, db.ForeignKey('product.id')),
    db.Column('category_id', db.Integer, db.ForeignKey('category.id')),
    db.Column('created_at', db.DateTime()),
    db.Column('update_at', db.DateTime()),
)


class Category(db.Model, Model):
    id = db.Column(db.Integer(), primary_key=True)
    title = db.Column(db.String(length=100))
    parent_id = db.Column(db.String(length=6))
    created_at = db.Column(db.DateTime())
    update_at = db.Column(db.DateTime())

    def parent(self):
        if self.parent_id:
            return Category.query.get(self.parent_id)
        else:
Ejemplo n.º 2
0
users_in_chat_room = db.Table(
    'users_in_chat_room',
    db.Model.metadata,
    db.Column('chat_room_id',
              db.Integer,
              db.ForeignKey(ChatRoom.id),
              nullable=False,
              index=True,
              primary_key=True),
    db.Column('user_id',
              db.Integer,
              db.ForeignKey(User.id),
              nullable=False,
              index=True,
              primary_key=True),
    db.Column('created', db.DateTime(True), default=now, nullable=False),
)


class Message(Mixins, db.Model):
    __tablename__ = 'messages'

    color = db.Column(db.Integer, index=True, nullable=False)
    message = db.Column(db.String(280), default='', nullable=False)
    user_id = db.Column(db.Integer,
                        db.ForeignKey(User.id),
                        index=True,
                        nullable=False)
    chat_room_id = db.Column(db.Integer,
                             db.ForeignKey(ChatRoom.id),
                             index=True,