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

[Ralf Lang]

Am 26.02.2018 um 14:56 schrieb Carsten:
> Hi,
> 
> I have put this to the turba list, but w/o any response.
> 
> Maybe somebody on the core list has an idea?!
> 
> 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

Hi, I think you are not using turba at the right level here. There is a
json-rpc api to browse/scan turba hierarchically (entries by
addressbook), independent of addressbook source (be it default schema,
custom schema, remote, ldap, ...).

That's the place you ought to grab any data.


-- 
Ralf Lang
Linux Consultant / Developer
Tel.: +49-170-6381563
Mail: lang at b1-systems.de
B1 Systems GmbH
Osterfeldstraße 7 / 85088 Vohburg / http://www.b1-systems.de
GF: Ralph Dehner / Unternehmenssitz: Vohburg / AG: Ingolstadt,HRB 3537