[tracker/sparql-update: 20/23] functional-tests: Use the newest qtcontact queries for REPLACE
- From: Philip Van Hoof <pvanhoof src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [tracker/sparql-update: 20/23] functional-tests: Use the newest qtcontact queries for REPLACE
- Date: Mon, 21 Mar 2011 11:20:57 +0000 (UTC)
commit 96fa20343587c8b56e29c4a3d3d620052478ce59
Author: Philip Van Hoof <philip codeminded be>
Date: Mon Mar 14 15:28:54 2011 +0100
functional-tests: Use the newest qtcontact queries for REPLACE
.../ipc/test-insert-or-replace.vala | 442 +++++--------------
1 files changed, 117 insertions(+), 325 deletions(-)
---
diff --git a/tests/functional-tests/ipc/test-insert-or-replace.vala b/tests/functional-tests/ipc/test-insert-or-replace.vala
index ad28047..d4d5073 100644
--- a/tests/functional-tests/ipc/test-insert-or-replace.vala
+++ b/tests/functional-tests/ipc/test-insert-or-replace.vala
@@ -2,346 +2,140 @@ using GLib;
using Tracker;
using Tracker.Sparql;
-const string insert_query_orig = "
-DELETE
-{
- ?subject nco:hasPostalAddress ?object .
-}
-WHERE
-{
- <contact_b:%d> nco:hasAffiliation ?subject .
- ?subject nco:hasPostalAddress ?object .
-}
-
-DELETE
-{
- ?subject nco:hasPostalAddress ?object .
-}
-WHERE
-{
- <contact_b:%d> nco:hasAffiliation [ nco:org ?subject ] .
- ?subject nco:hasPostalAddress ?object .
-}
-
-DELETE
-{
- ?resource a rdfs:Resource .
-}
-WHERE
-{
- <contact_b:%d> ?predicate ?resource .
-
- FILTER(?predicate IN (nao:hasProperty, nco:hasPostalAddress, ncal:anniversary,
- ncal:birthday, nco:hasLocation, nco:hasAffiliation)) .
-}
-
-DELETE
-{
- <mailto:andre andrews com> ?predicate ?object .
-}
-WHERE
-{
- <mailto:andre andrews com> ?predicate ?object .
- FILTER(?predicate IN (nco:emailAddress)) .
-}
-
-DELETE
-{
- <mailto:andre andrews meego com> ?predicate ?object .
-}
-WHERE
-{
- <mailto:andre andrews meego com> ?predicate ?object .
- FILTER(?predicate IN (nco:emailAddress)) .
-}
-
-DELETE
-{
- <tel:+4917212345%d> ?predicate ?object .
-}
-WHERE
-{
- <tel:+4917212345%d> ?predicate ?object .
- FILTER(?predicate IN (nao:hasProperty, nco:phoneNumber)) .
+const string insert_query_replace = "
+DELETE {
+ ?r nao:hasProperty ?property .
+} WHERE {
+ ?r a nco:PhoneNumber;
+ nco:phoneNumber \"02141730585%d\";
+ nao:hasProperty ?property .
}
-DELETE
-{
- <tel:+4916134567%d> ?predicate ?object .
-}
-WHERE
-{
- <tel:+4916134567%d> ?predicate ?object .
- FILTER(?predicate IN (nao:hasProperty, nco:phoneNumber)) .
+DELETE {
+ ?r a nco:CarPhoneNumber, nco:BbsNumber, nco:PagerNumber,
+ nco:VideoTelephoneNumber, nco:MessagingNumber,
+ nco:VoicePhoneNumber, nco:CellPhoneNumber,
+ nco:FaxNumber, nco:ModemNumber .
+} WHERE {
+ ?r a nco:PhoneNumber;
+ nco:phoneNumber \"02141730585%d\" .
}
-DELETE
-{
- ?resource a nco:CarPhoneNumber, nco:BbsNumber, nco:PagerNumber, nco:VideoTelephoneNumber,
- nco:MessagingNumber, nco:VoicePhoneNumber, nco:CellPhoneNumber, nco:FaxNumber,
- nco:ModemNumber .
-}
-WHERE
-{
- ?resource a nco:PhoneNumber .
- FILTER(?resource IN (<tel:+4917212345%d>, <tel:+4916134567%d>)) .
-}
-
-DELETE
-{
- GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
- {
- <contact_b:%d> ?predicate ?object .
- }
-}
-WHERE
-{
- GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
- {
- <contact_b:%d> ?predicate ?object .
- FILTER(?predicate NOT IN (nco:contactLocalUID,nco:contactUID,rdf:type)) .
+INSERT {
+ _:tel a nco:PhoneNumber ;
+ nco:phoneNumber \"02141730585%d\" .
+} WHERE {
+ OPTIONAL {
+ ?r a nco:PhoneNumber;
+ nco:phoneNumber \"02141730585%d\" .
}
+ FILTER(!bound(?r)) .
}
-INSERT
-{
- GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
- {
- <contact_b:%d> rdf:type nco:PersonContact .
- <contact_b:%d> nco:contactLocalUID \"%d\" .
- <contact_b:%d> nco:gender nco:gender-male .
-
- <contact_b:%d> nco:photo <avatar:photo:sleeping-bonobo> .
- <contact_b:%d> nco:video <avatar:video:crazy-banana> .
-
- <contact_b:%d> nco:nameHonorificPrefix \"Sir\" .
- <contact_b:%d> nco:nameGiven \"Andre b %d\" .
- <contact_b:%d> nco:nameFamily \"Andrews b %d\" .
-
- _:_Affiliation_Work000000001 rdf:type nco:Affiliation .
- _:_Affiliation_Work000000001 rdfs:label \"Work\" .
- <contact_b:%d> nco:hasAffiliation _:_Affiliation_Work000000001 .
-
- _:_Organization_Resource000000004 rdf:type nco:OrganizationContact .
- _:_Affiliation_Work000000001 nco:org _:_Organization_Resource000000004 .
-
- _:_Organization_Resource000000004 nco:logo <avatar:photo:boring-cube> .
-
- _:Affiliation_Home1 rdf:type nco:Affiliation .
- _:Affiliation_Home1 rdfs:label \"Home\" .
- <contact_b:%d> nco:hasAffiliation _:Affiliation_Home1 .
-
- <mailto:andre andrews com> rdf:type nco:EmailAddress .
- _:Affiliation_Home1 nco:hasEmailAddress <mailto:andre andrews com> .
- <mailto:andre andrews com> nco:emailAddress \"andre andrews com\" .
-
- _:Affiliation_Other1 rdf:type nco:Affiliation .
- _:Affiliation_Other1 rdfs:label \"Other\" .
- <contact_b:%d> nco:hasAffiliation _:Affiliation_Other1 .
-
- <mailto:andre andrews meego com> rdf:type nco:EmailAddress .
- _:Affiliation_Other1 nco:hasEmailAddress <mailto:andre andrews meego com> .
- <mailto:andre andrews meego com> nco:emailAddress \"andre andrews meego com\" .
-
- <tel:+4917212345%d> rdf:type nco:VoicePhoneNumber .
- _:Affiliation_Home1 nco:hasPhoneNumber <tel:+4917212345%d> .
- <tel:+4917212345%d> nco:phoneNumber \"+4917212345%d\" .
-
- <tel:+4916134567%d> rdf:type nco:CellPhoneNumber .
- _:Affiliation_Home1 nco:hasPhoneNumber <tel:+4916134567%d> .
- <tel:+4916134567%d> nco:phoneNumber \"+4916134567%d\" .
-
- _:Affiliation_Home1 nco:url \"http://andrews.com/\"; .
-
- _:Address_Resource4 rdf:type nco:DomesticDeliveryAddress .
- _:Affiliation_Home1 nco:hasPostalAddress _:Address_Resource4 .
- _:Address_Resource4 nco:country \"Germany\" .
- _:Address_Resource4 nco:locality \"Berlin\" .
- _:Address_Resource4 nco:streetAddress \"Alexanderplatz 1\" .
-
- _:Address_Resource5 rdf:type nco:ParcelDeliveryAddress .
- _:_Affiliation_Work000000001 nco:hasPostalAddress _:Address_Resource5 .
- _:Address_Resource5 nco:country \"Germany\" .
- _:Address_Resource5 nco:locality \"Berlin\" .
- _:Address_Resource5 nco:streetAddress \"Friedrichstrasse 105\" .
-
- _:Anniversary_Resource3 rdf:type ncal:Event .
- <contact_b:%d> ncal:anniversary _:Anniversary_Resource3 .
- _:Anniversary_Resource3 ncal:uid \"11223344\" .
- _:Anniversary_Resource3 ncal:dtstart \"2007-05-05T00:00:00\" .
- _:Anniversary_Resource3 ncal:description \"Hochzeit\" .
- _:Anniversary_Resource3 ncal:categories \"Wedding\" .
-
- <contact_b:%d> nie:generator \"addressbook\" .
- <contact_b:%d> nco:hobby \"fishing\" .
-
- ?_Tag_Resource000000010 rdf:type nao:Tag .
- <contact_b:%d> nao:hasTag ?_Tag_Resource000000010 .
- ?_Tag_Resource000000010 nao:prefLabel \"Knorke\" .
-
- <contact_b:%d> nie:contentLastModified \"2010-05-04T09:30:00Z\" .
- <contact_b:%d> nie:contentCreated \"2010-04-22T01:00:00Z\" .
- }
+DELETE { <mailto:rhome0 example com%d> ?predicate ?object . }
+WHERE {
+ <mailto:rhome0 example com%d> ?predicate ?object .
+ FILTER(?predicate IN (nco:emailAddress)) .
}
-";
-const string prepare_query_replace = "
INSERT {
- <avatar:photo:sleeping-bonobo> a nfo:FileDataObject ;
- nie:url \"file:///home/user/.contacts/avatars/sleeping-bonobo.png\" .
- <avatar:video:crazy-banana> a nfo:FileDataObject ;
- nie:url \"file:///home/user/.contacts/avatars/crazy-banana.ogv\" .
- <avatar:photo:boring-cube> a nfo:FileDataObject ;
- nie:url \"file:///home/user/.contacts/avatars/boring-cube.png\" .
-}";
-
-const string insert_query_replace = "
-DELETE
-{
- ?subject nco:hasPostalAddress ?object .
-}
-WHERE
-{
- <contact:%d> nco:hasAffiliation ?subject .
- ?subject nco:hasPostalAddress ?object .
-}
-
-DELETE
-{
- ?subject nco:hasPostalAddress ?object .
-}
-WHERE
-{
- <contact:%d> nco:hasAffiliation [ nco:org ?subject ] .
- ?subject nco:hasPostalAddress ?object .
-}
-
-DELETE
-{
- ?resource a rdfs:Resource .
-}
-WHERE
-{
- <contact:%d> ?predicate ?resource .
-
- FILTER(?predicate IN (nao:hasProperty, nco:hasPostalAddress, ncal:anniversary,
- ncal:birthday, nco:hasLocation, nco:hasAffiliation)) .
+ <mailto:rhome0 example com%d> a nco:EmailAddress ;
+ nco:emailAddress \"rhome0 example com%d\" .
+}
+
+DELETE { <contact:r:%d> nco:hasAffiliation ?e }
+WHERE { <contact:r:%d> nco:hasAffiliation ?e }
+
+INSERT OR REPLACE {
+ _:af1 a nco:Affiliation ;
+ rdfs:label \"Work\" ;
+ nco:hasEmailAddress <mailto:rhome0 example com%d> .
+
+ _:af2 a nco:Affiliation ;
+ rdfs:label \"Other\" ;
+ nco:hasPhoneNumber ?tel .
+
+ <contact:r:%d> a nco:PersonContact ;
+ nco:nameHonorificPrefix \"Mrs.\" ;
+ nco:nameGiven \"First %d\" ;
+ nco:nameFamily \"Last %d\" ;
+ nco:hasAffiliation _:af1 ;
+ nco:hasAffiliation _:af2 ;
+ nie:generator \"addressbook\" ;
+ nie:contentLastModified \"2011-03-14T13:47:25\" ;
+ nie:contentCreated \"2011-03-14T13:47:25\" ;
+ nco:contactUID \"c1f1b12d-bc75-4d45-9a1f-b1efe934409f\" .
+} WHERE {
+ ?tel nco:phoneNumber \"02141730585%d\"
}
+";
-DELETE
-{
- <tel:+4917212345%d> nao:hasProperty ?object .
-}
-WHERE
-{
- <tel:+4917212345%d> nao:hasProperty ?object .
+const string insert_query_orig = "
+DELETE { <mailto:home0 example com%d> ?predicate ?object . }
+WHERE {
+ <mailto:home0 example com%d> ?predicate ?object .
+ FILTER(?predicate IN (nco:emailAddress)) .
}
-DELETE
-{
- <tel:+4916134567%d> nao:hasProperty ?object .
-}
-WHERE
-{
- <tel:+4916134567%d> nao:hasProperty ?object .
+DELETE { ?resource nao:hasProperty ?property . }
+WHERE {
+ ?resource nao:hasProperty ?property ; nco:phoneNumber ?key .
+ FILTER(?key IN (\"2141730585%d\")) .
}
-DELETE
-{
- ?resource a nco:CarPhoneNumber, nco:BbsNumber, nco:PagerNumber, nco:VideoTelephoneNumber,
- nco:MessagingNumber, nco:VoicePhoneNumber, nco:CellPhoneNumber, nco:FaxNumber,
- nco:ModemNumber .
-}
-WHERE
-{
- ?resource a nco:PhoneNumber .
- FILTER(?resource IN (<tel:+4917212345%d>, <tel:+4916134567%d>)) .
+DELETE {
+ ?resource a nco:CarPhoneNumber, nco:BbsNumber, nco:PagerNumber,
+ nco:VideoTelephoneNumber, nco:MessagingNumber,
+ nco:VoicePhoneNumber, nco:CellPhoneNumber,
+ nco:FaxNumber, nco:ModemNumber .
+} WHERE {
+ ?resource a nco:PhoneNumber ; nco:phoneNumber ?key .
+ FILTER(?key IN (\"2141730585%d\")) .
}
-DELETE
-{
- GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
- {
- <contact:%d> ?predicate ?object .
- }
-}
-WHERE
-{
- GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
- {
- <contact:%d> ?predicate ?object .
- FILTER(?predicate NOT IN (nco:contactLocalUID,nco:contactUID,rdf:type)) .
+INSERT {
+ _:_ a nco:PhoneNumber ; nco:phoneNumber \"2141730585%d\" .
+} WHERE {
+ OPTIONAL {
+ ?resource a nco:PhoneNumber ; nco:phoneNumber \"2141730585%d\" .
}
+ FILTER(!bound(?resource)) .
}
-INSERT OR REPLACE
-{
- GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9>
- {
- ?_Tag a nao:Tag ; nao:prefLabel \"Knorke\" .
-
- <mailto:andre andrews com> a nco:EmailAddress ;
- nco:emailAddress \"andre andrews com\" .
-
- <mailto:andre andrews meego com> a nco:EmailAddress ;
- nco:emailAddress \"andre andrews meego com\" .
-
- <tel:+4917212345%d> a nco:VoicePhoneNumber ; nco:phoneNumber \"+4917212345%d\" .
-
- <tel:+4916134567%d> a nco:CellPhoneNumber ;
- nco:phoneNumber \"+4916134567%d\" .
-
- _:Anniversary a ncal:Event ;
- ncal:uid \"11223344\" ;
- ncal:dtstart \"2007-05-05T00:00:00\" ;
- ncal:description \"Hochzeit\" ;
- ncal:categories \"Wedding\" .
-
- _:Address_Resource1 a nco:DomesticDeliveryAddress ;
- nco:country \"Germany\" ;
- nco:locality \"Berlin\" ;
- nco:streetAddress \"Alexanderplatz 1\" .
-
- _:Address_Resource2 a nco:ParcelDeliveryAddress ;
- nco:country \"Germany\" ;
- nco:locality \"Berlin\" ;
- nco:streetAddress \"Friedrichstrasse 105\" .
-
- _:Organization_Resource a nco:OrganizationContact ;
- nco:logo <avatar:photo:boring-cube> .
-
- _:Affiliation_Work a nco:Affiliation ; rdfs:label \"Work\" ;
- nco:org _:_Organization_Resource ;
- nco:hasPostalAddress _:Address_Resource2 ;
- nco:hasPhoneNumber <tel:+4916134567%d> .
-
- _:Affiliation_Home a nco:Affiliation ; rdfs:label \"Home\" ;
- nco:hasEmailAddress <mailto:andre andrews com> ;
- nco:hasPhoneNumber <tel:+4917212345%d> ;
- nco:url \"http://andrews.com/\"; ;
- nco:hasPostalAddress _:Address_Resource1 .
-
- _:Affiliation_Other a nco:Affiliation ; rdfs:label \"Other\" ;
- nco:hasEmailAddress <mailto:andre andrews meego com> .
-
- <contact:%d> a nco:PersonContact ;
- nco:contactLocalUID \"%d\" ;
- nco:gender nco:gender-male ;
- nco:photo <avatar:photo:sleeping-bonobo> ;
- nco:video <avatar:video:crazy-banana> ;
- nco:nameHonorificPrefix \"Sir\" ;
- nco:nameGiven \"Andre%d\" ;
- nco:nameFamily \"Andrews%d\" ;
- nco:hasAffiliation _:Affiliation_Work ;
- nco:hasAffiliation _:Affiliation_Home ;
- nco:hasAffiliation _:Affiliation_Other ;
- ncal:anniversary _:Anniversary ;
- nie:generator \"addressbook\" ;
- nco:hobby \"fishing\" ;
- nao:hasTag ?_Tag ;
- nie:contentLastModified \"2010-05-04T09:30:00Z\" ;
- nie:contentCreated \"2010-04-22T01:00:00Z\" .
- }
+DELETE { GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9> {
+ <contact:o:%d> ?predicate ?object .
+} } WHERE { GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9> {
+ <contact:o:%d> ?predicate ?object .
+ FILTER(?predicate NOT IN (nco:contactLocalUID,nco:contactUID,rdf:type)) .
+} }
+
+INSERT { GRAPH <urn:uuid:08070f5c-a334-4d19-a8b0-12a3071bfab9> {
+ <mailto:home0 example com%d> a nco:EmailAddress ;
+ nco:emailAddress \"home0 example com%d\" .
+
+ _:_Affiliation_Work1 a nco:Affiliation ;
+ rdfs:label \"Work\" ;
+ nco:hasEmailAddress <mailto:home0 example com%d> .
+
+ ?_PhoneNumber_Resource3 a nco:VoicePhoneNumber, nco:PhoneNumber ;
+ nco:phoneNumber \"2141730585%d\" .
+
+ _:_Affiliation_Other2 a nco:Affiliation ;
+ rdfs:label \"Other\" ;
+ nco:hasPhoneNumber ?_PhoneNumber_Resource3 .
+
+ <contact:o:%d> a nco:PersonContact ;
+ nco:nameHonorificPrefix \"Mrs.\" ;
+ nco:nameGiven \"First %d\" ;
+ nco:nameFamily \"Last %d\" ;
+ nco:hasAffiliation _:_Affiliation_Work1 ;
+ nco:hasAffiliation _:_Affiliation_Other2 ;
+ nie:generator \"addressbook\" ;
+ nie:contentLastModified \"2011-03-14T13:47:25\" ;
+ nie:contentCreated \"2011-03-14T13:47:25\" ;
+ nco:contactUID \"c1f1b12d-bc75-4d45-9a1f-b1efe934409f\" .
+} } WHERE {
+ ?_PhoneNumber_Resource3 nco:phoneNumber \"2141730585%d\"
}
";
@@ -354,24 +148,22 @@ main( string[] args )
Connection c;
c = Connection.get ();
- c.update (prepare_query_replace);
-
t1.start ();
for (i = 0; i < y; i++) {
- c.update (insert_query_replace.printf (i, i, i, i, i, i, i, i, i, i));
+ c.update (insert_query_replace.printf (i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i));
}
t1.stop ();
- print ("%f\n", t1.elapsed());
+ print ("REPLACE: %f\n", t1.elapsed());
t2.start ();
for (i = 0; i < y; i++) {
- c.update (insert_query_orig.printf (i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i, i));
+ c.update (insert_query_orig.printf (i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i,i));
}
t2.stop ();
- print ("%f\n", t2.elapsed());
+ print ("ORIGINAL: %f\n", t2.elapsed());
return 0;
}
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]
