Database Access Layer (Not to be confused with database abstraction layer)

[David Freedman]

In one of my web2py apps, I’ve got a dynamic database calls sprinkled
throughout my controllers. While I don’t yet want to factor database
access out into a restful api, I do want to factor it out into a resource
design of a similar style even though it will use native python objects
rather than HTTP/JSON. Looking for any specific recommendations for
database access layer code organization? Should I just create a module of
CRUD methods that are invoked from controllers?
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/d/optout.

[Massimo Di Pierro]

If you use the latest web2py there is this code on
welcome/controllers/default.py

@auth.requires_login()
def api():
"""

this is example of API with access control

WEB2PY provides Hypermedia API (Collection+JSON) Experimental

"""
from gluon.contrib.hypermedia import Collection
rules = {
'<tablename>': {'GET':{},'POST':{},'PUT':{},'DELETE':{}},
}
return Collection(db).process(request,response,rules)

I guess you can copy and modify the file gluon.contrib.hypermedia to return
pickle instead of json.
I am not sure I answered the question.

Post by David Freedman
In one of my web2py apps, I’ve got a dynamic database calls sprinkled
throughout my controllers. While I don’t yet want to factor database
access out into a restful api, I do want to factor it out into a resource
design of a similar style even though it will use native python objects
rather than HTTP/JSON. Looking for any specific recommendations for
database access layer code organization? Should I just create a module of
CRUD methods that are invoked from controllers?

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/***@public.gmane.org
For more options, visit https://groups.google.com/d/optout.