Django application that provider the like and ilike lookups for the querysets
Project description
django-like
Information
django-like is a Django application that adds other useful fields.
It is distributed under the terms of the GNU Lesser General Public License <http://www.gnu.org/licenses/lgpl.html>
Requeriments
Django (>=1.1). It’s possible that works with other versions lower 1.1
Installation
In your settings.py
INSTALLED_APPS = ( 'django_like', )
- Or apply some of the next patches (This is not neccesary, you can only install the app):
Usage
Something that you can to do with like sentence
MyModel.objects.filter(field_name__like='xx%YY%zz') MyModel.objects.filter(field_name__ilike='xx%yy%zz') User.objects.filter(username__like='a%in')
It is more quick and more readable that something like this:
MyModel.objects.filter(field_name__regex='^xx.*YY.*zz$')
This app provider two new lookups: like and ilike.
Now you can compare the time it takes to run the same query, many times, with like and with regex
python manage.py benchmark_like
These are a results executing the benchmark_like in my machine:
Type & result \ Database |
postgres |
mysql |
sqllite |
oracle |
---|---|---|---|---|
like |
0:00:50.727005 |
0:00:14.025656 |
0:01:36.089407 |
?:??:??.?????? |
regex |
0:01:38.410019 |
0:02:57.255685 |
0:09:39.527765 |
?:??:??.?????? |
Improvement |
254% |
600% |
503% |
???% |
Reported
Development
You can get the bleeding edge version of django-like by doing a clone of its repository
git clone git://github.com/goinnn/django-like.git
Example project
In the source tree, you will find a directory called example. It contains a readily setup project that uses django-like. You can run it as usual:
python manage.py syncdb --noinput python manage.py runserver
0.1.0 (2013-12-20)
Added example project
Added tests (for SQLite, MySQL and PostgreSQL)
Integrated with travis and coverals
Python2.6 compatible (benchmark_like)
Added patche to Django 1.6
0.0.7 (2013-09-11)
Add licese file
0.0.6 (2013-09-10)
Fix README typo
0.0.5 (2013-08-14)
Fix README typo
0.0.4 (2013-08-14)
Improve the README
Fix a littles bugs
Python3 compatible
Django 1.5 compatible
- Thanks to:
0.0.3 (2012-02-14)
Fix a broken link in the readme
0.0.2 (2012-02-13)
Add benchmark command
0.0.1 (2011-12-28)
First version to django-like
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file django-like-0.1.0.tar.gz
.
File metadata
- Download URL: django-like-0.1.0.tar.gz
- Upload date:
- Size: 7.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 65b82ae9030196b1c4eec42f6e7fffee3b7b202fc8de1f8f57ba6be60d379729 |
|
MD5 | aa9345d2ff9f11a08d7cea2632b7b9af |
|
BLAKE2b-256 | 9f3ade9a0b0964e3f3031cf7cc49b5ef0c20526f75ab85591394fd0ca07dcb96 |