Django + SQLAlchemy + RESTful API (tastypie?)

Question

I am currently using Django with SQLAlchemy, and would like to implement an (simple to begin with) API for mobile devices.

Am evaluating at different python RESTful API frameworks, particularly tastypie and piston.

Can someone please point me to the right direction re: using either modules to bind resources to SQLAlchemy?

Alternatively, any other frameworks that'd work better with Django+SQLAlchemy?

Thanks guys.

Tastypie all the way. Piston was once the best but development is pretty much dead. — Chris Pratt, Feb 08 '12 at 15:26
@Chris: does it work with sqlalchemy? I cannot seem to find any example online for Django+SQLAlchemy+Tastypie — jho, Feb 08 '12 at 15:47

score 3 · Answer 1 · answered Feb 15 '12 at 12:50

3

You might want to take a look at the following page in the tastypie documentation:

http://django-tastypie.readthedocs.org/en/latest/non_orm_data_sources.html

Specifically, the riak example seems good and the kind of thing that you need to implement.

answered Feb 15 '12 at 12:50

Dominic Santos

1,900
12
14

score 2 · Answer 2 · answered Jul 16 '12 at 15:55

Tastypie does work with SQLAlchemy.

Check out tastyalchemy @ github - it is a good start for how to build a SQLAlchemyResource for Tastypie. Using it, you can create a resource for an SQLAlchemy ORM class like:

class MyORMResource(SQLAlchemyResource):
    class Meta:
        resource_name = 'myorm'
        object_class = MySQLAlchemyORMClass
        allowed_methods = ['get', 'post', 'put', 'delete']

I found I needed to implement SQLAlchemyResource.post_detail() to get the updating to work, and I handle my sessions differently so I had to change a few things, but if you don't mind reading through tastypie's resource.py it is pretty easy to get up and running. Foreign keys work too, although haven't found a way to get a One to Many relationship to work yet.

Django + SQLAlchemy + RESTful API (tastypie?)

2 Answers2