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