class Test(Model):
__table__ = 'test'
pk = IntField(primary_key=True, default=auto_increment())
id = StringField(50)
age = IntField()
birth_place = StringField(50, default='china')
grade = SmallIntField()
class Set_All_Field(Model):
__table__ = 'all_field'
small = SmallIntField(primary_key=True, default=auto_increment())
med = MediumIntField()
mint = IntField()
bgint = BigIntField()
mbool = BoolField()
mstr = StringField()
fixstr = FixedStringField()
text = TextField()
medtext = MediumTextField()
longtext = LongTextField()
mfloat = FloatField()
mdouble = DoubleField()
mdecimal = DecimalField()
date = DateField()
dt = DatetimeField()
time = TimeField()
tmstamp = TimestampField(default=table_default('ON UPDATE CURRENT_TIMESTAMP'))