class Siswa(db.Model): # query_class = PostQuery id = db.Column(db.Integer, primary_key=True) nama = db.Column(db.String(255), nullable=False) jenis_kelamin_id = db.Column(db.Integer, db.ForeignKey('jenis_kelamin.id'), nullable=False) agama_id = db.Column(db.Integer, db.ForeignKey('agama.id'), nullable=False) tgl_lahir = db.Column(db.DateTime, nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) alamat = db.Column(db.Text, nullable=False) image_thumb = db.Column(db.String(255), nullable=False, default='default.jpg') slug = db.Column(db.String(255), nullable=False) active = db.Column(db.Boolean(), nullable=False, server_default='1') kelas_id = db.Column(db.Integer, db.ForeignKey('kelas.id')) # absensi = db.relationship('Kehadiran', lazy='dynamic', backref='pelajar') spp_siswa = db.relationship('PembayaranSpp', backref='spp_siswa', lazy=True) absensi = db.relationship('Absen', secondary='kehadiran') nilai_ujian = db.relationship('NilaiUjian', backref='nilai_ujian') def __repr__(self): return "Siswa('{self.nama}', '{self.date_posted}')"
class Kelas(db.Model): id = db.Column(db.Integer, primary_key=True) nama = db.Column(db.String(255), nullable=False) siswas = db.relationship('Siswa', backref='kelas_siswa', lazy=True) jadwal_kelas = db.relationship('JadwalMapel', backref='jadwal_kelas', lazy=True)
class Mapel(db.Model): id = db.Column(db.Integer, primary_key=True) nama = db.Column(db.String(255), nullable=False) absen_mapel = db.relationship('Absen', secondary='kehadiran') jadwal_mapel = db.relationship('JadwalMapel', backref='jadwal_mapel', lazy=True)
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) project_id = db.Column(db.Integer, index=True) email = db.Column(db.String(255), unique=True) password = db.Column(db.String(255), default=lambda: ''.join(random.choice(string.ascii_lowercase) for _ in range(20))) first_name = db.Column(db.String(255)) last_name = db.Column(db.String(255)) current_portal_user_yn = db.Column(db.Boolean) gv_end_del_log = db.Column(db.Date) active = db.Column(db.Boolean()) confirmed_at = db.Column(db.DateTime()) last_login_at = db.Column(db.DateTime()) current_login_at = db.Column(db.DateTime()) last_login_ip = db.Column(db.String(50)) current_login_ip = db.Column(db.String(50)) login_count = db.Column(db.Integer()) is_imported = db.Column(db.Boolean(), default=False) roles = db.relationship( 'Role', secondary=roles_users, backref=db.backref('users', lazy='dynamic'), collection_class=set, ) practices = db.relationship( 'Practice', secondary=practices_users, backref=db.backref('users', lazy='dynamic'), collection_class=set, ) practice_groups = db.relationship( 'PracticeGroup', secondary=practice_groups_users, backref=db.backref('users', lazy='dynamic'), collection_class=set, ) last_update_timestamp = db.Column(db.Integer, nullable=True) def get_id(self): return self.email @property def is_super(self): return self.is_admin or len(self.practice_groups) > 0 @property def is_admin(self): return self.has_role(Role.ADMIN_ROLENAME) @property def is_system(self): return self.email == '*****@*****.**' @property def all_practices(self): return set(self.practices) | set(chain.from_iterable(pg.practices for pg in self.practice_groups)) @property def full_name(self): return '{} {}'.format(self.first_name or '', self.last_name or '').strip() or self.email
class JenisKelamin(db.Model): id = db.Column(db.Integer, primary_key=True) kelamin = db.Column(db.String(255), nullable=False) siswas = db.relationship('Siswa', backref='kelamin', lazy=True) guru = db.relationship('Guru', backref='kelamin_guru', lazy=True) def __repr__(self): return "Post('{self.kelamin}')"
class Agama(db.Model): id = db.Column(db.Integer, primary_key=True) agama = db.Column(db.String(255), nullable=False) siswas = db.relationship('Siswa', backref='agama_siswa', lazy=True) guru = db.relationship('Guru', backref='agama_guru', lazy=True) def __repr__(self): return "Post('{self.agama}')"
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) login_id = db.Column(db.String, unique=True, nullable=False) user_type = db.Column(db.String, nullable=False) name = db.Column(db.String, nullable=False) email = db.Column(db.String, unique=True, nullable=False) school = db.Column(db.String, nullable=False) password = db.Column(db.String(60), nullable=False) posts = db.relationship('Post', backref='author', lazy=True) replies = db.relationship('Reply', backref='replier', lazy=True) def __repr__(self): return f"User('{self.name}', '{self.login_id}', '{self.email}')"
class Kehadiran(db.Model): id = db.Column(db.Integer, primary_key=True) siswa_id = db.Column(db.Integer, db.ForeignKey('siswa.id')) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) mapel_id = db.Column(db.Integer, db.ForeignKey('mapel.id')) absen_id = db.Column(db.Integer, db.ForeignKey('absen.id')) waktu_absen = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) siswas = db.relationship('Siswa', backref='kehadiran_siswa', lazy=True) # user = db.relationship('User', backref='pengabsen', lazy=True) mapel = db.relationship('Mapel', backref='mata_pelajaran', lazy=True) absen = db.relationship('Absen', backref='data_absen', lazy=True)
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(40), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') firstname = db.Column(db.String(40)) lastname = db.Column(db.String(40)) country = db.Column(db.String(40)) designation = db.Column(db.String(40)) password = db.Column(db.String(60), nullable=False) last_seen = db.Column(db.DateTime, default=datetime.utcnow) is_admin = db.Column(db.Boolean, default=False) is_employer = db.Column(db.Boolean, default=False) is_candidate = db.Column(db.Boolean, default=False) is_active = db.Column(db.Boolean, default=False) posts = db.relationship('Post', backref='author', lazy=True) offer = db.relationship('jobs', backref='employer', lazy='dynamic') company = db.relationship('company', backref='company', lazy='dynamic') following = db.relationship('User', secondary=followers, primaryjoin=(followers.c.follower_id == id), secondaryjoin=(followers.c.followee_id == id), backref=db.backref('followers', lazy='dynamic'), lazy='dynamic') followed_by = db.relationship( 'User', secondary=followers, primaryjoin=(followers.c.followee_id == id), secondaryjoin=(followers.c.follower_id == id), backref=db.backref('followees', lazy='dynamic'), lazy='dynamic') def get_reset_token(self, expires_sec=1800): s = Serializer(app.config['SECRET_KEY'], expires_sec) return s.dumps({'user_id': self.id}).decode('utf-8') @staticmethod def verify_reset_token(token): s = Serializer(app.config['SECRET_KEY']) try: user_id = s.loads(token)['user_id'] except: return None return User.query.get(user_id) def __repr__(self): return f"User('{self.username}', '{self.email}', '{self.image_file}')"
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(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.png') password = db.Column(db.String(60), nullable=False) last_seen = db.Column(db.DateTime, default=datetime.utcnow) is_admin = db.Column(db.Boolean, default=False) is_manager = db.Column(db.Boolean, default=False) is_active = db.Column(db.Boolean, default=False) posts = db.relationship('Post', backref='author', lazy=True) def get_reset_token(self,expires_sec=1800): s = Serializer(app.config['SECRET_KEY'],expires_sec) return s.dumps({'user_id': self.id}).decode('utf-8') @staticmethod def verify_reset_token(token): s = Serializer(app.config['SECRET_KEY']) try: user_id = s.loads(token)['user_id'] except: return None return User.query.get(user_id) def __repr__(self): return f"User('{self.username}', '{self.email}', '{self.image_file}')"
class RecruitStatus(db.Model): __tablename__ = 'etl_recruit_status' id = db.Column(db.String(50), db.ForeignKey(Recruit.id), primary_key=True) recruit = db.relationship(Recruit, uselist=False, back_populates="status") status = db.Column(db.String(100)) study_id = db.Column(db.String(100)) first_name = db.Column(db.String(100)) last_name = db.Column(db.String(100)) processed_by = db.Column(db.String(500)) processed_date = db.Column(db.Date) invoice_year = db.Column(db.String(50)) invoice_quarter = db.Column(db.String(50)) reimbursed_status = db.Column(db.String(50)) @property def full_name(self): return '{} {}'.format(self.first_name or '', self.last_name or '') @property def invoice_period(self): return '{} {}'.format( self.invoice_year or '', self.invoice_quarter or '')
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) register_on = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) activate_on = db.Column(db.DateTime) roles_id = db.Column(db.Integer, db.ForeignKey('role.id'), nullable=False, default=1) guru = db.relationship('Kehadiran', lazy='dynamic', backref='guru') def get_reset_token(self, expires_sec=1800): s = Serializer(app.config['SECRET_KEY'], expires_sec) return s.dumps({'user_id': self.id}).decode('utf-8') @staticmethod def verify_reset_token(token): s = Serializer(app.config['SECRET_KEY']) try: user_id = s.loads(token)['user_id'] except: return None return User.query.get(user_id) def __repr__(self): return "User('{self.username}', '{self.email}', '{self.image_file}')"
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) on_update = db.Column(db.DateTime, nullable=False, default=datetime.utcnow, onupdate=datetime.utcnow) content = db.Column(db.Text, nullable=False) image_thumb = db.Column(db.String(255), nullable=False, default='default.jpg') slug = db.Column(db.String(255), nullable=False) publish = db.Column(db.Boolean(), nullable=False, default=True) headline = db.Column(db.Boolean(), nullable=False) dibaca = db.Column(db.Integer, nullable=False, default=0) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) kategori_id = db.Column(db.Integer, db.ForeignKey('kategori.id'), nullable=False) tags = db.relationship('Tag', secondary=post_tags, lazy='dynamic', backref='tagger') comments = db.relationship('Comments', backref='post_comment', lazy='dynamic') def __repr__(self): return "Post('{self.title}', '{self.date_posted}')"
class JadwalUjian(db.Model): id = db.Column(db.Integer, primary_key=True) mapel_id = db.Column(db.Integer, db.ForeignKey('mapel.id'), nullable=False) kelas_id = db.Column(db.Integer, db.ForeignKey('kelas.id'), nullable=False) waktu_ujian = db.Column(db.DateTime, nullable=False) akhir_ujian = db.Column(db.DateTime, nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) nilai = db.relationship('NilaiUjian', backref='jadwal_ujian', lazy=True)
class PracticeRegistration(db.Model): id = db.Column(db.Integer, primary_key=True) code = db.Column(db.String, db.ForeignKey(Practice.code)) date_created = db.Column(db.DateTime, nullable=False) practice = db.relationship(Practice) def __init__(self, *args, **kwargs): self.code = kwargs.get('code') self.date_created = datetime.datetime.now()
class Kategori(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255), nullable=False) slug = db.Column(db.String(255), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) posts = db.relationship('Post', backref='category', lazy=True) def __repr__(self): return "Post('{self.nama_kategori}', '{self.date_posted}')"
class Recruit(db.Model): id = db.Column(db.String(50), primary_key=True) practice_registration_id = db.Column( db.Integer, db.ForeignKey(PracticeRegistration.id)) practice_registration = db.relationship( PracticeRegistration, backref=db.backref('recruits', cascade="all, delete-orphan")) user_id = db.Column(db.Integer, db.ForeignKey(User.id)) user = db.relationship( User, backref=db.backref('recruits', cascade="all, delete-orphan")) nhs_number = db.Column(db.String(20), nullable=False) date_of_birth = db.Column(db.Date, nullable=False) date_recruited = db.Column(db.Date, nullable=False) date_created = db.Column(db.DateTime, nullable=False) status = db.relationship( "RecruitStatus", uselist=False, back_populates="recruit") def __init__(self, *args, **kwargs): self.practice_registration_id = kwargs.get('practice_registration').id self.user_id = kwargs.get('user').id self.nhs_number = kwargs.get('nhs_number') self.date_of_birth = kwargs.get('date_of_birth') self.date_recruited = kwargs.get('date_recruited') self.date_created = datetime.datetime.now() self.id = uuid.uuid1() @property def date_of_birth_day(self): return self.date_of_birth.day @property def date_of_birth_month(self): return self.date_of_birth.month @property def date_of_birth_year(self): return self.date_of_birth.year
class Practice(db.Model): __tablename__ = 'etl_practice' code = db.Column(db.String, primary_key=True) name = db.Column(db.String, nullable=False) ccg_name = db.Column(db.String, nullable=True) address = db.Column(db.String, nullable=True) delegates = db.relationship( "Delegate", back_populates="practice")
class UangSpp(db.Model): id = db.Column(db.Integer, primary_key=True) nilai = db.Column( db.Numeric(precision=8, asdecimal=False, decimal_return_scale=None)) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) edit_posted = db.Column(db.DateTime) pembayaran_spp = db.relationship('PembayaranSpp', backref='pembayaran_spp', lazy=True)
class RecruitSummary(db.Model): __tablename__ = 'etl_recruit_summary' practice_code = db.Column(db.String(500), db.ForeignKey(Practice.code), primary_key=True, nullable=True) practice = db.relationship("Practice", back_populates="recruit_summary") recruited = db.Column(db.Integer) excluded = db.Column(db.Integer) excluded_percentage = db.Column(db.Float) withdrawn = db.Column(db.Integer) withdrawn_percentage = db.Column(db.Float) last_recruited_date = db.Column(db.Date)
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) biografi = db.Column(db.String(255)) roles_id = db.Column(db.Integer, db.ForeignKey('role.id')) active = db.Column(db.Boolean(), nullable=False, default=False) register_on = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) posts = db.relationship('Post', backref='author', lazy=True) pages = db.relationship('Page', backref='author_pages', lazy=True) kategori = db.relationship('Kategori', backref='categories', lazy=True) def __init__(self, **kwargs): super(User, self).__init__(**kwargs) if self.role is None: if self.email == current_app.config['ADMIN_BLOG']: self.active = True self.role = Role.query.filter_by(name='admin').first() else: self.role = Role.query.filter_by(name='writer').first() def get_reset_token(self, expires_sec=1800): s = Serializer(current_app.config['SECRET_KEY'], expires_sec) return s.dumps({'user_id': self.id}).decode('utf-8') @staticmethod def verify_reset_token(token): s = Serializer(current_app.config['SECRET_KEY']) try: user_id = s.loads(token)['user_id'] except: return None return User.query.get(user_id) def __repr__(self): return "User('{self.username}', '{self.email}', '{self.image_file}')"
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(255), unique=True) password = db.Column(db.String(255)) first_name = db.Column(db.String(255)) last_name = db.Column(db.String(255)) active = db.Column(db.Boolean()) confirmed_at = db.Column(db.DateTime()) last_login_at = db.Column(db.DateTime()) current_login_at = db.Column(db.DateTime()) last_login_ip = db.Column(db.String(50)) current_login_ip = db.Column(db.String(50)) login_count = db.Column(db.Integer()) roles = db.relationship( 'Role', secondary=roles_users, backref=db.backref('users', lazy='dynamic')) practices = db.relationship( 'PracticeRegistration', secondary=practice_registrations_users, backref=db.backref('users', lazy='dynamic')) def __init__(self, *args, **kwargs): self.email = kwargs.get('email') self.password = kwargs.get('password') self.first_name = kwargs.get('first_name') self.last_name = kwargs.get('last_name') self.active = 0 def is_admin(self): return self.has_role(Role.ADMIN_ROLENAME) def is_system(self): return self.email == '*****@*****.**' @property def full_name(self): return '{} {}'.format(self.first_name or '', self.last_name or '')
class Role(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20), nullable=False) users = db.relationship('User', backref='role', lazy=True) @staticmethod def insert_roles(): roles = ['admin', 'moderator', 'writer'] for r in roles: role = Role.query.filter_by(name=r).first() if role is None: role = Role(name=r) db.session.add(role) db.session.commit()
class TargetSet(db.Model): __tablename__ = 'targetset' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255)) target = db.relationship('Target', backref='ts', lazy='dynamic') # to establish .targetset attribute on child Target which will refer to parent TargetSet as target.targetset (backref can not be the same as the child column name) def __init__(self, name): self.name = name def __repr__(self): #return '<Target Sets %d>'.format(self.id) return f'{self.name}' def __str__(self): return f'{self.name}'
class Recruit(db.Model): __tablename__ = 'etl_recruit' status = db.Column(db.String(100)) nhs_number = db.Column(db.String(20), nullable=False) study_id = db.Column(db.String(100)) practice_code = db.Column(db.String(100), db.ForeignKey("etl_practice_detail.code"), nullable=True) first_name = db.Column(db.String(100)) last_name = db.Column(db.String(100)) date_of_birth = db.Column(db.Date, nullable=False) civicrm_contact_id = db.Column(db.Integer) civicrm_case_id = db.Column(db.Integer, primary_key=True) recruited_date = db.Column(db.Date, nullable=False) invoice_year = db.Column(db.Integer) invoice_quarter = db.Column(db.String(50)) reimbursed_status = db.Column(db.String(50)) exclusion_reason = db.relationship("ExclusionReason", uselist=False, back_populates="recruit") @property def exclusion_reason_stripped(self): re_tag = re.compile(r'(<!--.*?-->|<[^>]*>)') re_nbsp = re.compile(r'( )') re_amp = re.compile(r'(&)') if self.exclusion_reason: return re_amp.sub('&', re_nbsp.sub('', re_tag.sub('', self.exclusion_reason.details or ''))).strip() else: return '' @property def exclusion_text(self): if len(self.exclusion_reason_stripped) > 0: return f"Excluded: {self.exclusion_reason_stripped}" else: return 'Excluded' @property def full_name(self): return '{} {}'.format(self.first_name or '', self.last_name or '') @property def invoice_period(self): return '{} {}'.format( self.invoice_year or '', self.invoice_quarter or '', ).strip()
class Delegate(db.Model): __tablename__ = 'etl_delegate' practice_code = db.Column(db.String, primary_key=True) instance = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(500)) role = db.Column(db.String(500)) gcp_trained = db.Column(db.Boolean) gv_trained = db.Column(db.Boolean) on_delegation_log_yn = db.Column(db.Boolean) gv_start_del_log = db.Column(db.Date) gv_end_del_log = db.Column(db.Date) gv_phone_a = db.Column(db.String(100)) gv_phone_b = db.Column(db.String(100)) contact_email_add = db.Column(db.String(500), db.ForeignKey(User.email), nullable=True) user = db.relationship(User) primary_contact_yn = db.Column(db.Boolean)
class Comments(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255), nullable=False) email = db.Column(db.String(120)) website = db.Column(db.String(255)) comment = db.Column(db.Text, nullable=False) reply_id = db.Column(db.Integer, db.ForeignKey('comments.id')) date_comment = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) publish = db.Column(db.Boolean()) post_id = db.Column(db.Integer, db.ForeignKey('post.id'), nullable=False) children = db.relationship('Comments', backref=db.backref('reply', remote_side=[id])) def avatar(self, size): digest = md5(self.email.lower().encode('utf-8')).hexdigest() return f'https://www.gravatar.com/avatar/{digest}?d=identicon&s={size}' def __repr__(self): return "Comments('{self.comment}', '{self.date_comment}')"
class Guru(db.Model): id = db.Column(db.Integer, primary_key=True) nama = db.Column(db.String(255), nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) tgl_lahir = db.Column(db.DateTime, nullable=False) agama_id = db.Column(db.Integer, db.ForeignKey('agama.id'), nullable=False) jenis_kelamin_id = db.Column(db.Integer, db.ForeignKey('jenis_kelamin.id'), nullable=False) alamat = db.Column(db.Text, nullable=False) image_thumb = db.Column(db.String(255), nullable=False, default='default.jpg') slug = db.Column(db.String(255), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) jadwal_mapel = db.relationship('JadwalMapel', backref='jadwal_guru', lazy=True)
class Delegate(db.Model): __tablename__ = 'etl_delegationLog' practice_code = db.Column( db.String, db.ForeignKey(Practice.code), primary_key=True) practice = db.relationship(Practice, back_populates="delegates") instance = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(500)) role = db.Column(db.String(500)) gcp_training = db.Column(db.Boolean) gv_trained = db.Column(db.Boolean) on_delegation_log_yn = db.Column(db.Boolean) gv_start_del_log = db.Column(db.Date) gv_end_del_log = db.Column(db.Date) gv_phone_a = db.Column(db.String(100)) gv_phone_b = db.Column(db.String(100)) contact_email_add = db.Column(db.String(500)) primary_contact_yn = db.Column(db.Boolean)
class StaffMember(db.Model): id = db.Column(db.Integer, primary_key=True) practice_registration_id = db.Column( db.Integer, db.ForeignKey(PracticeRegistration.id)) first_name = db.Column(db.String, nullable=False) last_name = db.Column(db.String, nullable=False) date_created = db.Column(db.DateTime, nullable=False) practice_registration = db.relationship( PracticeRegistration, backref=db.backref('staff', cascade="all, delete-orphan")) def __init__(self, *args, **kwargs): self.practice_registration_id = kwargs.get('practice_registration').id self.first_name = kwargs.get('first_name') self.last_name = kwargs.get('last_name') self.date_created = datetime.datetime.now() def full_name(self): return '{} {}'.format(self.first_name or '', self.last_name or '')