class Group(BaseUser):
__tablename__ = "group"
active = db.Column(db.Boolean, nullable=False, default=False)
name = db.Column(db.String(100))
description = db.Column(db.String(255))
admin = db.Column(db.Boolean, nullable=False, default=False)
def __repr__(self):
return "<Group %r : %r>" % self.id, self.name
class Role(BaseUser):
__tablename__ = "role"
name = db.Column(db.String(100), nullable=False, unique=True)
description = db.Column(db.String(150), nullable=False)
# if not otherwise stated on the target resource. e.g. monitoring users would be implicit UnixPermission.READ
# this is here to act like a mask -- so we can prevent a "demo users" Role from being able to write changes to
# and endpoint that someone forgot to lock down.
implicit_access = db.Column(db.Enum(UnixPermission), default=UnixPermission.READ)
super_admin = db.Column(db.Boolean, default=False)
def __repr__(self):
return '<Role %r>' % self.name
class Group(db.Model):
__tablename__ = "group"
_id = db.Column("id", db.Integer, primary_key=True)
uid = db.relationship("User",
secondary=uid_gid_association,
backref="group")
active = db.Column(db.Boolean, nullable=False, default=False)
name = db.Column(db.String(100))
description = db.Column(db.String(500))
admin = db.Column(db.Boolean, nullable=False, default=False)
def __repr__(self):
return "<Group %r : %r>" % self.id, self.name
class yamsBox(BaseDashboardUnitWithText):
__tablename__ = "yams_box"
# 25%....2500px, etc.
display_width = db.Column(db.String(10))
display_height = db.Column(db.String(10))
display_position = db.Column(db.Integer)
data_update_interval_seconds = db.Column(db.Integer, default=300)
data_update_method_type = db.Column(db.String(50)) # e.g. polling, etc
data_endpoint_path = db.Column(db.String(255))
data_metric_type = db.Column(db.String(50)) # e.g. "spot" or "series"
response_logic = db.Column(db.String(50)) # e.g. boolean for up/down
response_search_path = db.Column(db.String(1000))
response_search_path_datatype = db.Column(db.String(100))
response_search_path_extended_detail = db.Column(db.String(1000))
response_display_typehint = db.Column(
db.String(100)) # e.g. "list" or "graph"
# enabled = super().active
def __repr__(self):
return "<yamsBox %r : %r %r>" % self.id, self.active, self.last_updated
class User(BaseUser):
__tablename__ = "user"
first_name = db.Column(db.String(50))
last_name = db.Column(db.String(50))
description = db.Column(db.String(255))
# string because ext. #
phone_number = db.Column(db.String(100))
skype_handle = db.Column(db.String(100))
google_handle = db.Column(db.String(100))
email_address = db.Column(db.String(255), unique=True)
password_hash = db.Column(db.String(255), nullable=False)
active = db.Column(db.Boolean, nullable=False, default=False)
def __repr__(self):
return "<User %r : %r %r>" % self.id, self.email_address, self.active
class UserContact(db.Model):
__tablename__ = "user_contact"
_id = db.Column("id", db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
first_name = db.Column(db.String(50), default="", unique=True)
last_name = db.Column(db.String(50), default="", unique=True)
description = db.Column(db.String(500))
# string because ext. #
phone_number = db.Column(db.String(50))
skype_handle = db.Column(db.String(100))
google_handle = db.Column(db.String(100))
email_address = db.Column(db.String(200), unique=True)
class User(db.Model):
__tablename__ = "user"
_id = db.Column("id", db.Integer, primary_key=True)
usercontact_id = db.relationship("UserContact",
uselist=False,
backref="user")
password_hash = db.Column(db.String(255), nullable=False)
active = db.Column(db.Boolean, nullable=False, default=False)
super_admin = db.Column(db.Boolean, default=False)
last_updated = db.Column("last_updated",
db.DateTime,
default=datetime.utcnow())
def __repr__(self):
return "<User %r : %r %r>" % self.id, self.first_name, self.last_name
class BaseDashboardUnitWithText(BaseDashboardUnit):
__abstract__ = True
name = db.Column(db.String(100))
description = db.Column(db.String(255))