source: TI01-discovery/branches/ingestAutomation-upgrade/database/test_data.sql @ 3863

/* 
 * Test data to populate and exercise tables with
 * 
 * C Byrom May 08
 * 
 */
INSERT INTO original_document VALUES (DEFAULT, 'tst.xml', 'test_dummy', 'DIF', null, null, current_timestamp, null, 1, 1);
INSERT INTO original_document VALUES (DEFAULT, 'tst1.xml', 'test_record', 'DIF', '<?xml version="1.0" encoding="utf-8"?>
<kml xmlns="http://earth.google.com/kml/2.2">
  <Folder>
        <name>Aggregation of KML documents by NDG Portal</name>
    <visibility>0</visibility>
        <open>0</open>
        <description>The NetworkLink KML resources are those selected by the user when creating the document in the NDG portal (include URL?)</description>
                    <NetworkLink>
                        <name>ARGO Active float data; latitude range 45S to 90S; 18 March</name>
                        <visibility>0</visibility>
                        <open>0</open>
                        <description>ARGO Active float data; latitude range 45S to 90S; 18 March - aggregated by the NDG Portal</description>
                        <refreshVisibility>0</refreshVisibility>
                        <flyToView>0</flyToView>
                        <Link>
                                <href>
                                        http://psdocean.nerc-bas.ac.uk/ARGO/web/Active45S-90S.kmz
                                </href>
                        </Link>
                </NetworkLink>
  </Folder>
</kml>',
null, current_timestamp, null, 1, 1);

INSERT INTO original_document VALUES (DEFAULT, 'tst2.xml', 'test_dummy1', 'DIF', 'freds freds bloo' , null, current_timestamp, null, 1, 1);
INSERT INTO original_document VALUES (DEFAULT, 'tst3.xml', 'test_dummy2', null, 'fred fred bloo fred', null, current_timestamp, null, 1, 1);
INSERT INTO original_document VALUES (DEFAULT, 'tst4.xml', 'test_dummy3', null, 'fred fred bloo, fred, fred, fred, fre, fred', null, current_timestamp, null, 1, 1);

UPDATE original_document SET ts_vector = to_tsvector('english', original_document);

select original_document_id, ts_vector, ts_rank(ts_vector, query) as rank from original_document, to_tsquery('english', 'FRED') query WHERE query @@ coalesce(ts_vector,'') order by rank desc;


INSERT INTO transformed_document VALUES (DEFAULT, 1,  'moles', null, current_date, null, 1);
INSERT INTO transformed_document VALUES (DEFAULT, 1,  'mdip', 
'<mdip xmlns="http://earth.google.com/kml/2.2">
  <Folder>
        <name>Aggregation of KML documents by NDG Portal</name>
    <visibility>0</visibility>
        <open>0</open>
        <description>The NetworkLink KML resources are those selected by the user when creating the document in the NDG portal (include URL?)</description>
                    <NetworkLink>
                        <name>ARGO Active float data; latitude range 45S to 90S; 18 March</name>
                        <visibility>0</visibility>
                        <open>0</open>
                        <description>ARGO Active float data; latitude range 45S to 90S; 18 March - aggregated by the NDG Portal</description>
                        <refreshVisibility>0</refreshVisibility>
                        <flyToView>0</flyToView>
                        <Link>
                                <href>
                                        http://psdocean.nerc-bas.ac.uk/ARGO/web/Active45S-90S.kmz
                                </href>
                        </Link>
                </NetworkLink>
  </Folder>
</mdip>',
current_date, null, 1);