def run(self): c=self.D.getCount(id=4) assert c == 1 c=self.D.getCount() assert c == 20 if config.DRIVER == "sqlite2": c=self.D.getCount("x < ?", 3) else: c=self.D.getCount("x < %s", 3) assert c == 3 c=self.D.getCount(P.OR(P.EQ(P.FIELD('id'), 5), P.GT(P.FIELD('x'), 10))) assert c == 10
def run(self): r=self.A.getSome() assert len(r)==3 r=self.A.getSome('id <2') assert len(r)==1 assert r[0].d==55 r=self.A.getSome(P.EQ(P.FIELD('d'), 55)) assert len(r)==1 assert r[0].x==0 r=self.A.getSome(P.OR(P.LT(P.FIELD('y'), 0), P.LIKE(P.FIELD('name'), '%MAX%'))) assert len(r)==3 r=self.A.getSome(P.LIKE(P.FIELD('name'), '%TENS%'), order='z DESC') assert len(r)==2 assert r[0].z==6000 assert r[1].z==60
def run(self): self.B.updateSome(dict(x=None), P.LT(P.FIELD('x'), 500)) sql='SELECT COUNT(*) FROM b WHERE x IS NULL' c=self.db.cursor() c.execute(sql) nullcnt=c.fetchone()[0] assert nullcnt==self.count
def run(self): self.B.deleteSome(P.LT(P.FIELD('x'), 500)) sql='SELECT COUNT(*) FROM b WHERE x < 500' c=self.db.cursor() c.execute(sql) cnt=c.fetchone()[0] assert cnt==0
def run(self): tmp=self.ac1.getF(P.NE(P.FIELD('a_id'), 2)) assert len(tmp)==4 if config.DRIVER == "sqlite2": tmp=self.ac1.getF("a_id > ?", 100) else: tmp=self.ac1.getF("a_id > %s", 100) assert len(tmp)==0 tmp=self.ac1.getF(a_id=4000) assert len(tmp)==0