class Customer_Aliases(db.Model):
__tablename__ = 'customer_aliases'
id = db.Column(db.Integer(), primary_key=True)
customer_alias = db.Column(db.String(100))
customer_id = db.Column(db.String(50),
db.ForeignKey('customer_ids.customer_id'))
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(100))
pwdhash = db.Column(db.String())
def __init__(self, username, password):
self.username = username
self.pwdhash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.pwdhash, password)
@property
def is_authenticated(self):
return True
@property
def is_active(self):
return True
@property
def is_anonymous(self):
return False
def get_id(self):
return str(self.id)
class Category(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), unique=True, nullable=True)
item = db.relationship("Item", cascade="all, delete-orphan")
def __init__(self, name):
self.name = name
class Services(db.Model):
__tablename__ = 'services'
customer_id = db.Column(db.Integer, primary_key=True)
customer_name = db.Column(db.String(100))
as_sku = db.Column(db.String(45))
date_added = db.Column(db.DateTime)
class Borrow(db.Model):
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
book_id = db.Column(db.Integer, db.ForeignKey('book.id'), nullable=False)
returned = db.Column(db.Boolean)
def __init__(self, user_id, book_id):
self.returned = False
self.user_id = user_id
self.book_id = book_id
def save(self):
"""Save a student to the database.
This includes creating a new user and editing one.
"""
db.session.add(self)
db.session.commit()
def delete(self):
"""Delete a user from the database.
"""
db.session.delete(self)
db.session.commit()
def __repr__(self):
return '<user_id %d>' % self.user_id
class User(db.Model): id = db.Column(db.Integer , primary_key = True) username = db.Column(db.String(10)) pwdhash = db.Column(db.String()) admin = db.Column(db.Boolean()) def __init__(self,username,password,admin = False): self.username = username self.pwdhash = generate_password_hash(password) #here I need to generate_password_hash of password input self.admin = admin def check_user_password(self,password): return check_password_hash(self.pwdhash,password) def is_admin(self): return self.admin def is_authenticated(self): return True def is_active(self): return True def is_anonymous(self): return False def get_id(self): return self.id
class Customers(db.Model):
__tablename__ = 'customers'
customer_erp_name = db.Column(db.String(100))
customer_ultimate_name = db.Column(db.String(100))
date_added = db.Column(db.DateTime)
hash_value = db.Column(db.String(50), primary_key=True)
class Predio(db.Model):
__tablename__ = 'PREDIOS'
id = db.Column(db.Integer, primary_key=True)
condgnrl = db.Column(db.String(240))
direccion = db.Column(db.String(120))
elimres = db.Column(db.String(120))
numadultos = db.Column(db.Integer)
numninios = db.Column(db.Integer)
proposito = db.Column(db.String(120))
protecventana = db.Column(db.String(120))
suministroagua = db.Column(db.String(120))
form = db.Column(db.Integer, db.ForeignKey('FORMULARIOS.id'))
formulario = db.relationship('Criadero')
def __init__(self,
condgnrl=None,
direccion=None,
elimres=None,
numadultos=None,
numninios=None,
proposito=None,
protecventana=None,
suministroagua=None,
form=None):
self.condgnrl = condgnrl
self.direccion = direccion
self.elimres = elimres
self.numadultos = numadultos
self.numninios = numninios
self.proposito = proposito
self.protecventana = protecventana
self.suministroagua = suministroagua
self.elimres = elimres
self.form = form
class User(db.Model):
__tablename__ = "tb_user"
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255))
password = db.Column(db.String(255))
email = db.Column(db.String(255))
def __init__(self, name, password, email):
self.name = name
self.email = email
self.password = hashlib.md5(password.encode('utf-8')).hexdigest()
def encode_token(self, email):
try:
payload = {
'sub': email,
}
return jwt.encode(payload, 'keramenstruasi', algorithm='HS256')
except Exception as e:
return e
def decode_token(token):
try:
payload = jwt.decode(token, 'keramenstruasi', algorithms='HS256')
return payload['sub']
except jwt.InvalidTokenError:
return 'invalid token'
class Location(db.Model):
"""存储地理位置"""
id = db.Column(db.Integer, primary_key=True)
location_x = db.Column(db.Float)
location_y = db.Column(db.Float)
scale = db.Column(db.Float)
label = db.Column(db.String(255))
class Sales_Orders(db.Model):
__tablename__ = 'sales_orders'
id = db.Column(db.Integer(), primary_key=True)
so_number = db.Column(db.String(50))
customer_id = db.Column(db.String(50),
db.ForeignKey('customer_ids.customer_id'))
class AdminUsers(db.Model): id = db.Column(db.Integer,primary_key = True) username = db.Column(db.String()) pwdhash = db.Column(db.String()) permission = db.Column(db.String()) def __init__(self,username,password,permission = 'R'): self.username = username self.pwdhash = generate_password_hash(password) self.permission = permission def __repr__(self): return '<%s>' % self.username def check_user_password(self,password): return check_password_hash(self.pwdhash,password) def is_admin(self): return True def is_authenticated(self): return True def is_active(self): return True def is_anonymous(self): return False def get_id(self): return self.id
class Company(db.Model):
id = db.Column(db.Integer, primary_key=True)
siren = db.Column(db.String(255))
denomination = db.Column(db.String(255))
region = db.Column(db.String(255))
ville = db.Column(db.String(255))
code_postal = db.Column(db.String(255))
num_dept = db.Column(db.String(255))
date_immatriculation = db.Column(db.DateTime)
code_ape = db.Column(db.String(255))
fiche_identite = db.Column(db.String(255))
def __init__(self, siren, denomination, region, ville, code_postal,
num_dept, date_immatriculation, code_ape, fiche_identite):
self.siren = siren
self.denomination = denomination
self.region = region
self.ville = ville
self.code_postal = code_postal
self.num_dept = num_dept
self.date_immatriculation = date_immatriculation
self.code_ape = code_ape
self.fiche_identite = fiche_identite
def __repr__(self):
return '<Company %d>' % self.id
class Account(UserMixin, db.Model):
"""微信公众平台用户类
开发平台用户, 用来绑定公众号
Attributes:
email (str): 用户邮箱
id (int): 自增键
name (str): 用户名
password_hash (str): 用户密码哈希值
"""
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(255), unique=True)
email = db.Column(db.String(255), unique=True)
password_hash = db.Column(db.String(255))
@property
def password(self):
raise AttributeError('password is not readable attribute')
@password.setter
def password(self, password):
self.password_hash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.password_hash, password)
class Book(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50))
discription = db.Column(db.String(200))
quantity = db.Column(db.Integer)
borrows = relationship("Borrow", backref="book")
def __init__(self, name, discription):
self.name = name
self.discription = discription
self.quantity = 5
def save(self):
"""Save a student to the database.
This includes creating a new user and editing one.
"""
db.session.add(self)
db.session.commit()
def delete(self):
"""Delete a user from the database.
"""
db.session.delete(self)
db.session.commit()
def __repr__(self):
return '<discription %s>' % self.discription
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(255))
pwhash = db.Column(db.String(300))
rol = db.Column(Enum(RolUser))
@property
def is_authenticated(self):
return True
@property
def is_active(self):
return True
@property
def is_anonymous(self):
return False
def get_id(self):
return str(self.id)
def __init__(self, username, pwhash, rol=RolUser.regular):
self.username = username
self.pwhash = generate_password_hash(pwhash)
self.rol = rol
def __repr__(self):
return '<Usuario %r>' % (self.username)
def check_password(self, password):
return check_password_hash(self.pwhash, password)
class VideoLikes(db.Model):
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
video = db.Column(db.Integer(), db.ForeignKey("videos.id"))
ocenio = db.Column(db.Integer(), db.ForeignKey("users.id"))
def __repr__(self):
return self.id
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(100))
def __init__(self, username, password):
self.username = username
@staticmethod
def try_login(username, password):
conn = get_ldap_connection()
conn.simple_bind_s(
'cn=%s,ou=Users,dc=testathon,dc=net' % username, password
)
def is_authenticated(self):
return True
def is_active(self):
return True
def is_anonymous(self):
return False
def get_id(self):
return unicode(self.id)
class Area(db.Model):
__tablename__ = 'area'
code = db.Column(db.Text, nullable=False, primary_key=True)
area = db.Column(db.Text, nullable=False)
def __repr__(self):
return self.area
class Product(db.Model):
__tablename__ = 'products'
id = db.Column(db.Integer, primary_key=True)
sku = db.Column(db.String(200))
name = db.Column(db.String(200))
description = db.Column(db.Text)
brand = db.Column(db.String(200))
price = db.Column(db.Float)
category_id = db.Column(db.Integer,
db.ForeignKey('categories.id'),
nullable=False)
file = db.Column(db.String(200))
created = db.Column(db.DateTime(timezone=False),
nullable=False,
default=datetime.utcnow())
deleted = db.Column(db.Integer, default=0)
def __init__(self, sku, name, description, brand, price, category_id, file,
deleted):
self.sku = sku
self.name = name
self.description = description
self.brand = brand
self.price = price
self.category_id = category_id
self.file = file
self.deleted = deleted
# '[<Product 'producto1'>, <Product 'producto2'>]'
def __repr__(self):
return '<Product %r>' % (self.name)
@property
def serialize(self):
return {'id': self.id, 'price': self.price, 'name': self.name}
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(80), unique=True, nullable=False)
email = db.Column(db.String(120))
def __repr__(self):
return '<User %r>' % self.username
class User(db.Model):
id = db.Column(db.Integer, primary_key=True)
username = db.Column(db.String(100))
pwdhash = db.Column(db.String())
days = db.relationship('Day', backref='user', lazy='dynamic')
exercises = db.relationship('Exercise', backref='user', lazy='dynamic')
def __init__(self, username, password):
self.username = username
self.pwdhash = generate_password_hash(password)
def check_password(self, password):
return check_password_hash(self.pwdhash, password)
@property
def is_authenticated(self):
return True
@property
def is_active(self):
return True
@property
def is_anonymous(self):
return False
def get_id(self):
return str(self.id)
class ProjectEmployeeRole(db.Model):
__tablename__ = 'Project_employee_role'
rate = db.Column(db.Float(asdecimal=True), nullable=False)
employee_id = db.Column(db.ForeignKey('Employee.id'),
primary_key=True,
nullable=False,
index=True)
project_id = db.Column(db.ForeignKey('Project.id'),
primary_key=True,
nullable=False,
index=True)
employee_role_id = db.Column(db.ForeignKey('Employee_role.id'),
nullable=False,
index=True)
employee = db.relationship('Employee', lazy=True)
employee_role = db.relationship('EmployeeRole', lazy=True)
project = db.relationship('Project', lazy=True)
def __init__(self, project_id, employee_id, employee_role_id, rate):
self.project_id = project_id
self.employee_id = employee_id
self.employee_role_id = employee_role_id
self.rate = rate
class UserRoles(db.Model):
__tablename__ = 'user_roles'
id = db.Column(db.Integer(), primary_key=True)
user_id = db.Column(db.Integer(),
db.ForeignKey('users.id', ondelete='CASCADE'))
role_id = db.Column(db.Integer(),
db.ForeignKey('roles.id', ondelete='CASCADE'))
class Web_Orders(db.Model):
__tablename__ = 'web_orders'
id = db.Column(db.Integer(), primary_key=True)
erp_end_customer_name = db.Column(db.String(100))
offer_name = db.Column(db.String(50))
web_order_id = db.Column(db.String(50))
subscription_id = db.Column(db.String(50))
class Customers(db.Model):
id = db.Column(db.Integer, primary_key=True)
company_name = db.Column(db.String(45))
last_name = db.Column(db.String(45))
first_name = db.Column(db.String(45))
def __repr__(self):
return "<name {}: '{} , {}'>".format(self.id, self.last_name,self.first_name,self.company_name)
class Comments(db.Model):
__tablename__ = 'flask_admin_comments'
id = db.Column(db.Integer, primary_key=True)
comment_text = db.Column(db.String(255))
user_id = db.Column(db.Integer, db.ForeignKey('flask_admin_users.id'))
def __repr__(self):
return '<Comment {}>'.format(self.id)
class User(db.Model):
__tablename__ = 'users'
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(256), nullable=False, unique=True)
def __repr__(self):
return '<User(email={self.email!r})>'.format(self=self)
class Employee(db.Model):
__tablename__ = 'Employee'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
first_name = db.Column(db.String(45), nullable=False)
last_name = db.Column(db.String(45), nullable=False)
job_position = db.Column(db.String(45), nullable=False)
contract_finish_date = db.Column(db.Date)
class Trava_Admin(db.Model):
__tablename__ = 'trava_admin'
id = db.Column(db.Integer, primary_key=True)
user_id = db.Column(db.Integer, db.ForeignKey('trava_users.id'), unique=True)
def __init__(self, user_id):
self.user_id = user_id
