django-query-builder


Namedjango-query-builder JSON
Version 3.2.0 PyPI version JSON
download
home_pagehttps://github.com/ambitioninc/django-query-builder
SummaryBuild complex nested queries
upload_time2023-08-29 20:58:44
maintainer
docs_urlNone
authorWes Okes
requires_python
licenseMIT
keywords django database query sql postgres upsert
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage
            .. image:: https://travis-ci.org/ambitioninc/django-query-builder.png
   :target: https://travis-ci.org/ambitioninc/django-query-builder

.. image:: https://coveralls.io/repos/ambitioninc/django-query-builder/badge.png?branch=develop
    :target: https://coveralls.io/r/ambitioninc/django-query-builder?branch=develop

.. image:: https://pypip.in/v/django-query-builder/badge.png
    :target: https://crate.io/packages/django-query-builder/
    :alt: Latest PyPI version

.. image:: https://pypip.in/d/django-query-builder/badge.png
    :target: https://crate.io/packages/django-query-builder/

django-query-builder
====================
querybuilder is a django library for assisting with the construction and
execution of sql. This is not meant to replace django querysets; it is meant
for managing complex queries and helping perform database operations that
django doesn't handle.

Why use querybuilder?
---------------------
The django querybuilder allows you to control all parts of the query
construction. This is happens more clearly because the function calls more
closely represent the actual sql keywords.

Why not just use django's .raw() function?
------------------------------------------
While the raw function lets you execute custom sql, it doesn't provide any way
for the developer to build the query dynamically. Users lacking experience
writing "raw" sql should avoid using querybuilder and stick with django's
querysets. The querybuilder's query construction closely mirrors writing sql,
where django querysets simplify the sql generation process for simple queries.

Requirements
------------
* Python 3.7 - 3.9
* Django 2.2 - 4.1
* Postgres 9.3+

Installation
------------
To install the latest release, type::

    pip install django-query-builder

To install the latest code directly from source, type::

    pip install git+git://github.com/ambitioninc/django-query-builder.git

Documentation
-------------

Full documentation is available at http://django-query-builder.readthedocs.org

License
-------
MIT License (see LICENSE)

            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/ambitioninc/django-query-builder",
    "name": "django-query-builder",
    "maintainer": "",
    "docs_url": null,
    "requires_python": "",
    "maintainer_email": "",
    "keywords": "django,database,query,sql,postgres,upsert",
    "author": "Wes Okes",
    "author_email": "wes.okes@gmail.com",
    "download_url": "https://files.pythonhosted.org/packages/a6/0d/42dfd9ac19ba98dfe2487b0bcec26f21412bc0fcb1f4efe0ecb7daf63ea7/django-query-builder-3.2.0.tar.gz",
    "platform": null,
    "description": ".. image:: https://travis-ci.org/ambitioninc/django-query-builder.png\n   :target: https://travis-ci.org/ambitioninc/django-query-builder\n\n.. image:: https://coveralls.io/repos/ambitioninc/django-query-builder/badge.png?branch=develop\n    :target: https://coveralls.io/r/ambitioninc/django-query-builder?branch=develop\n\n.. image:: https://pypip.in/v/django-query-builder/badge.png\n    :target: https://crate.io/packages/django-query-builder/\n    :alt: Latest PyPI version\n\n.. image:: https://pypip.in/d/django-query-builder/badge.png\n    :target: https://crate.io/packages/django-query-builder/\n\ndjango-query-builder\n====================\nquerybuilder is a django library for assisting with the construction and\nexecution of sql. This is not meant to replace django querysets; it is meant\nfor managing complex queries and helping perform database operations that\ndjango doesn't handle.\n\nWhy use querybuilder?\n---------------------\nThe django querybuilder allows you to control all parts of the query\nconstruction. This is happens more clearly because the function calls more\nclosely represent the actual sql keywords.\n\nWhy not just use django's .raw() function?\n------------------------------------------\nWhile the raw function lets you execute custom sql, it doesn't provide any way\nfor the developer to build the query dynamically. Users lacking experience\nwriting \"raw\" sql should avoid using querybuilder and stick with django's\nquerysets. The querybuilder's query construction closely mirrors writing sql,\nwhere django querysets simplify the sql generation process for simple queries.\n\nRequirements\n------------\n* Python 3.7 - 3.9\n* Django 2.2 - 4.1\n* Postgres 9.3+\n\nInstallation\n------------\nTo install the latest release, type::\n\n    pip install django-query-builder\n\nTo install the latest code directly from source, type::\n\n    pip install git+git://github.com/ambitioninc/django-query-builder.git\n\nDocumentation\n-------------\n\nFull documentation is available at http://django-query-builder.readthedocs.org\n\nLicense\n-------\nMIT License (see LICENSE)\n",
    "bugtrack_url": null,
    "license": "MIT",
    "summary": "Build complex nested queries",
    "version": "3.2.0",
    "project_urls": {
        "Homepage": "https://github.com/ambitioninc/django-query-builder"
    },
    "split_keywords": [
        "django",
        "database",
        "query",
        "sql",
        "postgres",
        "upsert"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "670a40c91a58906c7fb87733e8f623052fcd2a8ae6d92cdb2501b1c34b4380a2",
                "md5": "af1076a127eecc37931dfd020e70b8e3",
                "sha256": "560ee939533b9e2cdd707a13a9cb79e34599d8455405934d27233532889c8abf"
            },
            "downloads": -1,
            "filename": "django_query_builder-3.2.0-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "af1076a127eecc37931dfd020e70b8e3",
            "packagetype": "bdist_wheel",
            "python_version": "py2.py3",
            "requires_python": null,
            "size": 57010,
            "upload_time": "2023-08-29T20:58:42",
            "upload_time_iso_8601": "2023-08-29T20:58:42.880497Z",
            "url": "https://files.pythonhosted.org/packages/67/0a/40c91a58906c7fb87733e8f623052fcd2a8ae6d92cdb2501b1c34b4380a2/django_query_builder-3.2.0-py2.py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "a60d42dfd9ac19ba98dfe2487b0bcec26f21412bc0fcb1f4efe0ecb7daf63ea7",
                "md5": "4eb24e13f6e803e43f74101abb135e74",
                "sha256": "e22228cb66305a08b2763a46c028b14c6627e7b31d536c7dd8a1c37c1a1c8c70"
            },
            "downloads": -1,
            "filename": "django-query-builder-3.2.0.tar.gz",
            "has_sig": false,
            "md5_digest": "4eb24e13f6e803e43f74101abb135e74",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 49965,
            "upload_time": "2023-08-29T20:58:44",
            "upload_time_iso_8601": "2023-08-29T20:58:44.639463Z",
            "url": "https://files.pythonhosted.org/packages/a6/0d/42dfd9ac19ba98dfe2487b0bcec26f21412bc0fcb1f4efe0ecb7daf63ea7/django-query-builder-3.2.0.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2023-08-29 20:58:44",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "ambitioninc",
    "github_project": "django-query-builder",
    "travis_ci": false,
    "coveralls": true,
    "github_actions": true,
    "lcname": "django-query-builder"
}
        
Elapsed time: 0.11102s