Re: [Tracker] Cleanup of sqlite files

[Mikkel Kamstrup Erlandsen <mikkel kamstrup gmail com>]

On Thu, 2006-10-05 at 04:13 +0200, Laurent Aguerreche wrote:
> Le jeudi 05 octobre 2006 Ã 00:50 +0200, Laurent Aguerreche a Ãcrit :
> > Le mercredi 04 octobre 2006 Ã 23:39 +0100, Jamie McCracken a Ãcrit :
> > > Jamie McCracken wrote:
> > > > Jamie McCracken wrote:
> > > > > Laurent Aguerreche wrote:
> > > > > > Le mercredi 04 octobre 2006 Ã 20:38 +0100, Jamie McCracken a Ãcrit :
> > > > > > > Laurent Aguerreche wrote:
> > > > > > > > Hello,
> > > > > > > >
> > > > > > > > I propose a patch to cleanup sqlite files.
> > > > > > > > It also explicitly set SQlite databases to UTF-8 and replace a bad
> > > > > > > > g_free() to g_slice_free() in tracker_db_get_field_def().
> > > > > > > thanks have applied to cvs
> > > > > > >
> > > > > > > (please refrain from big code cleanups until after I have made the 
> > > > > > > release next week - just in case bugs/leaks get introduced)
> > > > > > Ok. :-)
> > > > > >
> > > > > > > Have you got anywhere with the Evolution and Thunderbird URI formats?
> > > > > > >
> > > > > > > We need these before I can save the emails in the database 
> > > > > > > (otherwise the output data from tracker-search and rdf query will be 
> > > > > > > meaningless to end users)
> > > > > > I didn't do anything on that!
> > > > > >
> > > > > > Where did you find this line: evolution email:///inbox/blah;uid=10  ?
> > > > > > I read evolution's manpage and --help in with command line but I didn't
> > > > > > find anything useful. So I am currently unable to open evolution on a
> > > > > > precise email.
> > > >
> > > > also found this :
> > > >
> > > > http://lists.ximian.com/pipermail/evolution-hackers/2005-February/005162.html 
> > > >
> > > >
> > > > make sure to convert udi from hex to decimal for the uid
> > > >
> > > > the following works on my machine:
> > > >
> > > > evolution "email://local local/Inbox;uid=9874"
> > > >
> > > > where uid = 2692 in hex in the inbox file.
> > >
> > > for thunderbird found this in beagle:
> > >
> > > uri = new Uri (String.Format ("email:///{0};id={1}", message.Path, 
> > > message.Id));
> >
> >
> > Thanks.
> > I've been able to open a evolution's mail so I think it will be
> > okay.  :-)
>
> I propose a patch that works for Evolution.
> For Thunderbird, I can't currently figure out what "ID" in uris is...
> I'm investigating.
> For KMail it seems there isn't anything to open it on a precise mail.
>
> This patch also fix a wrong service name in trackerd.c and some mistakes
> to get mail attachment names.

You can run beagle with "beagle-query --verbose --type MailMessage
<query>" and then look at the "Uri" field of a few Thunderbird hits...
Analyzing stuff like this was how I got beagle integration in deskbar.

Anyways, good luck!

Cheers,
Mikkel