def findMaxID(self):
s = Schema()
u = s.user
q = s.select(u.id).max().from_(u)
results = self.t.execute(q)
for r in results:
return r[0]
def findMaxID(self):
s = Schema()
u = s.user
q = s.select(u.id).max().from_(u)
results = self.t.execute(q)
for r in results:
return r[0]
def testSelect(self):
schema = Schema()
u = schema.user("u")
query = schema.select(u).from_(u)
print query
results = self.t.execute(query)
for r in results:
print r
slice = results[2:5]
# self.assertEquals(3, len(slice))
self.assertTrue(len(results))
u = schema.user("u")
e = schema.email('e')
query = schema.select(u.fullname, e.email).from_(
u, e).where((u.id == e.user_id) & (u.reminder_medium == 'email'))
results = self.t.execute(query)
for r in results:
print r
def testSelect(self):
schema = Schema()
u = schema.user("u")
query = schema.select(u).from_(u)
print query
results = self.t.execute(query)
for r in results:
print r
slice = results[2:5]
# self.assertEquals(3, len(slice))
self.assertTrue(len(results))
u = schema.user("u")
e = schema.email('e')
query = schema.select(u.fullname, e.email).from_(u, e).where((u.id == e.user_id) & (u.reminder_medium == 'email'))
results = self.t.execute(query)
for r in results:
print r
