Example #1
0
class TestMapper(unittest.TestCase):
    def setUp(self):

        p = Person()
        self.m = ObjectMapper(p)

    def test_insert(self):
        self.assertEquals(
            self.m.insert(),
            ("INSERT INTO person(age,name) VALUES ('?','?')", '22', 'john'))

    def test_get_by_id(self):
        self.assertEquals(
            self.m.get_by_id(id=1),
            ('SELECT age, name FROM person WHERE id_person = ?', 1))

    def test_select_all(self):
        self.assertEquals(self.m.get_all(), "SELECT age, name FROM person")

    def test_delete(self):
        self.assertEquals(self.m.delete(id=1),
                          ('DELETE FROM person WHERE id_person = ?', 1))

    def test_update(self):
        self.assertEquals(
            self.m.update(id=1),
            ("UPDATE person SET age = '?', name = '?' WHERE id_person = ?",
             '22', 'john', 1))
Example #2
0
class TestMapper(unittest.TestCase):

    def setUp(self):

        p = Person()
        self.m = ObjectMapper(p)

    def test_insert(self):
        self.assertEquals(self.m.insert(), ("INSERT INTO person(age,name) VALUES ('?','?')", '22', 'john'))

    def test_get_by_id(self):
        self.assertEquals(self.m.get_by_id(id=1), ('SELECT age, name FROM person WHERE id_person = ?', 1))
        self.assertEquals(self.m.get_by_id(id=1, fields=['age']),
                ('SELECT age FROM person WHERE id_person = ?', 1))

    def test_select_all(self):
        self.assertEquals(self.m.get_all(), "SELECT age, name FROM person")
        self.assertEquals(self.m.get_all(fields=['name']), "SELECT name FROM person")

    def test_delete(self):
        self.assertEquals(self.m.delete(id=1), ('DELETE FROM person WHERE id_person = ?', 1))

    def test_update(self):
        self.assertEquals(self.m.update(id=1), ("UPDATE person SET age = '?', name = '?' WHERE id_person = ?", '22', 'john', 1))

    def test_get_table(self):
        self.assertEquals(self.m.get_table(), 'person')

    def test_get_id(self):
        self.assertEquals(self.m.get_id(), 'id_person')
Example #3
0
 def test_sql(self):
     
     p = Person()
     m = ObjectMapper(p)
     
     self.assertEquals(m.insert(), "INSERT INTO person(age,name) VALUES ('22','john')")        
     self.assertEquals(m.get_by_id(id=1), "SELECT age, name FROM person WHERE id_person = 1")        
     self.assertEquals(m.get_all(), "SELECT age, name FROM person")        
     self.assertEquals(m.delete(id=1), "DELETE FROM person WHERE id_person = 1")        
     self.assertEquals(m.update(id=1), "UPDATE person SET age = '22', name = 'john' WHERE id_person = '1'")
Example #4
0
    def setUp(self):

        p = Person()
        self.m = ObjectMapper(p)
Example #5
0
    def setUp(self):

        p = Person()
        self.m = ObjectMapper(p)