def test_project3():
class A(P.PyDO):
fields = (P.Sequence('id'), 'x')
p = A.project(P.Field('id'))
assert not p.getSequences()
assert not p.getUniquenessConstraints()
def test_project4():
class torte4(P.PyDO):
fields = (P.Sequence('id'), 'title', 'x', 'y', 'z')
foo = torte4.project(P.Field('id'), 'title', 'x', 'y')
assert not foo.getSequences(), "expected no sequences, got: %s" % str(
foo.getSequences())
assert len(foo.getUniquenessConstraints()) == 0
def run(self):
p=self.E.project('user1', P.Field(name='user3', asname='plapitude'))
#p=self.E.project('user1', 'user3 as plapitude')
cols=p.getColumns()
assert 'plapitude' in cols
assert 'user1' in cols
assert len(cols)==2
p2=self.E.project('user1', 'user3 as plapitude')
cols=p2.getColumns()
assert 'plapitude' in cols
assert 'user1' in cols
assert len(cols)==2
def run(self):
o1=self.E.getUnique(id=1)
assert o1.user1=='me'
assert o1.user2=='you'
p=self.E.project('user1', P.Field('count(*)', asname='count'))
if config.DRIVER=='sqlite2':
res=p.getSome('user1=? group by user1', 'me')
else:
res=p.getSome('user1=%s group by user1', 'me')
#print res
assert len(res)==1
assert res[0].count==2
if config.DRIVER=='sqlite2':
res=p.getSome('user1 = ? group by user1', 'bongo')
else:
res=p.getSome('user1 = %s group by user1', 'bongo')
assert len(res)==1
assert res[0].count==1
def test_picklefield1():
f = P.Field('x')
f2 = loads(dumps(f))
assert f.name == f2.name