class SysVars(db.Model):
__bind_key__ = 'general'
__tablename__ = 'sys_vars'
id = db.Column(db.Integer, primary_key=True)
# JSON might be better but SQLite doesn't seem to support it
var_name = db.Column(db.String(100), nullable=False)
var_data = db.Column(db.String(100), nullable=True)
class ScheduleJobMap(db.Model):
__bind_key__ = 'general'
__tablename__ = 'schedule_job_map'
id = db.Column(db.Integer, primary_key=True, nullable=False)
schedule_id = db.Column(db.Integer, db.ForeignKey('schedule.id'))
job_id = db.Column(db.Integer, db.ForeignKey('saved_jobs.id'))
sort = db.Column(db.Integer, default=0)
class CredentialStore(db.Model):
__bind_key__ = 'general'
__tablename__ = 'credential_store'
id = db.Column(db.Integer, primary_key=True)
group_id = db.Column(db.Integer,
db.ForeignKey('credential_group.id'),
nullable=False)
credential_role = db.Column(db.String(100), nullable=False)
credential_data = db.Column(db.String(100))
class SnapshotObjectData(db.Model):
__bind_key__ = 'general'
__tablename__ = 'snapshot_object_data'
id = db.Column(db.Integer, primary_key=True, nullable=False)
path = db.Column(db.String)
snapshot_objects = db.relationship('SnapshotObject',
back_populates='data',
cascade="all, delete, delete-orphan",
lazy=True)
class JobParameter(db.Model):
__bind_key__ = 'general'
__tablename__ = 'job_parameter'
id = db.Column(db.Integer, primary_key=True, nullable=False)
param_name = db.Column(db.String(50), nullable=False, index=True)
param_display_name = db.Column(db.String(50))
param_value = db.Column(db.Text)
job_id = db.Column(db.Integer,
db.ForeignKey('saved_jobs.id'),
nullable=False)
class BackupRecord(db.Model):
__bind_key__ = 'general'
__tablename__ = 'backup_record'
id = db.Column(db.Integer, primary_key=True, nullable=False)
snapshot_id = db.Column(db.String(64))
snap_time = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
backup_set_id = db.Column(db.Integer, db.ForeignKey('backup_set.id'))
backup_set = db.relationship("BackupSet", back_populates="backup_records")
repository_id = db.Column(db.Integer, db.ForeignKey('repository.id'))
repository = db.relationship("Repository", back_populates="backup_records")
class BackupObject(db.Model):
__bind_key__ = 'general'
__tablename__ = 'backup_object'
id = db.Column(db.Integer, primary_key=True, nullable=False)
data = db.Column(db.Text)
time_added = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
backup_set_id = db.Column(db.Integer, db.ForeignKey('backup_set.id'))
backup_set = db.relationship("BackupSet", back_populates="backup_objects")
class RepositoryType(db.Model):
__bind_key__ = 'general'
__tablename__ = 'repository_type'
id = db.Column(db.Integer, primary_key=True, nullable=False)
name = db.Column(db.String(50), nullable=False, unique=True)
type = db.Column(db.String(15), nullable=False) # cloud, local, offsite
internal_binding = db.Column(db.String(30), nullable=False)
description = db.Column(db.Text)
repositories = db.relationship('Repository',
backref='repository_type',
cascade="all, delete, delete-orphan",
lazy=True)
class CredentialGroup(db.Model):
__bind_key__ = 'general'
__tablename__ = 'credential_group'
id = db.Column(db.Integer, primary_key=True)
credentials = db.relationship('CredentialStore',
backref='credential_group',
lazy='subquery')
description = db.Column(db.String(100))
service_name = db.Column(db.String(50), nullable=False)
service_id = db.Column(db.String(50))
time_added = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
class Schedule(db.Model):
__bind_key__ = 'general'
__tablename__ = 'schedule'
id = db.Column(db.Integer, primary_key=True, nullable=False)
name = db.Column(db.String(50), nullable=False, unique=True)
description = db.Column(db.Text)
next_run = db.Column(db.DateTime)
time_unit = db.Column(db.String(20))
time_interval = db.Column(db.Integer)
time_at = db.Column(db.String(20))
days = db.Column(db.String(80))
missed_timeout = db.Column(db.Integer) # in minutes
paused = db.Column(db.Boolean, default=False)
schedule_job_maps = db.relationship('ScheduleJobMap',
backref='schedule',
cascade="all, delete, delete-orphan",
lazy=True)
class SavedJobs(db.Model):
__bind_key__ = 'general'
__tablename__ = 'saved_jobs'
id = db.Column(db.Integer, primary_key=True, nullable=False)
name = db.Column(db.String, nullable=False, unique=True, index=True)
notes = db.Column(db.Text)
engine_class = db.Column(db.String(50), nullable=False, index=True)
time_added = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
history = db.relationship('JobHistory', backref='saved_job', lazy=True)
parameters = db.relationship('JobParameter',
backref='saved_job',
lazy=True)
schedule_job_maps = db.relationship('ScheduleJobMap',
backref='saved_job',
cascade="all, delete, delete-orphan",
lazy=True)
class SnapshotObject(db.Model):
__bind_key__ = 'general'
__tablename__ = 'snapshot_object'
id = db.Column(db.Integer, primary_key=True, nullable=False)
name = db.Column(db.String(150), index=True)
type = db.Column(db.String)
struct_type = db.Column(db.String(50))
data_id = db.Column(db.Integer, db.ForeignKey('snapshot_object_data.id'))
data = db.relationship("SnapshotObjectData",
back_populates="snapshot_objects")
snapshot = db.relationship("Snapshot", back_populates="snapshot_objects")
snapshot_id = db.Column(db.String(200), db.ForeignKey('snapshot.snap_id'))
def to_dict(self):
return dict(id=self.id,
name=self.name,
type=self.type,
path=self.path,
uid=self.uid,
gid=self.gid,
size=self.size,
mode=self.mode,
struct_type=self.struct_type,
modified_time=self.modified_time,
accessed_time=self.accessed_time,
created_time=self.created_time)
class BackupSet(db.Model):
__bind_key__ = 'general'
__tablename__ = 'backup_set'
id = db.Column(db.Integer, primary_key=True, nullable=False)
name = db.Column(db.String(50), nullable=False, unique=True)
type = db.Column(db.Integer, nullable=False)
data = db.Column(db.Text)
source = db.Column(db.String, nullable=True)
concurrent_uses = db.Column(db.Integer, default=1)
timeout = db.Column(db.Integer, default=60)
time_added = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
backup_objects = db.relationship('BackupObject',
back_populates='backup_set',
cascade="all, delete, delete-orphan",
lazy=True)
backup_records = db.relationship('BackupRecord',
back_populates='backup_set',
cascade="all, delete, delete-orphan",
lazy=True)
class Snapshot(db.Model):
__bind_key__ = 'general'
__tablename__ = 'snapshot'
id = db.Column(db.Integer, primary_key=True, nullable=False)
data = db.Column(db.String)
snap_id = db.Column(db.String(64), nullable=False, index=True)
snap_short_id = db.Column(db.String(8))
snap_time = db.Column(db.DateTime)
paths = db.Column(db.Text)
hostname = db.Column(db.String(100))
username = db.Column(db.String(100))
tree = db.Column(db.String(64))
tags = db.Column(db.String)
snapshot_objects = db.relationship('SnapshotObject',
back_populates='snapshot',
cascade="all, delete, delete-orphan",
lazy=True)
repository_id = db.Column(db.Integer, db.ForeignKey('repository.id'))
def to_dict(self):
return dict(id=self.id,
data=self.data,
snap_id=self.snap_id,
snap_short_id=self.snap_short_id,
snap_time=self.snap_time,
paths=self.paths,
hostname=self.hostname,
username=self.username,
tree=self.tree)
class JobHistory(db.Model):
__bind_key__ = 'general'
__tablename__ = 'job_history'
id = db.Column(db.Integer, primary_key=True, nullable=False)
name = db.Column(db.String, nullable=False)
status = db.Column(db.Integer, nullable=False)
type = db.Column(db.String, nullable=False, index=True)
log = db.Column(db.Text)
result = db.Column(db.Text)
time_started = db.Column(db.DateTime)
time_finished = db.Column(db.DateTime)
time_elapsed = db.Column(db.Time)
time_added = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
saved_job_id = db.Column(db.Integer,
db.ForeignKey('saved_jobs.id'),
nullable=True)
class Repository(db.Model):
__bind_key__ = 'general'
__tablename__ = 'repository'
id = db.Column(db.Integer, primary_key=True, nullable=False)
name = db.Column(db.String, index=True)
repo_id = db.Column(db.String)
description = db.Column(db.Text)
cache_repo = db.Column(db.Boolean, default=False)
credential_group_id = db.Column(db.Integer)
data = db.Column(db.Text)
address = db.Column(db.String)
parameters = db.Column(db.Text)
concurrent_uses = db.Column(db.Integer, default=1)
timeout = db.Column(db.Integer, default=60)
repository_type_id = db.Column(db.Integer,
db.ForeignKey('repository_type.id'),
nullable=False)
time_added = db.Column(db.DateTime,
nullable=False,
default=datetime.utcnow)
snapshots = db.relationship("Snapshot",
backref='repository',
cascade="all, delete, delete-orphan",
lazy=True)
backup_records = db.relationship('BackupRecord',
back_populates='repository',
cascade="all, delete, delete-orphan",
lazy=True)
class User(db.Model, UserMixin):
__bind_key__ = 'general'
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)