Changeset 3367 for DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/test/resources/test-data/InsertTestData.sql

Timestamp:

08/13/13 11:18:07 (11 years ago)

Author:

olhsha

Message:

correction getting the list of annotation IDs, where annotations are filtered by link, text, etc. So far body is considered as a text (got from xmls list of elements, vis get(0)). NOT TESTED yet!

Getting sourceIDs of the sources referreing to a given link

File:

• DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/test/resources/test-data/InsertTestData.sql (modified) (4 diffs)

DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/test/resources/test-data/InsertTestData.sql

@@ -69 +69 @@
 INSERT INTO version (external_id, version) VALUES ('00000000-0000-0000-0000-000000000045', 'Art Nuveau wiki -version 2012'); --5 
 INSERT INTO version (external_id, version) VALUES ('00000000-0000-0000-0000-000000000046', 'Art Nuveau wiki -version 2011'); --6  not used
+INSERT INTO version (external_id, version) VALUES ('00000000-0000-0000-0000-000000000047', 'Art Nuveau wiki -version 2010'); --7
 
 -- CREATE TABLE target_source (
@@ -85 +86 @@
 INSERT INTO target_source (external_id, link_uri, version_id) VALUES ('00000000-0000-0000-0000-000000000033', 'http://en.wikipedia.org/wiki/Art_Nouveau', 4); --3
 INSERT INTO target_source (external_id, link_uri, version_id) VALUES ('00000000-0000-0000-0000-000000000034', '???', 5); --4
+INSERT INTO target_source (external_id, link_uri, version_id) VALUES ('00000000-0000-0000-0000-000000000035', '???', 5); --5
 
 -- CREATE TABLE annotations_target_sources (
@@ -96 +98 @@
 INSERT INTO annotations_target_sources (annotation_id, source_id) VALUES (3, 2); 
 INSERT INTO annotations_target_sources (annotation_id, source_id) VALUES (4, 3); 
+INSERT INTO annotations_target_sources (annotation_id, source_id) VALUES (5, 3); -- source 3 should not be deleted when annot 5 is deleted
+INSERT INTO annotations_target_sources (annotation_id, source_id) VALUES (5, 4); -- source 4 to be deleted when annot 5 is deleted
 
 ----------------------------------------------------------------
@@ -110 +114 @@
 INSERT INTO sources_versions (source_id, version_id) VALUES (3, 4);
 INSERT INTO sources_versions (source_id, version_id) VALUES (4, 5);
+INSERT INTO sources_versions (source_id, version_id) VALUES (5, 7);
 
 --------------------------------------------------------------