How do I setup sandman for read-only access?

[fccoelho]

Could you post in the readme an example for that? I think this is a very common use case...

[jmcarp]

I encountered the same issue and wrote up a patch that simplifies the read-only use case by allowing a custom base model. The code is in #13, and it can be used like this:

from sandman2 import model, get_app
from sqlalchemy.ext.automap import automap_base

class Base(model.Model, model.db.Model):
    __abstract__ = True
    __methods__ = {'GET'}
AutomapModel = automap_base(cls=Base)
app = get_app(database_uri, Base=AutomapModel)
app.run()

[jeffknupp]

The tests have a simple example of this. From tests/automap_models.py:

from sandman2 import AutomapModel


class User(AutomapModel):

    """A user of the blogging application."""

    __tablename__ = 'user'

    def __unicode__(self):
        return self.name


class Blog(AutomapModel):

    """An online weblog."""

    __tablename__ = 'blog'

    def __unicode__(self):
        return self.name

class Post(AutomapModel):

    """An individual blog post."""

    __tablename__ = 'post'

    def __unicode__(self):
        return self.title

Then simply override the __methods__ property to only support GET:
__methods__ = {'GET'}

Will add to docs.