class MarkModel(dataorm.Model):
create_time = dataorm.DatetimeField(ddl='datetime', updatable=False)
update_time = dataorm.DatetimeField(ddl='timestamp')
tid = baseorm.IdField(unique='data', updatable=False)
def __init__(self, **attributes):
# self.__mappings__['create_time'] = dataorm.DatetimeField(ddl='datetime')
# self.__mappings__['update_time'] = dataorm.DatetimeField(ddl='datetime')
# self.__mappings__['tid'] = baseorm.IdField(unique='data', updatable=False)
attributes['create_time'] = attributes.get('create_time',
datetime.datetime.now())
attributes['update_time'] = attributes.get('update_time',
datetime.datetime.now())
for key in self.__mappings__:
if key == '_id' and not key in attributes:
continue
if not key in attributes:
raise Exception('Need field %s. ' % key)
attributes[key] = self.__mappings__[key].check_value(
attributes[key])
super(MarkModel, self).__init__(**attributes)
def __setstate__(self, state):
self.__dict__ = state
def __getstate__(self):
return self.__dict__
class ProxyStatistics(dataorm.Model):
__table__ = 'grab_proxy_statistics'
pid = baseorm.IdField(updatable=False)
avg_elapse = dataorm.FloatField(ddl='float')
total_elapse = dataorm.FloatField(ddl='float')
start_time = dataorm.DatetimeField(ddl='datetime', updatable=False)
end_time = dataorm.DatetimeField(ddl='datetime', updatable=False)
create_time = dataorm.DatetimeField(ddl='datetime', updatable=False)
update_time = dataorm.DatetimeField(ddl='timestamp')
class Log(dataorm.Model):
__table__ = 'grab_log'
_id = dataorm.StrField(ddl='varchar', max_length=32, primary=True)
tid = baseorm.IdField(updatable=False)
status = dataorm.StrField(ddl='varchar', max_length=8)
elapse = dataorm.IntField(ddl='float')
desc = dataorm.StrField(ddl='varchar', default=None, max_length=1280)
create_time = dataorm.DatetimeField(ddl='datetime', updatable=False)
class Logsummary(dataorm.Model):
__table__ = 'grab_logsummary'
tid = baseorm.IdField(updatable=False)
succ = dataorm.IntField(ddl='int', max_length=10)
fail = dataorm.IntField(ddl='int', max_length=10)
timeout = dataorm.IntField(ddl='int', max_length=10)
elapse = dataorm.FloatField(ddl='float')
create_time = dataorm.DatetimeField(ddl='datetime', updatable=False)
class Shop(dataorm.Model):
__table__ = 'shop'
food_id = dataorm.ListField(ddl='list', comment='食物id')
name = dataorm.StrField(ddl='varchar', max_length=50, comment='食物名称')
desc = dataorm.StrField(ddl='varchar', max_length=640, comment='描述')
tel = dataorm.StrField(ddl='varchar', max_length=50, comment='电话')
pic = dataorm.ListField(ddl='list', comment='店面图片')
province_id = dataorm.StrField(ddl='varchar',
max_length=50,
comment='省份id')
city_id = dataorm.StrField(ddl='varchar', max_length=50, comment='城市id')
tag = dataorm.ListField(ddl='list', comment='标签')
area_id = dataorm.StrField(ddl='varchar', max_length=50, comment='区域id')
town_id = dataorm.StrField(ddl='varchar', max_length=50, comment='镇id')
country_id = dataorm.StrField(ddl='varchar', max_length=50, comment='国家id')
address = dataorm.StrField(ddl='varchar', max_length=250, comment='地址')
longitude = dataorm.StrField(ddl='float', comment='经度')
latitude = dataorm.StrField(ddl='float', comment='纬度')
dianping = dataorm.DictField(ddl='dict', comment='点评数据')
src = dataorm.StrField(ddl='varchar',
unique='data',
max_length=20,
comment='来源')
link_url = dataorm.StrField(ddl='varchar',
unique='data',
max_length=20,
comment='来源页面地址')
# {
# 'url': '',
# 'star': 0,
# 'average': 0,
# 'taste': 0,
# 'env': 0,
# 'service': 0,
# }
atime = dataorm.DatetimeField(ddl='datetime', comment='店面创建时间')
time = dataorm.DatetimeField(ddl='datetime', updatable=False, comment='时间')
uptime = dataorm.DatetimeField(ddl='timestamp', comment='更新时间')
tid = baseorm.IdField(unique='data', updatable=False)
class Media(MarkModel):
__table__ = 'media'
wxid = dataorm.StrField(ddl='varchar', max_length=60, comment='微信公众号')
url = dataorm.StrField(ddl='varchar', max_length=50, comment='二维码地址')
icon = dataorm.StrField(ddl='varchar', max_length=50, comment='图标地址')
name = dataorm.StrField(ddl='varchar', max_length=128, comment='名称')
desc = dataorm.StrField(ddl='varchar', max_length=640, comment='描述')
pay = dataorm.StrField(ddl='char',
default='0',
max_length=1,
comment='是否支持打赏')
follower = dataorm.IntField(ddl='int', default=0, comment='关注人数')
category = dataorm.StrField(ddl='varchar', max_length=256, comment='分类')
tag = dataorm.StrField(ddl='varchar', max_length=640, comment='标签')
region = dataorm.StrField(ddl='varchar', max_length=640, comment='地区')
user = dataorm.StrField(ddl='varchar', max_length=640, comment='用户信息')
status = dataorm.StrField(ddl='char',
default='0',
max_length=1,
comment='状态')
create_time = dataorm.DatetimeField(ddl='datetime', comment='创建时间')
update_time = dataorm.DatetimeField(ddl='timestamp', comment='更新时间')
class News(MarkModel):
__table__ = 'news'
name = dataorm.StrField(ddl='varchar', max_length=60, comment='名称')
icon = dataorm.StrField(ddl='varchar', max_length=50, comment='图标地址')
detail_link = dataorm.StrField(ddl='varchar',
unique='data',
max_length=50,
comment='详情地址')
desc = dataorm.StrField(ddl='varchar', max_length=640, comment='描述')
src = dataorm.StrField(ddl='varchar',
unique='data',
max_length=20,
comment='来源')
content = dataorm.TextField(ddl='text', default=None, comment='页面内容')
group = dataorm.StrField(ddl='varchar',
max_length=10,
default='text',
comment='新闻形式')
category = dataorm.StrField(ddl='varchar', max_length=640, comment='类别')
atime = dataorm.DatetimeField(ddl='datetime', comment='来源时间')
create_time = dataorm.DatetimeField(ddl='datetime', comment='创建时间')
update_time = dataorm.DatetimeField(ddl='timestamp', comment='更新时间')
class ProxyLog(dataorm.Model):
__table__ = 'grab_proxy_log'
pid = dataorm.IdField()
elapse = dataorm.FloatField(ddl='float')
create_time = dataorm.DatetimeField(ddl='datetime')