本文共 1552 字,大约阅读时间需要 5 分钟。
今天的内容比较简单,即基于昨天编写的ORM,将构建webapp需要用的三个表User、blog和commit使用model表示出来。
import time, uuid# 导入ORM模块的Model和五种主要存储类型from orm import Model, StringField, BooleanField, FloatField, TextField# 使用时间与伪随机数生成返回值def next_id(): return '%015d%s000' % (int(time.time() * 1000), uuid.uuid4().hex)# 定义ORM所有映射的基类:Model# Model类的任意子类可以映射一个数据库表# Model类可以看做是对所有数据库表操作的基本定义的映射# 继承自Model表示实现数据库操作的所有方法,定义为class方法,所有继承自model都具有数据库操作方法class User(Model): __table__ = 'users' id = StringField(primary_key=True, default=next_id, ddl='varchar(50)') email = StringField(ddl='varchar(50)') passwd = StringField(ddl='varchar(50)') admin = BooleanField() name = StringField(ddl='varchar(50)') image = StringField(ddl='varchar(500)') created_at = FloatField(default=time.time)class Blog(Model): __table__ = 'blogs' id = StringField(primary_key=True, default=next_id, ddl='varchar(50)') user_id = StringField(ddl='varchar(50)') user_name = StringField(ddl='varchar(50)') user_image = StringField(ddl='varchar(500)') name = StringField(ddl='varchar(50)') summary = StringField(ddl='varchar(200)') content = TextField() created_at = FloatField(default=time.time)class Comment(Model): __table__ = 'comments' id = StringField(primary_key=True, default=next_id, ddl='varchar(50)') blog_id = StringField(ddl='varchar(50)') user_id = StringField(ddl='varchar(50)') user_name = StringField(ddl='varchar(50)') user_image = StringField(ddl='varchar(500)') content = TextField() created_at = FloatField(default=time.time)
参考博客
转载地址:http://jmlxi.baihongyu.com/