main
|
Last change
on this file was
42bd667,
checked in by David Fuertes <dfuertes@…>, 4 years ago
|
|
Historial Limpio
|
-
Property mode set to
100755
|
|
File size:
649 bytes
|
| Line | |
|---|
| 1 | import pymysql |
|---|
| 2 | from pymysql.tests import base |
|---|
| 3 | |
|---|
| 4 | class TestExample(base.PyMySQLTestCase): |
|---|
| 5 | def test_example(self): |
|---|
| 6 | conn = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='', db='mysql') |
|---|
| 7 | |
|---|
| 8 | |
|---|
| 9 | cur = conn.cursor() |
|---|
| 10 | |
|---|
| 11 | cur.execute("SELECT Host,User FROM user") |
|---|
| 12 | |
|---|
| 13 | # print cur.description |
|---|
| 14 | |
|---|
| 15 | # r = cur.fetchall() |
|---|
| 16 | # print r |
|---|
| 17 | # ...or... |
|---|
| 18 | u = False |
|---|
| 19 | |
|---|
| 20 | for r in cur.fetchall(): |
|---|
| 21 | u = u or conn.user in r |
|---|
| 22 | |
|---|
| 23 | self.assertTrue(u) |
|---|
| 24 | |
|---|
| 25 | cur.close() |
|---|
| 26 | conn.close() |
|---|
| 27 | |
|---|
| 28 | __all__ = ["TestExample"] |
|---|
| 29 | |
|---|
| 30 | if __name__ == "__main__": |
|---|
| 31 | import unittest |
|---|
| 32 | unittest.main() |
|---|
Note: See
TracBrowser
for help on using the repository browser.
