{ "info": { "author": "Jos\u00e9 S\u00e1nchez Moreno", "author_email": "jose@o2w.es", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Intended Audience :: Developers", "License :: OSI Approved :: Python Software Foundation License", "Operating System :: MacOS :: MacOS X", "Operating System :: Microsoft :: Windows", "Operating System :: POSIX", "Programming Language :: Python", "Programming Language :: SQL" ], "description": "SQL Query Builder based on django ORM\n=====================================\n\nWhat's that?\n-----------\n\nIs a library that you can use to build sql queries if your are accustomed to use Django ORM\n\n\nHow to use\n----------\n\nThere are 4 main objects Q, F, QuerySet and SQLModel.\n\nUsing it \n---------------\n\n.. code-block:: python\n \n from sqlquerybuilder import SQLModel, Queryset, Q, F\n \n class Client(SQLModel):\n table = \"clients\"\n \n \n Client.objects.filter(name=\"Jhon\").exclude(lastname=\"Doe\").group_by(\"family\")\n\n sql = Queryset(\"clients\").filter(name=\"Jhon\").exclude(lastname=\"Doe\").group_by(\"family\")\n\n \n sql = Client.objects.filter(Q(name=\"John\") & ~Q(lastname=\"Doe\"))\n \n sql.group_by(\"family\")\n \n\n sql = Queryset(\"users\")\\\n .filter(nombre=\"jose\")\\\n .order_by( \"nombre\", \"-fecha\")\\\n .filter(fecha__lte=F(\"now()\"))[:10]\n\n \n \"SELECT * FROM users WHERE ((nombre='jose') AND (fecha<=now())) ORDER BY nombre, fecha DESC LIMIT 10\"\n\n Queryset(\"usuarios\").values(\"name\").extra({'select': 'count(*) as total'})\n \"SELECT name , count(*) as total FROM usuarios\"", "description_content_type": null, "docs_url": null, "download_url": "UNKNOWN", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/josesanch/sqlquerybuilder", "keywords": null, "license": "MIT", "maintainer": null, "maintainer_email": null, "name": "sqlquerybuilder", "package_url": "https://pypi.org/project/sqlquerybuilder/", "platform": "All platforms", "project_url": "https://pypi.org/project/sqlquerybuilder/", "project_urls": { "Download": "UNKNOWN", "Homepage": "https://github.com/josesanch/sqlquerybuilder" }, "release_url": "https://pypi.org/project/sqlquerybuilder/0.0.13/", "requires_dist": null, "requires_python": null, "summary": "SQL Query Builder inspired on django ORM Syntax", "version": "0.0.13" }, "last_serial": 1895400, "releases": { "0.0.1": [ { "comment_text": "", "digests": { "md5": "a37fd09f0be2e12f2a0b35603324ec01", "sha256": "8b6e6a1220e90c13f743a3a275e07e2ebb3b1c287a835ea4078389abababf91a" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.1.tar.gz", "has_sig": false, "md5_digest": "a37fd09f0be2e12f2a0b35603324ec01", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 3784, "upload_time": "2014-11-25T06:22:17", "url": "https://files.pythonhosted.org/packages/8d/74/b985b9a0f387900a84b7662818fe4d325b2fdba2d0944a72e2e46230e999/sqlquerybuilder-0.0.1.tar.gz" } ], "0.0.10": [ { "comment_text": "", "digests": { "md5": "0e3b6cbef37a0404823d81647aea3101", "sha256": "89e35d2c94c7e153ed1aef70e13e9e045a90b0ff9d0954879eb85240b25bc589" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.10.tar.gz", "has_sig": false, "md5_digest": "0e3b6cbef37a0404823d81647aea3101", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5623, "upload_time": "2015-02-23T11:35:08", "url": "https://files.pythonhosted.org/packages/93/a6/a58dcd3447db3fce80bb58e328833b5ab092fb5efa725a7835adb11ecd2a/sqlquerybuilder-0.0.10.tar.gz" } ], "0.0.11": [ { "comment_text": "", "digests": { "md5": "9f9c773eff774e67cbd7fc3b99054298", "sha256": "2b9339d51bcc3f0c0207a3921e2c4521c305a97ca843b7d4e8d6009c172cfde6" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.11.tar.gz", "has_sig": false, "md5_digest": "9f9c773eff774e67cbd7fc3b99054298", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5873, "upload_time": "2015-02-28T00:07:59", "url": "https://files.pythonhosted.org/packages/a3/c6/ef8f6fba6e701f8527a5dbfacc439562e5eef745cd4d70a520da7c265fee/sqlquerybuilder-0.0.11.tar.gz" } ], "0.0.12": [ { "comment_text": "", "digests": { "md5": "b96bd8e56d0edde15ccc0fe9eecf3f21", "sha256": "4d2a94a7ded1b72d4d95dc3bba246081b08afbaca281752e21999f874698f547" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.12.tar.gz", "has_sig": false, "md5_digest": "b96bd8e56d0edde15ccc0fe9eecf3f21", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5872, "upload_time": "2015-07-09T11:12:09", "url": "https://files.pythonhosted.org/packages/2e/c6/743775b9daa0915a30ff388cbf59b94fb64e580cfec8cfbfc4d6f3221b9a/sqlquerybuilder-0.0.12.tar.gz" } ], "0.0.13": [ { "comment_text": "", "digests": { "md5": "1fa9454e092966d24cb03ddc6790cffd", "sha256": "461c2b70aa867ca81a7f61bc19884b8cb3344e5070180f97c9580d28a202f4ae" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.13.tar.gz", "has_sig": false, "md5_digest": "1fa9454e092966d24cb03ddc6790cffd", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6037, "upload_time": "2016-01-08T17:55:46", "url": "https://files.pythonhosted.org/packages/1a/e4/11ad634b1cde1ffc2ba10909dd3e33439c3bd2063254bd7d9a9334929c22/sqlquerybuilder-0.0.13.tar.gz" } ], "0.0.2": [ { "comment_text": "", "digests": { "md5": "338a5525abdaaab12ea2a474dade5ac6", "sha256": "14a57b7d470f77c87d6169c14087c3248b48cd82ee47725d17cb6f865686fd1a" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.2.tar.gz", "has_sig": false, "md5_digest": "338a5525abdaaab12ea2a474dade5ac6", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4737, "upload_time": "2014-11-25T11:15:18", "url": "https://files.pythonhosted.org/packages/4e/d8/77bec286a5c885368d7a98fa16d5e44be615992931695ab01bffd21014cd/sqlquerybuilder-0.0.2.tar.gz" } ], "0.0.3": [ { "comment_text": "", "digests": { "md5": "e7b85d9aa0fe9888d96a46e441d2680b", "sha256": "e834b8549e2ee46bf096580310e6838509d6a692d069d0c574d7855782af5b22" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.3.tar.gz", "has_sig": false, "md5_digest": "e7b85d9aa0fe9888d96a46e441d2680b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 4936, "upload_time": "2014-11-25T21:51:28", "url": "https://files.pythonhosted.org/packages/50/55/a00daf9893e6deda968cbc83e0479dd9cea150b1b5192a23c620cbe7cf25/sqlquerybuilder-0.0.3.tar.gz" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "6d91892b6817d303c807cf13259a6053", "sha256": "87d5b9e86b9e39a77f100f4aff5f582ff64ec0ce763cff1e5ebafe8828f9f4be" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.4.tar.gz", "has_sig": false, "md5_digest": "6d91892b6817d303c807cf13259a6053", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5026, "upload_time": "2014-11-26T09:19:58", "url": "https://files.pythonhosted.org/packages/6c/c3/17348db17a604a870171f119653da10f421921b674e8bfcd665e72cd921d/sqlquerybuilder-0.0.4.tar.gz" } ], "0.0.5": [ { "comment_text": "", "digests": { "md5": "7093fb6d07ea204843dc51f7fafa079e", "sha256": "69a63e1770598e09d0c4755ec1d76a1802ea26675b722ed08f7236f80726d741" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.5.tar.gz", "has_sig": false, "md5_digest": "7093fb6d07ea204843dc51f7fafa079e", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5145, "upload_time": "2014-11-26T10:57:19", "url": "https://files.pythonhosted.org/packages/29/ca/4ba4057e5879b72710f0c6f7bb610c56496d0cb04c9764bed7d8026fb346/sqlquerybuilder-0.0.5.tar.gz" } ], "0.0.6": [ { "comment_text": "", "digests": { "md5": "bef5e235aa88c868aa19d40e82455dc5", "sha256": "1846c07fa028389c79b36d512e0b05cd21a328a781068a25c746c0e61d8b78b9" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.6.tar.gz", "has_sig": false, "md5_digest": "bef5e235aa88c868aa19d40e82455dc5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5226, "upload_time": "2014-11-29T20:06:45", "url": "https://files.pythonhosted.org/packages/59/20/3bf652e5a5440e212bce8eef330c6aa4dcd6f2340f88b5387b97b4922418/sqlquerybuilder-0.0.6.tar.gz" } ], "0.0.8": [ { "comment_text": "", "digests": { "md5": "3237dbb693b35d98e5a584392be29b7a", "sha256": "ab0d43f6f0ff952d0d715afd79ec0fc4903c6f64629077a7baea2a4ae53c6dcc" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.8.tar.gz", "has_sig": false, "md5_digest": "3237dbb693b35d98e5a584392be29b7a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5372, "upload_time": "2014-11-30T08:49:12", "url": "https://files.pythonhosted.org/packages/96/fb/3d484dc311a427193022a5fcc539fcf1e2e18da3ad83d3a066ce678d19fa/sqlquerybuilder-0.0.8.tar.gz" } ], "0.0.9": [ { "comment_text": "", "digests": { "md5": "3ee90f6683b2e6dd229de5c1ee132fc4", "sha256": "d9e5a35650de5daae945eb791020ca35c152b2a45063c12c762c1101185eb81e" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.9.tar.gz", "has_sig": false, "md5_digest": "3ee90f6683b2e6dd229de5c1ee132fc4", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 5372, "upload_time": "2014-12-01T10:03:28", "url": "https://files.pythonhosted.org/packages/df/50/0d3d0ea496b4437e6ace5235d3c03e7c741eb7fb8ffeb85921f707ecd34f/sqlquerybuilder-0.0.9.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "1fa9454e092966d24cb03ddc6790cffd", "sha256": "461c2b70aa867ca81a7f61bc19884b8cb3344e5070180f97c9580d28a202f4ae" }, "downloads": -1, "filename": "sqlquerybuilder-0.0.13.tar.gz", "has_sig": false, "md5_digest": "1fa9454e092966d24cb03ddc6790cffd", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6037, "upload_time": "2016-01-08T17:55:46", "url": "https://files.pythonhosted.org/packages/1a/e4/11ad634b1cde1ffc2ba10909dd3e33439c3bd2063254bd7d9a9334929c22/sqlquerybuilder-0.0.13.tar.gz" } ] }