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))
