<reponame>athaun/Python-ai-assistant<gh_stars>1-10
""" Persistent cache storage for web ressources, with different cache eviction strategies, and optional compression. """

__version__ = "1.1.0"
__author__ = "desbma"
__license__ = "LGPLv2"

import bz2
import collections
import enum
import functools
import inspect
import lzma
import os
import pickle
import queue
import sqlite3
import threading
import zlib


DB_FORMAT_VERSION = 2  # incremented at each incompatible database/pickle format change
PICKLE_PROTOCOL_VERSION = 4
DISABLE_PERSISTENT_CACHING = False  # useful for tests


class Compression(enum.IntEnum):
  NONE = 0
  DEFLATE = 1
  BZIP2 = 2
  LZMA = 3


CachingStrategy = enum.Enum("CachingStrategy", ("FIFO", "LRU"))


class WebCache:

  def __init__(self, db_filepath, table_name, *, caching_strategy, expiration=None, compression=Compression.NONE,
               compression_level=9, auto_compression_threshold=1, safe_mode=False):
    """
    Args:
      db_filepath: Database filepath
      table_name: Database table name used for the cache
      caching_strategy: CachingStrategy enum defining how cache entries are removed
      expiration: Cache item lifetime in seconds, used to clean items with the FIFO and LRU strateges, or None if items
        never expire
      compression: Algorithm used to compress cache items
      compression_level: Compression level (0-9)
      auto_compression_threshold: Don't compress if compression ratio is above this value
      safe_mode: If False, will enable some optimizations that increase cache write speed, but may compromise cache
        integrity in case of Python crash or power loss
    """
    # attribs
    self.__table_name = table_name
    assert(caching_strategy in CachingStrategy)
    self.__caching_strategy = caching_strategy
    self.__expiration = expiration
    assert(compression in Compression)
    self.__compression = compression
    self.__compression_level = compression_level
    assert(0 < auto_compression_threshold <= 1)
    self.__auto_compression_threshold = auto_compression_threshold

    # connection
    if DISABLE_PERSISTENT_CACHING:
      self.__connection = sqlite3.connect(":memory:")
    else:
      self.__db_filepath = db_filepath
      self.__connection = sqlite3.connect(self.__db_filepath)

    # create tables if necessary
    with self.__connection:
      if not safe_mode:
        # enable some optimizations that can cause data corruption in case of power loss or python crash
        self.__connection.executescript("""PRAGMA journal_mode = MEMORY;
                                           PRAGMA synchronous = OFF;""")
      self.__connection.execute("""CREATE TABLE IF NOT EXISTS %s
                                   (
                                     url TEXT PRIMARY KEY,
                                     added_timestamp INTEGER NOT NULL,
                                     last_accessed_timestamp INTEGER NOT NULL,
                                     compression INTEGER NOT NULL,
                                     data BLOB NOT NULL
                                   );""" % (self.getDbTableName()))
      self.__connection.execute("""CREATE TABLE IF NOT EXISTS %s
                                   (
                                     url TEXT NOT NULL,
                                     post_data BLOB NOT NULL,
                                     added_timestamp INTEGER NOT NULL,
                                     last_accessed_timestamp INTEGER NOT NULL,
                                     compression INTEGER NOT NULL,
                                     data BLOB NOT NULL
                                   );""" % (self.getDbTableName(post=True)))
      self.__connection.execute("CREATE INDEX IF NOT EXISTS idx ON %s(url, post_data);" % (self.getDbTableName(post=True)))

    # stats
    self.__hit_count = 0
    self.__miss_count = 0

  def getDbTableName(self, *, post=False):
    """ Get sqlite table name. """
    return "%s%s_f%u" % (self.__table_name, "_post" if post else "", DB_FORMAT_VERSION)

  def getDatabaseFileSize(self):
    """ Return the file size of the database as a pretty string. """
    if DISABLE_PERSISTENT_CACHING:
      return "?"
    size = os.path.getsize(self.__db_filepath)
    if size > 1000000000:
      size = "%0.3fGB" % (size / 1000000000)
    elif size > 1000000:
      size = "%0.2fMB" % (size / 1000000)
    elif size > 1000:
      size = "%uKB" % (size // 1000)
    else:
      size = "%uB" % (size)
    return size

  def getCacheHitStats(self):
    return self.__hit_count, self.__miss_count

  def __len__(self):
    """ Return the number of items in the cache. """
    row_count = 0
    with self.__connection:
      for post in (False, True):
        row_count += self.__connection.execute("SELECT COUNT(*) FROM %s;" % (self.getDbTableName(post=post))).fetchone()[0]
    return row_count

  def __del__(self):
    try:
      self.__connection.close()
    except AttributeError:
      pass

  def __getitem__(self, url_data):
    """ Get an item from cache. """
    if isinstance(url_data, tuple):
      url, post_data = url_data
    else:
      url = url_data
      post_data = None

    with self.__connection:
      if post_data is not None:
        post_bin_data = sqlite3.Binary(pickle.dumps(post_data, protocol=PICKLE_PROTOCOL_VERSION))
        r = self.__connection.execute("""SELECT data, compression
                                         FROM %s
                                         WHERE url = ? AND
                                               post_data = ?;""" % (self.getDbTableName(post=True)),
                                      (url, post_bin_data)).fetchone()
      else:
        r = self.__connection.execute("""SELECT data, compression
                                         FROM %s
                                         WHERE url = ?;""" % (self.getDbTableName()),
                                      (url,)).fetchone()
    if not r:
      raise KeyError(url_data)
    data, compression = r

    if compression == Compression.DEFLATE:
      buffer = memoryview(data)
      data = zlib.decompress(buffer)
    elif compression == Compression.BZIP2:
      buffer = memoryview(data)
      data = bz2.decompress(buffer)
    elif compression == Compression.LZMA:
      buffer = memoryview(data)
      data = lzma.decompress(buffer)

    if self.__caching_strategy is CachingStrategy.LRU:
      # update last access time
      with self.__connection:
        if post_data is not None:
          self.__connection.execute("UPDATE " +
                                    self.getDbTableName(post=True) + " " +
                                    "SET last_accessed_timestamp = strftime('%s', 'now') WHERE url = ? AND post_data = ?;",
                                    (url, post_bin_data))
        else:
          self.__connection.execute("UPDATE " +
                                    self.getDbTableName() + " " +
                                    "SET last_accessed_timestamp = strftime('%s', 'now') WHERE url = ?;",
                                    (url,))
    return data

  def __setitem__(self, url_data, data):
    """ Store an item in cache. """
    if isinstance(url_data, tuple):
      url, post_data = url_data
    else:
      url = url_data
      post_data = None

    if self.__compression is Compression.DEFLATE:
      buffer = memoryview(data)
      compressed_data = zlib.compress(buffer, self.__compression_level)
    elif self.__compression is Compression.BZIP2:
      buffer = memoryview(data)
      compressed_data = bz2.compress(buffer, compresslevel=self.__compression_level)
    elif self.__compression is Compression.LZMA:
      buffer = memoryview(data)
      compressed_data = lzma.compress(buffer, format=lzma.FORMAT_ALONE, preset=self.__compression_level)

    if (self.__compression is Compression.NONE) or (len(compressed_data) > len(data) * self.__auto_compression_threshold):
      data_to_store = data
      compression = Compression.NONE
    else:
      data_to_store = compressed_data
      compression = self.__compression

    # if self.__compression is not Compression.NONE:
    #   print("%s compression: "
    #         "original size = %u b, "
    #         "compressed size = %u b, "
    #         "compression threshold (%.1f%%) = %u b" % ("Disabling" if (compression is Compression.NONE) else "Enabling",
    #                                                    len(data),
    #                                                    len(compressed_data),
    #                                                    self.__auto_compression_threshold * 100,
    #                                                    self.__auto_compression_threshold * len(data)))

    with self.__connection:
      if post_data is not None:
        post_bin_data = sqlite3.Binary(pickle.dumps(post_data, protocol=PICKLE_PROTOCOL_VERSION))
        self.__connection.execute("INSERT OR REPLACE INTO " +
                                  self.getDbTableName(post=True) +
                                  " (url, post_data, added_timestamp, last_accessed_timestamp, compression, data) VALUES (?, ?, strftime('%s','now'), strftime('%s','now'), ?, ?);",
                                  (url, post_bin_data, compression, sqlite3.Binary(data_to_store)))
      else:
        self.__connection.execute("INSERT OR REPLACE INTO " +
                                  self.getDbTableName() +
                                  " (url, added_timestamp, last_accessed_timestamp, compression, data) VALUES (?, strftime('%s','now'), strftime('%s','now'), ?, ?);",
                                  (url, compression, sqlite3.Binary(data_to_store)))

  def __delitem__(self, url_data):
    """ Remove an item from cache. """
    if isinstance(url_data, tuple):
      url, post_data = url_data
    else:
      url = url_data
      post_data = None

    with self.__connection:
      if post_data is not None:
        post_bin_data = sqlite3.Binary(pickle.dumps(post_data, protocol=PICKLE_PROTOCOL_VERSION))
        deleted_count = self.__connection.execute("DELETE FROM " + self.getDbTableName(post=True) + " " +
                                                  "WHERE url = ? AND post_data = ?;",
                                                  (url, post_bin_data)).rowcount
      else:
        deleted_count = self.__connection.execute("DELETE FROM " + self.getDbTableName() + " WHERE url = ?;",
                                                  (url,)).rowcount
    if deleted_count == 0:
      raise KeyError(url_data)

  def purge(self):
    """ Purge cache by removing obsolete items. """
    purged_count = 0
    if self.__expiration is not None:
      with self.__connection:
        if self.__caching_strategy is CachingStrategy.FIFO:
          # dump least recently added rows
          for post in (False, True):
            purged_count += self.__connection.execute("DELETE FROM " +
                                                      self.getDbTableName(post=post) + " "
                                                      "WHERE (strftime('%s', 'now') - added_timestamp) > ?;",
                                                      (self.__expiration,)).rowcount
        elif self.__caching_strategy is CachingStrategy.LRU:
          # dump least recently accessed rows
          for post in (False, True):
            purged_count += self.__connection.execute("DELETE FROM " +
                                                      self.getDbTableName(post=post) + " "
                                                      "WHERE (strftime('%s', 'now') - last_accessed_timestamp) > ?;",
                                                      (self.__expiration,)).rowcount
    return purged_count

  def __contains__(self, url_data):
    """ Return true if an item is present in cache for that url, False instead. """
    if isinstance(url_data, tuple):
      url, post_data = url_data
    else:
      url = url_data
      post_data = None

    with self.__connection:
      if post_data is not None:
        post_bin_data = sqlite3.Binary(pickle.dumps(post_data, protocol=PICKLE_PROTOCOL_VERSION))
        hit = (self.__connection.execute("""SELECT COUNT(*)
                                            FROM %s
                                            WHERE url = ? AND
                                                  post_data = ?;""" % (self.getDbTableName(post=True)),
                                         (url, post_bin_data)).fetchone()[0] > 0)
      else:
        hit = (self.__connection.execute("""SELECT COUNT(*)
                                            FROM %s
                                            WHERE url = ?;""" % (self.getDbTableName()),
                                         (url,)).fetchone()[0] > 0)
    if hit:
      self.__hit_count += 1
    else:
      self.__miss_count += 1
    return hit


class ThreadedWebCache:

  """
  Similar to WebCache, but delegate all sqlite3 calls to a dedicated thread.

  This allows getting rid of the 'same thread' sqlite3 module limitation.
  Caller thread send calls in the execute queue and get the results in the result queue.
  All calls are blocking and synchronous.

  """

  def __init__(self, *args, **kwargs):
    # this is the tricky part:
    # attach methods from WebCache, decorated by callToThread, to this object's class
    methods = inspect.getmembers(WebCache, inspect.isfunction)
    for method_name, method in methods:
      if (method_name in ("__init__", "__del__")) or (method_name not in WebCache.__dict__):
        continue
      new_method = __class__.callToThread(method)
      setattr(self.__class__, method_name, new_method)
    # start thread
    self.thread = WebCacheThread()
    self.thread.execute_queue.put_nowait((threading.get_ident(), args, kwargs))
    self.thread.start()
    self.thread.execute_queue.join()
    # check WebCache object construction went ok
    try:
      e = self.thread.exception_queue[threading.get_ident()].get_nowait()
    except queue.Empty:
      pass
    else:
      raise e

  def __del__(self):
    self.thread.stop()

  def waitResult(self):
    """ Wait for the execution of the last enqueued job to be done, and return the result or raise an exception. """
    self.thread.execute_queue.join()
    try:
      e = self.thread.exception_queue[threading.get_ident()].get_nowait()
    except queue.Empty:
      return self.thread.result_queue[threading.get_ident()].get_nowait()
    else:
      raise e

  @staticmethod
  def callToThread(method):
    """ Wrap call to method to send it to WebCacheThread. """
    def func_wrapped(self, *args, **kwargs):
      self.thread.execute_queue.put_nowait((threading.get_ident(), method, args, kwargs))
      return self.waitResult()
    return func_wrapped


class WebCacheThread(threading.Thread):

  """ Thread executing all sqlite3 calls for the ThreadedWebCache class. """

  def __init__(self):
    self.execute_queue = queue.Queue()
    self.exception_queue = collections.defaultdict(functools.partial(queue.Queue, maxsize=1))
    self.result_queue = collections.defaultdict(functools.partial(queue.Queue, maxsize=1))
    self.loop = True
    super().__init__(name=__class__.__name__, daemon=True)

  def run(self):
    """ Thread loop. """
    # construct WebCache object locally
    thread_id, args, kwargs = self.execute_queue.get_nowait()
    try:
      cache_obj = WebCache(*args, **kwargs)
    except Exception as e:
      self.exception_queue[thread_id].put_nowait(e)
      self.loop = False
    self.execute_queue.task_done()

    # execute loop
    while self.loop:
      msg = self.execute_queue.get()
      if msg is None:
        # thread exist requested
        assert(not self.loop)
        break
      thread_id, method, args, kwargs = msg
      try:
        result = method(cache_obj, *args, **kwargs)
      except Exception as e:
        self.exception_queue[thread_id].put_nowait(e)
      else:
        self.result_queue[thread_id].put_nowait(result)
      self.execute_queue.task_done()

  def stop(self):
    """ Request thread stop. """
    self.loop = False
    self.execute_queue.put_nowait(None)

""" Persistent cache storage for web ressources, with different cache eviction strategies, and optional compression. """

__version__ = "1.1.0"
__author__ = "desbma"
__license__ = "LGPLv2"

import bz2
import collections
import enum
import functools
import inspect
import lzma
import os
import pickle
import queue
import sqlite3
import threading
import zlib


DB_FORMAT_VERSION = 2  # incremented at each incompatible database/pickle format change
PICKLE_PROTOCOL_VERSION = 4
DISABLE_PERSISTENT_CACHING = False  # useful for tests


class Compression(enum.IntEnum):
  NONE = 0
  DEFLATE = 1
  BZIP2 = 2
  LZMA = 3


CachingStrategy = enum.Enum("CachingStrategy", ("FIFO", "LRU"))


class WebCache:

  def __init__(self, db_filepath, table_name, *, caching_strategy, expiration=None, compression=Compression.NONE,
               compression_level=9, auto_compression_threshold=1, safe_mode=False):
    """
    Args:
      db_filepath: Database filepath
      table_name: Database table name used for the cache
      caching_strategy: CachingStrategy enum defining how cache entries are removed
      expiration: Cache item lifetime in seconds, used to clean items with the FIFO and LRU strateges, or None if items
        never expire
      compression: Algorithm used to compress cache items
      compression_level: Compression level (0-9)
      auto_compression_threshold: Don't compress if compression ratio is above this value
      safe_mode: If False, will enable some optimizations that increase cache write speed, but may compromise cache
        integrity in case of Python crash or power loss
    """
    # attribs
    self.__table_name = table_name
    assert(caching_strategy in CachingStrategy)
    self.__caching_strategy = caching_strategy
    self.__expiration = expiration
    assert(compression in Compression)
    self.__compression = compression
    self.__compression_level = compression_level
    assert(0 < auto_compression_threshold <= 1)
    self.__auto_compression_threshold = auto_compression_threshold

    # connection
    if DISABLE_PERSISTENT_CACHING:
      self.__connection = sqlite3.connect(":memory:")
    else:
      self.__db_filepath = db_filepath
      self.__connection = sqlite3.connect(self.__db_filepath)

    # create tables if necessary
    with self.__connection:
      if not safe_mode:
        # enable some optimizations that can cause data corruption in case of power loss or python crash
        self.__connection.executescript("""PRAGMA journal_mode = MEMORY;
                                           PRAGMA synchronous = OFF;""")
      self.__connection.execute("""CREATE TABLE IF NOT EXISTS %s
                                   (
                                     url TEXT PRIMARY KEY,
                                     added_timestamp INTEGER NOT NULL,
                                     last_accessed_timestamp INTEGER NOT NULL,
                                     compression INTEGER NOT NULL,
                                     data BLOB NOT NULL
                                   );""" % (self.getDbTableName()))
      self.__connection.execute("""CREATE TABLE IF NOT EXISTS %s
                                   (
                                     url TEXT NOT NULL,
                                     post_data BLOB NOT NULL,
                                     added_timestamp INTEGER NOT NULL,
                                     last_accessed_timestamp INTEGER NOT NULL,
                                     compression INTEGER NOT NULL,
                                     data BLOB NOT NULL
                                   );""" % (self.getDbTableName(post=True)))
      self.__connection.execute("CREATE INDEX IF NOT EXISTS idx ON %s(url, post_data);" % (self.getDbTableName(post=True)))

    # stats
    self.__hit_count = 0
    self.__miss_count = 0

  def getDbTableName(self, *, post=False):
    """ Get sqlite table name. """
    return "%s%s_f%u" % (self.__table_name, "_post" if post else "", DB_FORMAT_VERSION)

  def getDatabaseFileSize(self):
    """ Return the file size of the database as a pretty string. """
    if DISABLE_PERSISTENT_CACHING:
      return "?"
    size = os.path.getsize(self.__db_filepath)
    if size > 1000000000:
      size = "%0.3fGB" % (size / 1000000000)
    elif size > 1000000:
      size = "%0.2fMB" % (size / 1000000)
    elif size > 1000:
      size = "%uKB" % (size // 1000)
    else:
      size = "%uB" % (size)
    return size

  def getCacheHitStats(self):
    return self.__hit_count, self.__miss_count

  def __len__(self):
    """ Return the number of items in the cache. """
    row_count = 0
    with self.__connection:
      for post in (False, True):
        row_count += self.__connection.execute("SELECT COUNT(*) FROM %s;" % (self.getDbTableName(post=post))).fetchone()[0]
    return row_count

  def __del__(self):
    try:
      self.__connection.close()
    except AttributeError:
      pass

  def __getitem__(self, url_data):
    """ Get an item from cache. """
    if isinstance(url_data, tuple):
      url, post_data = url_data
    else:
      url = url_data
      post_data = None

    with self.__connection:
      if post_data is not None:
        post_bin_data = sqlite3.Binary(pickle.dumps(post_data, protocol=PICKLE_PROTOCOL_VERSION))
        r = self.__connection.execute("""SELECT data, compression
                                         FROM %s
                                         WHERE url = ? AND
                                               post_data = ?;""" % (self.getDbTableName(post=True)),
                                      (url, post_bin_data)).fetchone()
      else:
        r = self.__connection.execute("""SELECT data, compression
                                         FROM %s
                                         WHERE url = ?;""" % (self.getDbTableName()),
                                      (url,)).fetchone()
    if not r:
      raise KeyError(url_data)
    data, compression = r

    if compression == Compression.DEFLATE:
      buffer = memoryview(data)
      data = zlib.decompress(buffer)
    elif compression == Compression.BZIP2:
      buffer = memoryview(data)
      data = bz2.decompress(buffer)
    elif compression == Compression.LZMA:
      buffer = memoryview(data)
      data = lzma.decompress(buffer)

    if self.__caching_strategy is CachingStrategy.LRU:
      # update last access time
      with self.__connection:
        if post_data is not None:
          self.__connection.execute("UPDATE " +
                                    self.getDbTableName(post=True) + " " +
                                    "SET last_accessed_timestamp = strftime('%s', 'now') WHERE url = ? AND post_data = ?;",
                                    (url, post_bin_data))
        else:
          self.__connection.execute("UPDATE " +
                                    self.getDbTableName() + " " +
                                    "SET last_accessed_timestamp = strftime('%s', 'now') WHERE url = ?;",
                                    (url,))
    return data

  def __setitem__(self, url_data, data):
    """ Store an item in cache. """
    if isinstance(url_data, tuple):
      url, post_data = url_data
    else:
      url = url_data
      post_data = None

    if self.__compression is Compression.DEFLATE:
      buffer = memoryview(data)
      compressed_data = zlib.compress(buffer, self.__compression_level)
    elif self.__compression is Compression.BZIP2:
      buffer = memoryview(data)
      compressed_data = bz2.compress(buffer, compresslevel=self.__compression_level)
    elif self.__compression is Compression.LZMA:
      buffer = memoryview(data)
      compressed_data = lzma.compress(buffer, format=lzma.FORMAT_ALONE, preset=self.__compression_level)

    if (self.__compression is Compression.NONE) or (len(compressed_data) > len(data) * self.__auto_compression_threshold):
      data_to_store = data
      compression = Compression.NONE
    else:
      data_to_store = compressed_data
      compression = self.__compression

    # if self.__compression is not Compression.NONE:
    #   print("%s compression: "
    #         "original size = %u b, "
    #         "compressed size = %u b, "
    #         "compression threshold (%.1f%%) = %u b" % ("Disabling" if (compression is Compression.NONE) else "Enabling",
    #                                                    len(data),
    #                                                    len(compressed_data),
    #                                                    self.__auto_compression_threshold * 100,
    #                                                    self.__auto_compression_threshold * len(data)))

    with self.__connection:
      if post_data is not None:
        post_bin_data = sqlite3.Binary(pickle.dumps(post_data, protocol=PICKLE_PROTOCOL_VERSION))
        self.__connection.execute("INSERT OR REPLACE INTO " +
                                  self.getDbTableName(post=True) +
                                  " (url, post_data, added_timestamp, last_accessed_timestamp, compression, data) VALUES (?, ?, strftime('%s','now'), strftime('%s','now'), ?, ?);",
                                  (url, post_bin_data, compression, sqlite3.Binary(data_to_store)))
      else:
        self.__connection.execute("INSERT OR REPLACE INTO " +
                                  self.getDbTableName() +
                                  " (url, added_timestamp, last_accessed_timestamp, compression, data) VALUES (?, strftime('%s','now'), strftime('%s','now'), ?, ?);",
                                  (url, compression, sqlite3.Binary(data_to_store)))

  def __delitem__(self, url_data):
    """ Remove an item from cache. """
    if isinstance(url_data, tuple):
      url, post_data = url_data
    else:
      url = url_data
      post_data = None

    with self.__connection:
      if post_data is not None:
        post_bin_data = sqlite3.Binary(pickle.dumps(post_data, protocol=PICKLE_PROTOCOL_VERSION))
        deleted_count = self.__connection.execute("DELETE FROM " + self.getDbTableName(post=True) + " " +
                                                  "WHERE url = ? AND post_data = ?;",
                                                  (url, post_bin_data)).rowcount
      else:
        deleted_count = self.__connection.execute("DELETE FROM " + self.getDbTableName() + " WHERE url = ?;",
                                                  (url,)).rowcount
    if deleted_count == 0:
      raise KeyError(url_data)

  def purge(self):
    """ Purge cache by removing obsolete items. """
    purged_count = 0
    if self.__expiration is not None:
      with self.__connection:
        if self.__caching_strategy is CachingStrategy.FIFO:
          # dump least recently added rows
          for post in (False, True):
            purged_count += self.__connection.execute("DELETE FROM " +
                                                      self.getDbTableName(post=post) + " "
                                                      "WHERE (strftime('%s', 'now') - added_timestamp) > ?;",
                                                      (self.__expiration,)).rowcount
        elif self.__caching_strategy is CachingStrategy.LRU:
          # dump least recently accessed rows
          for post in (False, True):
            purged_count += self.__connection.execute("DELETE FROM " +
                                                      self.getDbTableName(post=post) + " "
                                                      "WHERE (strftime('%s', 'now') - last_accessed_timestamp) > ?;",
                                                      (self.__expiration,)).rowcount
    return purged_count

  def __contains__(self, url_data):
    """ Return true if an item is present in cache for that url, False instead. """
    if isinstance(url_data, tuple):
      url, post_data = url_data
    else:
      url = url_data
      post_data = None

    with self.__connection:
      if post_data is not None:
        post_bin_data = sqlite3.Binary(pickle.dumps(post_data, protocol=PICKLE_PROTOCOL_VERSION))
        hit = (self.__connection.execute("""SELECT COUNT(*)
                                            FROM %s
                                            WHERE url = ? AND
                                                  post_data = ?;""" % (self.getDbTableName(post=True)),
                                         (url, post_bin_data)).fetchone()[0] > 0)
      else:
        hit = (self.__connection.execute("""SELECT COUNT(*)
                                            FROM %s
                                            WHERE url = ?;""" % (self.getDbTableName()),
                                         (url,)).fetchone()[0] > 0)
    if hit:
      self.__hit_count += 1
    else:
      self.__miss_count += 1
    return hit


class ThreadedWebCache:

  """
  Similar to WebCache, but delegate all sqlite3 calls to a dedicated thread.

  This allows getting rid of the 'same thread' sqlite3 module limitation.
  Caller thread send calls in the execute queue and get the results in the result queue.
  All calls are blocking and synchronous.

  """

  def __init__(self, *args, **kwargs):
    # this is the tricky part:
    # attach methods from WebCache, decorated by callToThread, to this object's class
    methods = inspect.getmembers(WebCache, inspect.isfunction)
    for method_name, method in methods:
      if (method_name in ("__init__", "__del__")) or (method_name not in WebCache.__dict__):
        continue
      new_method = __class__.callToThread(method)
      setattr(self.__class__, method_name, new_method)
    # start thread
    self.thread = WebCacheThread()
    self.thread.execute_queue.put_nowait((threading.get_ident(), args, kwargs))
    self.thread.start()
    self.thread.execute_queue.join()
    # check WebCache object construction went ok
    try:
      e = self.thread.exception_queue[threading.get_ident()].get_nowait()
    except queue.Empty:
      pass
    else:
      raise e

  def __del__(self):
    self.thread.stop()

  def waitResult(self):
    """ Wait for the execution of the last enqueued job to be done, and return the result or raise an exception. """
    self.thread.execute_queue.join()
    try:
      e = self.thread.exception_queue[threading.get_ident()].get_nowait()
    except queue.Empty:
      return self.thread.result_queue[threading.get_ident()].get_nowait()
    else:
      raise e

  @staticmethod
  def callToThread(method):
    """ Wrap call to method to send it to WebCacheThread. """
    def func_wrapped(self, *args, **kwargs):
      self.thread.execute_queue.put_nowait((threading.get_ident(), method, args, kwargs))
      return self.waitResult()
    return func_wrapped


class WebCacheThread(threading.Thread):

  """ Thread executing all sqlite3 calls for the ThreadedWebCache class. """

  def __init__(self):
    self.execute_queue = queue.Queue()
    self.exception_queue = collections.defaultdict(functools.partial(queue.Queue, maxsize=1))
    self.result_queue = collections.defaultdict(functools.partial(queue.Queue, maxsize=1))
    self.loop = True
    super().__init__(name=__class__.__name__, daemon=True)

  def run(self):
    """ Thread loop. """
    # construct WebCache object locally
    thread_id, args, kwargs = self.execute_queue.get_nowait()
    try:
      cache_obj = WebCache(*args, **kwargs)
    except Exception as e:
      self.exception_queue[thread_id].put_nowait(e)
      self.loop = False
    self.execute_queue.task_done()

    # execute loop
    while self.loop:
      msg = self.execute_queue.get()
      if msg is None:
        # thread exist requested
        assert(not self.loop)
        break
      thread_id, method, args, kwargs = msg
      try:
        result = method(cache_obj, *args, **kwargs)
      except Exception as e:
        self.exception_queue[thread_id].put_nowait(e)
      else:
        self.result_queue[thread_id].put_nowait(result)
      self.execute_queue.task_done()

  def stop(self):
    """ Request thread stop. """
    self.loop = False
    self.execute_queue.put_nowait(None)
Persistent cache storage for web ressources, with different cache eviction strategies, and optional compression. # incremented at each incompatible database/pickle format change # useful for tests Args:       db_filepath: Database filepath       table_name: Database table name used for the cache       caching_strategy: CachingStrategy enum defining how cache entries are removed       expiration: Cache item lifetime in seconds, used to clean items with the FIFO and LRU strateges, or None if items         never expire       compression: Algorithm used to compress cache items       compression_level: Compression level (0-9)       auto_compression_threshold: Don't compress if compression ratio is above this value       safe_mode: If False, will enable some optimizations that increase cache write speed, but may compromise cache         integrity in case of Python crash or power loss # attribs # connection # create tables if necessary # enable some optimizations that can cause data corruption in case of power loss or python crash PRAGMA journal_mode = MEMORY;                                            PRAGMA synchronous = OFF; CREATE TABLE IF NOT EXISTS %s                                    (                                      url TEXT PRIMARY KEY,                                      added_timestamp INTEGER NOT NULL,                                      last_accessed_timestamp INTEGER NOT NULL,                                      compression INTEGER NOT NULL,                                      data BLOB NOT NULL                                    ); CREATE TABLE IF NOT EXISTS %s                                    (                                      url TEXT NOT NULL,                                      post_data BLOB NOT NULL,                                      added_timestamp INTEGER NOT NULL,                                      last_accessed_timestamp INTEGER NOT NULL,                                      compression INTEGER NOT NULL,                                      data BLOB NOT NULL                                    ); # stats Get sqlite table name. Return the file size of the database as a pretty string. Return the number of items in the cache. Get an item from cache. SELECT data, compression                                          FROM %s                                          WHERE url = ? AND                                                post_data = ?; SELECT data, compression                                          FROM %s                                          WHERE url = ?; # update last access time Store an item in cache. # if self.__compression is not Compression.NONE: #   print("%s compression: " #         "original size = %u b, " #         "compressed size = %u b, " #         "compression threshold (%.1f%%) = %u b" % ("Disabling" if (compression is Compression.NONE) else "Enabling", #                                                    len(data), #                                                    len(compressed_data), #                                                    self.__auto_compression_threshold * 100, #                                                    self.__auto_compression_threshold * len(data))) Remove an item from cache. Purge cache by removing obsolete items. # dump least recently added rows # dump least recently accessed rows Return true if an item is present in cache for that url, False instead. SELECT COUNT(*)                                             FROM %s                                             WHERE url = ? AND                                                   post_data = ?; SELECT COUNT(*)                                             FROM %s                                             WHERE url = ?; Similar to WebCache, but delegate all sqlite3 calls to a dedicated thread.    This allows getting rid of the 'same thread' sqlite3 module limitation.   Caller thread send calls in the execute queue and get the results in the result queue.   All calls are blocking and synchronous. # this is the tricky part: # attach methods from WebCache, decorated by callToThread, to this object's class # start thread # check WebCache object construction went ok Wait for the execution of the last enqueued job to be done, and return the result or raise an exception. Wrap call to method to send it to WebCacheThread. Thread executing all sqlite3 calls for the ThreadedWebCache class. Thread loop. # construct WebCache object locally # execute loop # thread exist requested Request thread stop.