{
    "info": {
        "author": "Tsuyoshi Hombashi",
        "author_email": "gogogo.vm@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 4 - Beta",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Operating System :: POSIX",
            "Operating System :: POSIX :: Linux",
            "Programming Language :: Python :: 2",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.3",
            "Programming Language :: Python :: 3.4",
            "Programming Language :: Python :: 3.5",
            "Topic :: Software Development :: Libraries",
            "Topic :: Software Development :: Libraries :: Python Modules"
        ],
        "description": "sqlitestructure\r\n===============\r\n\r\n.. image:: https://badge.fury.io/py/sqlitestructure.svg\r\n    :target: https://badge.fury.io/py/sqlitestructure\r\n    \r\n.. image:: https://img.shields.io/pypi/pyversions/sqlitestructure.svg\r\n    :target: https://pypi.python.org/pypi/sqlitestructure\r\n   \r\n.. image:: https://travis-ci.org/thombashi/sqlitestructure.svg?branch=master\r\n    :target: https://travis-ci.org/thombashi/sqlitestructure\r\n\r\n.. image:: https://coveralls.io/repos/github/thombashi/sqlitestructure/badge.svg?branch=master\r\n    :target: https://coveralls.io/github/thombashi/sqlitestructure?branch=master\r\n\r\n\r\nSummary\r\n=======\r\nPython library to dump table structure of a SQLite database file.\r\n\r\n\r\nInstallation\r\n============\r\n\r\n::\r\n\r\n    pip install sqlitestructure\r\n\r\n\r\nUsage\r\n=====\r\n\r\n.. code:: python\r\n\r\n    for verbosity_level in range(4):\r\n        print(\"===== verbosity level {} =====\".format(verbosity_level))\r\n        writer = sqlitestructure.TableStructureWriter(db_path, verbosity_level)\r\n        print(\"{}\\n\".format(writer.dumps()))\r\n\r\n\r\n.. code::\r\n    \r\n    ===== verbosity level 0 =====\r\n    testdb0\r\n    testdb1\r\n    \r\n    ===== verbosity level 1 =====\r\n    testdb0 (attr_a, attr_b)\r\n    testdb1 (foo, bar, hoge)\r\n    \r\n    ===== verbosity level 2 =====\r\n    testdb0 (attr_a INTEGER, attr_b INTEGER)\r\n    testdb1 (foo INTEGER, bar REAL, hoge TEXT)\r\n    \r\n    ===== verbosity level 3 =====\r\n    CREATE TABLE 'testdb0' (\"attr_a\" INTEGER, \"attr_b\" INTEGER)\r\n    CREATE TABLE 'testdb1' (foo INTEGER, bar REAL, hoge TEXT)\r\n    \r\n    CREATE INDEX testdb1_foo_index ON testdb1('foo')\r\n    CREATE INDEX testdb1_hoge_index ON testdb1('hoge')\r\n\r\n\r\nDependencies\r\n============\r\n\r\nPython 2.7+ or 3.3+\r\n\r\n- `click <https://github.com/pallets/click>`__\r\n- `DataPropery <https://github.com/thombashi/DataProperty>`__\r\n- `SimpleSQLite <https://github.com/thombashi/SimpleSQLite>`__\r\n- `six <https://pypi.python.org/pypi/six/>`__\r\n\r\nTest dependencies\r\n-----------------\r\n\r\n-  `pytest <https://pypi.python.org/pypi/pytest>`__\r\n-  `pytest-runner <https://pypi.python.org/pypi/pytest-runner>`__\r\n-  `tox <https://pypi.python.org/pypi/tox>`__",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "UNKNOWN",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/thombashi/sqlitestructure",
        "keywords": "SQLite,library",
        "license": "MIT License",
        "maintainer": null,
        "maintainer_email": null,
        "name": "sqlitestructure",
        "package_url": "https://pypi.org/project/sqlitestructure/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/sqlitestructure/",
        "project_urls": {
            "Download": "UNKNOWN",
            "Homepage": "https://github.com/thombashi/sqlitestructure"
        },
        "release_url": "https://pypi.org/project/sqlitestructure/0.2.0/",
        "requires_dist": null,
        "requires_python": null,
        "summary": "sqlitestructure is a Python library to dump table structure of\n    a SQLite database file.",
        "version": "0.2.0"
    },
    "last_serial": 2478696,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "dd7e055dc51ed60133932bed6a45cb7a",
                    "sha256": "e352e2de86ea4ea2853345cc187a9c2827904d64e2f43e7abeb0102be0573f2b"
                },
                "downloads": -1,
                "filename": "sqlitestructure-0.1.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "dd7e055dc51ed60133932bed6a45cb7a",
                "packagetype": "bdist_wheel",
                "python_version": "2.7",
                "requires_python": null,
                "size": 5002,
                "upload_time": "2016-08-07T09:25:58",
                "url": "https://files.pythonhosted.org/packages/ac/5a/0abc34824fa37964640ef30c2e593407a5ed57742a644451d0f15f490d39/sqlitestructure-0.1.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "a8ee7a519b8e32539133d5b917a96d0a",
                    "sha256": "cdb074424152fafe1088d9c688ac33401a055d730c1f436c5c95bf916480f919"
                },
                "downloads": -1,
                "filename": "sqlitestructure-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "a8ee7a519b8e32539133d5b917a96d0a",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4986,
                "upload_time": "2016-08-07T09:25:54",
                "url": "https://files.pythonhosted.org/packages/36/a8/f873410ab6fc7d031d54790609b049b2450aba74159a9e24d56a7db57a08/sqlitestructure-0.1.0.tar.gz"
            }
        ],
        "0.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "43f93c779b8872d2b8d188dd33c4c085",
                    "sha256": "9a98cb346f5e9075968e942d45cfb3ebd52f2bb5aa0a2b03cf2683878a632c15"
                },
                "downloads": -1,
                "filename": "sqlitestructure-0.2.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "43f93c779b8872d2b8d188dd33c4c085",
                "packagetype": "bdist_wheel",
                "python_version": "2.7",
                "requires_python": null,
                "size": 5913,
                "upload_time": "2016-11-23T13:32:37",
                "url": "https://files.pythonhosted.org/packages/35/75/f96d85f9623012e35bda1d1160f32070ae13986a38411b3a1e55147ef28a/sqlitestructure-0.2.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ddc0ae39e787b54c5b4ef3905487da10",
                    "sha256": "2db75b7c8cebc2c809749702cdd757738784099c73373f4b99d3d849cef0a1a9"
                },
                "downloads": -1,
                "filename": "sqlitestructure-0.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "ddc0ae39e787b54c5b4ef3905487da10",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5427,
                "upload_time": "2016-11-23T13:32:35",
                "url": "https://files.pythonhosted.org/packages/cc/65/cec7c69e81ce6d450cb05d93a4aad5e7dcb8d899a1232dc8dbc25a4f5760/sqlitestructure-0.2.0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "43f93c779b8872d2b8d188dd33c4c085",
                "sha256": "9a98cb346f5e9075968e942d45cfb3ebd52f2bb5aa0a2b03cf2683878a632c15"
            },
            "downloads": -1,
            "filename": "sqlitestructure-0.2.0-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "43f93c779b8872d2b8d188dd33c4c085",
            "packagetype": "bdist_wheel",
            "python_version": "2.7",
            "requires_python": null,
            "size": 5913,
            "upload_time": "2016-11-23T13:32:37",
            "url": "https://files.pythonhosted.org/packages/35/75/f96d85f9623012e35bda1d1160f32070ae13986a38411b3a1e55147ef28a/sqlitestructure-0.2.0-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "ddc0ae39e787b54c5b4ef3905487da10",
                "sha256": "2db75b7c8cebc2c809749702cdd757738784099c73373f4b99d3d849cef0a1a9"
            },
            "downloads": -1,
            "filename": "sqlitestructure-0.2.0.tar.gz",
            "has_sig": false,
            "md5_digest": "ddc0ae39e787b54c5b4ef3905487da10",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 5427,
            "upload_time": "2016-11-23T13:32:35",
            "url": "https://files.pythonhosted.org/packages/cc/65/cec7c69e81ce6d450cb05d93a4aad5e7dcb8d899a1232dc8dbc25a4f5760/sqlitestructure-0.2.0.tar.gz"
        }
    ]
}