def get_query(self,*args,**kw): kind = args[0] lines = None if kind=='publication': publication_id = args[1] publication_id = int(publication_id) lines = MRExemptionRecord.query(MRExemptionRecord.publication_id==publication_id) self.single = True elif kind=='budget': budget_code = args[1] lines = MRExemptionRecord.query(MRExemptionRecord.prefixes==budget_code) elif kind=='updated': date_from = datetime.date(int(args[1]),int(args[2]),int(args[3])) date_to = datetime.date(int(args[4]),int(args[5]),int(args[6])) lines = MRExemptionRecord.query(MRExemptionRecord.last_update_date >= date_from, MRExemptionRecord.last_update_date <= date_to) elif kind=='new': lines = MRExemptionRecord.query().order(-MRExemptionRecord.last_update_date) return lines
def get_query(self,*args,**kw): kind = args[0] lines = None if kind=='publication': publication_id = args[1] publication_id = int(publication_id) lines = MRExemptionRecord.query(MRExemptionRecord.publication_id==publication_id) self.single = True elif kind=='entity': entity_id = args[1] lines = MRExemptionRecord.query(MRExemptionRecord.entity_id==entity_id) self.single = True elif kind=='budget': budget_code = args[1] lines = MRExemptionRecord.query(MRExemptionRecord.prefixes==budget_code) elif kind=='updated': date_from = datetime.date(int(args[1]),int(args[2]),int(args[3])) date_to = datetime.date(int(args[4]),int(args[5]),int(args[6])) lines = MRExemptionRecord.query(MRExemptionRecord.last_update_date >= date_from, MRExemptionRecord.last_update_date <= date_to) elif kind=='new': if len(args)>1: days = int(args[1]) first_date = datetime.datetime.now() - datetime.timedelta(days=days+1) lines = MRExemptionRecord.query(MRExemptionRecord.last_update_date>first_date)\ .order(-MRExemptionRecord.last_update_date) else: lines = MRExemptionRecord.query().order(-MRExemptionRecord.last_update_date) return lines
def get_query(self, *args, **kw): kind = args[0] lines = None if kind == 'publication': publication_id = args[1] publication_id = int(publication_id) lines = MRExemptionRecord.query( MRExemptionRecord.publication_id == publication_id) self.single = True elif kind == 'budget': budget_code = args[1] lines = MRExemptionRecord.query( MRExemptionRecord.prefixes == budget_code) elif kind == 'updated': date_from = datetime.date(int(args[1]), int(args[2]), int(args[3])) date_to = datetime.date(int(args[4]), int(args[5]), int(args[6])) lines = MRExemptionRecord.query( MRExemptionRecord.last_update_date >= date_from, MRExemptionRecord.last_update_date <= date_to) elif kind == 'new': lines = MRExemptionRecord.query().order( -MRExemptionRecord.last_update_date) return lines
def get_query(self,id): lines = [] if ALL_DIGITS.match(id) is not None: lines = Entity.query(Entity.id==id).fetch(1) else: lines = Entity.query(Entity.name==id).fetch(1) if len(lines)>0: ret = lines[0].to_dict() id = ret['id'] logging.debug('entity-api: id='+id) supports = SupportLine.query(SupportLine.entity_id==id).order(-SupportLine.year).fetch(1000) ret['supports'] = [x.to_dict() for x in supports] exemptions = MRExemptionRecord.query(MRExemptionRecord.entity_id==id).order(-MRExemptionRecord.start_date).fetch(1000) ret['exemptions'] = [x.to_dict() for x in exemptions] return ret else: return {}
def get_query(self, id): lines = [] if ALL_DIGITS.match(id) is not None: lines = Entity.query(Entity.id == id).fetch(1) else: lines = Entity.query(Entity.name == id).fetch(1) if len(lines) > 0: ret = lines[0].to_dict() id = ret['id'] logging.debug('entity-api: id=' + id) supports = SupportLine.query(SupportLine.entity_id == id).order( -SupportLine.year).fetch(1000) ret['supports'] = [x.to_dict() for x in supports] exemptions = MRExemptionRecord.query( MRExemptionRecord.entity_id == id).order( -MRExemptionRecord.start_date).fetch(1000) ret['exemptions'] = [x.to_dict() for x in exemptions] return ret else: return {}