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

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

  • neexact

  • neiexact

  • necontains

  • neicontains

  • nestartswith

  • neendswith

  • neistartswith

  • neiendswith

  • neregex

  • neiregex

Extra regex lookup types

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

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.0.2.tar.gz (13.2 kB view details)

Uploaded Source

Built Distribution

django_lookup_extensions-0.0.2-py2.py3-none-any.whl (15.5 kB view details)

Uploaded Python 2 Python 3

File details

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

File metadata

File hashes

Hashes for django-lookup-extensions-0.0.2.tar.gz
Algorithm Hash digest
SHA256 2c3b649647cc5ad34c1ae2fb66d0d335de5a26626162efa15a2edf320a116095
MD5 3ecdd0776b971598a52e12d8144d5099
BLAKE2b-256 21f61f509f94c4ad8c01676ee77661b6440200e8a97bf8bfaa8af148e2f2fc11

See more details on using hashes here.

File details

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

File metadata

File hashes

Hashes for django_lookup_extensions-0.0.2-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 22aef7eb5b3bd9e35b0b62bf4f0f149da17c8b5c4b42d11742d83d543e58b6bf
MD5 bf7ca2738ab4d296207ba5e73654b072
BLAKE2b-256 e7addfe4ac1173a0a9c86f3df31940bbe4bb9cc313ac2760dc3ca79bffe3a3e9

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