Python Mysql Select Dict,,Python Sel
Python Mysql Select Dict,,Python Sel
Python Select Mysql 日期转换字符串 ,转换为字典
Python 读取出来的数据格式不是正规Json ,读取出来,直接是字典
Python 2.7
import MySQLdbfrom MySQLdb import converters as covconv = cov.conversions.copy()conv[246] = float # convert decimals to floatsconv[10] = str # convert dates to stringsconv[11] = str # convert TimeDelta_or_None to stringsconv[12] = str # convert DateTime_or_None to strings# conv[15] = str # convert DateTime_or_None to stringsconv[7] = str # convert DateTime_or_None to strings# conv[8] = str # convert DateTime_or_None to stringsconn = MySQLdb.connect( host=‘dbhost‘, port=3306, user=‘root‘, passwd=‘‘, db=‘mysql‘, charset=‘utf8‘, conv=conv)cur = conn.cursor(cursorclass = MySQLdb.cursors .DictCursor)cur.execute("select * from proxies_priv")test_data = cur.fetchall()print test_datacur.close()conn.close()
Python 3.+ tornado
#!/usr/bin/env pythonfrom __future__ import print_functionimport pymysqlfrom tornado import ioloop, genfrom tornado_mysql import poolsfrom pymysql import converters as cov# from MySQLdb import converters as covfrom tornado_mysql.cursors import DictCursorpools.DEBUG = Trueconv = cov.conversions.copy()conv[246] = float # convert decimals to floatsconv[10] = str # convert dates to stringsconv[11] = str # convert TimeDelta_or_None to stringsconv[12] = str # convert DateTime_or_None to strings# conv[15] = str # convert DateTime_or_None to stringsconv[7] = str # convert DateTime_or_None to stringsPOOL = pools.Pool( dict(host=‘dbhost‘, port=3306, user=‘root‘, passwd=‘‘, db=‘mysql‘, charset=‘utf8‘, conv=conv ,cursorclass=DictCursor) , max_idle_connections=1, max_recycle_sec=3)@gen.coroutinedef worker(n): cur = yield POOL.execute("SELECT * FROM proxies_priv limit 10") print(cur.fetchall())@gen.coroutinedef main(): workers = [worker(i) for i in range(1)] yield workersioloop.IOLoop.current().run_sync(main)print(POOL._opened_conns)
输出结果
[{‘User‘: ‘root‘, ‘Host‘: ‘localhost‘, ‘Proxied_host‘: ‘‘, ‘With_grant‘: 1, ‘Proxied_user‘: ‘‘, ‘Timestamp‘: ‘2017-05-04 09:07:49‘, ‘Grantor‘: ‘‘}, {‘User‘: ‘root‘, ‘Host‘: ‘pe-stats.wondershare.cn‘, ‘Proxied_host‘: ‘‘, ‘With_grant‘: 1, ‘Proxied_user‘: ‘‘, ‘Timestamp‘: ‘2017-05-04 09:07:49‘, ‘Grantor‘: ‘‘}]
Python Mysql Select Dict
相关内容
- python求均值、方差、标准差,,import num
- 【python学习】今天看看学习 %d ,%s, %f 等用法,下面的学
- python接口自动化 - Requests-1,,安装 Request
- Python豆瓣书籍信息爬虫,,练习下Beautif
- 利用Python进行SEPM virus definition自动下载:(一)环境准
- python isdigit()函数,,isdigit()
- 【Python】Java程序员学习Python(七)— 文本类详解(字
- Python —— 二分查找,,二分查找:l = [
- Python日记_os.urandom,,Python中os.
- 从尾到头打印链表(Python and C++解法),,题目: 输
评论关闭