class Appointments(db.Model):
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.DateTime, default=datetime.utcnow())
status = db.Column(db.String())
client = db.relationship("Client", uselist=False)
service = db.relationship("Service", uselist=False)
employee = db.relationship("Employee", uselist=False)
class Service(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(140))
price = db.Column(db.String())
appointments_id = db.Column(db.Integer, db.ForeignKey("appointments.id"))
appointment = db.relationship("Appointments")
sale_id = db.Column(db.Integer, db.ForeignKey("sale.id"))
class Post(db.Model):
id = db.Column(db.Integer, primary_key=True)
body = db.Column(db.String(140))
timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'))
def __repr__(self):
return '<Post {}>'.format(self.body)
class Owner(db.Model):
id = db.Column(db.Integer, primary_key=True)
userId = db.Column(db.Integer, db.ForeignKey("user.id"))
bookId = db.Column(db.Integer, db.ForeignKey("book.id"))
#Constructor
def __init__(self, userId, bookId):
self.userId = userId
self.bookId = bookId
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(64), index=True, unique=True)
email = db.Column(db.String(120), index=True, unique=True)
password_hash = db.Column(db.String(128))
posts = db.relationship('Post', backref='author', lazy='dynamic')
def __repr__(self):
return '<User {}>'.format(self.username)
class Book(db.Model):
id = db.Column(db.Integer, primary_key=True)
isbn = db.Column(db.String(100))
title = db.Column(db.String(100))
author = db.Column(db.String(100))
date = db.Column(db.String(100))
#Constructor
def __init__(self, isbn, title, author, date):
self.isbn = isbn
self.title = title
self.author = author
self.date = date
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
firstName = db.Column(db.String(100))
lastName = db.Column(db.String(100))
email = db.Column(db.String(100))
password = db.Column(db.String(100))
#Constructor
def __init__(self, firstName, lastName, email, password):
self.firstName = firstName
self.lastName = lastName
self.email = email
self.password = password
class Admin(db.Model):
__tablename__ = "admin"
id = db.Column(db.Integer, primary_key=True)
admin = db.Column(db.String(50), unique=True)
password = db.Column(db.String(100))
def __init__(self, admin=admin, password=password):
self.admin = admin
self.generate_password(password)
def generate_password(self, password):
self.password = generate_password_hash(password)
#def check_password(self, password):
# return check_password(self.password, password)
def check_password(self, password):
return check_password_hash(self.password, password)
class Employee(db.Model):
id = db.Column(db.Integer, primary_key=True)
names = db.Column(db.String(64))
email = db.Column(db.String(120))
phone = db.Column(db.String(10))
d_o_b = db.Column(db.DateTime, default=datetime.utcnow())
identification_no = db.Column(db.String(15))
appointments_id = db.Column(db.Integer, db.ForeignKey("appointments.id"))
appointment = db.relationship("Appointments")
sale_id = db.Column(db.Integer, db.ForeignKey("sale.id"))
sale = db.relationship("Sale")
class Projects(db.Model):
id = db.Column(db.Integer, primary_key=True)
code = db.Column(db.String(100))
status = db.Column(db.String(50))
project_name = db.Column(db.String(50))
location = db.Column(db.String(50))
project_status = db.Column(db.String(50))
phase_number = db.Column(db.String(50))
photos = db.relationship("Photos")
class Client(db.Model):
id = db.Column(db.Integer, primary_key=True)
names = db.Column(db.String(64))
email = db.Column(db.String())
phone = db.Column(db.String())
appointments_id = db.Column(db.Integer, db.ForeignKey("appointments.id"))
appointment = db.relationship("Appointments")
sale_id = db.Column(db.Integer, db.ForeignKey("sale.id"))
sale = db.relationship("Sale")
class Peneliti(db.Model):
__tablename__ = "peneliti"
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(50))
email = db.Column(db.String(50))
password = db.Column(db.String(50))
universitas = db.Column(db.String(50))
kategori_penelitian = db.Column(db.String(50))
jenis_kelamin = db.Column(db.Text)
def __init__(self, username, email, password, universitas, jenis_kelamin,
kategori_penelitian):
self.username = username
self.generate_password(password)
self.email = email
self.universitas = universitas
self.kategori_penelitian = kategori_penelitian
self.jenis_kelamin = jenis_kelamin
self.authenticated = False
self.confirmed = False
def address(self, address):
self.address = address
def is_authenticated(self):
return True
def is_anonymous(self):
return True
def check_password(self, password):
return check_password(self.password, password)
def is_confirmed(self):
return self.confirmed
def confirm_user(self):
self.confirmed = True
def get_id(self):
return str(self.user_id)
def generate_password(self, password):
self.password = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password, password)
def __repr__(self):
return "<User %r>" % (self.nama)
class Sale(db.Model):
id = db.Column(db.Integer, primary_key=True)
date = db.Column(db.DateTime, default=datetime.utcnow())
amount_paid = db.Column(db.String())
balance = db.Column(db.String)
employee_com = db.Column(db.String())
payment_mode = db.Column(db.String())
service = db.relationship("Service")
employee = db.relationship("Employee", uselist=False)
client = db.relationship("Client", uselist=False)
class Upload_data(db.Model):
__upload_data__ = "upload_data"
id = db.Column(db.Integer, primary_key=True)
gambar = db.Column(db.Text)
class Photos(db.Model):
id = db.Column(db.Integer, primary_key=True)
photo = db.Column(db.String(100))
projects_id = db.Column(db.Integer, db.ForeignKey("projects.id"))
projects = db.relationship("Projects", back_populates="photos")
