Python WCDB_query Examples

Example #1

File: UTNonObliviscar-TestWCDB.py Project: cs327e-spring-2014/wcdb-tests

    def test_query_3(self):
        c = WCDB_login()
        t = WCDB_query(c, 'drop table if exists Test3;')
        t = WCDB_query(
            c, """
create table Test3(
orgID int unsigned,
contactInfoID int unsigned)
;

""")
        self.assertTrue(t == None)

Example #2

File: UTNonObliviscar-TestWCDB.py Project: cs327e-spring-2014/wcdb-tests

    def test_query_1(self):
        c = WCDB_login()
        t = WCDB_query(c, 'drop table if exists Test1;')
        t = WCDB_query(
            c, """
create table Test1(
crisisID int unsigned,
personID int unsigned)
;

""")
        self.assertTrue(t == None)

Example #3

File: UTNonObliviscar-TestWCDB.py Project: cs327e-spring-2014/wcdb-tests

 def test_create_3(self):
     c = WCDB_login()
     WCDB_create(c)
     t = WCDB_query(c, 'select * from People;')
     self.assertTrue(t == ())

Example #4

File: UTNonObliviscar-TestWCDB.py Project: cs327e-spring-2014/wcdb-tests

 def test_create_1(self):
     c = WCDB_login()
     WCDB_create(c)
     t = WCDB_query(c, 'select name from Crises;')
     self.assertTrue(t == ())

Example #5

File: UTNonObliviscar-TestWCDB.py Project: cs327e-spring-2014/wcdb-tests

 def test_query_5(self):
     c = WCDB_login()
     t = WCDB_query(c, 'show tables;')
     self.assertTrue(t != None)
     self.assertTrue(type(t) is tuple)

Example #6

File: UTNonObliviscar-TestWCDB.py Project: cs327e-spring-2014/wcdb-tests

 def test_query_2(self):
     c = WCDB_login()
     t = WCDB_query(c, 'select * from Crises;')
     self.assertTrue(t != None)
     self.assertTrue(type(t) is tuple)

Example #7

File: UTNonObliviscar-TestWCDB.py Project: cs327e-spring-2014/wcdb-tests

 def test_create_4(self):
     c = WCDB_login()
     WCDB_create(c)
     t = WCDB_query(c, 'select * from Resources;')
     self.assertTrue(t == ())