Re: [Tracker] Cleanup of sqlite files

[Jamie McCracken <jamiemcc blueyonder co uk>]

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.

from beagle source:

for evolution:

public static Uri EmailUri (string accountName, string folderName, 
string uid)
{
return new Uri (String.Format ("email://{0}/{1};uid={2}",
                               accountName, folderName, uid));
}


System.Uri uri = EvolutionMailQueryable.EmailUri (this.account_name, 
this.folder_name, uid);

this.account_name = "local local";
this.folder_name = this.GetFolderName (this.mbox_info);


protected override string GetFolderName (FileSystemInfo info)
{
FileInfo file_info = (FileInfo) info;
DirectoryInfo di;
string folder_name = "";

di = file_info.Directory;
while (di != null) {
        // Evo uses ".sbd" as the extension on a folder
        if (di.Extension == ".sbd")
	folder_name = 				Path.CombinePath.GetFileNameWithoutExtension 
(di.Name), folder_name);

        else
                break;
        di = di.Parent;
}

        return Path.Combine (folder_name, file_info.Name);
}



So im guessing its:

email://local local/Folder;uid=?

I take it udi is the stuff in X-evolution (ie a unique number for the email)

I think folder is the path of the sdb file without extension



--
Mr Jamie McCracken
http://jamiemcc.livejournal.com/