Skip to main content

Django lookup extensions use NOT query.

Project description

Django lookup extensions

https://travis-ci.org/uncovertruth/django-lookup-extensions.svg?branch=master https://api.codacy.com/project/badge/Grade/d5a64517be0d49b6bf2f41c11df77730 https://codebeat.co/badges/20da13a3-e873-412a-89b1-1a02bba47a23 https://www.codefactor.io/repository/github/uncovertruth/django-lookup-extensions/badge https://codecov.io/gh/uncovertruth/django-lookup-extensions/branch/master/graph/badge.svg Documentation Status Updates Python 3 https://img.shields.io/pypi/v/django-lookup-extensions.svg

Django lookup extensions use NOT query.

Installation

To install Django lookup extensions, run this command in your terminal:

$ pip install django-lookup-extensions

This is the preferred method to install Django lookup extensions, as it will always install the most recent stable release.

If you don’t have pip installed, this Python installation guide can guide you through the process.

Usage

Setup

Add ‘lookup_extensions’ to your INSTALLED_APPS setting.:

INSTALLED_APPS = [
    ...
    'lookup_extensions',
    ...
]

AppConfig.ready imports lookups and register them using django.db.models.fields.Field.register_lookup.

Making queries

Use lookup like Django standard lookups.

ModelA.objects.filter(name__neexact='test name')

Supported lookup types

Negaetes

neexact is negate exact, neiexact is negate iexact, others are similar.

  • neexact

  • neiexact

  • necontains

  • neicontains

  • nestartswith

  • neendswith

  • neistartswith

  • neiendswith

  • neregex

  • neiregex

Complement

  • complement

Extra regexes

These regex lookups support metacharacters \d, \D, w, \W, \s, \S.

MySQL, PostgreSQL and Redshift also support \<, \>.

Prefix follows the previous section.

  • exregex

  • exiregex

  • neexregex

  • neexiregex

Supported vendor types

  • MySQL

  • PostgreSQL

  • sqlite

    • lookups using LIKE aren’t case sensitive.

      • necontains

      • nestartswith

      • neendswith

  • Redshift

Credits

This package was created with Cookiecutter and the audreyr/cookiecutter-pypackage project template.

History

0.2.1

  • Support related complement lookups

0.2.0

  • Add support for Django 2.1

  • Add support for Python 3.7

  • Migrate to complement from exists and neexists

0.1.0

  • Migrate installation to backend settings

  • Support exists and neexists lookups

0.0.1 - 0.0.2

  • Support extra regex lookups

  • Support negaete lookups

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

django-lookup-extensions-0.2.1.tar.gz (19.9 kB view details)

Uploaded Source

Built Distribution

django_lookup_extensions-0.2.1-py2.py3-none-any.whl (20.0 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file django-lookup-extensions-0.2.1.tar.gz.

File metadata

  • Download URL: django-lookup-extensions-0.2.1.tar.gz
  • Upload date:
  • Size: 19.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.11.0 pkginfo/1.4.2 requests/2.19.1 setuptools/40.0.0 requests-toolbelt/0.8.0 tqdm/4.24.0 CPython/3.7.0

File hashes

Hashes for django-lookup-extensions-0.2.1.tar.gz
Algorithm Hash digest
SHA256 978c5f045c3313e2cba58fd945b1d43d4c071f6d4a8e81f26b3265a62998c0a4
MD5 972f1f6c0599df263f981447b1a3b66b
BLAKE2b-256 ea519f2397d82e1694444beee76b034c68933d063aba140e6a8119c34f62abfc

See more details on using hashes here.

File details

Details for the file django_lookup_extensions-0.2.1-py2.py3-none-any.whl.

File metadata

  • Download URL: django_lookup_extensions-0.2.1-py2.py3-none-any.whl
  • Upload date:
  • Size: 20.0 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.11.0 pkginfo/1.4.2 requests/2.19.1 setuptools/40.0.0 requests-toolbelt/0.8.0 tqdm/4.24.0 CPython/3.7.0

File hashes

Hashes for django_lookup_extensions-0.2.1-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 5818cf78a6579483939b16acb73982cd0ff5e1b82db01d7cf02481fd59d84719
MD5 b918aaa3dfeeaa7e094bba75904ec92f
BLAKE2b-256 e77c1617ef7336b9e5b1db71766bfb8fc8ae186da0c8cb92c85a6dd3b9a62bf3

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page