{
    "info": {
        "author": "Keto Zhang, Weikang Zheng",
        "author_email": "keto.zhang@gmail.com",
        "bugtrack_url": null,
        "classifiers": [],
        "description": "[![Build Status](https://travis-ci.org/ketozhang/astroSQL.svg?branch=master)](https://travis-ci.org/ketozhang/astroSQL)\n\n# astroSQL - Simple Database Tools for Python\n\nSimple Python API to access existing astronomy MySQL database.\n> While designed for astronomy, astroSQL can be used for every field.\n\n## Features\n* **astroSQL** Python API:\n  - [x] create SQL database table\n  - [x] read SQL database table\n  - [x] update SQL database table\n  - [x] SQL query using peewee ORM\n* **astroSQL** Shell Command\n  - [ ]  query SQL database to text-based file\n  - [ ]  update SQL database with text-based file\n \u00a0\n## Dependencies\n* MySQL server\n* Python 3.x\n\n## Setup\n\n1. Perform a `pip install`,\n\n    ```sh\n    $ pip install astroSQL\n    ```\n\n    Check the version installed:\n\n    ```sh\n    $ pip show astroSQL\n    ```\n\n2. Edit the configuration file as necessary in `~/.astrosql/config.yml`:\n\n    <!-- $ ls $(python -c \"import site; print(site.getsitepackages()[0])\")/astrosql -->\n    ```yml\n    # Uncomment 'forward' if you want to place config.yml elsewhere, specify the file path (maybe `~/.astrosql/config.yml` ?)\n    # forward: '/path/to/config.yml'\n\n    # Comment out any unecessary lines, empty will be read\n    mysql:\n        host: 'localhost'\n        user: 'username'\n        password: ''\n        database: 'database_name'\n    ```\n\n\n    > <span style=\"color:rgb(200,0,0)\">WARNING:</span> Keep this file secure if password is written\n\n3. Test setup\n\n    ```python\n    >>> from astrosql.sqlconnector import connect\n    >>> from astrosql import AstroSQL\n\n    >>> db = AstroSQL(connect()) # connect does not need args as it reads from config.yml\n    >>> db.tables.values()\n    dict_values(['tb1, tb2, ...']) # should output all table names from your database\n    ```\n\n## Usage\n\nSee [wiki](https://github.com/ketozhang/astroSQL/wiki):\n\n* [Python Usage](https://github.com/ketozhang/astroSQL/wiki/Python-Usage)\n\n## References\n**Filippenko Group - Project Team**\n\nThe program was built for the Filippenko Group, astronomy researchers led by [Alex Filippenko](https://astro.berkeley.edu/faculty-profile/alex-filippenko) for analyzing data from the Lick Observatory and Keck Observatory.\n\nProject team led by [Keto Zhang](https://github.com/ketozhang) and [Weikang Zheng](https://astro.berkeley.edu/researcher-profile/2358133-weikang-zheng).\n\n**Source Code and Inspiration**:\n\nSome parts of the program was provided by and inspired from [Issac Shiver](https://github.com/ishivvers) and [Thomas Tu](https://github.com/thomastu) from the [FlipperPhoto repository](https://github.com/ketozhang/FlipperPhoto/tree/master/flipp/libs).\n\n\n",
        "description_content_type": "text/markdown",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/ketozhang/astroSQL",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "astroSQL",
        "package_url": "https://pypi.org/project/astroSQL/",
        "platform": "",
        "project_url": "https://pypi.org/project/astroSQL/",
        "project_urls": {
            "Homepage": "https://github.com/ketozhang/astroSQL"
        },
        "release_url": "https://pypi.org/project/astroSQL/0.3.0/",
        "requires_dist": [
            "peewee",
            "termcolor",
            "pymysql",
            "astropy",
            "numpy",
            "pandas",
            "pyyaml"
        ],
        "requires_python": "",
        "summary": "Simple API to access to existing astronomical MySQL database",
        "version": "0.3.0"
    },
    "last_serial": 4123315,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "94a0162d2947bcdca36637b82ec8ce88",
                    "sha256": "0e652f098ce03e2c4f25ec3a59595a900830b7e29ecce9f2dea9ec1a11a191fe"
                },
                "downloads": -1,
                "filename": "astroSQL-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "94a0162d2947bcdca36637b82ec8ce88",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 15258,
                "upload_time": "2018-04-13T02:21:19",
                "url": "https://files.pythonhosted.org/packages/a9/04/427f92fa833c2b31312d99b399f05e6543f131029625ed3183c1bfc7f30a/astroSQL-0.1.0.tar.gz"
            }
        ],
        "0.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "746f0d6a90212f6b56b91a2171dbb422",
                    "sha256": "1a9c8d8ef13c84731fd4ea8718c7f67b75365572ad967251a8f64c470a2ad08b"
                },
                "downloads": -1,
                "filename": "astrosql-0.1.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "746f0d6a90212f6b56b91a2171dbb422",
                "packagetype": "bdist_wheel",
                "python_version": "3.6",
                "requires_python": null,
                "size": 11549,
                "upload_time": "2018-04-13T13:34:39",
                "url": "https://files.pythonhosted.org/packages/bd/dd/da4e293e6b819dd6f96c9b594895875a21c6ce5ec95a7f2799a5ad6e04bd/astrosql-0.1.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "96bce0d4b07944eb0c5cdb1c5e98902b",
                    "sha256": "ed248bb980b204a3eb27125c9a48b0ae4865b0149cda37b6a4a40c8f4bbe0856"
                },
                "downloads": -1,
                "filename": "astrosql-0.1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "96bce0d4b07944eb0c5cdb1c5e98902b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9205,
                "upload_time": "2018-04-13T13:34:37",
                "url": "https://files.pythonhosted.org/packages/fe/c7/fb1b232c798417eeb68b53719d95a59b9af9c0507371368492d00ffc60a4/astrosql-0.1.2.tar.gz"
            }
        ],
        "0.1.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "3be5bc3d5de56d5e1e52c89af6acd7c5",
                    "sha256": "2dc1f49ee6e084201797eed4a3070f419b4b404fa3f3a5b957fbd398f8b12b97"
                },
                "downloads": -1,
                "filename": "astrosql-0.1.3-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "3be5bc3d5de56d5e1e52c89af6acd7c5",
                "packagetype": "bdist_wheel",
                "python_version": "3.6",
                "requires_python": null,
                "size": 11227,
                "upload_time": "2018-04-13T12:16:06",
                "url": "https://files.pythonhosted.org/packages/16/3e/02566c0309c93e898bf75da18673e598c4705b9f6154a2d081272d80b2fd/astrosql-0.1.3-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "6f37d7b5de24031b1e1f23486a0b2d39",
                    "sha256": "49677b61bd4a95b5930e7bee1261ee2e68c134dc2bdfa58f4a2a4027eafe1a61"
                },
                "downloads": -1,
                "filename": "astrosql-0.1.3.tar.gz",
                "has_sig": false,
                "md5_digest": "6f37d7b5de24031b1e1f23486a0b2d39",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9192,
                "upload_time": "2018-04-13T12:16:05",
                "url": "https://files.pythonhosted.org/packages/cc/30/e226f4cc69e70426e02a718a3c6de67ab49423c94a182ec0c8b61f62640a/astrosql-0.1.3.tar.gz"
            }
        ],
        "0.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f05ec33bd8e20be42953fbe1d39033e6",
                    "sha256": "771125090fd6bc9a1392c667a0e7618ad447092c94ed26aba42c6eef9f729992"
                },
                "downloads": -1,
                "filename": "astrosql-0.2.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "f05ec33bd8e20be42953fbe1d39033e6",
                "packagetype": "bdist_wheel",
                "python_version": "3.6",
                "requires_python": null,
                "size": 11245,
                "upload_time": "2018-04-23T23:57:58",
                "url": "https://files.pythonhosted.org/packages/ac/06/d378b9a087704490391a5e0d8816f38c8d703cf475336a421a64df77b67b/astrosql-0.2.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "e5c411dd26e048c5a1fb19ef1b6c56a8",
                    "sha256": "45fc8e8645f7c17d95e256971839f29b65ad6941eb58bde971d4c0d259087033"
                },
                "downloads": -1,
                "filename": "astrosql-0.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "e5c411dd26e048c5a1fb19ef1b6c56a8",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9714,
                "upload_time": "2018-04-23T23:57:56",
                "url": "https://files.pythonhosted.org/packages/ea/c7/5930db88bf1b65ea6d10c8d3e5bf10574c116886455c7a2f4b8d61fb6302/astrosql-0.2.0.tar.gz"
            }
        ],
        "0.2.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "87559e54070629fdb48c5e6fa81f09ab",
                    "sha256": "c8223d14f40dcaf2936fc2e979935d8aa52e7fa3b27e8f6aa59a8b06a889f30d"
                },
                "downloads": -1,
                "filename": "astrosql-0.2.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "87559e54070629fdb48c5e6fa81f09ab",
                "packagetype": "bdist_wheel",
                "python_version": "3.6",
                "requires_python": null,
                "size": 11228,
                "upload_time": "2018-04-24T00:28:42",
                "url": "https://files.pythonhosted.org/packages/b0/fa/7be83d8fbde69144958897fc2e2fde56d066f1abc144f76e4fe91c01ccbd/astrosql-0.2.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "84f0a1aee1e8b333434fabe6c0308765",
                    "sha256": "b40f64c6d0a5d91b897256eac2de26328fc899140695245e1d2dbd7a03fa64c3"
                },
                "downloads": -1,
                "filename": "astrosql-0.2.1.tar.gz",
                "has_sig": false,
                "md5_digest": "84f0a1aee1e8b333434fabe6c0308765",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9653,
                "upload_time": "2018-04-24T00:28:41",
                "url": "https://files.pythonhosted.org/packages/ce/f6/cf5620c4b733e69703004027b26c2f94e6bdc81de69a8d81fa47097ac9b6/astrosql-0.2.1.tar.gz"
            }
        ],
        "0.2.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "d379c40d5e5ab4ebe0e2d10f8b3df143",
                    "sha256": "189c45383f8d81790bb641e2947ea73444aae53b9868ec1d5b75cd2b5d00047c"
                },
                "downloads": -1,
                "filename": "astrosql-0.2.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "d379c40d5e5ab4ebe0e2d10f8b3df143",
                "packagetype": "bdist_wheel",
                "python_version": "3.6",
                "requires_python": null,
                "size": 11220,
                "upload_time": "2018-04-27T09:19:24",
                "url": "https://files.pythonhosted.org/packages/5f/32/e67baba72a872f006f8646a42626ffc17fc467f42f89c8a2641a262353c3/astrosql-0.2.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "6fad65c074f223ca589dc7fee02f3cad",
                    "sha256": "c2ca719530d517cb1ea98f6bea8ff5a663c76f7503d46a83cee6bad2a84dbc59"
                },
                "downloads": -1,
                "filename": "astrosql-0.2.2.tar.gz",
                "has_sig": false,
                "md5_digest": "6fad65c074f223ca589dc7fee02f3cad",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9705,
                "upload_time": "2018-04-27T09:19:23",
                "url": "https://files.pythonhosted.org/packages/38/3e/72dcb8d5b8e85e797e4e2cbf7723c818a92aded60615944338eed3e24a7d/astrosql-0.2.2.tar.gz"
            }
        ],
        "0.2.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f1543c10206fa4576e3d488b862b4640",
                    "sha256": "f9a55e3daecdd03aa5596890619950ffaff1a0e8c17ebdf03d679c8bf3ccf930"
                },
                "downloads": -1,
                "filename": "astrosql-0.2.3-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "f1543c10206fa4576e3d488b862b4640",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 10427,
                "upload_time": "2018-08-01T00:49:14",
                "url": "https://files.pythonhosted.org/packages/a1/c3/8d094300dd1936378cc92b5ff12bfc9bacbf51311445f9d0b8cf1dbfc7c0/astrosql-0.2.3-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "c0b7ad68594ad7166a093957642fc1ae",
                    "sha256": "055cbd60ee83842d665cb9f0ed8e77486954795190b848f6861edd04d5ab66bc"
                },
                "downloads": -1,
                "filename": "astrosql-0.2.3.tar.gz",
                "has_sig": false,
                "md5_digest": "c0b7ad68594ad7166a093957642fc1ae",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9479,
                "upload_time": "2018-08-01T00:49:15",
                "url": "https://files.pythonhosted.org/packages/63/fd/fe28cfe59cad20ecbaf179b9a5bfa32d29d7bb5e2a2c0ddcfd096ba5bc64/astrosql-0.2.3.tar.gz"
            }
        ],
        "0.2.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "d872934304d0b45c70bf06f60a65bdeb",
                    "sha256": "18eedbe4767fb2f895a78bc4662eee36d80686610431bc1618d4a9c67064430b"
                },
                "downloads": -1,
                "filename": "astrosql-0.2.4-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "d872934304d0b45c70bf06f60a65bdeb",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 10541,
                "upload_time": "2018-08-01T02:10:45",
                "url": "https://files.pythonhosted.org/packages/59/59/7a75242df0d7dfbd759934ca705a637eb8cb8f778dba7b9b48a40cf9ba5c/astrosql-0.2.4-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "194858549800c4fd9e06c64b2747b39f",
                    "sha256": "62496770b27409610444d224b1710c691346a49af7cd0ce7bc4bf2d7cc16d65c"
                },
                "downloads": -1,
                "filename": "astrosql-0.2.4.tar.gz",
                "has_sig": false,
                "md5_digest": "194858549800c4fd9e06c64b2747b39f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9590,
                "upload_time": "2018-08-01T02:10:47",
                "url": "https://files.pythonhosted.org/packages/c3/31/0e725d178c1ce4dedaccdc96cbea2d9f66502ab71a9e3467214dffb56f35/astrosql-0.2.4.tar.gz"
            }
        ],
        "0.3.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2addaa95dea3a126cab1bfa84c4b31cf",
                    "sha256": "bff633e6104edaf496898e1d0c04d707e454f3d9b2e5efd6d7292fe4a4a790c3"
                },
                "downloads": -1,
                "filename": "astrosql-0.3.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "2addaa95dea3a126cab1bfa84c4b31cf",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 11707,
                "upload_time": "2018-08-01T05:14:53",
                "url": "https://files.pythonhosted.org/packages/88/48/3c15e93d57dc4bb96b4abf99bd487a244a96068d93584b475d1436872f4c/astrosql-0.3.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "75b51365bc66b611b94d8989083ed6b1",
                    "sha256": "f0022d23ec3dcb8d03c20032d3b6e84bd8a09a74623be8a1795bc2ea3425dd07"
                },
                "downloads": -1,
                "filename": "astrosql-0.3.0.tar.gz",
                "has_sig": false,
                "md5_digest": "75b51365bc66b611b94d8989083ed6b1",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9999,
                "upload_time": "2018-08-01T05:14:54",
                "url": "https://files.pythonhosted.org/packages/e0/19/3a1e9982be7c499478c48a6bc9eaa1f930d324affa58e1b3b583c2ff09c6/astrosql-0.3.0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "2addaa95dea3a126cab1bfa84c4b31cf",
                "sha256": "bff633e6104edaf496898e1d0c04d707e454f3d9b2e5efd6d7292fe4a4a790c3"
            },
            "downloads": -1,
            "filename": "astrosql-0.3.0-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "2addaa95dea3a126cab1bfa84c4b31cf",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 11707,
            "upload_time": "2018-08-01T05:14:53",
            "url": "https://files.pythonhosted.org/packages/88/48/3c15e93d57dc4bb96b4abf99bd487a244a96068d93584b475d1436872f4c/astrosql-0.3.0-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "75b51365bc66b611b94d8989083ed6b1",
                "sha256": "f0022d23ec3dcb8d03c20032d3b6e84bd8a09a74623be8a1795bc2ea3425dd07"
            },
            "downloads": -1,
            "filename": "astrosql-0.3.0.tar.gz",
            "has_sig": false,
            "md5_digest": "75b51365bc66b611b94d8989083ed6b1",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 9999,
            "upload_time": "2018-08-01T05:14:54",
            "url": "https://files.pythonhosted.org/packages/e0/19/3a1e9982be7c499478c48a6bc9eaa1f930d324affa58e1b3b583c2ff09c6/astrosql-0.3.0.tar.gz"
        }
    ]
}