Simple CRUD REST API for Active Objects tables...?

[JamieA]

Is there any way of quickly producing a CRUD REST API for some active objects tables?

For example, in grails, there is some plugin you can add that will give you create / get / delete rest apis for all your domain objects. Is there something similar available for atlassian AO?

Or must I hand-roll it all...?

[JamieA]

Lovingly hand-rolled.

[francis]

Jamie, Did you ever found a solution or did you hand-rolled it ? Francis

[Remigiusz Jackowski]

Active Objects usage in plugins is limited to tables created by the same plugin. You could create plugin to store / retreive some data in JIRA's database, but it would still have some limitations

1. Table's scheme must be knows while compliling plugin - you can't have data structures made in run-time.
2. You could store structure as serialized text, but it can't be BLOB, so it will use a lot of space.

So plugin can't help you much.

Why don't you bypass JIRA and connect to your DB directly?

[Andy Brook [Plugin People]]

Not quite, the question was for easy exposure of stored AO data via REST or similar from within a plugin. the AO storage model works quite well, but falls over (IMO) as there isnt an braindead simple way to expose that information struture through REST. Reference to 'rolling your own' was writing the necessary serialization/deserialization so that REST services can front AO storage.

The key advantage of using AO over direct DB is that the plugin developer (and therefore customer) do not have to manage plugin-specific database backups and restore. Connecting to the database has always been possible, but has that significant drawback, and of course, puts the onus on the developer to support lots of different databases (with various db-specific issues included).

[JamieA]

What Andy said.