{
    "info": {
        "author": "Cesar Martinez Izquierdo",
        "author_email": "",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 4 - Beta",
            "Environment :: Console",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: GNU Affero General Public License v3",
            "Natural Language :: English",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 2",
            "Programming Language :: Python :: 2.6",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Topic :: Database",
            "Topic :: Software Development :: Libraries :: Python Modules"
        ],
        "description": "spatialite-introspect\n=====================\n\nPython library to do introspection in Sqlite/Spatialite databases.\n\nUseful to get the table names, the column names of a specific table, the\navailable geometry columns, etc, without needing to dig in SQL.\n\nInstallation\n------------\n\n::\n\n    pip install spatialiteintrospect\n\nDependences\n-----------\n\nspatialite-introspect uses\n`sqlite3 <https://docs.python.org/2/library/sqlite3.html>`__, which\nshould be included in any Python distribution since version 2.5.\n\nUsage\n-----\n\nBasic usage:\n\n::\n\n    import spatialiteintrospect as spintrospect\n\n    # open db connection\n    db = spintrospect.connect(\"mydb.sqlite\")\n\n    # get all the tables in the db\n    db.get_tables()\n    # The result is an array of table names, e.g.: ['tbl1', 'tbl2', 'tbl3']\n\n    # finally, we need to close the database\n    db.close()\n\nAvailable methods:\n\n::\n\n    # get all the tables in the db\n    db.get_tables()\n    # The result is an array of table names, e.g.: ['tbl1', 'tbl2', 'tbl3']\n\n    # get all the tables that contain at least one geometry field\n    db.get_geometry_tables()\n    # The result is an array of table names, e.g.: ['tbl1', 'tbl3']\n\n    # get the geometry columns of a specific table\n    db.get_geometry_columns(\"tbl1\")\n    # The result is an array of column names, e.g.: ['the_point_geom', 'the_line_geom']\n\n    # get the geometry columns of a specific tables, plus some information about the table containing it\n    db.get_geometry_columns_info(\"tbl1\")\n    # The result is an array of tuples such as\n    #     [\n    #         ('tbl1', 'the_point_geom', 2, 4326, 1, ['fid'], ['fid', 'title', 'the_point_geom', 'the_line_geom']),\n    #         ('tbl1', 'the_line_geom', 2, 4326, 2, ['fid'], ['fid', 'title', 'the_point_geom', 'the_line_geom'])\n    #     ]\n    # The contents of each tuple is: (table_name, geom_column, coord_dimension, srid, geometry_type, key_columns, fields)\n\n    # It also works with no table filter:\n    db.get_geometry_columns_info()\n    # Result:\n    #     [\n    #         ('tbl1', 'the_point_geom', 2, 4326, 1, ['fid'], ['fid', 'title', 'the_point_geom', 'the_line_geom']),\n    #         ('tbl1', 'the_line_geom', 2, 4326, 2, ['fid'], ['fid', 'title', 'the_point_geom', 'the_line_geom']),\n    #         ('tbl3', 'geom', 2, 4326, 1, ['fid'], ['fid', 'author', 'date', 'geom'])\n    #     ]\n\n    # get the primary column(s) of a table\n    db.get_pk_columns(\"tbl2\")\n    # The result is an array of the fields that compose the PK: ['country_cd', 'region_cd']\n\n    # get all the fields of a table\n    db.get_fields(\"tbl1\")\n    # The result is an array of field names such as ['fid', 'title', 'the_point_geom', 'the_line_geom']\n\nNote that the library expects Unicode strings on all the string params.\nNon unicode strings are also accepted if using ASCII-only characters.\n\nAuthors\n-------\n\nCesar Martinez Izquierdo - `Scolab <http://scolab.es>`__",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/scolab-dot-eu/spatialite-introspect",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "spatialiteintrospect",
        "package_url": "https://pypi.org/project/spatialiteintrospect/",
        "platform": "UNKNOWN",
        "project_url": "https://pypi.org/project/spatialiteintrospect/",
        "project_urls": {
            "Homepage": "https://github.com/scolab-dot-eu/spatialite-introspect"
        },
        "release_url": "https://pypi.org/project/spatialiteintrospect/1.2/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Python library for easily retrieving table names, geometry columns, geometry tables, etc from a Spatialite database",
        "version": "1.2"
    },
    "last_serial": 2455145,
    "releases": {
        "0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "4e3e19a951fefead8d498001a3d2ca81",
                    "sha256": "985d4c7417453d74d8541f2fa944b94fdf3588ba50ba519b60aed0e7590da4ee"
                },
                "downloads": -1,
                "filename": "spatialiteintrospect-0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "4e3e19a951fefead8d498001a3d2ca81",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 452265,
                "upload_time": "2016-11-07T16:42:23",
                "url": "https://files.pythonhosted.org/packages/d1/23/8e195d44380df5675c02fa39a06c6b2c922d405743716cf40d9f5b43bcf8/spatialiteintrospect-0.1.tar.gz"
            }
        ],
        "0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5078687b39d30328b75b5cda986fc016",
                    "sha256": "98b807644af8295bf910f3ef67033700a2fdda19e48e112f9f9028817b659b85"
                },
                "downloads": -1,
                "filename": "spatialiteintrospect-0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "5078687b39d30328b75b5cda986fc016",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 452267,
                "upload_time": "2016-11-04T18:40:16",
                "url": "https://files.pythonhosted.org/packages/6f/67/42ec2ac8fc4af296371d59a97a76a73cf809231ae3ee07710e150a87d196/spatialiteintrospect-0.2.tar.gz"
            }
        ],
        "0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f9657da0686ed04f917b59171dafee71",
                    "sha256": "2a899776507b43417200198cc8d8a4d3a861042124ef5ec776a311b0112fbe2b"
                },
                "downloads": -1,
                "filename": "spatialiteintrospect-0.3-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "f9657da0686ed04f917b59171dafee71",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 6689,
                "upload_time": "2016-11-07T16:42:17",
                "url": "https://files.pythonhosted.org/packages/5b/ec/db55b85f5191195490a6a5177d9c4ee18fac653e20c6179095de69304ab1/spatialiteintrospect-0.3-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "7c811debf241846c98f4f7ec3cd0c3d5",
                    "sha256": "3b6bf08047f5c3ed84867c03109675706543c1d82c5c9ab29fa1aeeede978e35"
                },
                "downloads": -1,
                "filename": "spatialiteintrospect-0.3.tar.gz",
                "has_sig": false,
                "md5_digest": "7c811debf241846c98f4f7ec3cd0c3d5",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 452278,
                "upload_time": "2016-11-07T16:42:27",
                "url": "https://files.pythonhosted.org/packages/9e/cb/8957c067ba9f5353ed92b8784b0d7fcc2ed05717c1e82ca1a742c08b2199/spatialiteintrospect-0.3.tar.gz"
            }
        ],
        "0.3.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8f7489b767cb3f26a893f82636aa16fc",
                    "sha256": "24ca1edc0ff333610bf2c5d472f67fa3a0a176ab1e0ac6fb83a52c9664afb0bc"
                },
                "downloads": -1,
                "filename": "spatialiteintrospect-0.3.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "8f7489b767cb3f26a893f82636aa16fc",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 6829,
                "upload_time": "2016-11-07T16:47:11",
                "url": "https://files.pythonhosted.org/packages/fd/3c/bbd8f775f4c5a739343c3da6f8171890132373888bab401feb2cb4e06cb3/spatialiteintrospect-0.3.1-py2.py3-none-any.whl"
            }
        ],
        "1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "4784ba3e6b8988d45030e9b8b63e863e",
                    "sha256": "4d9b4f7a43f350292d6a119008e133f57a4e5726ef49728029c870c7b95c76e7"
                },
                "downloads": -1,
                "filename": "spatialiteintrospect-1.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "4784ba3e6b8988d45030e9b8b63e863e",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 6727,
                "upload_time": "2016-11-07T19:31:57",
                "url": "https://files.pythonhosted.org/packages/75/1e/ed94eca5752dc28a827fe74b060bd20b8b35854a28485903317931d62a8f/spatialiteintrospect-1.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "6043cd6207e0cc2ce9f12a5bd97add41",
                    "sha256": "71d5f3b6669a7b18e5b41a8f7ea3136471622bb3efb0fc70f489cf128da8ec12"
                },
                "downloads": -1,
                "filename": "spatialiteintrospect-1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "6043cd6207e0cc2ce9f12a5bd97add41",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 452393,
                "upload_time": "2016-11-07T19:32:01",
                "url": "https://files.pythonhosted.org/packages/9e/07/f382af20b6df8a7c4dc2f61a9218e38e0631a9a36f253430aa64f6ec547f/spatialiteintrospect-1.0.tar.gz"
            }
        ],
        "1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "d8b4c5be818f088e7dbea85b3c359aed",
                    "sha256": "c69f4ca2de96f8e1ea346336fe7cdd8d92bcb7a786ec0ce8dafbab010b16c037"
                },
                "downloads": -1,
                "filename": "spatialiteintrospect-1.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "d8b4c5be818f088e7dbea85b3c359aed",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 6909,
                "upload_time": "2016-11-08T18:26:21",
                "url": "https://files.pythonhosted.org/packages/62/af/523bcce3cd5a9536cac97141f9193cea0852fd985df29ab500469951c0d1/spatialiteintrospect-1.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "d8b9b5ca6efea9d9e987c7e77bfe813b",
                    "sha256": "a5d2f812b4b6a8ae448a1e13cdfcab54265be81637440060f42f220dce924610"
                },
                "downloads": -1,
                "filename": "spatialiteintrospect-1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "d8b9b5ca6efea9d9e987c7e77bfe813b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 452552,
                "upload_time": "2016-11-08T18:26:25",
                "url": "https://files.pythonhosted.org/packages/5a/14/2f82de511e1d573587803c9970d2feecd9d8c323e29a8db3a79b3b458ce1/spatialiteintrospect-1.1.tar.gz"
            }
        ],
        "1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2a84ef86a88422f8c2b3e20d03480ac3",
                    "sha256": "be4bcea3b00a1a1f73b74fefb317b52ef14f566ecb5799c7ec53e48549685216"
                },
                "downloads": -1,
                "filename": "spatialiteintrospect-1.2-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "2a84ef86a88422f8c2b3e20d03480ac3",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 6922,
                "upload_time": "2016-11-11T13:39:08",
                "url": "https://files.pythonhosted.org/packages/78/37/2d8d865eaae38305774e08c7b88f66e83b96f776acc546b5eb40cfe0df56/spatialiteintrospect-1.2-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "94b1eb13cb031f953755f71a9ff3bd2d",
                    "sha256": "82e114960d628e40771611e2e24fd688c81e87a338d2e4eb93be0bc7f5e8cce4"
                },
                "downloads": -1,
                "filename": "spatialiteintrospect-1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "94b1eb13cb031f953755f71a9ff3bd2d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 452497,
                "upload_time": "2016-11-11T13:39:12",
                "url": "https://files.pythonhosted.org/packages/11/15/49855c9ec6a4a799575c5e7ac8e0609c0f29221eac9c0b69d91bbe043c8a/spatialiteintrospect-1.2.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "2a84ef86a88422f8c2b3e20d03480ac3",
                "sha256": "be4bcea3b00a1a1f73b74fefb317b52ef14f566ecb5799c7ec53e48549685216"
            },
            "downloads": -1,
            "filename": "spatialiteintrospect-1.2-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "2a84ef86a88422f8c2b3e20d03480ac3",
            "packagetype": "bdist_wheel",
            "python_version": "py2.py3",
            "requires_python": null,
            "size": 6922,
            "upload_time": "2016-11-11T13:39:08",
            "url": "https://files.pythonhosted.org/packages/78/37/2d8d865eaae38305774e08c7b88f66e83b96f776acc546b5eb40cfe0df56/spatialiteintrospect-1.2-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "94b1eb13cb031f953755f71a9ff3bd2d",
                "sha256": "82e114960d628e40771611e2e24fd688c81e87a338d2e4eb93be0bc7f5e8cce4"
            },
            "downloads": -1,
            "filename": "spatialiteintrospect-1.2.tar.gz",
            "has_sig": false,
            "md5_digest": "94b1eb13cb031f953755f71a9ff3bd2d",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 452497,
            "upload_time": "2016-11-11T13:39:12",
            "url": "https://files.pythonhosted.org/packages/11/15/49855c9ec6a4a799575c5e7ac8e0609c0f29221eac9c0b69d91bbe043c8a/spatialiteintrospect-1.2.tar.gz"
        }
    ]
}