Flask-AutoCRUD 1.2.1

Automatically generate a RESTful API service for CRUD operation on database

Based on sandman2 and sqlalchemy-filters.

Automatically generate a RESTful API service for CRUD operation on database. If a list of tables or a list of sqlalchemy model is not provided, all tables are affected.

Quickstart

Install flask_autocrud using pip:

$ pip install Flask-AutoCRUD

Example usage

from flask import Flask

from flask_autocrud import AutoCrud
from flask_sqlalchemy import SQLAlchemy


app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite+pysqlite:///db.sqlite3'
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['AUTOCRUD_METADATA_ENABLED'] = True

db = SQLAlchemy(app)
AutoCrud(app, db)

app.run(debug=True)

Go to http://127.0.0.1:5000/resources and see all available resources with its endpoint. NOTE: you must set SQLALCHEMY_DATABASE_URI with your database.

If you want to see an example use with Flask-Admin see in example folder.

Filtering and Sorting

Add filters as query string parameters, they are used in AND. NOTE: At this time OR operator are not implemented.

You can use entity fields as parameter with the following placeholders:

• null value: null

• in operator: list separated by ;

• not operator: ! means: not equal, not null, not in

• like operator: % for example: %%test%, %test% or %%test. NOTE first % are not used in expression, it only indicated that value must be used with like operator.

Other parameters:

• Use fields parameter to get only the fields listes as value, separated by ;.

• Use limit and page parameters for pagination.

• Sorting is implemented with sort parameter. The value is a list of field separated by ; You can prepend - to reverse order.

• Use export parameter to export data into csv format.

• Use extended in order to fetch data of related resources.

Example requests:

http://127.0.0.1:5000/invoice?fields=BillingCountry;Total;InvoiceId&InvoiceId=!355;344&sort=-InvoiceId

http://127.0.0.1:5000/invoice?fields=Total;InvoiceId&BillingPostalCode=!null&BillingCountry=%%ermany

http://127.0.0.1:5000/invoice?fields=Total;InvoiceDate;InvoiceId;CustomerId&page=2&limit=10

Example FETCH:

curl --request FETCH \
    --url http://127.0.0.1:5000/customer \
    --header 'content-type: application/json' \
    --data '{
        "fields": [
            "Address",
            "City"
        ],
        "joins": {
            "Employee": [
                "FirstName",
                "LastName"
            ],
            "Invoice": [
                "*"
            ]
        },
        "filters": [
            {
                "model": "Customer",
                "field": "SupportRepId",
                "op": "==",
                "value": 5
            },
            {
                "model": "Invoice",
                "field": "Total",
                "op": ">",
                "value": 6
            }
        ],
        "sortBy": [
            {
                "model": "Invoice",
                "field": "Total",
                "direction": "asc"
            },
            {
                "model": "Customer",
                "field": "Address",
                "direction": "desc"
            }
        ],
        "pagination": {
            "page": 1,
            "limit": 5
        }
    }'

Configuration

1. AUTOCRUD_METADATA_ENABLED: (default: True) enable metadata endpoint for a resource

2. AUTOCRUD_METADATA_URL: (default: ‘/meta) added at the end of url resource

3. AUTOCRUD_READ_ONLY: (default: False) enable only http GET method

4. AUTOCRUD_BASE_URL: (default: ‘’) prefix url for resources

5. AUTOCRUD_RESOURCES_URL: (default: ‘/resources’) url for all available resources

6. AUTOCRUD_RESOURCES_URL_ENABLED: (default: True) enable route for resources list

7. AUTOCRUD_SUBDOMAIN: (default: None) bind autocrud endpoints to a subdomain

8. AUTOCRUD_QUERY_LIMIT_ENABLED: (default True) enable max query limit

9. AUTOCRUD_MAX_QUERY_LIMIT: (default 1000) max query limit

10. AUTOCRUD_FETCH_ENABLED: (default True) enable or disable FETCH method

License MIT