Esempio n. 1
0
    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))
Esempio n. 2
0
 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))
Esempio n. 3
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]
Esempio n. 4
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]
Esempio n. 5
0
    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
Esempio n. 6
0
 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
Esempio n. 7
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
Esempio n. 8
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
Esempio n. 9
0
 def __init__(self, *args, **kw):
     self.schema = Schema()
     self._connection_factory = self._create_connection(*args, **kw)
     self._initial_tables = None