Python DB Exemples

Exemple #1

Fichier : test_xn_reset.py Projet : zms-publishing/ZPsycopgDA

 def test_issue_142(self):
     conn = DB(testconfig.dsn, tilevel=2, typecasts={})
     conn.open()
     try:
         cur1 = conn.getcursor()
         cur1.execute("create table test142(id integer)")
         cur1.close()
         cur2 = conn.getcursor()
         cur2.execute("insert into test142 values (1)")
         cur2.close()
         cur3 = conn.getcursor()
         cur3.execute("select * from test142")
         self.assertEquals(cur3.fetchone(), (1, ))
         cur3.close()
     finally:
         conn.close()

Exemple #2

Fichier : test_xn_reset.py Projet : Feneric/ZPsycopgDA

 def test_issue_142(self):
     conn = DB(testconfig.dsn, tilevel=2, typecasts={})
     conn.open()
     try:
         cur1 = conn.getcursor()
         cur1.execute("create table test142(id integer)")
         cur1.close()
         cur2 = conn.getcursor()
         cur2.execute("insert into test142 values (1)")
         cur2.close()
         cur3 = conn.getcursor()
         cur3.execute("select * from test142")
         self.assertEquals(cur3.fetchone(), (1,))
         cur3.close()
     finally:
         conn.close()

Exemple #3

 def DA_connect():
     db = DB(testconfig.dsn, tilevel=2, typecasts=typecasts)
     db.open()
     return db

Exemple #4

Fichier : test_da_threading.py Projet : Feneric/ZPsycopgDA

 def DA_connect():
     db = DB(testconfig.dsn, tilevel=2, typecasts=typecasts)
     db.open()
     return db