sqliteschema is a python library to dump table schema of a SQLite database file.
Project description
sqliteschema
Summary
Python library to dump table schema of a SQLite database file.
Installation
pip install sqlitestructure
Usage
for verbosity_level in range(6):
print("===== verbosity level {} =====".format(verbosity_level))
extractor = sqliteschema.SqliteSchemaExtractor(db_path, verbosity_level)
print(extractor.dumps())
===== verbosity level 0 =====
sampletable0
sampletable1
sampletable2
===== verbosity level 1 =====
sampletable0 ("attr_a", "attr_b")
sampletable1 (foo, bar, hoge)
sampletable2 (abc, efg)
===== verbosity level 2 =====
sampletable0 ("attr_a" INTEGER, "attr_b" INTEGER)
sampletable1 (foo INTEGER, bar REAL, hoge TEXT)
sampletable2 (abc INTEGER, efg REAL)
===== verbosity level 3 =====
sampletable0 ("attr_a" INTEGER, "attr_b" INTEGER)
sampletable1 (foo INTEGER, bar REAL, hoge TEXT)
sampletable2 (abc INTEGER PRIMARY KEY, efg REAL NOT NULL)
===== verbosity level 4 =====
sampletable0 (
"attr_a" INTEGER,
"attr_b" INTEGER
)
sampletable1 (
foo INTEGER,
bar REAL,
hoge TEXT
)
sampletable2 (
abc INTEGER PRIMARY KEY,
efg REAL NOT NULL
)
===== verbosity level 5 =====
sampletable0 (
"attr_a" INTEGER,
"attr_b" INTEGER
)
sampletable1 (
foo INTEGER,
bar REAL,
hoge TEXT
)
CREATE INDEX sampletable1_foo_index ON sampletable1('foo')
CREATE INDEX sampletable1_hoge_index ON sampletable1('hoge')
sampletable2 (
abc INTEGER PRIMARY KEY,
efg REAL NOT NULL
)
Full example can be found at examples/get_table_schema.py
Dependencies
Python 2.7+ or 3.3+
Test dependencies
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sqliteschema-0.6.0.tar.gz
(9.6 kB
view hashes)
Built Distribution
Close
Hashes for sqliteschema-0.6.0-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cbb6912d98a116f5b2d40a619bc76e3aa890f75cdd3c3d4a0f68d357c8ea2135 |
|
MD5 | 2758b326db14c81cd5f666e46fd7953a |
|
BLAKE2b-256 | 39a52b560daf4b022ba638ac0d6de4fdc8c1e184719ed2b92b8fcb9933b435cc |