[turba] How to access/insert Turba Lists (object_members) BLOB

[Alex Ng]

In general, I noticed that many of the "id's" in horde and it's applications
are in a varchar(32) type.  Was there a reason to use this as an index
rather than an int type (auto_increment) for the primary key?

Also, how is this 32 character key generated?  It resembles an MD5.

Thanks,
Alex

On 12/9/05, Kevin M. Myer <kevin_myer at iu13.org> wrote:
>
> Quoting Alex Ng <ngstylez at gmail.com>:
>
> > Ok, I think I understand it a bit.
> >
> > Example: the 'object_members' BLOB:
> >
> a:3:{i:0;s:32:"a2068fafcccc86517e0d77ee408af650";i:1;s:32:"41d6d558ffc9214c6db6dc41912460e2";i:2;s:32:"3874fff53e7948c71d12d57cd92bfc65";}
> >
> > This is a Turba List containing 3 contacts.
> >
> > This format is:
> > a:3:
> > .....array:<number of contacts within the list>:
> > {i:0;
> > .....{index: <index#>;
> > s:32:
> > .....Don't know what this is, and why it's 32
> > "a2068fafcccc86517e0d77ee408af650";
> > .....The object_id of a turba_object (object_type = Object)
> >
> > Anyone know what the "s:32" is?  Please correct me if I'm wrong with the
> > formatting structure.
>
> string:32 - the object_id.  The BLOB is a serialized array, pretty much
> as you described.  Use serialize/unserialize to work with the data.  In
> Turba 2.0.X, it will be an array of object_ids.  In Turba 2.1.X, it
> will be in the form of arrays, with the keys being the address book
> source, and the values being the object_ids.
>
> Kevin
>
> --
> Kevin M. Myer
> Senior Systems Administrator
> Lancaster-Lebanon Intermediate Unit 13  http://www.iu13.org
>
>
> --
> Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: turba-unsubscribe at lists.horde.org
>