Create a queryable data source from an existing database.
Project description
Django Rest Framework Discovery
Summary
Discovery allows you to create an API from an existing database with minimal effort. This project is based on Shabda Raaj's Bookrest. You can also leverage the capabilties of the Django Rest Framework to apply filtering, pagination and documentation generation. Examples can be found in the examples
directory.
Problem Statement
The data is not always accessible in legacy applications. You might be in a situation where you need access to the data for reporting or prototyping new tools. Adding new functionality to legacy software can be cost prohibitive and this solution aims to work-around this issue.
Requirements
For successful schema generation, you need to have a primary key present in the table. Otherwise, it will be silently ignored.
Installation
pip install djangorestframework-discovery
In your settings.py
:
INSTALLED_APPS = [
# ...
"rest_framework",
"rest_framework_discovery",
]
Add a variable to your settings.py
named DISCOVERY_ALIAS_NAME
. You can use any value, but discovery
is recommended. You will use that to define the database you would like to use for viewset generation.
DISCOVERY_ALIAS_NAME = 'discovery'
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.sqlite3',
'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
},
'discovery': {
'NAME': 'YOUR_DB_NAME',
'ENGINE': 'django.db.backends.postgresql',
'USER': 'YOUR_DB_USER',
'PASSWORD': 'YOUR_DB_PASSWORD',
'HOST': 'YOUR_DB_HOST',
'PORT': 'YOUR_DB_PORT',
},
}
Add the generated patterns to the rest of your application by modifying the urls.py
.
urlpatterns = [
# ...
url(r'^api/discovery/', include('rest_framework_discovery.urls')),
]
You will also need to include DEFAULT_SCHEMA_CLASS
explicitly in settings.py
to get this to work. See additional details..
REST_FRAMEWORK = {
...
'DEFAULT_SCHEMA_CLASS': 'rest_framework.schemas.coreapi.AutoSchema'
}
Testing
You can run through the testing suite by running runtests.py
or tox
.
Configuration
You can configure the following in settings.py
:
DISCOVERY_ALIAS_NAME
: (required) The database alias name to use with discovery.DISCOVERY_READ_ONLY
: (optional)True
orFalse
, whether or not the viewsets should be read-only.DISCOVERY_INCLUDE
: (optional) A list of tables that you would like to only include.DISCOVERY_EXCLUDE
: (optional) A list of tables that you would like to ignore.
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
Built Distribution
Hashes for djangorestframework-discovery-0.1.8.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 87961156c1fff0ebc1a7a53155bf0093b053b9b0a0623df11e719e65a469905a |
|
MD5 | 74fcf054531a5e2e184b9acaa32aee5a |
|
BLAKE2b-256 | e3ca76c63f900ff127022d17722d180a3ecc16b218ace6a84259ce1548ee1e75 |
Hashes for djangorestframework_discovery-0.1.8-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7c9ee614a6b66d261b0f0bccdacda56e4e94cad0e2a5992bf502ebb62f84dd37 |
|
MD5 | 9417c56e583ed593a6e0eff78767486d |
|
BLAKE2b-256 | f618677f3f4787bfdbdc5c05e912903312f37bbdeeab99451409682f34b121c3 |