pysqlar

Module for working with SQLite Archive files with an API mimicking the zipfile module.

The module requires zlib and sqlite3 support, but has no external dependencies.

Installation

$ pip install pysqlar

Usage

To open an archive for reading

from pysqlar import SQLiteArchive

ar = SQLiteArchive("filename.sqlar")

print(ar.read("file.txt"))

ar.close()

or as a context manager

from pysqlar import SQLiteArchive

with SQLiteArchive("filename.sqlar") as ar:
    print(ar.read("file.txt"))

To be able to write into the archive you need to specify the mode as "rwc" (Read-Write-Create)

from pysqlar import SQLiteArchive

with SQLiteArchive("filename.sqlar", mode="rwc") as ar:
    ar.writestr("file.txt", "Hello World!")
    print(ar.read("file.txt"))

Note that this will create a new archive if the file does not exist.

Changelog

0.1.3

• Fix a bug where comments in the SQL statement that created the sqlar table would cause the file to not be identified as an archive.