class User(models.Model): # 修改表名 __tablename__ = 'UserModel' id = models.Column(models.Integer, primary_key=True) # 编号 username = models.Column(models.String(100), unique=True) # 昵称 password = models.Column(models.String(100)) # 密码 desc = models.Column(models.String(128), nullable=True)
class FoodType(models.Model): id = models.Column(models.Integer, primary_key=True, autoincrement=True) __tablename__ = "axf_foodtypes" typeid = models.Column(models.String(32)) typename = models.Column(models.String(100)) childtypenames = models.Column(models.String(200)) typesort = models.Column(models.String(32))
class User(models.Model): id = models.Column(models.Integer, primary_key=True) username = models.Column(models.String(16)) def save(self): models.session.add(self) models.session.commit()
class User(models.Model): __tablename__ = 'user' id = models.Column(models.Integer, primary_key=True) username = models.Column(models.String(20)) def __repr__(self): return "<User %r>" % self.username
class People(BaseModel): name = models.Column(models.String(100)) age = models.Column(models.Integer) def __repr__(self): return str(self.id) + self.name + str(self.age) def __init__(self, name, age): self.name = name self.age = age
class Student(BaseModel): s_name = models.Column(models.String(16), unique=True) _s_password = models.Column(models.String(256)) _s_phone = models.Column(models.String(32), unique=True) @property def s_password(self): raise Exception("Error Action: You have no access to password.") @s_password.setter def s_password(self, password): self._s_password = generate_password_hash(password) def check_password(self, password): return check_password_hash(self._s_password, password)
class BaseModel(models.Model): __abstract__ = True id = models.Column(models.Integer, primary_key=True, autoincrement=True) def save(self): try: models.session.add(self) models.session.commit() return True except Exception as e: print(e) return False def delete(self): try: models.session.delete(self) models.session.commit() return True except Exception as e: print(e) return False
class Admin_Users(BaseModel): name = models.Column(models.String(32), unique=True) _password = models.Column(models.String(256)) is_delete = models.Column(models.Boolean(), default=False) is_super = models.Column(models.Boolean(), default=False) permission = models.Column(models.Integer, default=PERMISSION_NONE) @property def password(self): raise Exception('不准查看') @password.setter def password(self, password_value): self._password = generate_password_hash(password_value) def check_password(self, user_password): return check_password_hash(self._password, user_password) def check_permission(self, permission_s): return self.is_super or self.permission & permission_s == permission_s
class CityModel(BaseModel): let_szm_id = models.Column(models.Integer, models.ForeignKey(Let_szm.id)) c_id = models.Column(models.Integer, default=0) c_parent_id = models.Column(models.Integer, default=0) c_name = models.Column(models.String(16)) c_sitycode = models.Column(models.Integer, default=0) c_py = models.Column(models.String(128))
class MovieUser(BaseModel): username = models.Column(models.String(32), unique=True) _password = models.Column(models.String(256)) phone = models.Column(models.String(32), unique=True) # 逻辑删除 is_delete = models.Column(models.Boolean, default=False) permission = models.Column(models.Integer, default=PERMISSION_NONE) @property def password(self): raise Exception('no password') @password.setter def password(self, passwords): self._password = generate_password_hash(passwords) def check_password(self, password_v): return check_password_hash(self._password, password_v) def check_permission(self, permission): if BLACK_USER & self.permission == BLACK_USER: return False else: return permission & self.permission == permission
class News(models.Model): id = models.Column(models.Integer, primary_key=True, autoincrement=True) n_title = models.Column(models.String(32)) n_content = models.Column(models.String(256))
class Customer(models.Model): id = models.Column(models.Integer, primary_key=True, autoincrement=True) c_name = models.Column(models.String(30)) address = models.relationship("Address", backref="customer", lazy=True)
class Address(models.Model): id = models.Column(models.Integer, primary_key=True, autoincrement=True) a_position = models.Column(models.String(128)) # 这里的外键中,传入的值为字符串也可以,"Customer.id" a_customer_id = models.Column(models.Integer, models.ForeignKey(Customer.id))
class Student(models.Model): id = models.Column(models.Integer, primary_key=True) username = models.Column(models.String(32))
class User(models.Model): id = models.Column(models.Integer, primary_key=True, autoincrement=True) username = models.Column(models.String(16))
class Dog(Animal): d_tags = models.Column(models.Integer, default=4)
class movies_dy(BaseModel): __tablename__ = 'dy' dy_name = models.Column(models.String(64)) dy_id = models.Column(models.Integer) dy_daoyan = models.Column(models.String(64)) dy_zhuyan = models.Column(models.String(256)) by_type = models.Column(models.String(64)) dy_country = models.Column(models.String(64)) dy_yuyan = models.Column(models.String(64)) dy_pianchang = models.Column(models.Integer, default=120) dy_riqi = models.Column(models.DateTime) dy_img = models.Column(models.String(256)) dy_desc = models.Column(models.String(1248)) dy_xiazai = models.Column(models.String(128)) flag = models.Column(models.Boolean, default=False) is_del = models.Column(models.Boolean, default=False)
class User(ModelBase, models.Model): id = models.Column(models.Integer, primary_key=True) user_name = models.Column(models.String(16))
class User(models.Model): id = models.Column(models.Integer, primary_key=True) # 编号 username = models.Column(models.String(100), unique=True) # 昵称 password = models.Column(models.String(100)) # 密码
class News(BaseModel): n_title = models.Column(models.String(32)) n_content = models.Column(models.String(256))
class Let_szm(BaseModel): let_szm = models.Column(models.String(2), unique=True)
class Goods(BaseModel): g_name = models.Column(models.String(64)) g_price = models.Column(models.Float, default=0)
class Address(models.Model): id = models.Column(models.Integer, primary_key=True, autoincrement=True) a_position = models.Column(models.String(20)) a_customer_id = models.Column(models.Integer, models.ForeignKey(Customer.id))
class Cat(Animal): c_tags = models.Column(models.String(32), default='fish')
class Student(models.Model): id = models.Column(models.Integer, primary_key=True) s_name = models.Column(models.String(20)) s_password = models.Column(models.String(256))
class User(models.Model): id = models.Column(models.Integer, primary_key=True) username = models.Column(models.String(16)) userage = models.Column(models.Integer)
class Address(BaseModel): a_position = models.Column(models.String(128)) # 这里的外键中,传入的值为字符串也可以,"Customer.id" a_customer_id = models.Column(models.Integer, models.ForeignKey(Customer.id))
class Animal(models.Model): # Django 中可以把类变成抽象类处理,这里也把类变为抽象类 __abstract__ = True id = models.Column(models.Integer, primary_key=True) u_name = models.Column(models.String(100), unique=True)
class Student(ModelBase, models.Model): id = models.Column(models.Integer, primary_key=True) s_name = models.Column(models.String(16)) s_num = models.Column(models.Integer)
class Admins(models.Model): id = models.Column(models.Integer, primary_key=True) adminname = models.Column(models.String(16))