def testUpdate(self): schema = Schema() u = schema.user('u') query = schema.update(u).where(u.reminder_medium == None) u.reminder_medium = "email" print "Rows affected = %s" % (self.t.execute(query))
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
def testInsert(self): schema = Schema() u = schema.user('u') u.id = self.max_id + 1 u.fullname = 'Seamus Hugman' u.reminder_medium = "email" query = schema.insert_into(u) results = self.t.execute(query) print query print "Insert results = " + str(results) pass