| From: | "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com> |
|---|---|
| To: | psycopg(at)postgresql(dot)org |
| Subject: | Re: little_pger.py (a thin layer a tad above SQL and psycopg2) |
| Date: | 2012-12-19 16:56:35 |
| Message-ID: | 22582753-B809-47DC-8754-6958C519AB29@themactionfaction.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | psycopg |
On Dec 19, 2012, at 11:53 AM, Rory Campbell-Lange wrote:
> On 19/12/12, A.M. (agentm(at)themactionfaction(dot)com) wrote:
>> ...I, too, have been looking for something lightweight and quick which
>> would allow nearly-automatic JSON generation from database rows. The
>> trickier part is recursing a model attribute tree which always leads
>> me back to SQLAlchemy.
>
> Since psycopg can return namedtuples and simplejson serialises
> namedtuples, this should not be a difficult thing to do.
That doesn't help when there are columns or subselects which need to become part of a one-to-many or many-to-many relationship represented as arrays attached to the main model in JSON. That is what I meant by "recursing the model attribute tree".
Cheers,
M
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rory Campbell-Lange | 2012-12-19 17:12:16 | Re: little_pger.py (a thin layer a tad above SQL and psycopg2) |
| Previous Message | Rory Campbell-Lange | 2012-12-19 16:53:18 | Re: little_pger.py (a thin layer a tad above SQL and psycopg2) |