Experiment with API, upstream only

* uses just simple queries.
* for more advanced testing it would be good to have some rest wrapper around it.
    * I was asking abellotti if they are planning python client and if not I would make one if we needed it, but the conversation was confusing for me.
I am not sure yet. **dajo** said that we should "wire api tests next to the existing ones or maybe incorporate to the existing ones". I personally don't know how we want to manage multiple possibilities of object retrieval/check. I would like to see that implemented somehow in the CRUD objects, but not sure how to do that yet.