{
    "info": {
        "author": "Catherine Devlin",
        "author_email": "catherine.devlin@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 3 - Alpha",
            "Environment :: Console",
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 2",
            "Programming Language :: Python :: 3",
            "Topic :: Database",
            "Topic :: Database :: Front-Ends"
        ],
        "description": "===========\nipython-sql\n===========\n\n:Author: Catherine Devlin, http://catherinedevlin.blogspot.com\n\nIntroduces a %sql (or %%sql) magic.\n\nConnect to a database, using SQLAlchemy connect strings, then issue SQL\ncommands within IPython or IPython Notebook.\n\n.. image:: https://raw.github.com/catherinedevlin/ipython-sql/master/examples/writers.png\n   :width: 600px\n   :alt: screenshot of ipython-sql in the Notebook\n\nExamples\n--------\n\n.. code-block:: python\n\n    In [1]: %load_ext sql\n\n    In [2]: %%sql postgresql://will:longliveliz@localhost/shakes\n       ...: select * from character\n       ...: where abbrev = 'ALICE'\n       ...:\n    Out[2]: [(u'Alice', u'Alice', u'ALICE', u'a lady attending on Princess Katherine', 22)]\n\n    In [3]: result = _\n\n    In [4]: print(result)\n    charid   charname   abbrev                description                 speechcount\n    =================================================================================\n    Alice    Alice      ALICE    a lady attending on Princess Katherine   22\n\n    In [4]: result.keys\n    Out[5]: [u'charid', u'charname', u'abbrev', u'description', u'speechcount']\n\n    In [6]: result[0][0]\n    Out[6]: u'Alice'\n\n    In [7]: result[0].description\n    Out[7]: u'a lady attending on Princess Katherine'\n\nAfter the first connection, connect info can be omitted::\n\n    In [8]: %sql select count(*) from work\n    Out[8]: [(43L,)]\n\nConnections to multiple databases can be maintained.  You can refer to\nan existing connection by username@database\n\n.. code-block:: python\n\n    In [9]: %%sql will@shakes\n       ...: select charname, speechcount from character\n       ...: where  speechcount = (select max(speechcount)\n       ...:                       from character);\n       ...:\n    Out[9]: [(u'Poet', 733)]\n\n    In [10]: print(_)\n    charname   speechcount\n    ======================\n    Poet       733\n\nIf no connect string is supplied, ``%sql`` will provide a list of existing connections;\nhowever, if no connections have yet been made and the environment variable ``DATABASE_URL``\nis available, that will be used.\n\nFor secure access, you may dynamically access your credentials (e.g. from your system environment or `getpass.getpass`) to avoid storing your password in the notebook itself. Use the `$` before any variable to access it in your `%sql` command.\n\n.. code-block:: python\n\n    In [11]: user = os.getenv('SOME_USER')\n       ....: password = os.getenv('SOME_PASSWORD')\n       ....: connection_string = \"postgresql://{user}:{password}@localhost/some_database\".format(user=user, password=password)\n       ....: %sql $connection_string\n    Out[11]: u'Connected: some_user@some_database'\n\nYou may use multiple SQL statements inside a single cell, but you will\nonly see any query results from the last of them, so this really only\nmakes sense for statements with no output\n\n.. code-block:: python\n\n    In [11]: %%sql sqlite://\n       ....: CREATE TABLE writer (first_name, last_name, year_of_death);\n       ....: INSERT INTO writer VALUES ('William', 'Shakespeare', 1616);\n       ....: INSERT INTO writer VALUES ('Bertold', 'Brecht', 1956);\n       ....:\n    Out[11]: []\n\n\nBind variables (bind parameters) can be used in the \"named\" (:x) style.\nThe variable names used should be defined in the local namespace\n\n.. code-block:: python\n\n    In [12]: name = 'Countess'\n\n    In [13]: %sql select description from character where charname = :name\n    Out[13]: [(u'mother to Bertram',)]\n\nAs a convenience, dict-style access for result sets is supported, with the\nleftmost column serving as key, for unique values.\n\n.. code-block:: python\n\n    In [14]: result = %sql select * from work\n    43 rows affected.\n\n    In [15]: result['richard2']\n    Out[15]: (u'richard2', u'Richard II', u'History of Richard II', 1595, u'h', None, u'Moby', 22411, 628)\n\nResults can also be retrieved as an iterator of dictionaries (``result.dicts()``)\nor a single dictionary with a tuple of scalar values per key (``result.dict()``)\n\nAssignment\n----------\n\nOrdinary IPython assignment works for single-line `%sql` queries:\n\n.. code-block:: python\n\n    In [16]: works = %sql SELECT title, year FROM work\n    43 rows affected.\n\nThe `<<` operator captures query results in a local variable, and\ncan be used in multi-line ``%%sql``:\n\n.. code-block:: python\n\n    In [17]: %%sql works << SELECT title, year\n        ...: FROM work\n        ...:\n    43 rows affected.\n    Returning data to local variable works\n\nConnecting\n----------\n\nConnection strings are `SQLAlchemy`_ standard.\n\nSome example connection strings::\n\n    mysql+pymysql://scott:tiger@localhost/foo\n    oracle://scott:tiger@127.0.0.1:1521/sidname\n    sqlite://\n    sqlite:///foo.db\n    mssql+pyodbc://username:password@host/database?driver=SQL+Server+Native+Client+11.0\n\n.. _SQLAlchemy: http://docs.sqlalchemy.org/en/latest/core/engines.html#database-urls\n\nNote that ``mysql`` and ``mysql+pymysql`` connections (and perhaps others)\ndon't read your client character set information from .my.cnf.  You need\nto specify it in the connection string::\n\n    mysql+pymysql://scott:tiger@localhost/foo?charset=utf8\n\nNote that ``impala`` connecion with `impyla`_  for HiveServer2 requires to disable autocommit::\n\n    %config SqlMagic.autocommit=False\n    %sql impala://hserverhost:port/default?kerberos_service_name=hive&auth_mechanism=GSSAPI\n\n.. _impyla: https://github.com/cloudera/impyla\n\nConfiguration\n-------------\n\nQuery results are loaded as lists, so very large result sets may use up\nyour system's memory and/or hang your browser.  There is no autolimit\nby default.  However, `autolimit` (if set) limits the size of the result\nset (usually with a `LIMIT` clause in the SQL).  `displaylimit` is similar,\nbut the entire result set is still pulled into memory (for later analysis);\nonly the screen display is truncated.\n\n.. code-block:: python\n\n    In [2]: %config SqlMagic\n    SqlMagic options\n    --------------\n    SqlMagic.autocommit=<Bool>\n        Current: True\n        Set autocommit mode\n    SqlMagic.autolimit=<Int>\n        Current: 0\n        Automatically limit the size of the returned result sets\n    SqlMagic.autopandas=<Bool>\n        Current: False\n        Return Pandas DataFrames instead of regular result sets\n    SqlMagic.displaylimit=<Int>\n        Current: 0\n        Automatically limit the number of rows displayed (full result set is still\n        stored)\n    SqlMagic.feedback=<Bool>\n        Current: True\n        Print number of rows affected by DML\n    SqlMagic.short_errors=<Bool>\n        Current: True\n        Don't display the full traceback on SQL Programming Error\n    SqlMagic.style=<Unicode>\n        Current: 'DEFAULT'\n        Set the table printing style to any of prettytable's defined styles\n        (currently DEFAULT, MSWORD_FRIENDLY, PLAIN_COLUMNS, RANDOM)\n\n    In[3]: %config SqlMagic.feedback = False\n\nPlease note: if you have autopandas set to true, the displaylimit option will not apply. You can set the pandas display limit by using the pandas ``max_rows`` option as described in the `pandas documentation <http://pandas.pydata.org/pandas-docs/version/0.18.1/options.html#frequently-used-options>`_.\n\nPandas\n------\n\nIf you have installed ``pandas``, you can use a result set's\n``.DataFrame()`` method\n\n.. code-block:: python\n\n    In [3]: result = %sql SELECT * FROM character WHERE speechcount > 25\n\n    In [4]: dataframe = result.DataFrame()\n\nThe bogus non-standard pseudo-SQL command ``PERSIST`` will create a table name\nin the database from the named DataFrame.\n\n.. code-block:: python\n\n    In [5]: %sql PERSIST dataframe\n\n    In [6]: %sql SELECT * FROM dataframe;\n\n.. _Pandas: http://pandas.pydata.org/\n\nGraphing\n--------\n\nIf you have installed ``matplotlib``, you can use a result set's\n``.plot()``, ``.pie()``, and ``.bar()`` methods for quick plotting\n\n.. code-block:: python\n\n    In[5]: result = %sql SELECT title, totalwords FROM work WHERE genretype = 'c'\n\n    In[6]: %matplotlib inline\n\n    In[7]: result.pie()\n\n.. image:: https://raw.github.com/catherinedevlin/ipython-sql/master/examples/wordcount.png\n   :alt: pie chart of word count of Shakespeare's comedies\n\nDumping\n-------\n\nResult sets come with a ``.csv(filename=None)`` method.  This generates\ncomma-separated text either as a return value (if ``filename`` is not\nspecified) or in a file of the given name.\n\n.. code-block:: python\n\n    In[8]: result = %sql SELECT title, totalwords FROM work WHERE genretype = 'c'\n\n    In[9]: result.csv(filename='work.csv')\n\nPostgreSQL features\n-------------------\n\n``psql``-style \"backslash\" `meta-commands`_ commands (``\\d``, ``\\dt``, etc.)\nare provided by `PGSpecial`_.  Example:\n\n.. code-block:: python\n\n    In[9]: %sql \\d\n\n.. _PGSpecial: https://pypi.python.org/pypi/pgspecial\n\n.. _meta-commands: https://www.postgresql.org/docs/9.6/static/app-psql.html#APP-PSQL-META-COMMANDS\n\nInstalling\n----------\n\nInstall the lastest release with::\n\n    pip install ipython-sql\n\nor download from https://github.com/catherinedevlin/ipython-sql and::\n\n    cd ipython-sql\n    sudo python setup.py install\n\nDevelopment\n-----------\n\nhttps://github.com/catherinedevlin/ipython-sql\n\nCredits\n-------\n\n- Matthias Bussonnier for help with configuration\n- Olivier Le Thanh Duong for ``%config`` fixes and improvements\n- Distribute_\n- Buildout_\n- modern-package-template_\n- Mike Wilson for bind variable code\n- Thomas Kluyver and Steve Holden for debugging help\n- Berton Earnshaw for DSN connection syntax\n- Andr\u00e9s Celis for SQL Server bugfix\n- Michael Erasmus for DataFrame truth bugfix\n- Noam Finkelstein for README clarification\n- Xiaochuan Yu for `<<` operator, syntax colorization\n- Amjith Ramanujam for PGSpecial and incorporating it here\n\n.. _Distribute: http://pypi.python.org/pypi/distribute\n.. _Buildout: http://www.buildout.org/\n.. _modern-package-template: http://pypi.python.org/pypi/modern-package-template\n\n\nNews\n====\n\n0.1\n---\n\n*Release date: 21-Mar-2013*\n\n* Initial release\n\n0.1.1\n-----\n\n*Release date: 29-Mar-2013*\n\n* Release to PyPI\n\n* Results returned as lists\n\n* print(_) to get table form in text console\n\n* set autolimit and text wrap in configuration\n\n\n0.1.2\n-----\n\n*Release date: 29-Mar-2013*\n\n* Python 3 compatibility\n\n* use prettyprint package\n\n* allow multiple SQL per cell\n\n0.2.0\n-----\n\n*Release date: 30-May-2013*\n\n* Accept bind variables (Thanks Mike Wilson!)\n\n0.2.1\n-----\n\n*Release date: 15-June-2013*\n\n* Recognize socket connection strings\n\n* Bugfix - issue 4 (remember existing connections by case)\n\n0.2.2\n-----\n\n*Release date: 30-July-2013*\n\nConverted from an IPython Plugin to an Extension for 1.0 compatibility\n\n0.2.2.1\n-------\n\n*Release date: 01-Aug-2013*\n\nDeleted Plugin import left behind in 0.2.2\n\n0.2.3\n-----\n\n*Release date: 20-Sep-2013*\n\n* Contributions from Olivier Le Thanh Duong:\n\n  - SQL errors reported without internal IPython error stack\n\n  - Proper handling of configuration\n\n* Added .DataFrame(), .pie(), .plot(), and .bar() methods to\n  result sets\n\n0.3.0\n-----\n\n*Release date: 13-Oct-2013*\n\n* displaylimit config parameter\n\n* reports number of rows affected by each query\n\n* test suite working again\n\n* dict-style access for result sets by primary key\n\n0.3.1\n-----\n\n* Reporting of number of rows affected configurable with ``feedback``\n\n* Local variables usable as SQL bind variables\n\n0.3.2\n-----\n\n* ``.csv(filename=None)`` method added to result sets\n\n0.3.3\n-----\n\n* Python 3 compatibility restored\n* DSN access supported (thanks Berton Earnshaw)\n\n0.3.4\n-----\n\n* PERSIST pseudo-SQL command added\n\n0.3.5\n-----\n\n* Indentations visible in HTML cells\n* COMMIT each SQL statement immediately - prevent locks\n\n0.3.6\n-----\n\n* Fixed issue #30, commit failures for sqlite (thanks stonebig, jandot)\n\n0.3.7\n-----\n\n* New `column_local_vars` config option submitted by darikg\n* Avoid contaminating user namespace from locals (thanks alope107)\n\n0.3.7.1\n-------\n\n* Avoid \"connection busy\" error for SQL Server (thanks Andr\u00e9s Celis)\n\n0.3.8\n-----\n\n* Stop warnings for deprecated use of IPython 3 traitlets in IPython 4 (thanks graphaelli; also stonebig, aebrahim, mccahill)\n* README update for keeping connection info private, from eshilts\n\n0.3.9\n-----\n\n* Fix truth value of DataFrame error (thanks michael-erasmus)\n* `<<` operator (thanks xiaochuanyu)\n* added README example (thanks tanhuil)\n* bugfix in executing column_local_vars (thanks tebeka)\n* pgspecial installation optional (thanks jstoebel and arjoe)\n* conceal passwords in connection strings (thanks jstoebel)\n\n\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://pypi.python.org/pypi/ipython-sql",
        "keywords": "database ipython postgresql mysql",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "ipython-sql",
        "package_url": "https://pypi.org/project/ipython-sql/",
        "platform": "",
        "project_url": "https://pypi.org/project/ipython-sql/",
        "project_urls": {
            "Homepage": "https://pypi.python.org/pypi/ipython-sql"
        },
        "release_url": "https://pypi.org/project/ipython-sql/0.3.9/",
        "requires_dist": [
            "prettytable",
            "ipython (>=1.0)",
            "sqlalchemy (>=0.6.7)",
            "sqlparse",
            "six",
            "ipython-genutils (>=0.1.0)"
        ],
        "requires_python": "",
        "summary": "RDBMS access via IPython",
        "version": "0.3.9"
    },
    "last_serial": 3739659,
    "releases": {
        "0.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "57502c95ec777e3b8a0e499e1ed9dcd5",
                    "sha256": "a643bb9978ea67f4d519f10bbdd533fb1882a5371b0ea821884608090a84a8f3"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.1.2-py2.7.egg",
                "has_sig": false,
                "md5_digest": "57502c95ec777e3b8a0e499e1ed9dcd5",
                "packagetype": "bdist_egg",
                "python_version": "2.7",
                "requires_python": null,
                "size": 9987,
                "upload_time": "2013-03-29T17:57:39",
                "url": "https://files.pythonhosted.org/packages/43/bb/6cc63d2cba5409801770bfab7cc7ecdcab6249d61cf9914cb8c7c9d9d1a5/ipython_sql-0.1.2-py2.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "da9f038fef60b24220379ce09b284143",
                    "sha256": "2738c7cfd09f693fc1c8930b4f953c6da522c4ded50a949790b787bc79f5a0be"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.1.2-py3.2.egg",
                "has_sig": false,
                "md5_digest": "da9f038fef60b24220379ce09b284143",
                "packagetype": "bdist_egg",
                "python_version": "3.2",
                "requires_python": null,
                "size": 10268,
                "upload_time": "2013-03-29T17:57:03",
                "url": "https://files.pythonhosted.org/packages/2a/d6/df0f305ab0130f4374a8166959cf4ae7f261bdae0c671319252c0eb27472/ipython_sql-0.1.2-py3.2.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "95aca091c27a56f05e21e7044a4ee8e2",
                    "sha256": "45602466b9d99a86026dbb2ae801b4cba61bd3962342a70299833d35dc1b12dd"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "95aca091c27a56f05e21e7044a4ee8e2",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5498,
                "upload_time": "2013-03-29T17:57:00",
                "url": "https://files.pythonhosted.org/packages/7b/99/7f717ecae64c942e7ab984c217f5d9ab2662dde47c62474f78a475a95f30/ipython-sql-0.1.2.tar.gz"
            }
        ],
        "0.1.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3ae3e4ba48658c89ea2b1c916e50633d",
                    "sha256": "1ab3c9517118e79c80196bc9aec689696b6f7c64bcc1779db137c207292d21ce"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.1.2.1-py3.2.egg",
                "has_sig": false,
                "md5_digest": "3ae3e4ba48658c89ea2b1c916e50633d",
                "packagetype": "bdist_egg",
                "python_version": "3.2",
                "requires_python": null,
                "size": 10267,
                "upload_time": "2013-03-29T18:02:39",
                "url": "https://files.pythonhosted.org/packages/fb/ef/64635e4091fb34e0fba6f106fb080f5af6a083c11b00e50e2c17d73b13fa/ipython_sql-0.1.2.1-py3.2.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "41d7f1911dc0b657396dab560e696609",
                    "sha256": "5aa385966de08f91fb436a5797d1870b23b31a70cf555dc0213a2c1cf9ee6d97"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.1.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "41d7f1911dc0b657396dab560e696609",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5527,
                "upload_time": "2013-03-29T18:02:36",
                "url": "https://files.pythonhosted.org/packages/91/d7/7f6e891b3fbf4c7988b8a57f0cfec13c3b5f8a006ccacdd6742c1a90d6fd/ipython-sql-0.1.2.1.tar.gz"
            }
        ],
        "0.1.2.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "0e086bdd98a9b03539392de2856aa18a",
                    "sha256": "435de8861aa7e9beba1c7bea4ae73836484e29fe4187114b7a3e67bd21abe6b2"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.1.2.2-py2.6.egg",
                "has_sig": false,
                "md5_digest": "0e086bdd98a9b03539392de2856aa18a",
                "packagetype": "bdist_egg",
                "python_version": "2.6",
                "requires_python": null,
                "size": 10063,
                "upload_time": "2013-03-29T18:17:46",
                "url": "https://files.pythonhosted.org/packages/98/49/d8e4f68058f00d2030bc7c7b181fa59bf05c540f147b4b680bbd310046e0/ipython_sql-0.1.2.2-py2.6.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "d226913c3f41c7194bccb600657553f8",
                    "sha256": "2ba51bc2a654f9fc4413924cee8e7e70a96a0d399541e9f8a295d2bf52919a9e"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.1.2.2-py2.7.egg",
                "has_sig": false,
                "md5_digest": "d226913c3f41c7194bccb600657553f8",
                "packagetype": "bdist_egg",
                "python_version": "2.7",
                "requires_python": null,
                "size": 10031,
                "upload_time": "2013-03-29T18:17:58",
                "url": "https://files.pythonhosted.org/packages/01/bf/49a11dad4f607c08295daf5cf69d4a6938fc86c83bc6154f2429ab4107a1/ipython_sql-0.1.2.2-py2.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "f7010b37be22d809cc5204cdcf154d0e",
                    "sha256": "2aac3235d09a36b244f40d5c9eb8b4a9ffa2ab6bafd4ae2c3e470bf6d811954f"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.1.2.2-py3.2.egg",
                "has_sig": false,
                "md5_digest": "f7010b37be22d809cc5204cdcf154d0e",
                "packagetype": "bdist_egg",
                "python_version": "3.2",
                "requires_python": null,
                "size": 10291,
                "upload_time": "2013-03-29T18:05:09",
                "url": "https://files.pythonhosted.org/packages/29/e9/a5736811dc942f99a61e10b21cb36388c8bbc13c0f5369ce88ecd89a4cf4/ipython_sql-0.1.2.2-py3.2.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "1c9735093197a7bd05824692a9171c1b",
                    "sha256": "25e5681185fea439e8fb7829c78d08c7ca8b0af5157bf74b2a497c9144d24d01"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.1.2.2.tar.gz",
                "has_sig": false,
                "md5_digest": "1c9735093197a7bd05824692a9171c1b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5554,
                "upload_time": "2013-03-29T18:05:07",
                "url": "https://files.pythonhosted.org/packages/9e/69/7f5d210cb3957bcc14598dfe190fa54a8b40560bcb12d7c01586f61c3c08/ipython-sql-0.1.2.2.tar.gz"
            }
        ],
        "0.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "e353a2f301a675fe9f88524cde2763ab",
                    "sha256": "ebf68c05da7dffb596eb741c3793777a5da0edc6e8765064a1726bb63d1694b0"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.2.0-py2.7.egg",
                "has_sig": false,
                "md5_digest": "e353a2f301a675fe9f88524cde2763ab",
                "packagetype": "bdist_egg",
                "python_version": "2.7",
                "requires_python": null,
                "size": 10534,
                "upload_time": "2013-05-30T21:06:02",
                "url": "https://files.pythonhosted.org/packages/b6/c5/ad3c1a375710a92d5018c0b6a15776a36f03af76474b3c6c3c6bccbee83a/ipython_sql-0.2.0-py2.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "141abc2d2180f5902b0df333b04d10b2",
                    "sha256": "112a2bddf4543ca7557018fe6a70caec9d8dfee1a8978829d34a7702df81c369"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "141abc2d2180f5902b0df333b04d10b2",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6072,
                "upload_time": "2013-05-30T21:05:59",
                "url": "https://files.pythonhosted.org/packages/60/c6/5dd3fae513d00d19c036720dc356082e3e049125f1670663fb17f1717f1e/ipython-sql-0.2.0.tar.gz"
            }
        ],
        "0.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "09b339286f6618ff963c6332a9c78d86",
                    "sha256": "5c65a6f71b6dce55d4d43349d2a83faa1f4728ba87abe74f5b4ebce75b0e1fe4"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.2.1-py3.3.egg",
                "has_sig": false,
                "md5_digest": "09b339286f6618ff963c6332a9c78d86",
                "packagetype": "bdist_egg",
                "python_version": "3.3",
                "requires_python": null,
                "size": 11197,
                "upload_time": "2013-06-15T17:49:56",
                "url": "https://files.pythonhosted.org/packages/f3/f5/db1c2b7614fff55bff4360c99a5f829b6aa530261ea98c2c2d6bc04b9b41/ipython_sql-0.2.1-py3.3.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "f1ba644e6d69970088bfb611301934e9",
                    "sha256": "4a911b448d2625d230de4b8425257c1875b2e962d7fca51f548323b974a81978"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "f1ba644e6d69970088bfb611301934e9",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6348,
                "upload_time": "2013-06-15T17:49:53",
                "url": "https://files.pythonhosted.org/packages/46/26/cc946f153040d2b64471f8af6894f7b22fbf23ed22bdb218773af657d3ee/ipython-sql-0.2.1.tar.gz"
            }
        ],
        "0.2.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "463ad6f28e6006c15a4a846301007ff8",
                    "sha256": "f26cfc22949985950d4403dc24f36a304233439951085d3abe5dec8a03ef2ee2"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.2.2-py2.7.egg",
                "has_sig": false,
                "md5_digest": "463ad6f28e6006c15a4a846301007ff8",
                "packagetype": "bdist_egg",
                "python_version": "2.7",
                "requires_python": null,
                "size": 10276,
                "upload_time": "2013-07-30T04:41:24",
                "url": "https://files.pythonhosted.org/packages/f0/fe/09ce06b43a5b22dbb3da5923beb4dbf1b73479a34527dd1db365acc9cadf/ipython_sql-0.2.2-py2.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "db37edfc9a46684a5d879bd18ec788aa",
                    "sha256": "08cb478ca3c8cab440a9cb9ea9270fd35677777468d375551866082253bdc762"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.2.2-py3.3.egg",
                "has_sig": false,
                "md5_digest": "db37edfc9a46684a5d879bd18ec788aa",
                "packagetype": "bdist_egg",
                "python_version": "3.3",
                "requires_python": null,
                "size": 10671,
                "upload_time": "2013-07-30T04:41:15",
                "url": "https://files.pythonhosted.org/packages/c5/42/fd4ca91bce85713dcc897cb0a1a2b1aeb87141a1153e9666ce1795087db3/ipython_sql-0.2.2-py3.3.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "2b74cc5220d135982f9d5d680d39cf73",
                    "sha256": "c5bda13560f8e51b3dd21f1e3493c88fecc04ad44478931eaaa538b77de2d327"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.2.2.tar.gz",
                "has_sig": false,
                "md5_digest": "2b74cc5220d135982f9d5d680d39cf73",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6234,
                "upload_time": "2013-07-30T04:41:12",
                "url": "https://files.pythonhosted.org/packages/09/ba/e715762589025ceff0ae2b1cb8c3535a724cd2f344b664829037b3750afb/ipython-sql-0.2.2.tar.gz"
            }
        ],
        "0.2.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "bcd9afa1a9e3116a07851fad1e3377bf",
                    "sha256": "7356d4fa38ada4f362effd1b273fce812881010d04af034abe811881ff9a0751"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.2.2.1-py2.7.egg",
                "has_sig": false,
                "md5_digest": "bcd9afa1a9e3116a07851fad1e3377bf",
                "packagetype": "bdist_egg",
                "python_version": "2.7",
                "requires_python": null,
                "size": 10270,
                "upload_time": "2013-08-01T19:49:59",
                "url": "https://files.pythonhosted.org/packages/2c/ec/61836d41ce2380ba189fb15888dc1f6bbf62d99322c8aed1a99d6eaa159c/ipython_sql-0.2.2.1-py2.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "37e5616cb57091c4898fbbf52398bb05",
                    "sha256": "09fab902ebf950efbed7071b64c6a326cf0804827739db4f082423a3fab327c3"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.2.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "37e5616cb57091c4898fbbf52398bb05",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6267,
                "upload_time": "2013-08-01T19:49:57",
                "url": "https://files.pythonhosted.org/packages/c7/43/594086310c105187ff65758135967dd77d47c70e81d8c2046bfe7aebac4a/ipython-sql-0.2.2.1.tar.gz"
            }
        ],
        "0.2.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "e82b908271314b5a56f93102f9db8c6a",
                    "sha256": "2002510b9f423bc910f9f25a8867032a8f766bd286d7f206a9fd2c69bacf47e1"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.2.3-py2.7.egg",
                "has_sig": false,
                "md5_digest": "e82b908271314b5a56f93102f9db8c6a",
                "packagetype": "bdist_egg",
                "python_version": "2.7",
                "requires_python": null,
                "size": 16799,
                "upload_time": "2013-09-21T02:48:33",
                "url": "https://files.pythonhosted.org/packages/fa/40/6c69f433570335686724c192ec70046bc0051eb044377e9f5350fcac34f7/ipython_sql-0.2.3-py2.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "bae8e264d813eb5340b29b2ed0c841ad",
                    "sha256": "97951421413f6cb4782506ece64fbd20729f8ae2b971996659f5c23e7abcf0b6"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.2.3-py3.3.egg",
                "has_sig": false,
                "md5_digest": "bae8e264d813eb5340b29b2ed0c841ad",
                "packagetype": "bdist_egg",
                "python_version": "3.3",
                "requires_python": null,
                "size": 17577,
                "upload_time": "2013-09-21T02:48:45",
                "url": "https://files.pythonhosted.org/packages/5d/be/a5b80cd8645747ad6dac97decaf082c71ca7b0ed9c83f408b26718f4f499/ipython_sql-0.2.3-py3.3.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "e3025a5c39db36a0e2688e43f5274521",
                    "sha256": "13c409d8a346c835bb9ae9efa8751265d20887bade19100cfd29d6db01a6fbd3"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.2.3.tar.gz",
                "has_sig": false,
                "md5_digest": "e3025a5c39db36a0e2688e43f5274521",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8556,
                "upload_time": "2013-09-21T02:48:19",
                "url": "https://files.pythonhosted.org/packages/3c/47/bdcee08bc074f3f7fa355debf0dcac522a99882e4bf8ecd600d13926eaae/ipython-sql-0.2.3.tar.gz"
            }
        ],
        "0.3.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "71ac053a132444140e9622899906c3c7",
                    "sha256": "5bb07386a12c45e7a5b000f4575260c84f98e2ca3667d28184d119810a48e026"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.3.0-py2.7.egg",
                "has_sig": false,
                "md5_digest": "71ac053a132444140e9622899906c3c7",
                "packagetype": "bdist_egg",
                "python_version": "2.7",
                "requires_python": null,
                "size": 18468,
                "upload_time": "2013-10-14T03:44:06",
                "url": "https://files.pythonhosted.org/packages/3c/b8/ba6e77837b125da28867969001fb0bb93bbb279edf40c0177d6450b14164/ipython_sql-0.3.0-py2.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "c7d5335fc45b515fc3387cbbdb689aef",
                    "sha256": "7260509db88620e3f32dfd13364ec269df4e7de3c0a3d04477f454ab9a835be5"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.3.0.tar.gz",
                "has_sig": false,
                "md5_digest": "c7d5335fc45b515fc3387cbbdb689aef",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12013,
                "upload_time": "2013-10-14T03:44:03",
                "url": "https://files.pythonhosted.org/packages/33/fd/c8b23e69108804b4a555929ac7fb2e55d5e01a342e52e7597156a6b55295/ipython-sql-0.3.0.tar.gz"
            }
        ],
        "0.3.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "308e855a153ad9cf2b5d7b512a1c803d",
                    "sha256": "499e1448b984eb341a6568a363dc743503a8940b087de7c65e5156608e14313a"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.3.1-py2.7.egg",
                "has_sig": false,
                "md5_digest": "308e855a153ad9cf2b5d7b512a1c803d",
                "packagetype": "bdist_egg",
                "python_version": "2.7",
                "requires_python": null,
                "size": 18792,
                "upload_time": "2013-11-13T19:25:04",
                "url": "https://files.pythonhosted.org/packages/e2/09/faa8b695a73170cbad2f731348815634f32c42f4d2b4c63dc16bdf24b82b/ipython_sql-0.3.1-py2.7.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "6435b2238e884371a5d6da7cc79c4ed6",
                    "sha256": "f96b4a014ba00e8ff12333e3271dfbba32d648e9d5a23d9782c438fb3e626863"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.3.1.tar.gz",
                "has_sig": false,
                "md5_digest": "6435b2238e884371a5d6da7cc79c4ed6",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12441,
                "upload_time": "2013-11-13T19:25:01",
                "url": "https://files.pythonhosted.org/packages/b3/26/7baa776ab2dcb26e545d5a2a5634ef8e7ac4e544ceddd0baa447f8b7101b/ipython-sql-0.3.1.tar.gz"
            }
        ],
        "0.3.3": [],
        "0.3.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ee0ed6401618dfde4eb51de5cece726b",
                    "sha256": "130773c38522a1e0989c046e559649f7d71afbd171898540a05a8a88ed97206b"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.3.4-py3.4.egg",
                "has_sig": false,
                "md5_digest": "ee0ed6401618dfde4eb51de5cece726b",
                "packagetype": "bdist_egg",
                "python_version": "3.4",
                "requires_python": null,
                "size": 23303,
                "upload_time": "2014-08-26T10:39:36",
                "url": "https://files.pythonhosted.org/packages/56/57/1567169a644215cab0029ad0f15df84097b224c5359d000cbfecef2b5637/ipython_sql-0.3.4-py3.4.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "a68076f11ae62197a16ed4000dcbe8d3",
                    "sha256": "a1f601d9a22d77524b25996d5f8670f47122521f4593272f6f30015ad47738f1"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.3.4.tar.gz",
                "has_sig": false,
                "md5_digest": "a68076f11ae62197a16ed4000dcbe8d3",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11243,
                "upload_time": "2014-08-26T10:39:32",
                "url": "https://files.pythonhosted.org/packages/a4/b5/48b9c99456c362efd7436f6dcab9bf7c3dd95887231bab72e2d51d5d0a18/ipython-sql-0.3.4.tar.gz"
            }
        ],
        "0.3.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "466fb69311ce1a7beef942ef94280cf8",
                    "sha256": "a29fe075d6c993b110b85a3c8956bbdf294251c96dce2c087af9c9ffc87a0774"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.3.5-py3.4.egg",
                "has_sig": false,
                "md5_digest": "466fb69311ce1a7beef942ef94280cf8",
                "packagetype": "bdist_egg",
                "python_version": "3.4",
                "requires_python": null,
                "size": 24017,
                "upload_time": "2015-01-30T20:00:53",
                "url": "https://files.pythonhosted.org/packages/da/24/3c4fd1119818c56a7b94bb7e61485b2df2e527bcb02315ca31c74db9e9f1/ipython_sql-0.3.5-py3.4.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "e28cc41c6321c6142a4a6ee4049859a7",
                    "sha256": "92d2129b64f7ca6a02963e720cf89d1c476c05a9c3bd0d4c0beaf8033cd93227"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.3.5.tar.gz",
                "has_sig": false,
                "md5_digest": "e28cc41c6321c6142a4a6ee4049859a7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11644,
                "upload_time": "2015-01-30T20:00:49",
                "url": "https://files.pythonhosted.org/packages/a6/74/a8cbe7b1510794cd398771a054d2f21ebd4b4753e1ea03656d195cf1af91/ipython-sql-0.3.5.tar.gz"
            }
        ],
        "0.3.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ed0d93e8ebdd027fad5940924ecab2c2",
                    "sha256": "9fdad528eeef10cbbd1384a3ee72b86bf3f0ecf4701858f8aa70ac5420db9542"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.3.6-py3.4.egg",
                "has_sig": false,
                "md5_digest": "ed0d93e8ebdd027fad5940924ecab2c2",
                "packagetype": "bdist_egg",
                "python_version": "3.4",
                "requires_python": null,
                "size": 24258,
                "upload_time": "2015-05-20T01:14:43",
                "url": "https://files.pythonhosted.org/packages/e7/c7/8af20eb8c962e73cb918431903ef7fadd8ef6a5fd336e0d6a1384343e6ed/ipython_sql-0.3.6-py3.4.egg"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "d4feb00ac5806d7640b2545a43974766",
                    "sha256": "7af7e5342a86d79d4d3f73211c6aca076a2c41f0b702590e5515552af169b47b"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.3.6.tar.gz",
                "has_sig": false,
                "md5_digest": "d4feb00ac5806d7640b2545a43974766",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 11812,
                "upload_time": "2015-05-20T01:14:39",
                "url": "https://files.pythonhosted.org/packages/80/6f/f0db647035f805a50f99bc28975657a12d7f425bf09c89992ee5fd0848ba/ipython-sql-0.3.6.tar.gz"
            }
        ],
        "0.3.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2565736f946dbe2629ea1688191b3146",
                    "sha256": "53f083b0a478bf534b5da52cd5baf49c4c235fe1b6962d508253961894f885a6"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.3.8-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "2565736f946dbe2629ea1688191b3146",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 17960,
                "upload_time": "2016-10-09T23:05:07",
                "url": "https://files.pythonhosted.org/packages/74/53/eca4c2d302ba3623003cb79360f24691e9828efe18a0478fc63a784affee/ipython_sql-0.3.8-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "89080b1bd4f383006a07164673af5d0d",
                    "sha256": "62f3689f4e2b4071eb9fd743386f358bfca8f76c942d50abf306914580fc149d"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.3.8.tar.gz",
                "has_sig": false,
                "md5_digest": "89080b1bd4f383006a07164673af5d0d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 12770,
                "upload_time": "2016-10-09T23:05:10",
                "url": "https://files.pythonhosted.org/packages/4b/4d/d62e65d8f501a305f45ff0b5a317163b742ea0c61e01ae85595ef5d1a54f/ipython-sql-0.3.8.tar.gz"
            }
        ],
        "0.3.9": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ad353d79070b251b160ff428a15c5d9e",
                    "sha256": "bbeebb6c0b520350cc8fc86061c202ecc52ba8525a883541f35578513b43f112"
                },
                "downloads": -1,
                "filename": "ipython_sql-0.3.9-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "ad353d79070b251b160ff428a15c5d9e",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 21606,
                "upload_time": "2018-04-06T02:20:51",
                "url": "https://files.pythonhosted.org/packages/ab/df/427e7cf05ffc67e78672ad57dce2436c1e825129033effe6fcaf804d0c60/ipython_sql-0.3.9-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "69407492ac7fcb92520e10d24b3b3194",
                    "sha256": "7187f6371f38b89d8fb63c2c7c4233d9000fb53b460dae79e4a359df366cc3ed"
                },
                "downloads": -1,
                "filename": "ipython-sql-0.3.9.tar.gz",
                "has_sig": false,
                "md5_digest": "69407492ac7fcb92520e10d24b3b3194",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 18028,
                "upload_time": "2018-04-06T02:20:53",
                "url": "https://files.pythonhosted.org/packages/83/ed/f6c8ece48f0f10a7543c971cdb1a62e6f91b374e31f6b579b7a37fb0a6a3/ipython-sql-0.3.9.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "ad353d79070b251b160ff428a15c5d9e",
                "sha256": "bbeebb6c0b520350cc8fc86061c202ecc52ba8525a883541f35578513b43f112"
            },
            "downloads": -1,
            "filename": "ipython_sql-0.3.9-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "ad353d79070b251b160ff428a15c5d9e",
            "packagetype": "bdist_wheel",
            "python_version": "py2.py3",
            "requires_python": null,
            "size": 21606,
            "upload_time": "2018-04-06T02:20:51",
            "url": "https://files.pythonhosted.org/packages/ab/df/427e7cf05ffc67e78672ad57dce2436c1e825129033effe6fcaf804d0c60/ipython_sql-0.3.9-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "69407492ac7fcb92520e10d24b3b3194",
                "sha256": "7187f6371f38b89d8fb63c2c7c4233d9000fb53b460dae79e4a359df366cc3ed"
            },
            "downloads": -1,
            "filename": "ipython-sql-0.3.9.tar.gz",
            "has_sig": false,
            "md5_digest": "69407492ac7fcb92520e10d24b3b3194",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 18028,
            "upload_time": "2018-04-06T02:20:53",
            "url": "https://files.pythonhosted.org/packages/83/ed/f6c8ece48f0f10a7543c971cdb1a62e6f91b374e31f6b579b7a37fb0a6a3/ipython-sql-0.3.9.tar.gz"
        }
    ]
}