def test_example(self): conn = pymysql.connect(host='127.0.0.1', port=3306, user='******', passwd='', db='mysql') cur = conn.cursor() cur.execute("SELECT Host,User FROM user") # print cur.description # r = cur.fetchall() # print r # ...or... u = False for r in cur.fetchall(): u = u or conn.user in r self.assertTrue(u) cur.close() conn.close()
def setUp(self): try: self.connections = [] for params in self.databases: self.connections.append(pymysql.connect(**params)) except pymysql.err.OperationalError as e: self.skipTest("Cannot connect to MySQL - skipping pymysql tests because of (%s) %s" % (type(e), e))
def test_issue_6(self): """ exception: TypeError: ord() expected a character, but string of length 0 found """ conn = pymysql.connect(host="localhost", user="******", passwd="", db="mysql") c = conn.cursor() c.execute("select * from user") conn.close()
def test_issue_33(self): conn = pymysql.connect(host="localhost", user="******", db=self.databases[0]["db"], charset="utf8") c = conn.cursor() try: c.execute(_uni("create table hei\xc3\x9fe (name varchar(32))", "utf8")) c.execute(_uni("insert into hei\xc3\x9fe (name) values ('Pi\xc3\xb1ata')", "utf8")) c.execute(_uni("select name from hei\xc3\x9fe", "utf8")) self.assertEqual(_uni("Pi\xc3\xb1ata","utf8"), c.fetchone()[0]) finally: c.execute(_uni("drop table hei\xc3\x9fe", "utf8"))
def setUp(self): try: self.connections = [] for params in self.databases: self.connections.append(pymysql.connect(**params)) except pymysql.err.OperationalError as e: self.skipTest( 'Cannot connect to MySQL - skipping pymysql tests because of (%s) %s' % (type(e), e))
def test_issue_33(self): conn = pymysql.connect(host="localhost", user="******", db=self.databases[0]["db"], charset="utf8") c = conn.cursor() try: c.execute( _uni("create table hei\xc3\x9fe (name varchar(32))", "utf8")) c.execute( _uni( "insert into hei\xc3\x9fe (name) values ('Pi\xc3\xb1ata')", "utf8")) c.execute(_uni("select name from hei\xc3\x9fe", "utf8")) self.assertEqual(_uni("Pi\xc3\xb1ata", "utf8"), c.fetchone()[0]) finally: c.execute(_uni("drop table hei\xc3\x9fe", "utf8"))
def test_issue_17(self): """ could not connect mysql use passwod """ conn = self.connections[0] host = self.databases[0]["host"] db = self.databases[0]["db"] c = conn.cursor() # grant access to a table to a user with a password try: c.execute("create table issue17 (x varchar(32) primary key)") c.execute("insert into issue17 (x) values ('hello, world!')") c.execute("grant all privileges on %s.issue17 to 'issue17user'@'%%' identified by '1234'" % db) conn.commit() conn2 = pymysql.connect(host=host, user="******", passwd="1234", db=db) c2 = conn2.cursor() c2.execute("select x from issue17") self.assertEqual("hello, world!", c2.fetchone()[0]) finally: c.execute("drop table issue17")
def test_issue_17(self): """ could not connect mysql use passwod """ conn = self.connections[0] host = self.databases[0]["host"] db = self.databases[0]["db"] c = conn.cursor() # grant access to a table to a user with a password try: c.execute("create table issue17 (x varchar(32) primary key)") c.execute("insert into issue17 (x) values ('hello, world!')") c.execute( "grant all privileges on %s.issue17 to 'issue17user'@'%%' identified by '1234'" % db) conn.commit() conn2 = pymysql.connect(host=host, user="******", passwd="1234", db=db) c2 = conn2.cursor() c2.execute("select x from issue17") self.assertEqual("hello, world!", c2.fetchone()[0]) finally: c.execute("drop table issue17")
def test_issue_34(self): try: pymysql.connect(host="localhost", port=1237, user="******") self.fail() except pymysql.OperationalError, e: self.assertEqual(2003, e.args[0])
def test_issue_6(self): """ exception: TypeError: ord() expected a character, but string of length 0 found """ conn = pymysql.connect(host="localhost",user="******",passwd="",db="mysql") c = conn.cursor() c.execute("select * from user") conn.close()