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
Fluent Assertions is facing backlash after dropping the Apache license for a commercial model, leaving users blindsided and questioning contributor rights.
Research
Security News
Socket researchers uncover the risks of a malicious Python package targeting Discord developers.
Security News
The UK is proposing a bold ban on ransomware payments by public entities to disrupt cybercrime, protect critical services, and lead global cybersecurity efforts.