python-sqlite3-backupSqlite3 online backup API implementation | |
Download |
python-sqlite3-backup Ranking & Summary
Advertisement
- License:
- MIT/X Consortium Lic...
- Price:
- FREE
- Publisher Name:
- Piotr Husiatynski
- Publisher web site:
- http://www.vim.org/scripts/script.php?script_id=2240
python-sqlite3-backup Tags
python-sqlite3-backup Description
sqlitebck is a single function that allows to save any sqlite3 database one to another. You can use this for example for loading and dumping memory database (:memory:) into file (alternative to iter dump functionality).See the Sqlite3 C API docs for more info.Build and installationNow you can build or install sqlitebck using distutils: python setup.py installTestsNothing big, just test basic functionality: python tests.pyUsage exampleBasic usage example - memory database saved into file:>>> import sqlite3>>> conn = sqlite3.connect(':memory:')>>> curr = conn.cursor()# create table and put there some data>>> curr.execute('CREATE TABLE foo (bar INTEGER)')< sqlite3.Cursor object at 0xb73b2800 >>>> curr.execute('INSERT INTO foo VALUES (123)')< sqlite3.Cursor object at 0xb73b2800 >>>> curr.close()>>> conn.commit()>>> import sqlitebck# save in memory database (conn) into file>>> conn2 = sqlite3.connect('/tmp/in_memory_sqlite_db_save.db')>>> sqlitebck.copy(conn, conn2)>>> conn.close()>>> curr2 = conn2.cursor()# check if data is in file database ;)>>> curr2.execute('SELECT * FROM foo');< sqlite3.Cursor object at 0xb73b2860 >>>> curr2.fetchall()If you want to load file database into memory, just call:>>> sqlitebck.copy(conn2, conn)Product's homepage
python-sqlite3-backup Related Software