def updateuser(user): log.debug("Updating:" + user) que = DBSession.query(UserStat).filter(UserStat.user==user). \ order_by(UserStat.sid.desc()).first() sd = 1 if que != None: sd = que.sid + 1 log.debug(sd) # col=[] col = ZOJNet.query(user, sd) for us in col: DBSession.add(us)
def updateuser(user): log.debug("Updating:"+user) que = DBSession.query(UserStat).filter(UserStat.user==user). \ order_by(UserStat.sid.desc()).first() sd=1 if que != None : sd=que.sid+1 log.debug(sd) # col=[] col = ZOJNet.query(user,sd) for us in col: DBSession.add(us)
def gaindata(user): log.debug("Query:" + user) usds = DBSession.query(UserStat).filter(UserStat.user==user). \ order_by(UserStat.sid) report = [] dic = dict() for usd in usds: if dic.has_key(usd.pid): qt = dic[usd.pid] if usd.status == 0: qt.status = 0 qt.etime = usd.time qt.count = qt.count + 1 dic[usd.pid] = qt else: ur = UserReport(usd.pid, usd.status, usd.time, usd.time, 1) dic[usd.pid] = ur for p in dic.values(): report.append(p) report.sort(lambda x, y: cmp(x.pid, y.pid)) # print html.tags.image('/images/rss.png', 'rss syndication') return dict(user=user, count=len(report), zuses=report)
def gaindata(user): log.info("Query:"+user) res = DBSession.query(ReportInfo).filter(ReportInfo.user==user) \ .order_by(ReportInfo.pid) report=[] passed=0 for b in res: p=copy.copy(b) p.duration=(p.etime-p.btime).__str__() if p.ac==1: p.status='Accepted' passed+=1 if ttable.has_key(p.status): p.status=ttable[p.status] else: p.status=ttable['u'] if(p.status=='AC'): p.ac=True else: p.ac=False report.append(p) return dict(user=user,passed=passed,count=len(report),zuses=report)
def getmaxsid(user): que=DBSession.query(SubmissionInfo).filter(SubmissionInfo.user==user). \ order_by(SubmissionInfo.sid.desc()).first() rt = 0 if que != None : rt = que.sid return rt;
def gaindata(user): log.debug("Query:"+user) usds = DBSession.query(UserStat).filter(UserStat.user==user). \ order_by(UserStat.sid) report = [] dic = dict() for usd in usds: if dic.has_key(usd.pid): qt=dic[usd.pid] if usd.status == 0 : qt.status = 0 qt.etime=usd.time qt.count=qt.count+1 dic[usd.pid]=qt else: ur = UserReport(usd.pid,usd.status,usd.time,usd.time,1) dic[usd.pid]=ur for p in dic.values(): report.append(p) report.sort(lambda x,y:cmp(x.pid,y.pid)) # print html.tags.image('/images/rss.png', 'rss syndication') return dict(user=user,count=len(report),zuses=report)
def setUp(self): """Prepare model test fixture.""" try: new_attrs = {} new_attrs.update(self.attrs) new_attrs.update(self.do_get_dependencies()) self.obj = self.klass(**new_attrs) DBSession.add(self.obj) DBSession.flush() return self.obj except: DBSession.rollback() raise
def getmaxpid(): que=DBSession.query(func.max(SubmissionInfo.pid)) rt = 0 if que.scalar() != None : rt = que.scalar() return rt;
def _savesinfo(data): t = SubmissionInfo.__table__.insert(data.__dict__) \ .prefix_with("ignore") w=DBSession.connection().execute(t)
def teardown(self): """Finish model test fixture.""" DBSession.rollback()
def test_query_obj(self): """Model objects can be queried""" obj = DBSession.query(self.klass).one() for key, value in self.attrs.iteritems(): assert_equals(getattr(obj, key), value)
def tearDown(self): """Finish model test fixture.""" DBSession.rollback()
def getmaxvid(): que=DBSession.query(func.max(ProblemInfo.cata)) rt = 0 if que.scalar() != None : rt = que.scalar() return rt;