楼主改 py2 了记得也贴下

# coding:utf-8
import sqlite3
import queue, os


def singleton(cls):
instances = {}

def _singleton(*args, **kw):
if cls not in instances:
instances[cls] = cls(*args, **kw)
return instances[cls]

return _singleton


@singleton
class SQLiteUtil(object):
__queue_conn = queue.Queue(maxsize=1)
__path = None

def __init__(self, path):
self.__path = path
print('path:', self.__path)
self.__create_conn()

def __create_conn(self):
conn = sqlite3.connect(self.__path, check_same_thread=False)
self.__queue_conn.put(conn)

def __close(self, cursor, conn):
if cursor is not None:
cursor.close()
if conn is not None:
cursor.close()
self.__create_conn()

def execute_query(self, sql, params):
conn = self.__queue_conn.get()
cursor = conn.cursor()
value = None
try:
records = None
if not params is None:
records = cursor.execute(sql, params).fetchall()
else:
records = cursor.execute(sql).fetchall()
field = [i[0] for i in cursor.description]
value = [dict(zip(field, i)) for i in records]
finally:
self.__close(cursor, conn)
return value

def executescript(self, sql):
conn = self.__queue_conn.get()
cursor = conn.cursor()
try:
cursor.executescript(sql)
conn.commit()
except Exception as e:
conn.rollback()
raise
finally:
self.__close(cursor, conn)

def execute_update(self, sql, params):
return self.execute_update_many([sql], [params])

def execute_update_many(self, sql_list, params_list):
conn = self.__queue_conn.get()
cursor = conn.cursor()
count = 0
try:
for index in range(len(sql_list)):
sql = sql_list[index]
params = params_list[index]
if not params is None:
count += cursor.execute(sql, params).rowcount
else:
count += cursor.execute(sql).rowcount
conn.commit()
except Exception as e:
conn.rollback()
raise
finally:
self.__close(cursor, conn)
return count


'''
example:

one = SQLiteUtil('xxx.sqlite')

rst = one.execute_query('select * from website', None)
for line in rst:
print(line.get('id'), line.get('url'), line.get('content'))


print(one.execute_update('update website set content = \'2222222\' where id = ?', ('1',)))
print(one.execute_update('update website set content = \'2222222\' where id = \'1\'', None))


print('update many')
count = one.execute_update_many(
[
'update website set content = \'一\' where id = \'1\'',
'update website set content = \'二\' where id = \'2\'',
'update website set content = 1 where id = \'3\''
],
[None, None, None]
)
print('count:', count)
'''

python3 的 用 py2 自己改改，可抗千万级并发[v2ex 滑稽专属表情]

https://www.zhihu.com/question/19803440
问前先搜索，爬虫不现实

去掉所有文字，单击换色，方可解决所有设备

可能因为 gif 帧大小不一样

楼主要不贴我的微信二维码，支付宝也行，比特币 paypal 也还行

@gaobh 企业用的软件不建议小白话，因为需求多种多样，功能不怕多就怕没有，参见 office 系列，功能一多很考验设计能力，要不然以后 bug 一大堆

还不错，套个 https://github.com/electron/electron 搞个离线程序，加登录

帮你顶一个，行内人柿来说说

@oooovvssdsx 我是重度鼠标点按用户， macbook 自带触版手磨的不能自理，划来划去太费劲了

@163.com 不专业，说不定是坑

以前百度网盘出 bug ，我不是会员 100M 带宽，居然能 7 、 8KB 的下载，老感动了！

百度网盘不是非会员禁止下载吗？[滑稽]

[http://p1.bpimg.com/567571/a7c0b11fc0d98417.png]


滚轮对 macbook 支持最好的鼠标我用过的：
M558 、 Microsoft Designer 、 Microsoft Designer 2014 ，仅仅是中间的滚轮

我的鼠标设置，卸载厂商鼠标驱动：
系统-偏好设置-鼠标-滚动方向:自然-跟踪速度 5 档-滚动速度 4 档