Skip to main content
Help the Python Software Foundation raise $60,000 USD by December 31st!  Building the PSF Q4 Fundraiser

API Star tools to create CRUD resources.

Project description

API Star CRUD

Build Status codecov PyPI version

  • Version: 0.6.0
  • Status: Production/Stable
  • Author: José Antonio Perdiguero López

Features

API Star CRUD provides an easy way to define a REST resource and generic operations over it.

Resource

The resources are classes with a default implementation for methods:

  • create: Create a new element for this resource.
  • retrieve: Retrieve an element of this resource.
  • update: Update (partially or fully) an element of this resource.
  • delete: Delete an element of this resource.
  • list: List resource collection with filtering capabilities.
  • drop: Drop resource collection.

ORM

API Star CRUD supports the following ORM:

Admin site

API Star CRUD serves an admin site to handle resources in a graphical way, by default this site is routed to /admin/.

Quick start

Install API Star CRUD:

$ pip install apistar-crud[peewee]

or

$ pip install apistar-crud[sqlalchemy]

Follow the steps:

  1. Create an input type and output type for your resource:
  2. Define a model based on your ORM.
  3. Build your resource using the metaclass specific for your ORM.
  4. Add the routes for your resources.

Usage

SQLAlchemy

Example of a fully functional resource based on SQLAlchemy.

Create an input type and output type:

class PuppyInputType(types.Type):
    name = validators.String()

class PuppyOutputType(types.Type):
    id = validators.Integer()
    name = validators.String()

Define a model:

class PuppyModel(Base):
    __tablename__ = "Puppy"

    id = Column(Integer, primary_key=True)
    name = Column(String)

The resource:

from apistar_crud.resource.sqlalchemy import Resource

class PuppyResource(metaclass=Resource):
    name = "puppy"
    verbose_name = "Puppy"
    
    model = PuppyModel
    input_type = PuppyInputType
    output_type = PuppyOutputType
    methods = ("create", "retrieve", "update", "delete", "list", "drop")

The resource generates his own routes:

from apistar import App
from apistar_crud.routes import routes as resource_routes

resource_routes.register(PuppyResource, "/puppy/", admin=True)

routes = [
    # ... your app routes
]

routes += resource_routes.routes(admin="/admin/")
packages = ("apistar", "apistar_crud")
app = App(routes=routes, packages=packages)

Peewee

Example of a fully functional resource based on Peewee.

Create an input type and output type:

class PuppyInputType(types.Type):
    name = validators.String()

class PuppyOutputType(types.Type):
    id = validators.Integer()
    name = validators.String()

Define a model:

class PuppyModel(peewee.Model):
    name = peewee.CharField()

The resource:

from apistar_crud.resource.peewee import Resource

class PuppyResource(metaclass=Resource):
    name = "puppy"
    verbose_name = "Puppy"
    
    model = PuppyModel
    input_type = PuppyInputType
    output_type = PuppyOutputType
    methods = ("create", "retrieve", "update", "delete", "list", "drop")

The resource generates his own routes:

from apistar import App
from apistar_crud.routes import routes as resource_routes

resource_routes.register(PuppyResource, "/puppy/", admin=True)

routes = [
    # ... your app routes
]

routes += resource_routes.routes(admin="/admin/")
packages = ("apistar", "apistar_crud")
app = App(routes=routes, packages=packages)

Resources

Routes

The routes for resource methods are:

Method Verb URL
create POST /
retrieve GET /{element_id}/
update PUT /{element_id}/
delete DELETE /{element_id}/
list GET /
drop DELETE /

Override methods

To customize CRUD methods you can override them like:

from apistar_crud.resource.peewee import Resource

class PuppyResource(metaclass=Resource):
    name = "puppy"
    verbose_name = "Puppy"
    
    model = PuppyModel
    input_type = PuppyInputType
    output_type = PuppyOutputType
    methods = ("create", "retrieve", "update", "delete", "list", "drop")
    
    @classmethod
    def create(cls, element: PuppyInputType) -> PuppyOutputType:
        # Do your custom process

Filtering

Default list implementation has filtering capabilities but to reflect it in the schema is necessary to override that method defining all the parameters that will be used as a filter and pass it as keywords to _list() method.

It is a direct translation to ORM keyword arguments so in case of SQLAlchemy it uses a filter_by() method and a where() in Peewee case.

import typing

from apistar import http
from apistar_crud.resource.peewee import Resource
from apistar_pagination import PageNumberResponse

class PuppyResource(metaclass=Resource):
    name = "puppy"
    verbose_name = "Puppy"
    
    model = PuppyModel
    input_type = PuppyInputType
    output_type = PuppyOutputType
    methods = ("create", "retrieve", "update", "delete", "list", "drop")
    
    @classmethod
    def list(cls, name: http.QueryParam, page: http.QueryParam=None, page_size: http.QueryParam=None) -> typing.List[PuppyOutputType]:
        return PageNumberResponse(page=page, page_size=page_size, content=cls._filter(name=name))

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for apistar-crud, version 0.6.0
Filename, size File type Python version Upload date Hashes
Filename, size apistar_crud-0.6.0-py3-none-any.whl (14.4 MB) File type Wheel Python version py3 Upload date Hashes View
Filename, size apistar-crud-0.6.0.tar.gz (2.2 MB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page