Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
from docassemble.webapp.db_object import db, UserMixin
from docassemble.base.config import daconfig, dbtableprefix
class UserModel(db.Model, UserMixin):
__tablename__ = dbtableprefix + 'user'
id = db.Column(db.Integer, primary_key=True)
social_id = db.Column(db.String(255), nullable=False, unique=True)
nickname = db.Column(db.String(255), nullable=False)
email = db.Column(db.String(255), nullable=True, unique=True, index=True)
confirmed_at = db.Column(db.DateTime())
active = db.Column('active', db.Boolean(), nullable=False, server_default='0')
first_name = db.Column(db.String(255), nullable=False, server_default='')
last_name = db.Column(db.String(255), nullable=False, server_default='')
country = db.Column(db.String(3))
subdivisionfirst = db.Column(db.String(255))
subdivisionsecond = db.Column(db.String(255))
subdivisionthird = db.Column(db.String(255))
organization = db.Column(db.String(255))
timezone = db.Column(db.String(64))
language = db.Column(db.String(64))
user_auth = db.relationship('UserAuthModel', uselist=False, primaryjoin="UserAuthModel.user_id==UserModel.id")
roles = db.relationship('Role', secondary=dbtableprefix + 'user_roles', backref=db.backref(dbtableprefix + 'user', lazy='dynamic'))
password = db.Column(db.String(255), nullable=False, server_default='') # work around a bug
otp_secret = db.Column(db.String(255), nullable=True)
pypi_username = db.Column(db.String(255), nullable=True)
pypi_password = db.Column(db.String(255), nullable=True)
modified_at = db.Column(db.DateTime())
#email_is_phone_number = db.Column(db.Boolean(), nullable=True, server_default='0')
from docassemble.webapp.db_object import db
from docassemble.base.config import daconfig, dbtableprefix
from sqlalchemy import true, false
import docassemble.webapp.users.models
class Uploads(db.Model):
__tablename__ = dbtableprefix + "uploads"
indexno = db.Column(db.Integer(), primary_key=True)
key = db.Column(db.String(250), index=True)
filename = db.Column(db.Text(), index=True)
yamlfile = db.Column(db.Text())
private = db.Column(db.Boolean(), nullable=False, server_default=true())
persistent = db.Column(db.Boolean(), nullable=False, server_default=false())
class UploadsUserAuth(db.Model):
__tablename__ = dbtableprefix + "uploadsuserauth"
id = db.Column(db.Integer(), primary_key=True)
uploads_indexno = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE'), nullable=False, index=True)
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'), index=True)
temp_user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'tempuser.id', ondelete='CASCADE'), index=True)
class UploadsRoleAuth(db.Model):
__tablename__ = dbtableprefix + "uploadsroleauth"
id = db.Column(db.Integer(), primary_key=True)
__tablename__ = dbtableprefix + "shortener"
id = db.Column(db.Integer(), primary_key=True)
short = db.Column(db.String(250), nullable=False, unique=True)
filename = db.Column(db.Text(), index=True)
uid = db.Column(db.String(250))
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
temp_user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'tempuser.id', ondelete='CASCADE'))
key = db.Column(db.Text(), index=True)
index = db.Column(db.Integer())
modtime = db.Column(db.DateTime(), server_default=db.func.now())
class Email(db.Model):
__tablename__ = dbtableprefix + "email"
id = db.Column(db.Integer(), primary_key=True)
short = db.Column(db.String(250), db.ForeignKey(dbtableprefix + 'shortener.short', ondelete='CASCADE'))
all_addr = db.Column(db.Text())
to_addr = db.Column(db.Text())
cc_addr = db.Column(db.Text())
from_addr = db.Column(db.Text())
reply_to_addr = db.Column(db.Text())
return_path_addr = db.Column(db.Text())
subject = db.Column(db.Text())
datetime_message = db.Column(db.DateTime())
datetime_received = db.Column(db.DateTime())
class EmailAttachment(db.Model):
__tablename__ = dbtableprefix + "emailattachment"
id = db.Column(db.Integer(), primary_key=True)
email_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'email.id', ondelete='CASCADE'))
index = db.Column(db.Integer())
content_type = db.Column(db.Text())
extension = db.Column(db.Text())
import docassemble.webapp.users.models
class Uploads(db.Model):
__tablename__ = dbtableprefix + "uploads"
indexno = db.Column(db.Integer(), primary_key=True)
key = db.Column(db.String(250), index=True)
filename = db.Column(db.Text(), index=True)
yamlfile = db.Column(db.Text())
private = db.Column(db.Boolean(), nullable=False, server_default=true())
persistent = db.Column(db.Boolean(), nullable=False, server_default=false())
class UploadsUserAuth(db.Model):
__tablename__ = dbtableprefix + "uploadsuserauth"
id = db.Column(db.Integer(), primary_key=True)
uploads_indexno = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE'), nullable=False, index=True)
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'), index=True)
temp_user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'tempuser.id', ondelete='CASCADE'), index=True)
class UploadsRoleAuth(db.Model):
__tablename__ = dbtableprefix + "uploadsroleauth"
id = db.Column(db.Integer(), primary_key=True)
uploads_indexno = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE'), nullable=False, index=True)
role_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'role.id', ondelete='CASCADE'), nullable=False, index=True)
class ObjectStorage(db.Model):
__tablename__ = dbtableprefix + "objectstorage"
id = db.Column(db.Integer(), primary_key=True)
key = db.Column(db.Text(), index=True)
value = db.Column(db.Text())
class SpeakList(db.Model):
__tablename__ = dbtableprefix + "speaklist"
import docassemble.webapp.users.models
import docassemble.webapp.core.models
from docassemble.base.config import daconfig, dbtableprefix
class Package(db.Model):
__tablename__ = dbtableprefix + 'package'
id = db.Column(db.Integer, primary_key=True, unique=True)
name = db.Column(db.String(255), nullable=False)
type = db.Column(db.Text()) #github, zip, pip
giturl = db.Column(db.String(255), nullable=True)
gitsubdir = db.Column(db.Text(), nullable=True)
upload = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE'))
package_auth = db.relationship('PackageAuth', uselist=False, primaryjoin="PackageAuth.package_id==Package.id")
version = db.Column(db.Integer(), server_default='1')
packageversion = db.Column(db.Text())
limitation = db.Column(db.Text())
dependency = db.Column(db.Boolean(), nullable=False, server_default='0')
core = db.Column(db.Boolean(), nullable=False, server_default='0')
active = db.Column(db.Boolean(), nullable=False, server_default='1')
gitbranch = db.Column(db.String(255), nullable=True)
class PackageAuth(db.Model):
__tablename__ = dbtableprefix + 'package_auth'
id = db.Column(db.Integer, primary_key=True, unique=True)
package_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'package.id', ondelete='CASCADE'))
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
authtype = db.Column(db.String(255), server_default='owner')
class Install(db.Model):
__tablename__ = dbtableprefix + "install"
id = db.Column(db.Integer(), primary_key=True, unique=True)
hostname = db.Column(db.Text())
name = db.Column(db.String(50), unique=True, index=True)
description = db.Column(db.String(255))
class UserRoles(db.Model):
__tablename__ = dbtableprefix + 'user_roles'
id = db.Column(db.Integer(), primary_key=True)
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'), index=True)
role_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'role.id', ondelete='CASCADE'), index=True)
class UserDict(db.Model):
__tablename__ = dbtableprefix + "userdict"
indexno = db.Column(db.Integer(), primary_key=True)
filename = db.Column(db.Text(), index=True)
key = db.Column(db.String(250), index=True)
dictionary = db.Column(db.Text())
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
encrypted = db.Column(db.Boolean(), nullable=False, server_default='1')
modtime = db.Column(db.DateTime())
db.Index(dbtableprefix + 'ix_userdict_key_filename', UserDict.key, UserDict.filename)
class UserDictKeys(db.Model):
__tablename__ = dbtableprefix + "userdictkeys"
indexno = db.Column(db.Integer(), primary_key=True)
filename = db.Column(db.Text(), index=True)
key = db.Column(db.String(250), index=True)
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'), index=True)
temp_user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'tempuser.id', ondelete='CASCADE'), index=True)
db.Index(dbtableprefix + 'ix_userdictkeys_key_filename', UserDict.key, UserDict.filename)
class TempUser(db.Model):
from docassemble.webapp.db_object import db
import docassemble.webapp.users.models
import docassemble.webapp.core.models
from docassemble.base.config import daconfig, dbtableprefix
class Package(db.Model):
__tablename__ = dbtableprefix + 'package'
id = db.Column(db.Integer, primary_key=True, unique=True)
name = db.Column(db.String(255), nullable=False)
type = db.Column(db.Text()) #github, zip, pip
giturl = db.Column(db.String(255), nullable=True)
gitsubdir = db.Column(db.Text(), nullable=True)
upload = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE'))
package_auth = db.relationship('PackageAuth', uselist=False, primaryjoin="PackageAuth.package_id==Package.id")
version = db.Column(db.Integer(), server_default='1')
packageversion = db.Column(db.Text())
limitation = db.Column(db.Text())
dependency = db.Column(db.Boolean(), nullable=False, server_default='0')
core = db.Column(db.Boolean(), nullable=False, server_default='0')
active = db.Column(db.Boolean(), nullable=False, server_default='1')
gitbranch = db.Column(db.String(255), nullable=True)
class PackageAuth(db.Model):
__tablename__ = dbtableprefix + 'package_auth'
id = db.Column(db.Integer, primary_key=True, unique=True)
package_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'package.id', ondelete='CASCADE'))
user_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'user.id', ondelete='CASCADE'))
authtype = db.Column(db.String(255), server_default='owner')
class Install(db.Model):
__tablename__ = dbtableprefix + "install"
id = db.Column(db.Integer(), primary_key=True, unique=True)
class UploadsRoleAuth(db.Model):
__tablename__ = dbtableprefix + "uploadsroleauth"
id = db.Column(db.Integer(), primary_key=True)
uploads_indexno = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE'), nullable=False, index=True)
role_id = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'role.id', ondelete='CASCADE'), nullable=False, index=True)
class ObjectStorage(db.Model):
__tablename__ = dbtableprefix + "objectstorage"
id = db.Column(db.Integer(), primary_key=True)
key = db.Column(db.Text(), index=True)
value = db.Column(db.Text())
class SpeakList(db.Model):
__tablename__ = dbtableprefix + "speaklist"
id = db.Column(db.Integer(), primary_key=True)
filename = db.Column(db.Text(), index=True)
key = db.Column(db.String(250), index=True)
phrase = db.Column(db.Text())
question = db.Column(db.Integer())
type = db.Column(db.String(20))
language = db.Column(db.String(10))
dialect = db.Column(db.String(10))
upload = db.Column(db.Integer(), db.ForeignKey(dbtableprefix + 'uploads.indexno', ondelete='CASCADE'))
encrypted = db.Column(db.Boolean(), nullable=False, server_default=true())
digest = db.Column(db.Text())
class Supervisors(db.Model):
__tablename__ = dbtableprefix + "supervisors"
id = db.Column(db.Integer(), primary_key=True)
hostname = db.Column(db.Text())
url = db.Column(db.Text())
start_time = db.Column(db.DateTime(), server_default=db.func.now())
from docassemble.webapp.db_object import db, UserMixin
from docassemble.base.config import daconfig, dbtableprefix
class UserModel(db.Model, UserMixin):
__tablename__ = dbtableprefix + 'user'
id = db.Column(db.Integer, primary_key=True)
social_id = db.Column(db.String(255), nullable=False, unique=True)
nickname = db.Column(db.String(255), nullable=False)
email = db.Column(db.String(255), nullable=True, unique=True, index=True)
confirmed_at = db.Column(db.DateTime())
active = db.Column('active', db.Boolean(), nullable=False, server_default='0')
first_name = db.Column(db.String(255), nullable=False, server_default='')
last_name = db.Column(db.String(255), nullable=False, server_default='')
country = db.Column(db.String(3))
subdivisionfirst = db.Column(db.String(255))
subdivisionsecond = db.Column(db.String(255))
subdivisionthird = db.Column(db.String(255))
organization = db.Column(db.String(255))
timezone = db.Column(db.String(64))
language = db.Column(db.String(64))
user_auth = db.relationship('UserAuthModel', uselist=False, primaryjoin="UserAuthModel.user_id==UserModel.id")
roles = db.relationship('Role', secondary=dbtableprefix + 'user_roles', backref=db.backref(dbtableprefix + 'user', lazy='dynamic'))
password = db.Column(db.String(255), nullable=False, server_default='') # work around a bug
otp_secret = db.Column(db.String(255), nullable=True)
pypi_username = db.Column(db.String(255), nullable=True)
pypi_password = db.Column(db.String(255), nullable=True)
modified_at = db.Column(db.DateTime())
#email_is_phone_number = db.Column(db.Boolean(), nullable=True, server_default='0')