{ "info": { "author": "Imad ElOuajib", "author_email": "elouajib.im@gmail.com", "bugtrack_url": null, "classifiers": [ "License :: OSI Approved :: MIT License", "Operating System :: OS Independent", "Programming Language :: Python :: 3" ], "description": "Python module to escape SQL special characters and quotes in strings\n\ninstall:\n`pip install sqlescapy`\n\nAssuming `dangerous_input` is a variable coming from a user input, a bad actor can exploit it to start injecting your database.\n```python\nfrom sqlescapy import sqlescape\n\ndangerous_input = \"JhonWick'\"\n\nprotected_raw_statement = \"\\\"foo_table\\\".username='%s'\" % sqlescape(dangerous_input)\n\nprotected_query = \"\"\"\n\nSELECT \"foo_table\".*, \"bar_table\".*\nFROM \"foo_table\", \"bar_table\"\nWHERE \"foo_table\".id = \"bar_table\".id\n AND %s\n\"\"\" % protected_raw_statement\n\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://github.com/elouajib/sqlescapy", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "sqlescapy", "package_url": "https://pypi.org/project/sqlescapy/", "platform": "", "project_url": "https://pypi.org/project/sqlescapy/", "project_urls": { "Homepage": "https://github.com/elouajib/sqlescapy" }, "release_url": "https://pypi.org/project/sqlescapy/1.0.1/", "requires_dist": null, "requires_python": ">=2.7", "summary": "Python module to escape SQL special characters and quotes in strings", "version": "1.0.1" }, "last_serial": 5827164, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "c6a4adcc0add69c87496c5752d1c05ef", "sha256": "5da26ffc1327ce9b96cc2f493b5057d6fcef936121b78bf0da98964e4dd049f5" }, "downloads": -1, "filename": "sqlescapy-1.0.0-py3-none-any.whl", "has_sig": false, "md5_digest": "c6a4adcc0add69c87496c5752d1c05ef", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.6", "size": 2761, "upload_time": "2019-09-13T18:03:48", "url": "https://files.pythonhosted.org/packages/80/0f/c0be556ada12acf635725cb1aa89131dc86e6f4f9653148f2499ed8b1bb1/sqlescapy-1.0.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "0f47120df90b9a16f6b03a80ec77ab08", "sha256": "952b66de0c864c52d0e7c0961669387976d21f292751bd82da749253d73308e8" }, "downloads": -1, "filename": "sqlescapy-1.0.0.tar.gz", "has_sig": false, "md5_digest": "0f47120df90b9a16f6b03a80ec77ab08", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.6", "size": 1484, "upload_time": "2019-09-13T18:03:50", "url": "https://files.pythonhosted.org/packages/f4/f4/1ccdf4dff65dcc74f8c0a9d39c4af79db2bae6d9b83a52d7b6dbe2df1329/sqlescapy-1.0.0.tar.gz" } ], "1.0.1": [ { "comment_text": "", "digests": { "md5": "44e3bc0456b1cdcaf50a26d1f015bc32", "sha256": "3a50b4b1eb8971b51a3c097c37cd58921a8f9e296619534aed515116356f5fbf" }, "downloads": -1, "filename": "sqlescapy-1.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "44e3bc0456b1cdcaf50a26d1f015bc32", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=2.7", "size": 2792, "upload_time": "2019-09-13T18:18:15", "url": "https://files.pythonhosted.org/packages/c4/6a/bd5df7aeed348a0ac9d2d0417128ed82af6291bd76afb16254379a55ad3f/sqlescapy-1.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "f455a9c35e201ef642d5f946107c3940", "sha256": "281c27266e9f6934a7728a7272b2299bce395d0aeb12a314641add1ffd7e0872" }, "downloads": -1, "filename": "sqlescapy-1.0.1.tar.gz", "has_sig": false, "md5_digest": "f455a9c35e201ef642d5f946107c3940", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7", "size": 1520, "upload_time": "2019-09-13T18:18:16", "url": "https://files.pythonhosted.org/packages/43/bb/d5077ee1599474af84393bc000212d2aa29e846e10044c4a5eb0813f2339/sqlescapy-1.0.1.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "44e3bc0456b1cdcaf50a26d1f015bc32", "sha256": "3a50b4b1eb8971b51a3c097c37cd58921a8f9e296619534aed515116356f5fbf" }, "downloads": -1, "filename": "sqlescapy-1.0.1-py3-none-any.whl", "has_sig": false, "md5_digest": "44e3bc0456b1cdcaf50a26d1f015bc32", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=2.7", "size": 2792, "upload_time": "2019-09-13T18:18:15", "url": "https://files.pythonhosted.org/packages/c4/6a/bd5df7aeed348a0ac9d2d0417128ed82af6291bd76afb16254379a55ad3f/sqlescapy-1.0.1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "f455a9c35e201ef642d5f946107c3940", "sha256": "281c27266e9f6934a7728a7272b2299bce395d0aeb12a314641add1ffd7e0872" }, "downloads": -1, "filename": "sqlescapy-1.0.1.tar.gz", "has_sig": false, "md5_digest": "f455a9c35e201ef642d5f946107c3940", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7", "size": 1520, "upload_time": "2019-09-13T18:18:16", "url": "https://files.pythonhosted.org/packages/43/bb/d5077ee1599474af84393bc000212d2aa29e846e10044c4a5eb0813f2339/sqlescapy-1.0.1.tar.gz" } ] }