class TomoTag(UserMixin, Model):
"""A user of the app."""
__tablename__ = 'tomotags'
username = Column(db.Integer, nullable=False)
created_at = Column(db.DateTime,
nullable=False,
default=dt.datetime.utcnow)
path = Column(db.String(1000), nullable=False)
hash = Column(db.String(40), nullable=False)
id = Column(db.Integer, unique=True, primary_key=True, autoincrement=True)
# __table_args__ = {'extend_existing': True}
rating = Column(db.Integer, nullable=False)
def __init__(self, username, path, hash, rating, **kwargs):
"""Create instance."""
db.Model.__init__(self,
username=username,
path=path,
hash=hash,
rating=rating,
**kwargs)
def __repr__(self):
"""Represent instance as a unique string."""
return '<Tag({path!r})>'.format(path=self.path)
class Tag(UserMixin, Model):
"""A user of the app."""
__tablename__ = 'tags'
username = Column(db.Integer, nullable=False)
created_at = Column(db.DateTime,
nullable=False,
default=dt.datetime.utcnow)
path = Column(db.String(1000), nullable=False)
hash = Column(db.String(40), nullable=False)
id = Column(db.Integer, unique=True, primary_key=True, autoincrement=True)
# __table_args__ = {'extend_existing': True}
tags = {
'GISAXS':
'Grazing Incidence Small-Angle geometry. Yoneda line, horizon, or specular are visible. Scattering is typically more diffuse.',
'GIWAXS':
'Grazing Incidence Wide-Angle geometry. Yoneda line, horizon, or specular are visible. Scattering is typically more defined.',
'SAXS':
'Small-Angle Transmission geometry. Scattering is typically more diffuse.',
'WAXS':
'Wide-Angle Transmission geometry. Scattering is typically more defined.',
'AgB':
'Silver Behenate calibrant. At least 3 rings with regular spacing.',
'Arc':
'A ring with anisotropic azimuthal intensity (like a bean).',
'Isotropic':
'Radially uniform scattering without rings',
'Peaks':
'Localized intensity spots',
'Ring':
'Isotropic ring',
'Rod':
'Vertical streak-like scattering in Grazing geometry',
'Crystalline':
'Many peaks regularly spaced/patterned in multiple directions',
'Featureless':
'No features visible, i.e. shutter closed or no sample. Exclusive of AgB, Arc, Isotropic, Peaks, Ring, Rod, or Crystalline'
}
for tag in tags:
locals()[tag] = Column(db.Boolean, default=False, nullable=False)
def __init__(self, username, path, hash, **kwargs):
"""Create instance."""
db.Model.__init__(self,
username=username,
path=path,
hash=hash,
**kwargs)
def __repr__(self):
"""Represent instance as a unique string."""
return '<Tag({path!r})>'.format(path=self.path)
class DataFile(Model):
__tablename__ = 'datafiles'
hash = Column(db.String(40), nullable=False, unique=True, primary_key=True)
path = Column(db.String(1000), nullable=False, unique=True)
tagged = Column(db.Integer, nullable=False, default=0)
username = Column(db.Integer, nullable=False)
# __table_args__ = {'extend_existing': True}
def __init__(self, hash, path, username, **kwargs):
db.Model.__init__(self,
hash=hash,
path=path,
username=username,
**kwargs)
def __repr__(self):
"""Represent instance as a unique string."""
return '<DataFile({path!r})>'.format(path=self.path)
class User(UserMixin, SurrogatePK, Model):
"""A user of the app."""
__tablename__ = 'users'
username = Column(db.String(80), unique=True, nullable=False)
email = Column(db.String(80), unique=True, nullable=False)
#: The hashed password
password = Column(db.Binary(128), nullable=True)
created_at = Column(db.DateTime,
nullable=False,
default=dt.datetime.utcnow)
first_name = Column(db.String(30), nullable=True)
last_name = Column(db.String(30), nullable=True)
active = Column(db.Boolean(), default=False)
is_admin = Column(db.Boolean(), default=False)
def __init__(self, username, email, password=None, **kwargs):
"""Create instance."""
db.Model.__init__(self, username=username, email=email, **kwargs)
if password:
self.set_password(password)
else:
self.password = None
def set_password(self, password):
"""Set password."""
self.password = bcrypt.generate_password_hash(password)
def check_password(self, value):
"""Check password."""
return bcrypt.check_password_hash(self.password, value)
@property
def full_name(self):
"""Full user name."""
return '{0} {1}'.format(self.first_name, self.last_name)
def __repr__(self):
"""Represent instance as a unique string."""
return '<User({username!r})>'.format(username=self.username)
class TomoDataFile(Model):
__tablename__ = 'tomodatafiles'
hash = Column(db.String(40), nullable=False, unique=True, primary_key=True)
path = Column(db.String(1000), nullable=False, unique=True)
tagged = Column(db.Integer, nullable=False, default=0)
username = Column(db.Integer, nullable=False)
groupid = Column(db.String(40), nullable=False)
operation = Column(db.String(100), nullable=False)
operationtype = Column(db.String(100), nullable=False)
parameter = Column(db.String(100), nullable=False)
value = Column(db.Float, nullable=False)
# __table_args__ = {'extend_existing': True}
def __init__(self, hash, path, username, groupid, operation, operationtype,
parameter, value, **kwargs):
db.Model.__init__(self,
hash=hash,
path=path,
username=username,
groupid=groupid,
operation=operation,
operationtype=operationtype,
parameter=parameter,
value=value,
**kwargs)
def __repr__(self):
"""Represent instance as a unique string."""
return '<DataFile({path!r})>'.format(path=self.path)
class Role(SurrogatePK, Model):
"""A role for a user."""
__tablename__ = 'roles'
name = Column(db.String(80), unique=True, nullable=False)
user_id = reference_col('users', nullable=True)
user = relationship('User', backref='roles')
def __init__(self, name, **kwargs):
"""Create instance."""
db.Model.__init__(self, name=name, **kwargs)
def __repr__(self):
"""Represent instance as a unique string."""
return '<Role({name})>'.format(name=self.name)