{
    "info": {
        "author": "aescwork",
        "author_email": "aescwork@protonmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3.5",
            "Topic :: Database",
            "Topic :: Software Development :: Libraries :: Python Modules"
        ],
        "description": "sqlitemgr\n=========\n\nThis package can be found at https://github.com/aescwork/sqlitemgr. \n\nIn the github repository there is sphinx-generated documentation: the main page is docs/index.html. \n\n\n\nsqlitemgr -- the SQLite Manager module -- is a wrapper class for basic management of an sqlite database and its\ntables.  It can be used to create and delete database files, tables, create and return a connection to a database file as \nwell as a cursor which is used for executing statements against an sqlite database.  \n\nIt has two main purposes: 1. to encapsulate all of the basic database management actions in one class, and 2. to create\ntables with the option of not having to directly enter the structured query language necessary.  Specific methods for\ncomposing and executing sql statements can be chained together for creating tables (including specifying column names, data types\nand constraints) in an sqlite database.  \n\nThere are also a few utility methods for managing data in and getting information about the tables.  These can get the\nnumber of tables in a database, get the number of rows in a table, or re-index a column which is used for storing numbers.\n\nThis module was written as a companion to the sqliteminor module, whose functionality focuses on creating, reading, updating and deleting\ndata in sqlite database columns.  \n\nNOTE:\n\nThis module requires sqlite3 to be installed prior to use.\n\n\nAfter installation of this package is complete, trying to use the module might result in the following error: \"ImportError: No module named sqlitemgr\"\nor some other error message.\n\nThis probably indicates that the Python interpreter may not be able to locate the module.  In this case,\nthe following is recommended:\n\n\tOn Linux:\n\n\t\tLocate where the package was installed.  In the terminal, navigate to the root directory and execute the following command:\n\n\t\t\t\t\t\t\t\t\t\t\t\tsudo find . -name sqlitemgr.py\n\n\n\t\tThis should give a path to the sqlitemgr.py file.  \n\t\tCreate a file called \"local_python.sh\" and put the following text in it:\n\n\t\t\t\t\t\t\t\tPYTHONPATH=\"/usr/local/lib/python*.*/dist-packages/sqlitemgr/\":\"${PYTHONPATH}\"\n\t\t\t\t\t\t\t\texport PYTHONPATH\n\n\t\tTo make the module available to all users, place this file in /etc/profile.d.  Then place a line to execute this\n\t\tfile somewhere in .bashrc or one of the other bash configuration files in the individual (non-root) user's terminal: \n\n\t\t\t\t\t\t\t\t\t\t    . /etc/profile.d/local_python.sh\n\n\t\tThis should cause the python interpreter to locate the sqlitemgr.py file in the module.   \n\n\n\tOn MS Windows:\n\n\t\tThe following was tested on a machine running Windows 10. \n\n\t\t(This assumes that Python is installed on the machine.)\n\n\t\tLocate where the package was installed.  On Windows 10, Look for the Python folder.  Its usually right under the C: drive. \n\t\tThe name of the folder probably has the version number in it as well, like \"Python27\".  Look for the sqlitemgr folder: it should\n\t\tbe in \"Lib\\\" and then \"site-packages\\\" folder.  \n\n\t\tOpen up the System Properties Panel.  (You can find this by clicking on the \"Settings\" icon and entering \"Environment Variables\" in the \n\t\tsearch bar.  When the panel comes up, Click the \"Environment Variables\" button.  Under \"System variables\", click \"New\" and type in the full path to\n\t\tthe sqlitemgr folder.\n\n\t\tTest this by opening the command line application and starting the Python interpreter (type the command \"python\" and press enter).\n\t\tNow try to import the module and instantiate an sqlitemgr object.  Type the following:\n\n\t\t>>> import sqlitemgr\n\t\t>>> sg = sqlitemgr.SQLiteMinor()\n\t\t>>> sg.result\n\n\t\tIf everything went well, 'None' should print out on the screen.  If there was an \"ImportError\" or any other error, try importing the\n\t\tmodule again and test as follows: \n\n\n\t\t>>> import sqlitemgr.sqlitemgr as sqlitemgr\n\t\t>>> sg = sqlitemgr.SQLiteMgr()\n\t\t>>> sg.result\n\n\n\n\n\n",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/aescwork/sqlitemgr",
        "keywords": "sqlitemgr sqlite development database sqlite3",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "sqlitemgr",
        "package_url": "https://pypi.org/project/sqlitemgr/",
        "platform": "",
        "project_url": "https://pypi.org/project/sqlitemgr/",
        "project_urls": {
            "Homepage": "https://github.com/aescwork/sqlitemgr"
        },
        "release_url": "https://pypi.org/project/sqlitemgr/1.2.6/",
        "requires_dist": [
            "check-manifest; extra == 'dev'",
            "coverage; extra == 'test'"
        ],
        "requires_python": "",
        "summary": "A wrapper class for basic setup and management of an SQLite database.",
        "version": "1.2.6"
    },
    "last_serial": 3173861,
    "releases": {
        "1.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ae18a8536725d6417e716b8067e7788b",
                    "sha256": "e73de7a70557fe01e9c8f8f98bd993a55bf799406514cf18c29b90ba555785c0"
                },
                "downloads": -1,
                "filename": "sqlitemgr-1.2.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "ae18a8536725d6417e716b8067e7788b",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 8118,
                "upload_time": "2017-09-05T14:40:43",
                "url": "https://files.pythonhosted.org/packages/d8/3b/d4baf9e7b4735468cfc97f2f6abdbd810654787725b0b32dd1a3b341e624/sqlitemgr-1.2.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "d255ae7597ffa08bee0bb8b0dbde218d",
                    "sha256": "9b27f3598d6b992914362b35b368dc85e19f4dfea8fdafde1f862a5c920403dd"
                },
                "downloads": -1,
                "filename": "sqlitemgr-1.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "d255ae7597ffa08bee0bb8b0dbde218d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6797,
                "upload_time": "2017-09-05T14:40:44",
                "url": "https://files.pythonhosted.org/packages/82/4a/8d46ca7b977ee824a1cdee48492233d340bd4f2859bae3464b610af6e0d7/sqlitemgr-1.2.0.tar.gz"
            }
        ],
        "1.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "686f64415ca6554d8bfc80d279db46bd",
                    "sha256": "b3e0958ff8b7e1ed696a9754b849c23512c0b1721dcbe03fffae03c9d79f33ad"
                },
                "downloads": -1,
                "filename": "sqlitemgr-1.2.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "686f64415ca6554d8bfc80d279db46bd",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 8111,
                "upload_time": "2017-09-09T13:42:41",
                "url": "https://files.pythonhosted.org/packages/9e/9f/7002cc27a6c021edbefeb056304b3aa9a34a1a214708c5dea2fdcdb4d0b1/sqlitemgr-1.2.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "9355b18aad46d09c17f4fd2845bec0c4",
                    "sha256": "baeb8c1287321e4bde7da172100986d93fd5f1d937d0b1c86aaaa137849a7a2b"
                },
                "downloads": -1,
                "filename": "sqlitemgr-1.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "9355b18aad46d09c17f4fd2845bec0c4",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6790,
                "upload_time": "2017-09-09T13:42:43",
                "url": "https://files.pythonhosted.org/packages/b4/49/704b79122c19001989ff8fdf67677341a84a6eb63352ff73ad824a306152/sqlitemgr-1.2.1.tar.gz"
            }
        ],
        "1.2.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "cadc07562c6a66dd572e7a9c74bdd66a",
                    "sha256": "0352a38a50932c779f0c32760c05b54c0f4180feb7ac8bb519fa1af4044e76be"
                },
                "downloads": -1,
                "filename": "sqlitemgr-1.2.6-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "cadc07562c6a66dd572e7a9c74bdd66a",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 10228,
                "upload_time": "2017-09-14T14:04:50",
                "url": "https://files.pythonhosted.org/packages/d4/bd/b0b5cf276602312c8db30178f4621effa2973cc4be1aa11d363601f63478/sqlitemgr-1.2.6-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "dd14403be65a259fd82d7ef0d406654d",
                    "sha256": "7da17a836bdd7c17d96fb53d52df1b2075ca7749ec1fb36796e908007b5398d7"
                },
                "downloads": -1,
                "filename": "sqlitemgr-1.2.6.tar.gz",
                "has_sig": false,
                "md5_digest": "dd14403be65a259fd82d7ef0d406654d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8073,
                "upload_time": "2017-09-14T14:04:52",
                "url": "https://files.pythonhosted.org/packages/bb/1d/9e454e1ac3d4e7b6ed7f513189f417bd6acf66a2c73fd0a34306dfde1fd3/sqlitemgr-1.2.6.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "cadc07562c6a66dd572e7a9c74bdd66a",
                "sha256": "0352a38a50932c779f0c32760c05b54c0f4180feb7ac8bb519fa1af4044e76be"
            },
            "downloads": -1,
            "filename": "sqlitemgr-1.2.6-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "cadc07562c6a66dd572e7a9c74bdd66a",
            "packagetype": "bdist_wheel",
            "python_version": "py2.py3",
            "requires_python": null,
            "size": 10228,
            "upload_time": "2017-09-14T14:04:50",
            "url": "https://files.pythonhosted.org/packages/d4/bd/b0b5cf276602312c8db30178f4621effa2973cc4be1aa11d363601f63478/sqlitemgr-1.2.6-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "dd14403be65a259fd82d7ef0d406654d",
                "sha256": "7da17a836bdd7c17d96fb53d52df1b2075ca7749ec1fb36796e908007b5398d7"
            },
            "downloads": -1,
            "filename": "sqlitemgr-1.2.6.tar.gz",
            "has_sig": false,
            "md5_digest": "dd14403be65a259fd82d7ef0d406654d",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 8073,
            "upload_time": "2017-09-14T14:04:52",
            "url": "https://files.pythonhosted.org/packages/bb/1d/9e454e1ac3d4e7b6ed7f513189f417bd6acf66a2c73fd0a34306dfde1fd3/sqlitemgr-1.2.6.tar.gz"
        }
    ]
}