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