Class ServerGroup

web/pgadmin/model/__init__.py:246–276

Define a server group for the treeview

class ServerGroup(db.Model, UserScopedMixin):
    """Define a server group for the treeview"""
    __tablename__ = 'servergroup'
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey(USER_ID), nullable=False)

    name = db.Column(db.String(128), nullable=False)
    __table_args__ = (db.UniqueConstraint('user_id', 'name'),)

    servers = db.relationship(
        'Server',
        back_populates='servergroup',
        lazy='select',
        cascade=CASCADE_STR
    )

    sharedservers = db.relationship(
        'SharedServer',
        back_populates='servergroup',
        lazy='select',
        cascade=CASCADE_STR
    )

    @property
    def serialize(self):
        """Return object data in easily serializable format"""
        return {
            'id': self.id,
            'user_id': self.user_id,
            'name': self.name,
        }


class Server(db.Model, UserScopedMixin):