def ApplyNewFeedSubmit(self):
max_id = Session.query(func.max(ApplyNewFeed.apply_id)).scalar() or 0
pm_emails = request.params['pm_emails']
pm_names = request.params['pm_names']
stype_desc = request.params['stype_desc']
a = ApplyNewFeed(max_id + 1,
pm_names = pm_names,
pm_emails = pm_emails,
dev_names = request.params['dev_names'],
dev_emails = request.params['dev_emails'],
stype_desc = stype_desc,
stype_text = request.params['stype_text'],
push_news = int(request.params['push_news']),
push_mini = int(request.params['push_mini']),
news_merge_desc = request.params['news_merge_desc'],
mini_merge_desc = request.params['mini_merge_desc'],
lifetime = int(request.params['lifetime']),
status = 0,
apply_time = int(time.time())
)
Session.add(a)
Session.commit()
self.SendMail('*****@*****.**', pm_emails, '申请创建新鲜事类型', pm_names + ':' + stype_desc)
return '申请保存成功'
def SaveStypeConfig(self):
cfg = self.page_config.filter_by(
stype=int(request.params['stype'])).first()
if not cfg:
cfg = StypeConfig(int(request.params['stype']),
request.params['title'],
int(request.params['weight']),
int(request.params['send-news']),
request.params['news-merge-by'],
int(request.params['news-merge-type']),
int(request.params['send-mini']),
request.params['mini-merge-by'],
int(request.params['mini-merge-type']),
request.params['extra-configs'], 0)
Session.add(cfg)
else:
cfg.title = request.params['title']
cfg.weight = int(request.params['weight'])
cfg.send_newsfeed = int(request.params['send-news'])
cfg.news_merge_by = request.params['news-merge-by']
cfg.news_merge_type = int(request.params['news-merge-type'])
cfg.send_minifeed = int(request.params['send-mini'])
cfg.mini_merge_by = request.params['mini-merge-by']
cfg.mini_merge_type = int(request.params['mini-merge-type'])
cfg.extras = request.params['extra-configs']
Session.commit()
return 'config保存成功'
def SaveTemplate(self):
sk = TplView(request.params['tpl_id'],
view = request.params['view'],
template = request.params['tpl'])
Session.merge(sk)
Session.commit()
return '保存模板成功2'
def ApplyNewFeedSubmit(self):
max_id = Session.query(func.max(ApplyNewFeed.apply_id)).scalar() or 0
pm_emails = request.params['pm_emails']
pm_names = request.params['pm_names']
stype_desc = request.params['stype_desc']
a = ApplyNewFeed(max_id + 1,
pm_names=pm_names,
pm_emails=pm_emails,
dev_names=request.params['dev_names'],
dev_emails=request.params['dev_emails'],
stype_desc=stype_desc,
stype_text=request.params['stype_text'],
push_news=int(request.params['push_news']),
push_mini=int(request.params['push_mini']),
news_merge_desc=request.params['news_merge_desc'],
mini_merge_desc=request.params['mini_merge_desc'],
lifetime=int(request.params['lifetime']),
status=0,
apply_time=int(time.time()))
Session.add(a)
Session.commit()
self.SendMail('*****@*****.**', pm_emails, '申请创建新鲜事类型',
pm_names + ':' + stype_desc)
return '申请保存成功'
def TplApplyHandled(self):
a = self.apply_tpls_.filter_by(apply_id = int(request.params['apply_id'])).first()
if a:
a.status = 1
Session.commit()
return ''
def SaveTemplate(self):
sk = TplView(request.params['tpl_id'],
view=request.params['view'],
template=request.params['tpl'])
Session.merge(sk)
Session.commit()
return '保存模板成功2'
def AddStypeVersion(self): stype = int(request.params['stype']) max_ver = Session.query(func.max(DataVersion.version)).filter_by(stype = stype).scalar() or 0 vc = DataVersion(stype, max_ver + 1, 0, 0) Session.add(vc) Session.commit() return str(max_ver + 1)
def SaveStypeConfig(self):
cfg = self.page_config.filter_by(stype=int(request.params['stype'])).first()
if not cfg:
cfg = StypeConfig(int(request.params['stype']),
request.params['title'],
int(request.params['weight']),
int(request.params['send-news']),
request.params['news-merge-by'],
int(request.params['news-merge-type']),
int(request.params['send-mini']),
request.params['mini-merge-by'],
int(request.params['mini-merge-type']),
request.params['extra-configs'],
0)
Session.add(cfg)
else:
cfg.title = request.params['title']
cfg.weight = int(request.params['weight'])
cfg.send_newsfeed = int(request.params['send-news'])
cfg.news_merge_by = request.params['news-merge-by']
cfg.news_merge_type = int(request.params['news-merge-type'])
cfg.send_minifeed = int(request.params['send-mini'])
cfg.mini_merge_by = request.params['mini-merge-by']
cfg.mini_merge_type = int(request.params['mini-merge-type'])
cfg.extras = request.params['extra-configs']
Session.commit()
return 'config保存成功'
def AddStypeVersion(self):
stype = int(request.params['stype'])
max_ver = Session.query(func.max(
DataVersion.version)).filter_by(stype=stype).scalar() or 0
vc = DataVersion(stype, max_ver + 1, 0, 0)
Session.add(vc)
Session.commit()
return str(max_ver + 1)
def TplApplyHandled(self):
a = self.apply_tpls_.filter_by(
apply_id=int(request.params['apply_id'])).first()
if a:
a.status = 1
Session.commit()
return ''
def SaveStypeKeys(self):
sk = StypeKeys(request.params['stype'],
version=request.params['version'],
key_list=request.params['kl'])
#Session.save(sk)
Session.merge(sk)
Session.commit()
return 'save ok, ', request.params['kl']
def SaveTemplate(self):
sk = StypeTemplate(request.params['stype'],
version=request.params['version'],
view=request.params['view'],
template=request.params['tpl'])
Session.merge(sk)
Session.commit()
return '保存模板成功2'
def SaveTemplate(self):
sk = StypeTemplate(request.params['stype'],
version = request.params['version'],
view = request.params['view'],
template = request.params['tpl'])
Session.merge(sk)
Session.commit()
return '保存模板成功2'
def SaveStypeKeys(self):
sk = StypeKeys(request.params['stype'],
version = request.params['version'],
key_list = request.params['kl'])
#Session.save(sk)
Session.merge(sk)
Session.commit()
return 'save ok, ', request.params['kl']
def AddVersionTpl(self):
max_id = Session.query(func.max(VersionTplMapping.tpl_id)).scalar() or 1
tpl_id = max_id + 1
feed_key = VersionTplMapping(tpl_id = tpl_id,
stype = request.params['stype'],
version = request.params['version'])
Session.add(feed_key)
Session.commit()
return str(tpl_id)
def AddVersionTpl(self):
max_id = Session.query(func.max(
VersionTplMapping.tpl_id)).scalar() or 1
tpl_id = max_id + 1
feed_key = VersionTplMapping(tpl_id=tpl_id,
stype=request.params['stype'],
version=request.params['version'])
Session.add(feed_key)
Session.commit()
return str(tpl_id)
def RemoveTemplate(self):
tpl_id = int(request.params['tpl_id'])
view = int(request.params['view'])
if tpl_id <= 0 or view < 0:
return '参数错误'
tpl = self.tpl_views_.filter_by(tpl_id = tpl_id, view = view).first()
Session.delete(tpl)
Session.commit()
return '删除模板成功'
def RemoveTemplate(self):
tpl_id = int(request.params['tpl_id'])
view = int(request.params['view'])
if tpl_id <= 0 or view < 0:
return '参数错误'
tpl = self.tpl_views_.filter_by(tpl_id=tpl_id, view=view).first()
Session.delete(tpl)
Session.commit()
return '删除模板成功'
def UpdateStypeVersionStatus(self):
stype = int(request.params['stype'])
version = int(request.params['version'])
status = int(request.params['status'])
if stype > 0 and version > 0:
ver = self.data_version_.filter_by(stype = stype, version = version).first()
if ver:
ver.status = status
Session.commit()
return '保存成功' + str(ver.status)
else:
return '版本 ' + str(version) + '不存在'
return '参数有错误'
def __before__(self):
self.stype_config_ = Session.query(StypeConfig)
self.version_tpl_mapping_ = Session.query(VersionTplMapping)
self.data_version_ = Session.query(DataVersion)
self.tpl_views_ = Session.query(TplView)
self.apply_feeds_ = Session.query(ApplyNewFeed)
self.apply_versions_ = Session.query(ApplyNewVersion)
self.apply_tpls_ = Session.query(ApplyNewTpl)
self.apply_rollbacks_ = Session.query(ApplyRollback)
self.apply_publishs_ = Session.query(ApplyPublish)
def __before__(self): self.stype_config_ = Session.query(StypeConfig) self.version_tpl_mapping_ = Session.query(VersionTplMapping) self.data_version_ = Session.query(DataVersion) self.tpl_views_ = Session.query(TplView) self.apply_feeds_ = Session.query(ApplyNewFeed) self.apply_versions_ = Session.query(ApplyNewVersion) self.apply_tpls_ = Session.query(ApplyNewTpl) self.apply_rollbacks_ = Session.query(ApplyRollback) self.apply_publishs_ = Session.query(ApplyPublish)
def UpdateStypeVersionUsingId(self):
stype = int(request.params['stype'])
version = int(request.params['version'])
tpl_id = int(request.params['tpl_id'])
if stype > 0 and version > 0 and tpl_id > 0:
ver = self.data_version_.filter_by(stype = stype, version = version).first()
if ver:
ver.using_tpl_id = tpl_id
else:
ver = DataVersion(stype, version, 0, tpl_id, 0)
Session.add(ver)
Session.commit()
return '保存成功' + str(ver.using_tpl_id)
return '参数有错误'
def UpdateStypeVersionStatus(self):
stype = int(request.params['stype'])
version = int(request.params['version'])
status = int(request.params['status'])
if stype > 0 and version > 0:
ver = self.data_version_.filter_by(stype=stype,
version=version).first()
if ver:
ver.status = status
Session.commit()
return '保存成功' + str(ver.status)
else:
return '版本 ' + str(version) + '不存在'
return '参数有错误'
def UpdateStypeVersionUsingId(self):
stype = int(request.params['stype'])
version = int(request.params['version'])
tpl_id = int(request.params['tpl_id'])
if stype > 0 and version > 0 and tpl_id > 0:
ver = self.data_version_.filter_by(stype=stype,
version=version).first()
if ver:
ver.using_tpl_id = tpl_id
else:
ver = DataVersion(stype, version, 0, tpl_id, 0)
Session.add(ver)
Session.commit()
return '保存成功' + str(ver.using_tpl_id)
return '参数有错误'
def SaveStypeConfig(self):
cfg = self.stype_config_.filter_by(
stype=int(request.params['stype'])).first()
if not cfg:
cfg = StypeConfig(
stype=int(request.params['stype']),
weight=int(request.params['weight']),
type=int(request.params['type']),
ptype=int(request.params['ptype']),
description=request.params['title'],
push_feed_flags=int(request.params['push_flags']),
news_merge_type=int(request.params['news_merge_type']),
mini_merge_type=int(request.params['mini_merge_type']),
update_time_on_merge=int(
request.params['update_time_on_merge']),
custom_expr=int(request.params['custom_expr']),
persist_body=int(request.params['save_content']),
persist_feeddb=int(request.params['save_feed_db']),
lifetime=int(request.params['lifetime']),
daily_quota=int(request.params['daily_quota']))
Session.add(cfg)
if 'apply_id' in request.params:
apply_id = int(request.params['apply_id'])
self.FeedApplyHandled(apply_id)
else:
if int(request.params['is_new']) > 0:
return '{"status":1, "desc":"新建子类型保存失败(已经存在)"}'
cfg.weight = request.params['weight']
cfg.type = int(request.params['type'])
cfg.ptype = int(request.params['ptype'])
cfg.description = request.params['title']
cfg.push_feed_flags = int(request.params['push_flags'])
cfg.news_merge_type = int(request.params['news_merge_type'])
cfg.mini_merge_type = int(request.params['mini_merge_type'])
cfg.update_time_on_merge = int(
request.params['update_time_on_merge'])
cfg.custom_expr = int(request.params['custom_expr'])
cfg.persist_body = int(request.params['save_content'])
cfg.persist_feeddb = int(request.params['save_feed_db'])
cfg.lifetime = int(request.params['lifetime'])
cfg.daily_quota = int(request.params['daily_quota'])
Session.commit()
return '{"status":0, "desc":"保存成功"}'
def SaveVersionKeys(self):
stype = int(request.params['stype'])
version = int(request.params['version'])
if stype <= 0 or version <= 0:
return "参数错误"
o = self.data_version_.filter_by(stype=stype, version=version).first()
if o:
o.keys_xml = request.params['kl']
o.news_merge_by = request.params['news_merge_by']
o.mini_merge_by = request.params['mini_merge_by']
o.source_by = request.params['source_by']
o.psource_by = request.params['psource_by']
o.actor_by = request.params['actor_by']
o.dispatch_expr = request.params['dispatch_expr']
Session.commit()
return '保存成功'
else:
return '该版本不存在'
def SaveVersionKeys(self):
stype = int(request.params['stype'])
version = int(request.params['version'])
if stype <= 0 or version <= 0:
return "参数错误"
o = self.data_version_.filter_by(stype=stype, version=version).first()
if o:
o.keys_xml = request.params['kl']
o.news_merge_by = request.params['news_merge_by']
o.mini_merge_by = request.params['mini_merge_by']
o.source_by = request.params['source_by']
o.psource_by = request.params['psource_by']
o.actor_by = request.params['actor_by']
o.dispatch_expr = request.params['dispatch_expr']
Session.commit()
return '保存成功'
else:
return '该版本不存在'
def SaveStypeConfig(self):
cfg = self.stype_config_.filter_by(stype=int(request.params['stype'])).first()
if not cfg:
cfg = StypeConfig(stype = int(request.params['stype']),
weight = int(request.params['weight']),
type = int(request.params['type']),
ptype = int(request.params['ptype']),
description = request.params['title'],
push_feed_flags = int(request.params['push_flags']),
news_merge_type = int(request.params['news_merge_type']),
mini_merge_type = int(request.params['mini_merge_type']),
update_time_on_merge = int(request.params['update_time_on_merge']),
custom_expr = int(request.params['custom_expr']),
persist_body = int(request.params['save_content']),
persist_feeddb = int(request.params['save_feed_db']),
lifetime = int(request.params['lifetime']),
daily_quota = int(request.params['daily_quota']))
Session.add(cfg)
if 'apply_id' in request.params:
apply_id = int(request.params['apply_id'])
self.FeedApplyHandled(apply_id)
else:
if int(request.params['is_new']) > 0:
return '{"status":1, "desc":"新建子类型保存失败(已经存在)"}'
cfg.weight = request.params['weight']
cfg.type = int(request.params['type'])
cfg.ptype = int(request.params['ptype'])
cfg.description = request.params['title']
cfg.push_feed_flags = int(request.params['push_flags'])
cfg.news_merge_type = int(request.params['news_merge_type'])
cfg.mini_merge_type = int(request.params['mini_merge_type'])
cfg.update_time_on_merge = int(request.params['update_time_on_merge'])
cfg.custom_expr = int(request.params['custom_expr'])
cfg.persist_body = int(request.params['save_content'])
cfg.persist_feeddb = int(request.params['save_feed_db'])
cfg.lifetime = int(request.params['lifetime'])
cfg.daily_quota = int(request.params['daily_quota'])
Session.commit()
return '{"status":0, "desc":"保存成功"}'
def GetStypeIds(self):
ids = Session.query(StypeConfig.stype)
rsp = '['
count = 0
for o in ids:
if count > 0:
rsp += ','
rsp += str(o[0])
count += 1
rsp += ']'
return rsp
def GetStypeIds(self):
ids = Session.query(StypeConfig.stype)
rsp = '['
count = 0
for o in ids:
if count > 0:
rsp += ','
rsp += str(o[0])
count += 1
rsp += ']'
return rsp
def ApplyPublishSubmit(self):
max_id = Session.query(func.max(ApplyPublish.apply_id)).scalar() or 0
pm_emails = request.params['pm_emails']
pm_names = request.params['pm_names']
publish_desc = request.params['publish_desc']
a = ApplyPublish(max_id + 1,
stype_id=int(request.params['stype_id']),
version=int(request.params['version']),
tpl_id=int(request.params['tpl_id']),
pm_names=pm_names,
pm_emails=pm_emails,
dev_names=request.params['dev_names'],
dev_emails=request.params['dev_emails'],
publish_desc=publish_desc,
status=0,
apply_time=int(time.time()))
Session.add(a)
Session.commit()
# self.SendMail('*****@*****.**', pm_emails, '申请创建新鲜事类型', pm_names + ':' + stype_desc)
return '申请保存成功'
def ApplyPublishSubmit(self):
max_id = Session.query(func.max(ApplyPublish.apply_id)).scalar() or 0
pm_emails = request.params['pm_emails']
pm_names = request.params['pm_names']
publish_desc = request.params['publish_desc']
a = ApplyPublish(max_id + 1,
stype_id = int(request.params['stype_id']),
version = int(request.params['version']),
tpl_id = int(request.params['tpl_id']),
pm_names = pm_names,
pm_emails = pm_emails,
dev_names = request.params['dev_names'],
dev_emails = request.params['dev_emails'],
publish_desc = publish_desc,
status = 0,
apply_time = int(time.time())
)
Session.add(a)
Session.commit()
# self.SendMail('*****@*****.**', pm_emails, '申请创建新鲜事类型', pm_names + ':' + stype_desc)
return '申请保存成功'
def ApplyNewVersionSubmit(self):
max_id = Session.query(func.max(ApplyNewVersion.apply_id)).scalar() or 0
pm_emails = request.params['pm_emails']
pm_names = request.params['pm_names']
version_desc = request.params['version_desc']
a = ApplyNewVersion(max_id + 1,
stype_id = int(request.params['stype_id']),
from_version_id = int(request.params['from_version_id']),
pm_names = pm_names,
pm_emails = pm_emails,
dev_names = request.params['dev_names'],
dev_emails = request.params['dev_emails'],
version_desc = version_desc,
version_text = request.params['version_text'],
status = 0,
apply_time = int(time.time())
)
Session.add(a)
Session.commit()
# self.SendMail('*****@*****.**', pm_emails, '申请创建新鲜事类型', pm_names + ':' + stype_desc)
return '申请保存成功'
def ApplyNewVersionSubmit(self):
max_id = Session.query(func.max(
ApplyNewVersion.apply_id)).scalar() or 0
pm_emails = request.params['pm_emails']
pm_names = request.params['pm_names']
version_desc = request.params['version_desc']
a = ApplyNewVersion(max_id + 1,
stype_id=int(request.params['stype_id']),
from_version_id=int(
request.params['from_version_id']),
pm_names=pm_names,
pm_emails=pm_emails,
dev_names=request.params['dev_names'],
dev_emails=request.params['dev_emails'],
version_desc=version_desc,
version_text=request.params['version_text'],
status=0,
apply_time=int(time.time()))
Session.add(a)
Session.commit()
# self.SendMail('*****@*****.**', pm_emails, '申请创建新鲜事类型', pm_names + ':' + stype_desc)
return '申请保存成功'
def __before__(self):
# model 加载数据
self.page_q = Session.query(StypeKeys)
self.page_config = Session.query(StypeConfig)
def SetStypeState(self):
o = self.page_config.filter_by(
stype=int(request.params['stype'])).first()
o.state = int(request.params['state'])
Session.commit()
return str(o.state)
def FeedApplyHandled(self, apply_id):
a = self.apply_feeds_.filter_by(apply_id = apply_id).first()
if a:
a.status = 1
Session.commit()
def FeedApplyHandled(self, apply_id):
a = self.apply_feeds_.filter_by(apply_id=apply_id).first()
if a:
a.status = 1
Session.commit()
def SetStypeState(self): o = self.page_config.filter_by(stype=int(request.params['stype'])).first() o.state = int(request.params['state']) Session.commit() return str(o.state)
def __before__(self): # model 加载数据 self.page_q = Session.query(StypeKeys) self.page_config = Session.query(StypeConfig)
