def test_simple_query(self): c = mysqlp.connect('testuser1', 'pass1', database='mysqlp_test'); cur = c.cursor() cur.execute('BEGIN') cur.execute('SELECT 1') cur.fetchall() c.commit() cur.close() c.close()
#!/usr/bin/python import logging import mysqlp if '__main__' == __name__: logging.basicConfig(level=logging.DEBUG) conn = mysqlp.connect(user='******', db='test') c = conn.cursor() c.execute('SELECT 1, 2, "three"') print c.fetchall() c.close() conn.close()
def test_password323(self): """Old style password login.""" c = mysqlp.connect('testuser2', 'pass2', database='mysqlp_test'); c.close()
def test_password(self): """Basic login.""" c = mysqlp.connect('testuser1', 'pass1', database='mysqlp_test'); c.close()