Django complementary index definition and management.
Project description
Describe your database index in json files into your apps
Detailed documentation is in the “docs” directory.
Quick start
Add “json_dbindex” to your INSTALLED_APPS setting like this:
INSTALLED_APPS = ( ... 'json_dbindex', )
Run python manage.py list_jsindex to list all defined indexes.
Create indexes
Create a file in you app directory called dbindex_create.json with following contents
- [{“name”: “django_site_composite_idx”},
“table”: “django_site”, “column”: [“domain”,”name”], “predicat”: “WHERE id > 1000”, “using”: “btree”, “database”: “default”, “unique”: yes}]
Trying to create an existing index will not generate an error, only a logging at level notice will be raised.
Drop indexes
Create a file in you app directory called dbindex_drop.json with following contents.
- [{“name”: “django_site_composite_idx”},
{“name”: “django_site_domain_idx”}]
Only the name is required. In the above example two indexes will be dropped. Trying to drop a non existing index will not generate an error, only a logging at level notice will be raised.
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
Hashes for django-json-dbindex-1.0.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | fe282ee7753ce9fbcbc8b105c9a9faaa1c352a638e40d27063fde23ffe4a4e4f |
|
MD5 | c03fe12f019700b91b67b43e78316ee2 |
|
BLAKE2b-256 | 924bbb72a72083932f79e54b6570628c2c51954332dd3a8187dba4b96a41454e |