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
