class PersonNotes(db.Model):
__tablename__ = 'people_note'
person_id = db.Column(db.Integer, db.ForeignKey('people.unique_id'), primary_key=True)
note = db.Column(db.Text())
def __str__(self):
return 'Person(person_id={}, note={}'.format(self.person_id, self.note)
def __repr__(self):
return str(self)
@staticmethod
def update() -> None:
db.session.commit()
def add(self) -> None:
db.session.add(self)
db.session.commit()
def delete(self) -> None:
db.session.delete(self)
db.session.commit()
def to_json_str(self) -> str:
return self.note
class PersonPhone(db.Model):
__tablename__ = 'person_phone'
unique_id = db.Column(db.Integer(), primary_key=True)
person_id = db.Column(db.Integer(), db.ForeignKey('people.unique_id'))
phone_number = db.Column(db.Integer())
type = db.Column(db.String(15))
def __str__(self):
return 'PersonPhone(unique_id={}, person_id={}, phone_number={}, type={}' \
.format(self.unique_id, self.person_id, self.phone_number, self.type)
def __repr__(self):
return str(self)
@staticmethod
def update() -> None:
db.session.commit()
def add(self) -> None:
db.session.add(self)
db.session.commit()
def delete(self) -> None:
db.session.delete(self)
db.session.commit()
def to_json(self):
return {
'unique_id': self.unique_id,
'person_id': self.person_id,
'phone_number': self.phone_number,
'type': self.type,
}
class PersonWork(db.Model):
__tablename__ = 'people_work'
person_id = db.Column(db.Integer,
db.ForeignKey('people.unique_id'),
primary_key=True)
occupation = db.Column(db.String(50))
occupation_start = db.Column(db.Date())
employer = db.Column(db.String(50))
employer_start = db.Column(db.Date())
level_of_education = db.Column(db.String(20))
def add(self) -> None:
db.session.add(self)
db.session.commit()
def delete(self) -> None:
db.session.delete(self)
db.session.commit()
def to_json(self) -> dict:
return {
'person_id': self.person_id,
'occupation': self.occupation,
'occupation_start': self.occupation_start,
'employer': self.employer,
'employer_start': self.employer_start,
'level_of_education': self.level_of_education
}
class PersonDrivingAccident(db.Model):
__tablename__ = 'person_driving_accident'
unique_id = db.Column(db.Integer(), primary_key=True)
person_id = db.Column(db.Integer(), db.ForeignKey('people.unique_id'))
percent_fault = db.Column(db.Numeric(3))
date_occurred = db.Column(db.Date())
injuries = db.Column(db.Integer())
description = db.Column(db.Text())
paid_by = db.Column(db.String(70))
def __str__(self):
return 'Person(unique_id={}, person_id={}, date_received={}, date_convicted={}, type={}' \
.format(self.unique_id, self.person_id, self.date_received, self.date_convicted, self.type)
def __repr__(self):
return str(self)
@staticmethod
def update() -> None:
db.session.commit()
def add(self) -> None:
db.session.add(self)
db.session.commit()
def delete(self) -> None:
db.session.delete(self)
db.session.commit()
def to_json(self) -> dict:
return {
'unique_id': self.unique_id,
'person_id': self.person_id,
'date_occurred': self.date_occurred,
'percent_fault': self.percent_fault,
'injuries': self.injuries,
'description': self.description,
'paid_by': self.paid_by
}
class PersonDrivingViolation(db.Model):
__tablename__ = 'person_driving_violation'
unique_id = db.Column(db.Integer(), primary_key=True)
person_id = db.Column(db.Integer(), db.ForeignKey('people.unique_id'))
date_received = db.Column(db.Date())
date_convicted = db.Column(db.Date())
type = db.Column(db.Text())
def __str__(self):
return 'Person(unique_id={}, person_id={}, date_received={}, date_convicted={}, type={}' \
.format(self.unique_id, self.person_id, self.date_received, self.date_convicted, self.type)
def __repr__(self):
return str(self)
@staticmethod
def update() -> None:
db.session.commit()
def add(self) -> None:
db.session.add(self)
db.session.commit()
def delete(self) -> None:
db.session.delete(self)
db.session.commit()
def to_json(self) -> dict:
return {
'unique_id': self.unique_id,
'person_id': self.person_id,
'date_received': self.date_received,
'date_convicted': self.date_convicted,
'type': self.type
}