[Kde-pim] akonadi with postgresql (patch)

[Igor Trindade Oliveira]

Well,

Nobody are working on that and we are very interested on that work :>
Volker Krause can review better, but for me look likes good.

Javier Goday <jgoday at gmail.com> wrote:

> De: Javier Goday <jgoday at gmail.com>
> Assunto: [Kde-pim] akonadi with postgresql (patch)
> Para: kde-pim at kde.org
> Data: Domingo, 7 de Junho de 2009, 12:18
> Hi,
> 
> i was trying to set akonadi working with postgresql,
> i made a patch for it (attached)
> 
> to make it work i manually change configuration in
> ~/.config/akonadi/akonadiserverrc
> and creating the database (createuser and createdb ...)
> [%General]
> Driver=QPSQL
> SizeThreshold=4096
> ExternalPayload=false
> 
> [QPSQL]
> Name=akonadi
> User=akonadi
> Password=akonadi
> Options=
> StartServer=false
> 
> list of changes :
> 1. Akonadi database description file and schema
> (kdesupport/akonadi/server/src/storage/akonadidb.xml and
> kdesupport/akonadi/server/src/storage/akonadidb.xsd)
>  - New element 'columnproperty' into column, to describe
> database type
> dependent properties
> 2. Akonadi database storage initializer
> (kdesupport/akonadi/server/src/storage/dbinitializer.cpp)
>  - When postgresql, create database relations with complete
> table name
>  - Check for database type dependent properties
> 3. Collection list handler
> (kdesupport/akonadi/server/src/handler/aklist.cpp)
>  - Get root collections (without parent) with null
> parent_id instead of 0
> 4. Entity header
> (kdesupport/akonadi/server/src/storage/entity.h)
>  - Include QSqlRecord header, to manually access recent
> inserted id when
> using postgresql
> 5. Entity xsl template (
> kdesupport/akonadi/server/src/storage/entities.xsl
> and entities-source.xsl)
>  - extractResult method: check if the value is null before
> setting it
>  - retrieveFiltered method: if using postgresql, when
> filtering by a
> reference column and null value, use 'is null' instead of '
> = 0'
>  - insert method: - add 'returning id' option when using
> postgresql to get
> the inserted id
>                
>   - not insert 0 or null references values
>                
>   - get the inserted id manually when using postgresql
> ( i
> cannot make DataStore::lastinsertid work )
> 
> i don't know if postgresql support is planned or someone is
> working on it
> i will appreciate any comments, to make sure i do not make
> any mistake
> and maybe to continue with it (allowing postgresql
> configuration too)
> 
> Thanks.
> 
> -----Anexo incorporado-----
> 
> _______________________________________________
> KDE PIM mailing list kde-pim at kde.org
> https://mail.kde.org/mailman/listinfo/kde-pim
> KDE PIM home page at http://pim.kde.org/


      Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/