peewee中创建自己的Field

peewee中创建自己的Field,主要通过继承Field或其子类来完成，

 

• 如果有mysql中对应的字段，则将其赋值给db_field即可。这里对set, enum并没有找到通用的字段定义，但是对具体的业务可以进行如GenderField这样的个性化定制。
• 如果没有，则使用其父类的db_field字段，并定义db_value和python_value两个方法来完成与数据库中数据类型之间的转化 

 

 1 # 时间戳字段

 2 class TimeStampField(Field):

 3     db_field = 'timestamp'

 4 

 5 class SmallIntegerField(IntegerField):

 6     db_field = 'smallint'

 7 

 8 class PasswordField(FixedCharField):

 9 

     def __init__(self, *args, **kwargs):

         self.max_length =64

         super(PasswordField, self).__init__(max_length=self.max_length, *args, **kwargs)

 

     def db_value(self, value):

         return encrypt(value)

 

     def python_value(self, value):

         return encrypt(value)

 # 性别字段

 class GenderField(Field):

     db_field = 'enum("f", "m")'

 建立表格如下：

 1 class Base(Model):

 2     class Meta:

 3         database = db

 4 

 5 class Person(Base):

 6     name = CharField(max_length=20, default='haha')

 7     intro = TextField(default='')

 8     birth = DateTimeField(default=datetime.now())

 9     Married = BooleanField(default=False)

     height = FloatField(default=0)

     wight = DoubleField(default=0)

     salary = DecimalField(default=0)

     Save = BigIntegerField(default=0)

     family = SmallIntegerField(default=0)

     age = IntegerField(default=0)

     username = CharField(max_length=20)

     password = PasswordField(default='')

     ctime = TimeStampField()

     today = DateField(default=datetime.date(datetime.today()))

     now = TimeField(default=datetime.today())

     secret = BlobField(default='')

     gender = GenderField()

mysql中的表描述如下：