Changeset 3212

Timestamp:

07/30/13 15:47:28 (11 years ago)

Author:

olhsha

Message:

the test database is almost ready (except permissions and permission table)

Location:

DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src

Files:

• main/sql/DashishAnnotatorCreate.sql (modified) (1 diff)
• test/resources/test-data/InsertTestData.sql (modified) (1 diff)

DASISH/t5.6/backend/annotator-backend/trunk/annotator-backend/src/main/sql/DashishAnnotatorCreate.sql

@@ -167 +167 @@
 CREATE TABLE annotations_target_sources (
    annotation_id integer REFERENCES annotation(annotation_id), -- defining a foreign key: there must be a uniquely defined row in "annotation", that is defined by "annotation_id"
-   -- source_id integer REFERENCES target_source(source_id),
-   -- unique(annotation_id, source_id),
+   source_id integer REFERENCES target_source(source_id),
+   unique(annotation_id, source_id),
 );
 

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

@@ -87 +87 @@
 -- );
 
--- INSERT INTO annotations_target_sources (annotation_id, source_id) VALUES (2, 1); 
--- INSERT INTO annotations_target_sources (annotation_id, source_id) VALUES (2, 2); 
--- 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 (2, 1); 
+INSERT INTO annotations_target_sources (annotation_id, source_id) VALUES (2, 2); 
+INSERT INTO annotations_target_sources (annotation_id, source_id) VALUES (3, 2); 
+INSERT INTO annotations_target_sources (annotation_id, source_id) VALUES (4, 3); 
 
+
+----------------------------------------------------------------
+
+-- CREATE TABLE sources_versions (
+--     source_id integer REFERENCES target_source(source_id),
+--     version_id integer REFERENCES version(version_id),
+--     unique(source_id, version_id),
+-- );
+
+INSERT INTO sources_versions (source_id, version_id) VALUES (1, 1);
+INSERT INTO sources_versions (source_id, version_id) VALUES (1, 2);
+INSERT INTO sources_versions (source_id, version_id) VALUES (2, 3);
+INSERT INTO sources_versions (source_id, version_id) VALUES (3, 4);
+
+--------------------------------------------------------------
+
+-- CREATE TABLE cached_representation_info (
+--     cached_representation_id SERIAL UNIQUE NOT NULL,
+--     external_id UUID UNIQUE NOT NULL,
+--     mime_type text,
+--     tool text,
+--     type_ text, 
+--     where_is_the_file text -- DIFFERS FROM the schema
+-- );
+
+INSERT INTO cached_representation_info (external_id, mime_type, tool, type_, where_is_the_file) VALUES ('00000000-0000-0000-0000-000000000051', 'text/html', 'latex', 'text', 'corpus1'); --1
+INSERT INTO cached_representation_info (external_id, mime_type, tool, type_, where_is_the_file) VALUES ('00000000-0000-0000-0000-000000000052', 'text/html', 'vi', 'text', 'corpus1'); -- 2
+INSERT INTO cached_representation_info (external_id, mime_type, tool, type_, where_is_the_file) VALUES ('00000000-0000-0000-0000-000000000053', 'image/png', 'screenshooter', 'image', 'corpus1'); -- 3
+INSERT INTO cached_representation_info (external_id, mime_type, tool, type_, where_is_the_file) VALUES ('00000000-0000-0000-0000-000000000054', 'text/html', 'oxygen', 'text', 'corpus1'); --4 
+
+--------------------------------------------------------------
+
+
+
+-- CREATE TABLE versions_cached_representations (
+--     version_id integer REFERENCES version(version_id),
+--     cached_representation_id integer REFERENCES cached_representation_info(cached_representation_id),
+--     unique(version_id, cached_representation_id),
+-- );
+
+INSERT INTO versions_cached_representations (version_id, cached_representation_id) VALUES (1, 1);
+INSERT INTO versions_cached_representations (version_id, cached_representation_id) VALUES (2, 3);
+INSERT INTO versions_cached_representations (version_id, cached_representation_id) VALUES (3, 2);
+INSERT INTO versions_cached_representations (version_id, cached_representation_id) VALUES (4, 4);