python多线程访问sqlite3_sqlite3 多线程高并发的访问如何处理？

11

2017-01-19 11:50:02 +08:00

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