{
    "info": {
        "author": "Farukh Dilawar Tamboli",
        "author_email": "farukht@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: GNU General Public License v3 (GPLv3)",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3"
        ],
        "description": "# MySQL easy\n\nMySQL easy is a tool to augment your database development using MySQL. It gives you more insight into your MySQL database, by providing you an ability to graphically trace code dependencies between MySQL views, stored procedures and tables.\n\nIt is also an intelligent code generator. It generates code for you in SQL or in Python based on your table structure and relationships between the table. This tool will help debug larger database applications easily and write code in matter of clicks that you may require few days of effort. \n\n## SQL code\nSample code that you can use to create a table named user with three columns user_id, last_name and first_name.\n\n```sql\nCREATE TABLE `user` (\n  `user_id` int(11) NOT NULL AUTO_INCREMENT,\n  `first_name` varchar(70) DEFAULT NULL,\n  `last_name` varchar(70) DEFAULT NULL,\n  PRIMARY KEY (`user_id`)\n) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;\n```\n\n## Code generation\n\nUse [MySQLeasy](http://www.mysqleasy.com) to generate code for your table. Once python class for user is generated run it.\n\n## Python code\n\nFollowing code will insert a new user John Smith. Then search the records with last name Smith. Then update the first name to Mike in the first row. Update the records in database and at the end close the connection.\n\n```python\nfrom mysqleasy.Connection import Connection as Connection\nfrom mysqleasy.Access import Access as Access\nconnector = \"mysqlconnector\"\ndb_config = {'host': 'your_database_host_address', 'user': 'your_database_user_name', 'password': 'your_database_password'}\nconn = Connection.create(connector, db_config)\nlast_row_id = user.insert(conn, first_name = \"John\", last_name = \"Smith\")\ncolumns, users = user.search(conn, last_name='Smith')\nuser_list = [o for o in Access.iter_object(columns, users)]\nlast_row_id, count_affected = user.insertupdate_multiple(conn, [('Mike', 'Smith', 1)])\nconn.commit()\nconn.close()\n``` \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://www.mysqleasy.com",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "mysqleasy",
        "package_url": "https://pypi.org/project/mysqleasy/",
        "platform": "",
        "project_url": "https://pypi.org/project/mysqleasy/",
        "project_urls": {
            "Homepage": "https://www.mysqleasy.com"
        },
        "release_url": "https://pypi.org/project/mysqleasy/0.0.2/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "MySQL-easy provides an easy access to MySQL database",
        "version": "0.0.2"
    },
    "last_serial": 5331633,
    "releases": {
        "0.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "bbfac5ccedc814b0ee8c083cc9ad0e79",
                    "sha256": "97fb62ca41a38d20cb8cc71f8b4542ecea887c5caf26717c58024546b07510e9"
                },
                "downloads": -1,
                "filename": "mysqleasy-0.0.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "bbfac5ccedc814b0ee8c083cc9ad0e79",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 6891,
                "upload_time": "2019-05-28T04:17:59",
                "url": "https://files.pythonhosted.org/packages/9d/e0/152fd47904d00949a9b82fa4ea93cf6c866c2f3fbd47d7a897b825fcd614/mysqleasy-0.0.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "e2ca6e04382d2ab09daad48ef24c3c7d",
                    "sha256": "1eff051d0aaf52e989c9446a2b422890f09147767f220d6a04742d3ad0533d35"
                },
                "downloads": -1,
                "filename": "mysqleasy-0.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "e2ca6e04382d2ab09daad48ef24c3c7d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4048,
                "upload_time": "2019-05-28T04:18:02",
                "url": "https://files.pythonhosted.org/packages/bf/ce/478a873acf34242e1bb089bae21cb4c7d22af165beb1b814a83e84b3ce0d/mysqleasy-0.0.1.tar.gz"
            }
        ],
        "0.0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b523c002aa678fc08227c418c1aaab1e",
                    "sha256": "164bad58573047592f6dedf2203bedbb818a35c0761c1f0bd0ba14b1cc8d1de9"
                },
                "downloads": -1,
                "filename": "mysqleasy-0.0.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "b523c002aa678fc08227c418c1aaab1e",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 6919,
                "upload_time": "2019-05-29T10:25:56",
                "url": "https://files.pythonhosted.org/packages/70/ec/b8fcf810dabe8c43bdbf786c5b252b1edc23a49b6373ca10eb1e6dc2b7eb/mysqleasy-0.0.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "20806ecc24a9f9e17bbd2161f64e619d",
                    "sha256": "832d9c8d331f8b922d51834b10e8801703c4d659bf283d8c26f429d2574cf8e3"
                },
                "downloads": -1,
                "filename": "mysqleasy-0.0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "20806ecc24a9f9e17bbd2161f64e619d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4077,
                "upload_time": "2019-05-29T10:25:57",
                "url": "https://files.pythonhosted.org/packages/77/72/c07b808728728bb844a7aed7a8c7298ba5dcb6cffe046eea2a242e9183ca/mysqleasy-0.0.2.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "b523c002aa678fc08227c418c1aaab1e",
                "sha256": "164bad58573047592f6dedf2203bedbb818a35c0761c1f0bd0ba14b1cc8d1de9"
            },
            "downloads": -1,
            "filename": "mysqleasy-0.0.2-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "b523c002aa678fc08227c418c1aaab1e",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 6919,
            "upload_time": "2019-05-29T10:25:56",
            "url": "https://files.pythonhosted.org/packages/70/ec/b8fcf810dabe8c43bdbf786c5b252b1edc23a49b6373ca10eb1e6dc2b7eb/mysqleasy-0.0.2-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "20806ecc24a9f9e17bbd2161f64e619d",
                "sha256": "832d9c8d331f8b922d51834b10e8801703c4d659bf283d8c26f429d2574cf8e3"
            },
            "downloads": -1,
            "filename": "mysqleasy-0.0.2.tar.gz",
            "has_sig": false,
            "md5_digest": "20806ecc24a9f9e17bbd2161f64e619d",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 4077,
            "upload_time": "2019-05-29T10:25:57",
            "url": "https://files.pythonhosted.org/packages/77/72/c07b808728728bb844a7aed7a8c7298ba5dcb6cffe046eea2a242e9183ca/mysqleasy-0.0.2.tar.gz"
        }
    ]
}