[Gpe-list] Proper handling of imported VCARDs' categories

[Paul Sokolovsky]

Hello gpe-list,

  FYI, I've committed to OE support for handling categories of
imported VCARDs,
http://www.openembedded.org/viewmtn/revision/info/6a123114c50d24ba777fd796259528ed55d645bd
After more testing, I'm going to submit those patches to GPE tracker.

  Also, result of quick sprint to make category view switch to take
half-second, not half-minute:

create index contacts__tag_val on contacts(tag, value);
create index contacts__urn on contacts(urn);

--- libcontactsdb.org/contacts-db.c     Mon Jan 21 03:10:01 2008 +0200
+++ libcontactsdb/contacts-db.c Mon Jan 21 03:16:45 2008 +0200 
@@ -456,8 +456,7 @@ contacts_db_get_entries_list (const gcha 
     { 
       r = sqlite_exec_printf (contacts_db, 
                  "select contacts_urn.urn, contacts_urn.name, contacts_urn.family_name, contacts_urn.company " 
-                 "from contacts_urn, contacts where contacts_urn.urn = contacts.urn " 
-                 "and contacts.tag = 'CATEGORY' and contacts.value like '%q%%'", 
+                 "from contacts_urn where urn in (select urn from contacts where tag='CATEGORY' and value='%q')", 
                  contacts_read_one_entry, &list, &err, cat); 
     } 
   else if (no_cat) 


Of course, that's mostly a monkey's job - before such work can be
performed in sustainable manner, underlying DB engine should be
upgraded to a supported version.


-- 
Best regards,
 Paul                          mailto:pmiscml at gmail.com