示例#1
0
class User(db.Model, UserMixin):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(20), unique=True, nullable=False)
    email = db.Column(db.String(100), unique=True, nullable=False)
    password = db.Column(db.String(60), nullable=False)

    def __repr__(self):
        return f"User('{self.username}', '{self.email}')"
示例#2
0
class Condition(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    description = db.Column(db.String(200), nullable=False)
    condition_status = db.Column(db.String(100))
    reporting_date = db.Column(db.String(50))
    resolving_date = db.Column(db.String(50))

    def __repr__(self):
        return f"Condition('{self.description}', '{self.condition_status}', '{self.reporting_date}', '{self.resolving_date}')"
示例#3
0
class Assigned_to(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    first_name = db.Column(db.String(20), nullable=False)
    last_name = db.Column(db.String(20), nullable=False)
    department = db.Column(db.String(20), nullable=False)
    assigned_date = db.Column(db.String(30), nullable=False)
    asset = db.relationship('Asset', backref='asset', lazy=True)

    def __repr__(self):
        return f"Assigned_to('{self.first_name}', '{self.last_name}', '{self.department}', '{self.assigned_date}')"
示例#4
0
class Computer(db.Model):
	serial_number = db.Column(db.String(10), primary_key=True)
	computer_color = db.Column(db.String(50), unique=True, nullable=False)
	memory = db.Column(db.String(50), nullable=False)
	processor = db.Column(db.String(50), nullable=False)
	delivery_date = db.Column(db.DateTime, nullable=False)
	company_id = db.Column(db.Integer, db.ForeignKey('company.id'))
	staff = db.relationship('Staff', backref='computer', lazy=True)
	issues = db.relationship('Issue', secondary=issues, lazy='subquery', backref=db.backref('computer', lazy=True))
	#user = db.relationship('User', backref='username', lazy=True)

	def __repr__(self):
		return f"Computer('{self.serial_number}', '{self.computer_color}', '{self.memory}', '{self.processor}', '{self.delivery_date}'"
示例#5
0
class Company(db.Model):
	id = db.Column(db.Integer, primary_key=True)
	company_name = db.Column(db.String(15), unique=True, nullable=False)
	computers = db.relationship('Computer', backref='company')

	def __repr__(self):
		return f"Company('{self.company_name}')"
示例#6
0
class Issue(db.Model):
	id = db.Column(db.Integer, primary_key=True)
	description = db.Column(db.String(200), nullable=False)
	issue_date = db.Column(db.DateTime, nullable=False, default=datetime)
	#comp_id = db.Column(db.Integer, db.ForeignKey('computer.serial_number'))

	def __repr__(self):
		return f"Issue('{self.description}', '{self.issue_date}'"
示例#7
0
class Staff(db.Model):
	id = db.Column(db.Integer, primary_key=True)
	staff_name = db.Column(db.String(50), unique=True, nullable=False)
	ownership_date = db.Column(db.DateTime, nullable=True)
	comp_id = db.Column(db.Integer, db.ForeignKey('computer.serial_number'))

	def __repr__(self):
		return f"Staff('{self.staff_name}', '{self.ownership_date}'"
示例#8
0
class Asset(db.Model):
    serial_number = db.Column(db.String(10), primary_key=True)
    asset_category = db.Column(db.String(20), nullable=False)
    model_name = db.Column(db.String(20), nullable=False)
    series_name = db.Column(db.String(20))
    asset_color = db.Column(db.String(50), nullable=False)
    memory = db.Column(db.String(50))
    processor = db.Column(db.String(50))
    location = db.Column(db.String(50), nullable=False)
    status = db.Column(db.String(10), nullable=False)
    delivery_date = db.Column(db.String(30), nullable=False)
    condition = db.relationship("Condition",
                                secondary=conditions,
                                lazy='subquery',
                                backref=db.backref('assets', lazy=True))
    assigned_id = db.Column(db.Integer, db.ForeignKey('assigned_to.id'))

    def __repr__(self):
        return f"Asset('{self.serial_number}', '{self.catalogue}', '{self.model_name}', '{self.asset_color}', '{self.memory}', '{self.processor}', '{self.location}', '{self.department}', '{self.assigned_to}', '{self.status}', '{self.delivery_date}', '{self.assigned_date}', '{self.condition}')"
示例#9
0
    username = db.Column(db.String(20), unique=True, nullable=False)
    email = db.Column(db.String(100), unique=True, nullable=False)
    password = db.Column(db.String(60), nullable=False)

    def __repr__(self):
        return f"User('{self.username}', '{self.email}')"


conditions = db.Table(
    'conditions',
    db.Column('condition_id',
              db.Integer,
              db.ForeignKey('condition.id'),
              primary_key=True),
    db.Column('asset_id',
              db.String(10),
              db.ForeignKey('asset.serial_number'),
              primary_key=True))


class Asset(db.Model):
    serial_number = db.Column(db.String(10), primary_key=True)
    asset_category = db.Column(db.String(20), nullable=False)
    model_name = db.Column(db.String(20), nullable=False)
    series_name = db.Column(db.String(20))
    asset_color = db.Column(db.String(50), nullable=False)
    memory = db.Column(db.String(50))
    processor = db.Column(db.String(50))
    location = db.Column(db.String(50), nullable=False)
    status = db.Column(db.String(10), nullable=False)
    delivery_date = db.Column(db.String(30), nullable=False)