class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) password = db.Column(db.String(60), nullable=False) def __repr__(self): return self.username
class Files(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String()) path = db.Column(db.String()) external_path = db.Column(db.String()) cache = db.Column(db.String()) folder = db.Column(db.String())
class Logbook(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String()) info = db.Column(db.String()) dt = db.Column(db.String()) log_type = db.Column(db.String()) vector_id = db.Column(db.Integer, db.ForeignKey("vectors.id"))
class Vectors(db.Model): id = db.Column(db.Integer, primary_key=True) serial = db.Column(db.String()) cert_file = db.Column(db.String()) ip = db.Column(db.String()) name = db.Column(db.String()) guid = db.Column(db.String()) custom_name = db.Column(db.String()) description = db.Column(db.String())
class Vectors(db.Model): id = db.Column(db.Integer, primary_key=True) serial = db.Column(db.String()) cert_file = db.Column(db.String()) ip = db.Column(db.String()) name = db.Column(db.String()) guid = db.Column(db.String()) custom_name = db.Column(db.String()) description = db.Column(db.String()) logbook_items = db.relationship("Logbook", backref="vector", order_by="desc(Logbook.dt)")
class ApplicationStore(db.Model): id = db.Column(db.Integer, primary_key=True) script_name = db.Column(db.Text) author = db.Column(db.Text) website = db.Column(db.Text) description = db.Column(db.Text) icon = db.Column(db.String(20)) installed = db.Column(db.Boolean, default=False) zip_file = db.Column(db.Text) def __repr__(self): return [self.id, self.script_name, self.author, self.website, self.description, self.icon, self.installed, self.zip_file]
class Application(db.Model): id = db.Column(db.Integer, primary_key=True) script_name = db.Column(db.Text) author = db.Column(db.Text) website = db.Column(db.Text) description = db.Column(db.Text) icon = db.Column(db.String(20)) hex_id = db.Column(db.Text) run_in_bkrd = db.Column(db.Boolean, default=False) pid = db.Column(db.Integer, default=None) def __repr__(self): return [self.id, self.script_name, self.author, self.website, self.description, self.icon, self.hex_id, self.run_in_bkrd, self.pid]
class Repositories(db.Model): id = db.Column(db.Integer, primary_key=True) url = db.Column(db.String()) name = db.Column(db.String()) fp = db.Column(db.String()) auto_update = db.Column(db.String())
class PluginStorage(db.Model): id = db.Column(db.Integer, primary_key=True) plugin = db.Column(db.String()) entry_type = db.Column(db.String()) value_json = db.Column(db.String()) vector_id = db.Column(db.Integer)
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(120), nullable=False) password = db.Column(db.String(60), nullable=False)