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 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 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 Role(db.Model, RoleMixin): ADMIN_ROLENAME = 'admin' id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(80), unique=True) description = db.Column(db.String(255)) def __str__(self): return self.name
class Hubungi(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) pesan = db.Column(db.TEXT, nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) def __repr__(self): return "Hubungi('{self.nama}', '{self.date_posted}')"
class Role(db.Model, RoleMixin): ADMIN_ROLENAME = 'admin' id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(80), unique=True) description = db.Column(db.String(255)) def __init__(self, *args, **kwargs): self.name = kwargs.get('name') self.description = kwargs.get('description')
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 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 Page(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255), nullable=False) content = db.Column(db.Text, 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) slug = db.Column(db.String(255), nullable=False) publish = db.Column(db.Boolean(), nullable=False, server_default='1') user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return "Post('{self.title}', '{self.date_posted}')"
class Tag(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.Unicode(64)) slug = db.Column(db.String(255), nullable=False) def __repr__(self): return f"{self.name}"
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 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 company(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(200), nullable=False) email = db.Column(db.String(100)) location = db.Column(db.String(1000)) description = db.Column(db.String(4000), nullable=False) image_file = db.Column(db.String(200), nullable=False, default='company.jpg') date_joined = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) owner_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"company('{self.name}', '{self.date_joined}')"
class Subscribers(db.Model): id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(120), unique=True, nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) def __repr__(self): return "Hubungi('{self.email}', '{self.date_posted}')"
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 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 Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Post('{self.title}', '{self.date_posted}')"
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 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 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 JadwalMapel(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) guru_id = db.Column(db.Integer, db.ForeignKey('guru.id'), nullable=False) hari = db.Column(db.String(8), nullable=False) mulai = db.Column(db.Time, nullable=False) akhir = db.Column(db.Time, nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
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 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 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 Tag(db.Model): __tablename__ = 'tag' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(32), unique=True, index=True) @staticmethod def insert_tags(): default_tags = ['diagram', 'uml', 'flow_chat'] for strTag in default_tags: tag = Tag(name=strTag) db.session.add(tag) db.session.commit()
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) 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 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) 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