How to use the sqlitedict.SqliteMultithread function in sqlitedict

To help you get started, we’ve selected a few sqlitedict examples, based on popular ways it is used in public projects.

Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.

github RaRe-Technologies / sqlitedict / tests / test_sqlite_migration.py View on Github external
def setUp(self):
        self.old_file = norm_file(
            os.path.join(os.path.dirname(__file__),
                         'db', 'migrate.sqlite'))
        self.new_file = norm_file(
            os.path.join(os.path.dirname(__file__),
                         'db', 'migrate_new.sqlite'))
        self.table_name = 'unnamed'
        MAKE_TABLE = 'CREATE TABLE IF NOT EXISTS %s (key TEXT PRIMARY KEY, value BLOB)' % self.table_name
        self.conn_old = sqlitedict.SqliteMultithread(self.old_file, autocommit=True, journal_mode="DELETE")
        self.conn_old.execute(MAKE_TABLE)
        self.conn_old.commit()
        self.conn_new = sqlitedict.SqliteMultithread(self.new_file, autocommit=True, journal_mode="DELETE")
        self.conn_new.execute(MAKE_TABLE)
        self.conn_new.commit()
github RaRe-Technologies / sqlitedict / tests / test_sqlite_migration.py View on Github external
def setUp(self):
        self.old_file = norm_file(
            os.path.join(os.path.dirname(__file__),
                         'db', 'migrate.sqlite'))
        self.new_file = norm_file(
            os.path.join(os.path.dirname(__file__),
                         'db', 'migrate_new.sqlite'))
        self.table_name = 'unnamed'
        MAKE_TABLE = 'CREATE TABLE IF NOT EXISTS %s (key TEXT PRIMARY KEY, value BLOB)' % self.table_name
        self.conn_old = sqlitedict.SqliteMultithread(self.old_file, autocommit=True, journal_mode="DELETE")
        self.conn_old.execute(MAKE_TABLE)
        self.conn_old.commit()
        self.conn_new = sqlitedict.SqliteMultithread(self.new_file, autocommit=True, journal_mode="DELETE")
        self.conn_new.execute(MAKE_TABLE)
        self.conn_new.commit()
github RaRe-Technologies / sqlitedict / sqlite_migration.py View on Github external
program = os.path.basename(sys.argv[0])

    if len(sys.argv) < 3:
        print(globals()['__doc__'] % locals())
        sys.exit(1)

    path_old = sys.argv[1]
    path_new = sys.argv[2]

    if len(sys.argv) == 4:
        table_name = sys.argv[3]
    else:
        table_name = 'unnamed'

    MAKE_TABLE = 'CREATE TABLE IF NOT EXISTS %s (key TEXT PRIMARY KEY, value BLOB)' % table_name
    conn_old = SqliteMultithread(path_old, autocommit=True, journal_mode="DELETE")
    conn_old.execute(MAKE_TABLE)
    conn_old.commit()

    conn_new = SqliteMultithread(path_new, autocommit=True, journal_mode="DELETE")
    conn_new.execute(MAKE_TABLE)
    conn_new.commit()

    migrate(table_name, conn_old, conn_new)

    conn_old.close()
    conn_new.close()

    logger.info("finished running %s", program)
github RaRe-Technologies / sqlitedict / sqlitedict.py View on Github external
if flag == 'n':
            if os.path.exists(filename):
                os.remove(filename)

        dirname = os.path.dirname(filename)
        if dirname:
            if not os.path.exists(dirname):
                raise RuntimeError('Error! The directory does not exist, %s' % dirname)

        self.filename = filename
        self.tablename = tablename

        logger.info("opening Sqlite table %r in %s" % (tablename, filename))
        MAKE_TABLE = 'CREATE TABLE IF NOT EXISTS %s (key TEXT PRIMARY KEY, value BLOB)' % self.tablename
        self.conn = SqliteMultithread(filename, autocommit=autocommit, journal_mode=journal_mode)
        self.conn.execute(MAKE_TABLE)
        self.conn.commit()
        if flag == 'w':
            self.clear()
github RaRe-Technologies / sqlitedict / sqlite_migration.py View on Github external
sys.exit(1)

    path_old = sys.argv[1]
    path_new = sys.argv[2]

    if len(sys.argv) == 4:
        table_name = sys.argv[3]
    else:
        table_name = 'unnamed'

    MAKE_TABLE = 'CREATE TABLE IF NOT EXISTS %s (key TEXT PRIMARY KEY, value BLOB)' % table_name
    conn_old = SqliteMultithread(path_old, autocommit=True, journal_mode="DELETE")
    conn_old.execute(MAKE_TABLE)
    conn_old.commit()

    conn_new = SqliteMultithread(path_new, autocommit=True, journal_mode="DELETE")
    conn_new.execute(MAKE_TABLE)
    conn_new.commit()

    migrate(table_name, conn_old, conn_new)

    conn_old.close()
    conn_new.close()

    logger.info("finished running %s", program)
github RaRe-Technologies / sqlitedict / sqlitedict.py View on Github external
def __init__(self, filename, autocommit, journal_mode):
        super(SqliteMultithread, self).__init__()
        self.filename = filename
        self.autocommit = autocommit
        self.journal_mode = journal_mode
        # use request queue of unlimited size
        self.reqs = Queue()
        self.setDaemon(True)  # python2.5-compatible
        self.exception = None
        self.log = logging.getLogger('sqlitedict.SqliteMultithread')
        self.start()
github RaRe-Technologies / sqlitedict / sqlitedict.py View on Github external
def __init__(self, filename, autocommit, journal_mode):
        super(SqliteMultithread, self).__init__()
        self.filename = filename
        self.autocommit = autocommit
        self.journal_mode = journal_mode
        # use request queue of unlimited size
        self.reqs = Queue()
        self.setDaemon(True)  # python2.5-compatible
        self.exception = None
        self.log = logging.getLogger('sqlitedict.SqliteMultithread')
        self.start()
github RaRe-Technologies / sqlitedict / sqlitedict.py View on Github external
def _new_conn(self):
        return SqliteMultithread(self.filename, autocommit=self.autocommit, journal_mode=self.journal_mode)

sqlitedict

Persistent dict in Python, backed up by sqlite3 and pickle, multithread-safe.

Apache-2.0
Latest version published 2 years ago

Package Health Score

43 / 100
Full package analysis