[Owncloud] Database access for apps.

[Côme BERNIGAUD]

I wrote a little something that can be used for a start.
It's pushed on the git, the file is "lib/db4app.php".
I also did the test_db app that shows how to use this lib.

Please share any remarks about this.

It can at least be a temporary solution in order to avoid SQL code in apps.

PS: I got some trouble with serialize + OC_DB::escape function, I had to 
add a base64_encode thing, it works but it takes some space.

Le 26/08/2011 19:15, Frank Karlitschek a écrit :
> I agree.
> We should provide a clean API, including one for database access, for our Apps.
>
> Cheers
> Frank
>
> On 26.08.2011, at 18:56, Côme BERNIGAUD wrote:
>
>> I think owncloud should provide an API for accessing databases in the apps code.
>> Apps code should not contain any SQL code.
>> An app should be able to easily store and retrieve information linked to the current user.
>> "I, docsapp, want to save that the connected user have this object with this properties"
>>
>> Basically the app should be able to do something like objectid = OC_Database::store(userid,id) (the object would be serialized to be inserted in the database)
>> And then OC_Database::get_object(objectid) and OC_Database::get_objectsids(userid)
>> Maybe all these should takes as first parameter the name of the app. (so that it use a separate base/table for each app)
>>
>> This should preferably work both from PHP and Javascript.
>>
>> Côme.
>> _______________________________________________
>> Owncloud mailing list
>> Owncloud at kde.org
>> https://mail.kde.org/mailman/listinfo/owncloud
> Frank Karlitschek
> karlitschek at kde.org
>
>