{ "info": { "author": "Rafael Izidoro", "author_email": "izidoro.rafa@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Programming Language :: Python :: 3.8", "Topic :: Utilities" ], "description": "# SQLoad\n\nA simple utility tool that scan SQL files with queries separated by comments into python dicts.\n\n\n# Usage\nGiven a file called `queries.sql` with the following content:\n\n```sql\n-- find-all-by-name\nSELECT * FROM users WHERE name = :name\n\n-- find-one-by-id\nSELECT * FROM users WHERE id = 10 LIMIT 1\n\n-- find-users-join-products\nSELECT * FROM users u\n INNER JOIN products p ON u.id = p.user_id\n WHERE u.id = 1\n LIMIT 1\n```\n\nYou can load those queries into dicts as follow:\n\n```python\nfrom sqload import load\n\nq = load('queries.sql')\n\n\nassert q['find-all-by-name'] == \"SELECT * FROM users WHERE name = :name\"\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/rizidoro/sqload", "keywords": "", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "sqload", "package_url": "https://pypi.org/project/sqload/", "platform": "", "project_url": "https://pypi.org/project/sqload/", "project_urls": { "Homepage": "https://github.com/rizidoro/sqload" }, "release_url": "https://pypi.org/project/sqload/0.1.0/", "requires_dist": null, "requires_python": "", "summary": "A simple utility tool that scan SQL files with queries separated by comments into python dicts.", "version": "0.1.0" }, "last_serial": 5892054, "releases": { "0.1.0": [ { "comment_text": "", "digests": { "md5": "db4e26dc504d5e417b69a949ceac27db", "sha256": "f5863a4b5fc3f681b36ac0d293a702ac1157b1e53ebfd2983d9e0a60de56ef53" }, "downloads": -1, "filename": "sqload-0.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "db4e26dc504d5e417b69a949ceac27db", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2692, "upload_time": "2019-09-26T18:25:29", "url": "https://files.pythonhosted.org/packages/d6/46/99c3cc3b2e45a1f0fa523a7b01babfa02c8683534d3dd734c7f89f1bcf56/sqload-0.1.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "54d84f2ea1151c132447aa35072e8e0b", "sha256": "c2faf7afe4fd4e1ca21a85c2409adbd42e8f4174a6325c548f6f398e929a635d" }, "downloads": -1, "filename": "sqload-0.1.0.tar.gz", "has_sig": false, "md5_digest": "54d84f2ea1151c132447aa35072e8e0b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1689, "upload_time": "2019-09-26T18:25:32", "url": "https://files.pythonhosted.org/packages/45/68/4f19359a2f21a532d8d8db4e7dd49721b87ce806bb9ecee5da004605515a/sqload-0.1.0.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "db4e26dc504d5e417b69a949ceac27db", "sha256": "f5863a4b5fc3f681b36ac0d293a702ac1157b1e53ebfd2983d9e0a60de56ef53" }, "downloads": -1, "filename": "sqload-0.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "db4e26dc504d5e417b69a949ceac27db", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 2692, "upload_time": "2019-09-26T18:25:29", "url": "https://files.pythonhosted.org/packages/d6/46/99c3cc3b2e45a1f0fa523a7b01babfa02c8683534d3dd734c7f89f1bcf56/sqload-0.1.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "54d84f2ea1151c132447aa35072e8e0b", "sha256": "c2faf7afe4fd4e1ca21a85c2409adbd42e8f4174a6325c548f6f398e929a635d" }, "downloads": -1, "filename": "sqload-0.1.0.tar.gz", "has_sig": false, "md5_digest": "54d84f2ea1151c132447aa35072e8e0b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1689, "upload_time": "2019-09-26T18:25:32", "url": "https://files.pythonhosted.org/packages/45/68/4f19359a2f21a532d8d8db4e7dd49721b87ce806bb9ecee5da004605515a/sqload-0.1.0.tar.gz" } ] }