Revision 11879
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/CTFS/TaxonOccurrence.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CTFS.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<sourceaccessioncode>$locationID</sourceaccessioncode> |
|
| 11 |
<locationevent> |
|
| 12 |
<sourceaccessioncode>$eventID</sourceaccessioncode> |
|
| 13 |
<locationevent fkey="parent_id"> |
|
| 14 |
<sourceaccessioncode>$eventID</sourceaccessioncode> |
|
| 15 |
<taxonoccurrence><sourceaccessioncode>$taxonOccurrenceID</sourceaccessioncode></taxonoccurrence> |
|
| 16 |
</locationevent> |
|
| 17 |
</locationevent> |
|
| 18 |
</location> |
|
| 19 |
</path> |
|
| 20 |
</_simplifyPath> |
|
| 21 |
</path> |
|
| 22 |
</_setDefault> |
|
| 23 |
</VegBIEN> |
|
| 24 |
Inserted 5 new rows into database |
|
| inputs/CTFS/Country.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CTFS.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationplace> |
|
| 11 |
<place_id> |
|
| 12 |
<place> |
|
| 13 |
<country>$country</country> |
|
| 14 |
<matched_place_id> |
|
| 15 |
<place> |
|
| 16 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
|
| 17 |
<country>$country</country> |
|
| 18 |
</place> |
|
| 19 |
</matched_place_id> |
|
| 20 |
</place> |
|
| 21 |
</place_id> |
|
| 22 |
</locationplace> |
|
| 23 |
</location> |
|
| 24 |
</path> |
|
| 25 |
</_simplifyPath> |
|
| 26 |
</path> |
|
| 27 |
</_setDefault> |
|
| 28 |
</VegBIEN> |
|
| 29 |
Inserted 4 new rows into database |
|
| inputs/CTFS/SpecificEpithet.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CTFS.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationevent> |
|
| 11 |
<locationevent fkey="parent_id"> |
|
| 12 |
<taxonoccurrence> |
|
| 13 |
<taxondetermination> |
|
| 14 |
<taxonverbatim_id> |
|
| 15 |
<taxonverbatim> |
|
| 16 |
<taxonlabel_id> |
|
| 17 |
<taxonlabel> |
|
| 18 |
<parent_id> |
|
| 19 |
<taxonlabel> |
|
| 20 |
<parent_id> |
|
| 21 |
<taxonlabel> |
|
| 22 |
<rank>cultivar</rank> |
|
| 23 |
<parent_id> |
|
| 24 |
<taxonlabel> |
|
| 25 |
<rank>forma</rank> |
|
| 26 |
<parent_id> |
|
| 27 |
<taxonlabel> |
|
| 28 |
<rank>variety</rank> |
|
| 29 |
<parent_id> |
|
| 30 |
<taxonlabel> |
|
| 31 |
<rank>subspecies</rank> |
|
| 32 |
<parent_id> |
|
| 33 |
<taxonlabel> |
|
| 34 |
<rank>species</rank> |
|
| 35 |
<taxonepithet>$specificEpithet</taxonepithet> |
|
| 36 |
</taxonlabel> |
|
| 37 |
</parent_id> |
|
| 38 |
</taxonlabel> |
|
| 39 |
</parent_id> |
|
| 40 |
</taxonlabel> |
|
| 41 |
</parent_id> |
|
| 42 |
</taxonlabel> |
|
| 43 |
</parent_id> |
|
| 44 |
</taxonlabel> |
|
| 45 |
</parent_id> |
|
| 46 |
</taxonlabel> |
|
| 47 |
</parent_id> |
|
| 48 |
<taxonomicname> |
|
| 49 |
<_join_words> |
|
| 50 |
<1>$specificEpithet</1> |
|
| 51 |
<2>$scientificNameAuthorship</2> |
|
| 52 |
</_join_words> |
|
| 53 |
</taxonomicname> |
|
| 54 |
</taxonlabel> |
|
| 55 |
</taxonlabel_id> |
|
| 56 |
<author>$scientificNameAuthorship</author> |
|
| 57 |
<specific_epithet>$specificEpithet</specific_epithet> |
|
| 58 |
</taxonverbatim> |
|
| 59 |
</taxonverbatim_id> |
|
| 60 |
</taxondetermination> |
|
| 61 |
</taxonoccurrence> |
|
| 62 |
</locationevent> |
|
| 63 |
</locationevent> |
|
| 64 |
</location> |
|
| 65 |
</path> |
|
| 66 |
</_simplifyPath> |
|
| 67 |
</path> |
|
| 68 |
</_setDefault> |
|
| 69 |
</VegBIEN> |
|
| 70 |
Inserted 7 new rows into database |
|
| inputs/CTFS/Stem.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CTFS.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path><location><locationevent><locationevent fkey="parent_id"><taxonoccurrence><aggregateoccurrence><plantobservation><stemobservation><authorstemcode>$authorStemCode</authorstemcode></stemobservation></plantobservation></aggregateoccurrence></taxonoccurrence></locationevent></locationevent></location></path> |
|
| 9 |
</_simplifyPath> |
|
| 10 |
</path> |
|
| 11 |
</_setDefault> |
|
| 12 |
</VegBIEN> |
|
| 13 |
Inserted 1 new rows into database |
|
| inputs/CTFS/Organism.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CTFS.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<parent_id><location><sourceaccessioncode>$locationID</sourceaccessioncode></location></parent_id> |
|
| 11 |
<authorlocationcode>$subplot</authorlocationcode> |
|
| 12 |
<locationevent> |
|
| 13 |
<locationevent fkey="parent_id"> |
|
| 14 |
<taxonoccurrence> |
|
| 15 |
<aggregateoccurrence> |
|
| 16 |
<plantobservation> |
|
| 17 |
<stemobservation> |
|
| 18 |
<xposition_m>$organismX_m</xposition_m> |
|
| 19 |
<yposition_m>$organismY_m</yposition_m> |
|
| 20 |
</stemobservation> |
|
| 21 |
</plantobservation> |
|
| 22 |
</aggregateoccurrence> |
|
| 23 |
</taxonoccurrence> |
|
| 24 |
</locationevent> |
|
| 25 |
</locationevent> |
|
| 26 |
<sourceaccessioncode> |
|
| 27 |
<_join> |
|
| 28 |
<1>$locationID</1> |
|
| 29 |
<2>$subplot</2> |
|
| 30 |
</_join> |
|
| 31 |
</sourceaccessioncode> |
|
| 32 |
</location> |
|
| 33 |
</path> |
|
| 34 |
</_simplifyPath> |
|
| 35 |
</path> |
|
| 36 |
</_setDefault> |
|
| 37 |
</VegBIEN> |
|
| 38 |
Inserted 14 new rows into database |
|
| inputs/CTFS/InfraspecificEpithet.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CTFS.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationevent> |
|
| 11 |
<locationevent fkey="parent_id"> |
|
| 12 |
<taxonoccurrence> |
|
| 13 |
<taxondetermination> |
|
| 14 |
<taxonverbatim_id> |
|
| 15 |
<taxonverbatim> |
|
| 16 |
<taxonlabel_id> |
|
| 17 |
<taxonlabel> |
|
| 18 |
<parent_id> |
|
| 19 |
<taxonlabel> |
|
| 20 |
<parent_id> |
|
| 21 |
<taxonlabel> |
|
| 22 |
<rank>cultivar</rank> |
|
| 23 |
<parent_id> |
|
| 24 |
<taxonlabel> |
|
| 25 |
<rank>forma</rank> |
|
| 26 |
<parent_id> |
|
| 27 |
<taxonlabel> |
|
| 28 |
<rank>variety</rank> |
|
| 29 |
<parent_id> |
|
| 30 |
<taxonlabel> |
|
| 31 |
<rank>subspecies</rank> |
|
| 32 |
<taxonepithet>$subspecies</taxonepithet> |
|
| 33 |
</taxonlabel> |
|
| 34 |
</parent_id> |
|
| 35 |
</taxonlabel> |
|
| 36 |
</parent_id> |
|
| 37 |
</taxonlabel> |
|
| 38 |
</parent_id> |
|
| 39 |
</taxonlabel> |
|
| 40 |
</parent_id> |
|
| 41 |
</taxonlabel> |
|
| 42 |
</parent_id> |
|
| 43 |
<taxonomicname>$subspecies</taxonomicname> |
|
| 44 |
</taxonlabel> |
|
| 45 |
</taxonlabel_id> |
|
| 46 |
</taxonverbatim> |
|
| 47 |
</taxonverbatim_id> |
|
| 48 |
</taxondetermination> |
|
| 49 |
</taxonoccurrence> |
|
| 50 |
</locationevent> |
|
| 51 |
</locationevent> |
|
| 52 |
</location> |
|
| 53 |
</path> |
|
| 54 |
</_simplifyPath> |
|
| 55 |
</path> |
|
| 56 |
</_setDefault> |
|
| 57 |
</VegBIEN> |
|
| 58 |
Inserted 7 new rows into database |
|
| inputs/CTFS/Plot.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CTFS.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<authorlocationcode>$locationName</authorlocationcode> |
|
| 11 |
<sourceaccessioncode>$locationID</sourceaccessioncode> |
|
| 12 |
<area_m2><_ha_to_m2><value>$plotArea_ha</value></_ha_to_m2></area_m2> |
|
| 13 |
<elevation_m>$elevationInMeters</elevation_m> |
|
| 14 |
<iscultivated><_locationnarrative_is_cultivated><locationnarrative>$locality</locationnarrative></_locationnarrative_is_cultivated></iscultivated> |
|
| 15 |
<locationnarrative> |
|
| 16 |
<_merge> |
|
| 17 |
<1>$locality</1> |
|
| 18 |
<4>$locationRemarks</4> |
|
| 19 |
</_merge> |
|
| 20 |
</locationnarrative> |
|
| 21 |
<locationplace> |
|
| 22 |
<place_id> |
|
| 23 |
<place> |
|
| 24 |
<coordinates_id> |
|
| 25 |
<coordinates> |
|
| 26 |
<footprintgeometry_dwc>$footprintWKT</footprintgeometry_dwc> |
|
| 27 |
<latitude_deg> |
|
| 28 |
<_nullIf> |
|
| 29 |
<null>0</null> |
|
| 30 |
<type>float</type> |
|
| 31 |
<value>$decimalLatitude</value> |
|
| 32 |
</_nullIf> |
|
| 33 |
</latitude_deg> |
|
| 34 |
<longitude_deg> |
|
| 35 |
<_nullIf> |
|
| 36 |
<null>0</null> |
|
| 37 |
<type>float</type> |
|
| 38 |
<value>$decimalLongitude</value> |
|
| 39 |
</_nullIf> |
|
| 40 |
</longitude_deg> |
|
| 41 |
</coordinates> |
|
| 42 |
</coordinates_id> |
|
| 43 |
<matched_place_id> |
|
| 44 |
<place> |
|
| 45 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
|
| 46 |
<coordinates_id> |
|
| 47 |
<coordinates> |
|
| 48 |
<source_id><source><shortname>geoscrub</shortname></source></source_id> |
|
| 49 |
<latitude_deg> |
|
| 50 |
<_nullIf> |
|
| 51 |
<null>0</null> |
|
| 52 |
<type>float</type> |
|
| 53 |
<value>$decimalLatitude</value> |
|
| 54 |
</_nullIf> |
|
| 55 |
</latitude_deg> |
|
| 56 |
<longitude_deg> |
|
| 57 |
<_nullIf> |
|
| 58 |
<null>0</null> |
|
| 59 |
<type>float</type> |
|
| 60 |
<value>$decimalLongitude</value> |
|
| 61 |
</_nullIf> |
|
| 62 |
</longitude_deg> |
|
| 63 |
</coordinates> |
|
| 64 |
</coordinates_id> |
|
| 65 |
</place> |
|
| 66 |
</matched_place_id> |
|
| 67 |
</place> |
|
| 68 |
</place_id> |
|
| 69 |
</locationplace> |
|
| 70 |
</location> |
|
| 71 |
</path> |
|
| 72 |
</_simplifyPath> |
|
| 73 |
</path> |
|
| 74 |
</_setDefault> |
|
| 75 |
</VegBIEN> |
|
| 76 |
Inserted 14 new rows into database |
|
| inputs/CTFS/Genus.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CTFS.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationevent> |
|
| 11 |
<locationevent fkey="parent_id"> |
|
| 12 |
<taxonoccurrence> |
|
| 13 |
<taxondetermination> |
|
| 14 |
<taxonverbatim_id> |
|
| 15 |
<taxonverbatim> |
|
| 16 |
<taxonlabel_id> |
|
| 17 |
<taxonlabel> |
|
| 18 |
<parent_id> |
|
| 19 |
<taxonlabel> |
|
| 20 |
<parent_id> |
|
| 21 |
<taxonlabel> |
|
| 22 |
<rank>cultivar</rank> |
|
| 23 |
<parent_id> |
|
| 24 |
<taxonlabel> |
|
| 25 |
<rank>forma</rank> |
|
| 26 |
<parent_id> |
|
| 27 |
<taxonlabel> |
|
| 28 |
<rank>variety</rank> |
|
| 29 |
<parent_id> |
|
| 30 |
<taxonlabel> |
|
| 31 |
<rank>subspecies</rank> |
|
| 32 |
<parent_id> |
|
| 33 |
<taxonlabel> |
|
| 34 |
<rank>species</rank> |
|
| 35 |
<parent_id> |
|
| 36 |
<taxonlabel> |
|
| 37 |
<rank>genus</rank> |
|
| 38 |
<taxonepithet>$genus</taxonepithet> |
|
| 39 |
</taxonlabel> |
|
| 40 |
</parent_id> |
|
| 41 |
</taxonlabel> |
|
| 42 |
</parent_id> |
|
| 43 |
</taxonlabel> |
|
| 44 |
</parent_id> |
|
| 45 |
</taxonlabel> |
|
| 46 |
</parent_id> |
|
| 47 |
</taxonlabel> |
|
| 48 |
</parent_id> |
|
| 49 |
</taxonlabel> |
|
| 50 |
</parent_id> |
|
| 51 |
</taxonlabel> |
|
| 52 |
</parent_id> |
|
| 53 |
<taxonomicname><_filter_genus><value>$genus</value></_filter_genus></taxonomicname> |
|
| 54 |
</taxonlabel> |
|
| 55 |
</taxonlabel_id> |
|
| 56 |
<genus>$genus</genus> |
|
| 57 |
</taxonverbatim> |
|
| 58 |
</taxonverbatim_id> |
|
| 59 |
</taxondetermination> |
|
| 60 |
</taxonoccurrence> |
|
| 61 |
</locationevent> |
|
| 62 |
</locationevent> |
|
| 63 |
</location> |
|
| 64 |
</path> |
|
| 65 |
</_simplifyPath> |
|
| 66 |
</path> |
|
| 67 |
</_setDefault> |
|
| 68 |
</VegBIEN> |
|
| 69 |
Inserted 7 new rows into database |
|
| inputs/CTFS/Family.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CTFS.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationevent> |
|
| 11 |
<locationevent fkey="parent_id"> |
|
| 12 |
<taxonoccurrence> |
|
| 13 |
<taxondetermination> |
|
| 14 |
<taxonverbatim_id> |
|
| 15 |
<taxonverbatim> |
|
| 16 |
<taxonlabel_id> |
|
| 17 |
<taxonlabel> |
|
| 18 |
<parent_id> |
|
| 19 |
<taxonlabel> |
|
| 20 |
<parent_id> |
|
| 21 |
<taxonlabel> |
|
| 22 |
<rank>cultivar</rank> |
|
| 23 |
<parent_id> |
|
| 24 |
<taxonlabel> |
|
| 25 |
<rank>forma</rank> |
|
| 26 |
<parent_id> |
|
| 27 |
<taxonlabel> |
|
| 28 |
<rank>variety</rank> |
|
| 29 |
<parent_id> |
|
| 30 |
<taxonlabel> |
|
| 31 |
<rank>subspecies</rank> |
|
| 32 |
<parent_id> |
|
| 33 |
<taxonlabel> |
|
| 34 |
<rank>species</rank> |
|
| 35 |
<parent_id> |
|
| 36 |
<taxonlabel> |
|
| 37 |
<rank>genus</rank> |
|
| 38 |
<parent_id> |
|
| 39 |
<taxonlabel> |
|
| 40 |
<rank>family</rank> |
|
| 41 |
<taxonepithet>$family</taxonepithet> |
|
| 42 |
</taxonlabel> |
|
| 43 |
</parent_id> |
|
| 44 |
</taxonlabel> |
|
| 45 |
</parent_id> |
|
| 46 |
</taxonlabel> |
|
| 47 |
</parent_id> |
|
| 48 |
</taxonlabel> |
|
| 49 |
</parent_id> |
|
| 50 |
</taxonlabel> |
|
| 51 |
</parent_id> |
|
| 52 |
</taxonlabel> |
|
| 53 |
</parent_id> |
|
| 54 |
</taxonlabel> |
|
| 55 |
</parent_id> |
|
| 56 |
</taxonlabel> |
|
| 57 |
</parent_id> |
|
| 58 |
<taxonomicname><_taxon_family_require_std><family>$family</family></_taxon_family_require_std></taxonomicname> |
|
| 59 |
</taxonlabel> |
|
| 60 |
</taxonlabel_id> |
|
| 61 |
<family>$family</family> |
|
| 62 |
</taxonverbatim> |
|
| 63 |
</taxonverbatim_id> |
|
| 64 |
</taxondetermination> |
|
| 65 |
</taxonoccurrence> |
|
| 66 |
</locationevent> |
|
| 67 |
</locationevent> |
|
| 68 |
</location> |
|
| 69 |
</path> |
|
| 70 |
</_simplifyPath> |
|
| 71 |
</path> |
|
| 72 |
</_setDefault> |
|
| 73 |
</VegBIEN> |
|
| 74 |
Inserted 7 new rows into database |
|
| inputs/CTFS/StemObservation.src/test.xml.ref | ||
|---|---|---|
| 1 |
<!--put template--> |
|
| 2 |
<VegBIEN> |
|
| 3 |
<_setDefault id="-1"> |
|
| 4 |
<source_id><source><shortname>CTFS.new</shortname></source></source_id> |
|
| 5 |
<path> |
|
| 6 |
<_simplifyPath> |
|
| 7 |
<next>parent_id</next> |
|
| 8 |
<path> |
|
| 9 |
<location> |
|
| 10 |
<locationevent> |
|
| 11 |
<sourceaccessioncode>$eventID</sourceaccessioncode> |
|
| 12 |
<locationevent fkey="parent_id"> |
|
| 13 |
<sourceaccessioncode>$eventID</sourceaccessioncode> |
|
| 14 |
<taxonoccurrence> |
|
| 15 |
<aggregateoccurrence> |
|
| 16 |
<plantobservation> |
|
| 17 |
<sourceaccessioncode>$individualID</sourceaccessioncode> |
|
| 18 |
<stemobservation> |
|
| 19 |
<authorstemcode>$authorStemCode</authorstemcode> |
|
| 20 |
<diameterbreastheight_m><_cm_to_m><value>$diameterBreastHeight_cm</value></_cm_to_m></diameterbreastheight_m> |
|
| 21 |
</stemobservation> |
|
| 22 |
</plantobservation> |
|
| 23 |
</aggregateoccurrence> |
|
| 24 |
<sourceaccessioncode>$individualID</sourceaccessioncode> |
|
| 25 |
</taxonoccurrence> |
|
| 26 |
</locationevent> |
|
| 27 |
</locationevent> |
|
| 28 |
</location> |
|
| 29 |
</path> |
|
| 30 |
</_simplifyPath> |
|
| 31 |
</path> |
|
| 32 |
</_setDefault> |
|
| 33 |
</VegBIEN> |
|
| 34 |
Inserted 7 new rows into database |
|
Also available in: Unified diff
inputs/CTFS/*.src/: added test.xml.ref