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

Michael J Rubinsky mrubinsk at horde.org
Mon Feb 26 14:50:10 UTC 2018

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  

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

The Horde Project
-------------- 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>

More information about the horde mailing list