[horde] Fwd: [turba]: entity relation ship model of turba database

[Michael J Rubinsky]

Quoting Carsten <horde-groupware at familie-lahme.de>:

> Hi,
>
> I have put this to the turba list, but w/o any response.

Not unusual to wait a day or so for a response, especially on a weekend.


>
> Maybe somebody on the core list has an idea?!

If the user is to be able to have multiple address books, you MUST use  
the share system. I.e., 'use_shares' => true in $cfgSources. In that  
case, as you mention, turba_objects.owner_id is mapped to the share.  
What you are seeing when the turba_objects.owner_id is the horde  
username instead of a share_id - this is the user's original, default  
address book. The reasons for this are  
historical/backwards-compatibility/flexibility.

The database tables in Turba, and Horde in general, are not really  
designed to be accessed from outside applications. For that, you  
should be using the external API.

> br
>
> Carsten
>
>
>
> -------- Weitergeleitete Nachricht --------
> To: 	turba at lists.horde.org
> From: 	Carsten <horde-groupware at familie-lahme.de>
> Subject: 	[horde][turba]: entity relation ship model of turba database
> Message-ID: 	<7b7994a6-6e6d-8f0a-6e62-048724a6b44f at familie-lahme.de>
> Date: 	Sat, 24 Feb 2018 14:43:27 +0100
> User-Agent: 	Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101  
> Thunderbird/52.6.0
> MIME-Version: 	1.0
> Content-Type: 	text/plain; charset=utf-8; format=flowed
> Content-Transfer-Encoding: 	7bit
> Content-Language: 	en-US
>
>
>
> Hi all,
>
> I try to create queries for my Cisco phonebook to get phonebooks from
> turba.
> At the moment I struggle with the relation ship model on the turba tables.
>
> The main issue is, how to decide, whether an object is bound to a
> shareng or not.
> If I use just .share_owner, I always get the same output, regardless
> which share (phonebook) I select.
>
> If the user has more than one phonebook, there is a crypted value in
> turba_objects.owner_id, that points to turba_sharesng.share_id.
> But unless there is only one phonebook (shareng), the
> turba_shareng.share_owner is mapped.
>
> This seems somehow odd to me, if I view from ER-Model perspektive.
>
> Is there any graphical overview (Visio o.s.) in the wild, showing the
> ER-Model?
>
> br
>
> Carsten
>
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-keys
Size: 9272 bytes
Desc: PGP Public Key
URL: <https://lists.horde.org/archives/horde/attachments/20180226/37fc9ee1/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 821 bytes
Desc: PGP Digital Signature
URL: <https://lists.horde.org/archives/horde/attachments/20180226/37fc9ee1/attachment-0001.bin>