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
Research
An advanced npm supply chain attack is leveraging Ethereum smart contracts for decentralized, persistent malware control, evading traditional defenses.
Security News
Research
Attackers are impersonating Sindre Sorhus on npm with a fake 'chalk-node' package containing a malicious backdoor to compromise developers' projects.
Security News
The npm package for the LottieFiles Player web component was hit with a supply chain attack after a software engineer's npmjs credentials were compromised.