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()
