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 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 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 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)