{
    "info": {
        "author": "stonebig",
        "author_email": "write_pull_requests_to_stonebig@github.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Environment :: Console",
            "Intended Audience :: Education",
            "License :: OSI Approved :: MIT License",
            "Operating System :: OS Independent",
            "Programming Language :: Python",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.3",
            "Programming Language :: Python :: 3.4",
            "Topic :: Scientific/Engineering :: Information Analysis"
        ],
        "description": "baresql : playing SQL directly on Python datas\n==============================================\n\nbaresql improves sql agility of python data science beginners by :\n * allowing sql over python objects (list, ranges, ...) and SQL Tables,\n * requiring no special module except : pandas. \n\nInspiration :\n-------------\n\n* pypi.python.org/pypi/pandasql : sqldf for pandas\n\n* pypi.python.org/pypi/ipython-sql :  sql magic in Ipython\n\n\nFeatures\n--------\n\n* query lists , tuple, dictionnaries, dataframes \n\n* result as a dataframe, list of records, or list\n\n* basic Common Table Expression support on old python3.3- versions\n\n\nInstallation\n------------\n\nYou can install, upgrade, uninstall sqlite_bro.py with these commands::\n\n  $ pip install baresql\n  $ pip install --upgrade baresql\n  $ pip uninstall baresql\n\nor just launch it from IPython with %load https://raw.githubusercontent.com/stonebig/baresql/master/baresql/baresql.py\n\nBasic Example \n-------------\n\n::\n\n  from __future__ import print_function, unicode_literals, division  # if Python2.7\n  from baresql import baresql\n  bsql = baresql.baresql(keep_log = True )\n  bsqldf = lambda q: bsql.df(q, dict(globals(),**locals()))\n\n  users = ['Alexander', 'Bernard', 'Charly', 'Danielle', 'Esmeralda', 'Franz']\n  #  We use the python 'users' list like a SQL table\n  sql = \"select 'Welcome ! ' , c0 from users$$\"\n  bsqldf(sql)\n\n\nExamples\n--------\nhttp://nbviewer.ipython.org/github/stonebig/baresql/blob/master/examples/baresql_with_cte.ipynb\n\nLinks\n-----\n\n* `Fork me on GitHub <http://github.com/stonebig/baresql>`_\n\nChangelog\n=========\n\n\n2016-09-18a : v0.7.4 'pandas walk'\n-------------------------------------------\n\n* bug fix: pandas 0.19 compatibility fix\n\nolder versions :\n----------------\n\n * 0.7.3 : Python keyword is 'pass', not 'Pass'\n * 0.7.2 : support space in dataframe column title\n * 0.7.1 : cleanups\n * 0.7.0 : support of pandas 0.14 sqlalchemy\n * 0.6.6 : sqlite_py_manager.py browser added functions and fix, fix tokenizer error in baresql\n * 0.6.4 : minimal compatibility of sqlite_py_manager.py with old versions : python 2.7 and sqlite 3.6.21\n * 0.6.1 : a pure standard-installation Python SQLite browser in examples\\sqlite_py_manager.py \n * 0.6 : first version with correct mysql support\n * 0.5.1 : bug correction + SQLite3.8.3 beta from 2013-01-22\n * 0.5 : use SQLite true CTE if SQLite >= 3.8.3\n * 0.4.1 : inline CTE when syntax is \"with x as (y)\"\n * 0.4 : rewrite with token\n * 0.3.2 : support comments in the SQL\n * 0.3 : includes a basic CTE\n * 0.2 : add \"range(10)\" iterable object support \n * 0.1 : initial version\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/stonebig/baresql",
        "keywords": "sqlite,sql",
        "license": "MIT license",
        "maintainer": "",
        "maintainer_email": "",
        "name": "baresql",
        "package_url": "https://pypi.org/project/baresql/",
        "platform": "",
        "project_url": "https://pypi.org/project/baresql/",
        "project_urls": {
            "Homepage": "https://github.com/stonebig/baresql"
        },
        "release_url": "https://pypi.org/project/baresql/0.7.4/",
        "requires_dist": [
            "pandas"
        ],
        "requires_python": "",
        "summary": "playing SQL directly on Python datas",
        "version": "0.7.4"
    },
    "last_serial": 2349080,
    "releases": {
        "0.7.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "0d0ad2e44408c9cd6922630a011e2e00",
                    "sha256": "6e4a5b75fea727119ec7bd30bcd0bede848abb2ae0b8f4fb8d3a1790403cdfc6"
                },
                "downloads": -1,
                "filename": "baresql-0.7.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "0d0ad2e44408c9cd6922630a011e2e00",
                "packagetype": "bdist_wheel",
                "python_version": "3.4",
                "requires_python": null,
                "size": 11746,
                "upload_time": "2014-11-11T23:05:04",
                "url": "https://files.pythonhosted.org/packages/d6/30/469de02eef3263882fd59a9fc7f957f65ef7422f419102cd2ccf269ce74e/baresql-0.7.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "a4533c18928d0c2576ed08bc05e26936",
                    "sha256": "d1cce71253c359ae7ee87fd9b52a4d09b52ff4b223661219b791797ec0e60717"
                },
                "downloads": -1,
                "filename": "baresql-0.7.0.zip",
                "has_sig": false,
                "md5_digest": "a4533c18928d0c2576ed08bc05e26936",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 14699,
                "upload_time": "2014-11-11T23:05:01",
                "url": "https://files.pythonhosted.org/packages/6c/72/6d7a827e998300d3c646d7c95ea82a5047238af6e6339e25cd6ac70f40c1/baresql-0.7.0.zip"
            }
        ],
        "0.7.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "1c0b9b7279b31f7da4c60f17cf01f2ef",
                    "sha256": "71d8105bad45780088c65cdbcd84a8313ef26df2a590c8bccb02126756457741"
                },
                "downloads": -1,
                "filename": "baresql-0.7.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "1c0b9b7279b31f7da4c60f17cf01f2ef",
                "packagetype": "bdist_wheel",
                "python_version": "3.4",
                "requires_python": null,
                "size": 11786,
                "upload_time": "2014-11-12T06:13:44",
                "url": "https://files.pythonhosted.org/packages/da/ae/f567bbcfb49ef110ff8341e263e84cddb057359031f467983a9d9ff4d72c/baresql-0.7.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "d77ffa8ff802758d18e825c18be6cd1c",
                    "sha256": "88b5ccf41cbbbfe613f7aabe8e0166a29598cbd6ee0e894ba0c8b73f37aea928"
                },
                "downloads": -1,
                "filename": "baresql-0.7.1.zip",
                "has_sig": false,
                "md5_digest": "d77ffa8ff802758d18e825c18be6cd1c",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 13693,
                "upload_time": "2014-11-12T06:13:41",
                "url": "https://files.pythonhosted.org/packages/d9/78/fa308fbd5986b2bfeb63043cd764bc3058061f203bd709e12de7f99e745a/baresql-0.7.1.zip"
            }
        ],
        "0.7.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "854ce25d6e341f4dbab172cb430cfa65",
                    "sha256": "9abf3ed8dc6d27eeef6ef8476052104814fd559400acd8df8114bbadb99d04b2"
                },
                "downloads": -1,
                "filename": "baresql-0.7.2-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "854ce25d6e341f4dbab172cb430cfa65",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 11787,
                "upload_time": "2015-08-17T16:57:17",
                "url": "https://files.pythonhosted.org/packages/9d/da/36ec1696e6a3b12831825d09b64dd28ed6a5996206e418192f87e788ef23/baresql-0.7.2-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "e5f32213794be7e78f605bcb4c9ec297",
                    "sha256": "a8821c22275ed045e62c237dc022b6f615792fec2e47d853b26b27247156d052"
                },
                "downloads": -1,
                "filename": "baresql-0.7.2.zip",
                "has_sig": false,
                "md5_digest": "e5f32213794be7e78f605bcb4c9ec297",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 13653,
                "upload_time": "2015-08-17T16:57:23",
                "url": "https://files.pythonhosted.org/packages/cf/7e/c762b2067a8c1aacb571e6ee1316a522162460b3e77ef7930804bc588746/baresql-0.7.2.zip"
            }
        ],
        "0.7.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "dc270f7a03ed541415c489f7602b24fb",
                    "sha256": "a654c9049193ae146cd0d79551b76134f6d8f4f042f6b5c447e04920e9971eaa"
                },
                "downloads": -1,
                "filename": "baresql-0.7.3-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "dc270f7a03ed541415c489f7602b24fb",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 11755,
                "upload_time": "2015-11-10T16:37:44",
                "url": "https://files.pythonhosted.org/packages/af/b9/425ed06cc7c3ca5fd20540a9585f1be43463ae46ef6b0a08bf0f7106388f/baresql-0.7.3-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "cde45226fdfc7288af400e97202a05d7",
                    "sha256": "3f4daf93a9daa19d4b8b33de0bbf980d7eee75590de022e18e81d4d888ac4746"
                },
                "downloads": -1,
                "filename": "baresql-0.7.3.zip",
                "has_sig": false,
                "md5_digest": "cde45226fdfc7288af400e97202a05d7",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 13621,
                "upload_time": "2015-11-10T16:37:49",
                "url": "https://files.pythonhosted.org/packages/4a/d6/635cb8b285e6145a579ad87ecd78115648ff584b81d9ae8f80d77f028969/baresql-0.7.3.zip"
            }
        ],
        "0.7.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "68b9aa1042e9fd1183bc78ce378607b3",
                    "sha256": "ce2de6460484858da32111d50989b4676fad156ecb7feb8321f7a71ab742e2f1"
                },
                "downloads": -1,
                "filename": "baresql-0.7.4-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "68b9aa1042e9fd1183bc78ce378607b3",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 11847,
                "upload_time": "2016-09-18T12:56:43",
                "url": "https://files.pythonhosted.org/packages/e1/c6/3b1365915b1bbddab55ec44416829614fd1185e9d1c88d7dcf5153a6e8d1/baresql-0.7.4-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "a0e35f87188bcdcbb8571eb8e639121f",
                    "sha256": "797daa263ac1f826394318c27090afca665663750d58a5f9fb9cd98c16eaf2b1"
                },
                "downloads": -1,
                "filename": "baresql-0.7.4.tar.gz",
                "has_sig": false,
                "md5_digest": "a0e35f87188bcdcbb8571eb8e639121f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9471,
                "upload_time": "2016-09-18T12:56:45",
                "url": "https://files.pythonhosted.org/packages/c5/14/ba7e63228dfd8ea9f1b7070ed2f245d8a9abcdeaaee3d130ee866f9cfc6e/baresql-0.7.4.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "68b9aa1042e9fd1183bc78ce378607b3",
                "sha256": "ce2de6460484858da32111d50989b4676fad156ecb7feb8321f7a71ab742e2f1"
            },
            "downloads": -1,
            "filename": "baresql-0.7.4-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "68b9aa1042e9fd1183bc78ce378607b3",
            "packagetype": "bdist_wheel",
            "python_version": "py2.py3",
            "requires_python": null,
            "size": 11847,
            "upload_time": "2016-09-18T12:56:43",
            "url": "https://files.pythonhosted.org/packages/e1/c6/3b1365915b1bbddab55ec44416829614fd1185e9d1c88d7dcf5153a6e8d1/baresql-0.7.4-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "a0e35f87188bcdcbb8571eb8e639121f",
                "sha256": "797daa263ac1f826394318c27090afca665663750d58a5f9fb9cd98c16eaf2b1"
            },
            "downloads": -1,
            "filename": "baresql-0.7.4.tar.gz",
            "has_sig": false,
            "md5_digest": "a0e35f87188bcdcbb8571eb8e639121f",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 9471,
            "upload_time": "2016-09-18T12:56:45",
            "url": "https://files.pythonhosted.org/packages/c5/14/ba7e63228dfd8ea9f1b7070ed2f245d8a9abcdeaaee3d130ee866f9cfc6e/baresql-0.7.4.tar.gz"
        }
    ]
}