Hi Piotr, Usually you speak to any SQL database using SQLAlchemy which also offers robust reflection capabilities. However there is usually some manual integration work to map things between JSON and SQL as due do differences in data formats there is no automatic 1:1 solutions.
For Pyramid + REST services Cornice is one of the more mature solutions out there https://pypi.python.org/pypi/cornice Also check out pyramid_swagger https://github.com/striglia/pyramid_swagger - as a bonus you get the documentation tool and standard. Another potential (Flask-based) project is Python EVE which offers it own configuration language to expose MongoDB and SQL databases to web: http://python-eve.org/ Cheers, Mikko On 24 August 2016 at 16:28, Piotr Dobrogost < p...@2016.groups.google.dobrogost.net> wrote: > Hi! > > I'm looking for a project based on Pyramid which would automatically > (based on db reflection) give JSON API to Oracle database allowing for > selecting, adding, updating and removing data. > > Thank you in advance. > > Regards, > Piotr > > -- > You received this message because you are subscribed to the Google Groups > "pylons-discuss" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to pylons-discuss+unsubscr...@googlegroups.com. > To post to this group, send email to pylons-discuss@googlegroups.com. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/pylons-discuss/dcc6a84d-1363-466b-83fd-3f5dffafb9c0% > 40googlegroups.com > <https://groups.google.com/d/msgid/pylons-discuss/dcc6a84d-1363-466b-83fd-3f5dffafb9c0%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Mikko Ohtamaa http://opensourcehacker.com http://twitter.com/moo9000 -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to pylons-discuss+unsubscr...@googlegroups.com. To post to this group, send email to pylons-discuss@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/CAK8RCUv_aR591ZCChHUpV_CPJ4CrtA9mz_MW6r9Bkx9O5CCN%3Dg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.