{
    "info": {
        "author": "Kyle Pericak",
        "author_email": "kyle@pericak.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 3 - Alpha",
            "Intended Audience :: Information Technology",
            "License :: OSI Approved :: MIT License",
            "Natural Language :: English",
            "Programming Language :: Python :: 3",
            "Topic :: Database"
        ],
        "description": "# JSC2F: JSON SQL Cell to File\n\nThis module contains functions to save a JSON cell from a MySQL or Mariadb\ndatabase to a file in a nice and easy to use format. It can also upload JSON\nfiles back to the database.\n\n\n---\n\n\n# Installation\n\nJSC2FF can be installed by cloning the github repo or from PyPi.\n\n```bash\npip install jsc2f\n```\n\n\n---\n\n\n# CLI Usage Example\n\n- `download` will save the JSON string from the SQL cell to a nicely formatted\n  file for editing.\n- `upload` will update the cell with the JSON file\n- `--where` is used as a selector: `--where \"id == 3\"`\n\n```bash\n# Download a cell to a file\njsc2f download \\\n  --db-ip $database_ip \\\n  --db-name $database_name  \\\n  --db-password $database_password \\\n  --db-user $database_user \\\n  --filename $file_path \\\n  --table $table_name \\\n  -column $column_name\n\n# Upload a file to a cell\njsc2f upload \\\n  --db-ip $database_ip \\\n  --db-name $database_name  \\\n  --db-password $database_password \\\n  --db-user $database_user \\\n  --filename $file_path \\\n  --table $table_name \\\n  -column $column_name\n```\n\n```bash\n# jsc2f  --help\nUsage: jsc2f [OPTIONS]\n\n  Upload/Download JSON SQL Cell from/to a local file\n\nOptions:\n  --where TEXT\n  --table TEXT           [required]\n  --column TEXT          [required]\n  --db-name TEXT         [required]\n  --db-password TEXT     [required]\n  --db-user TEXT         [required]\n  --db-port INTEGER\n  --db-ip TEXT           [required]\n  --filename TEXT        [required]\n  --upload / --download  Upload or download  [required]\n  --help                 Show this message and exit.\n```\n\n\n---\n\n\n# Python Module Usage Example\n\n```python\nimport jsc2f.lib as jsc2f\n\n# Get data from SQL cell and write it to JSON file\njsc2f.save_to_file(filename=filename, host=db_ip, user=db_user,\n                   password=db_password, database=db_name, column=column,\n                   table=table, where=where, port=db_port)\n\n# Get JSON from file and write it to SQL cell\njsc2f.update_from_file(filename=filename, host=db_ip, user=db_user,\n                       password=db_password, database=db_name,\n                       column=column, table=table, where=where,\n                       port=db_port)\n```",
        "description_content_type": "text/markdown",
        "docs_url": null,
        "download_url": "https://github.com/kylep/jsc2f/archive/v0.1.tar.gz",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/kylep/jsc2f",
        "keywords": "SQL,JSON,file",
        "license": "MIT",
        "maintainer": "",
        "maintainer_email": "",
        "name": "jsc2f",
        "package_url": "https://pypi.org/project/jsc2f/",
        "platform": "",
        "project_url": "https://pypi.org/project/jsc2f/",
        "project_urls": {
            "Download": "https://github.com/kylep/jsc2f/archive/v0.1.tar.gz",
            "Homepage": "https://github.com/kylep/jsc2f"
        },
        "release_url": "https://pypi.org/project/jsc2f/0.1.3/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Saves a JSON fields SQLs cell to a file, or UPDATE it back",
        "version": "0.1.3"
    },
    "last_serial": 5797818,
    "releases": {
        "0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "7ab25a69e604a8de4a016a7b0293d420",
                    "sha256": "b94597eb4c13b78448268d7e0d6a189b3d8c13da3b59f6c86be06e9e84504ac5"
                },
                "downloads": -1,
                "filename": "jsc2f-0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "7ab25a69e604a8de4a016a7b0293d420",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2716,
                "upload_time": "2019-09-07T20:13:04",
                "url": "https://files.pythonhosted.org/packages/56/b9/68b2317d0f3c308ab63518b9c59bc157f6fc7bcdc6b22856cd02ed44a9db/jsc2f-0.1.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "fb0247600d1e83b82998b3c0d63b6ab5",
                    "sha256": "b2ed1763e196b2bd3ace8a8d8a7dd2790b7216e14ae2dba0051087fb27c734a0"
                },
                "downloads": -1,
                "filename": "jsc2f-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "fb0247600d1e83b82998b3c0d63b6ab5",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2752,
                "upload_time": "2019-09-07T20:17:34",
                "url": "https://files.pythonhosted.org/packages/b7/47/9c92d18cafa7e19272e4df8ec9b63af19ffb4cad9de4425be6494bc8018c/jsc2f-0.1.1.tar.gz"
            }
        ],
        "0.1.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "65d25382f4bb72a9d72c7267c391ec03",
                    "sha256": "b566d430c6fb7a71b8312f38bd2f919d5f2be9fe2cfbbe365dcccd352be40c1a"
                },
                "downloads": -1,
                "filename": "jsc2f-0.1.3.tar.gz",
                "has_sig": false,
                "md5_digest": "65d25382f4bb72a9d72c7267c391ec03",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3010,
                "upload_time": "2019-09-08T00:02:57",
                "url": "https://files.pythonhosted.org/packages/83/93/607c72272608f2cfe57b386416e692eb411ad6223ed8b8eff786a44c6015/jsc2f-0.1.3.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "65d25382f4bb72a9d72c7267c391ec03",
                "sha256": "b566d430c6fb7a71b8312f38bd2f919d5f2be9fe2cfbbe365dcccd352be40c1a"
            },
            "downloads": -1,
            "filename": "jsc2f-0.1.3.tar.gz",
            "has_sig": false,
            "md5_digest": "65d25382f4bb72a9d72c7267c391ec03",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 3010,
            "upload_time": "2019-09-08T00:02:57",
            "url": "https://files.pythonhosted.org/packages/83/93/607c72272608f2cfe57b386416e692eb411ad6223ed8b8eff786a44c6015/jsc2f-0.1.3.tar.gz"
        }
    ]
}