sqlitestructure is a Python library to dump table structure of a SQLite database file.
.. image:: https://badge.fury.io/py/sqlitestructure.svg :target: https://badge.fury.io/py/sqlitestructure
.. image:: https://img.shields.io/pypi/pyversions/sqlitestructure.svg :target: https://pypi.python.org/pypi/sqlitestructure
.. image:: https://travis-ci.org/thombashi/sqlitestructure.svg?branch=master :target: https://travis-ci.org/thombashi/sqlitestructure
.. image:: https://coveralls.io/repos/github/thombashi/sqlitestructure/badge.svg?branch=master :target: https://coveralls.io/github/thombashi/sqlitestructure?branch=master
Python library to dump table structure of a SQLite database file.
::
pip install sqlitestructure
.. code:: python
for verbosity_level in range(4):
print("===== verbosity level {} =====".format(verbosity_level))
writer = sqlitestructure.TableStructureWriter(db_path, verbosity_level)
print("{}\n".format(writer.dumps()))
.. code::
===== verbosity level 0 =====
testdb0
testdb1
===== verbosity level 1 =====
testdb0 (attr_a, attr_b)
testdb1 (foo, bar, hoge)
===== verbosity level 2 =====
testdb0 (attr_a INTEGER, attr_b INTEGER)
testdb1 (foo INTEGER, bar REAL, hoge TEXT)
===== verbosity level 3 =====
CREATE TABLE 'testdb0' ("attr_a" INTEGER, "attr_b" INTEGER)
CREATE TABLE 'testdb1' (foo INTEGER, bar REAL, hoge TEXT)
CREATE INDEX testdb1_foo_index ON testdb1('foo')
CREATE INDEX testdb1_hoge_index ON testdb1('hoge')
Python 2.7+ or 3.3+
click <https://github.com/pallets/click>__DataPropery <https://github.com/thombashi/DataProperty>__SimpleSQLite <https://github.com/thombashi/SimpleSQLite>__six <https://pypi.python.org/pypi/six/>__pytest <https://pypi.python.org/pypi/pytest>__pytest-runner <https://pypi.python.org/pypi/pytest-runner>__tox <https://pypi.python.org/pypi/tox>__FAQs
sqlitestructure is a Python library to dump table structure of a SQLite database file.
We found that sqlitestructure demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Elastic’s return to open source with the AGPL license has been met with skepticism, as many developers see it as a strategic move rather than a genuine effort to restore user trust and freedoms.
Security News
A new "revival hijack" supply chain attack targets deleted Python packages, with an estimated 22K packages at risk. Socket can detect and block hijacked packages that have added malicious code.
Product
We're introducing a new Analytics feature in the Socket dashboard so you can view changes in your organization's and repositories' alerts over time.