Project

General

Profile

Revision 100e37d9

ID100e37d93b8a2f7b45073425cfedb6345a528501
Parent 321a37d1
Child 5aa29971

Added by Patrick Plitzner almost 4 years ago

ref #2380 Implement service for getting parent of
UuidAndTitleCache

  • parent of either ITaxonTree or UuidAndTitleCache can be retrieved
  • added JUnit test and test file

View differences:

cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/hibernate/taxon/TaxonNodeDaoHibernateImpl.java
147 147
        return list;
148 148
    }
149 149

  
150
    /**
151
     * {@inheritDoc}
152
     */
153
    @Override
154
    public UuidAndTitleCache<TaxonNode> getParentUuidAndTitleCache(UuidAndTitleCache<TaxonNode> child) {
155
        String queryString = "select tn.parent.uuid, tn.parent.id, tn.parent.taxon.titleCache, tn.parent.classification.titleCache "
156
                + " from TaxonNode tn"
157
                + " LEFT OUTER JOIN tn.parent.taxon"
158
                + " where tn.id = :childId";
159
        Query query =  getSession().createQuery(queryString);
160
        query.setParameter("childId", child.getId());
161
        List<UuidAndTitleCache<TaxonNode>> list = new ArrayList<>();
162

  
163
        List<Object[]> result = query.list();
164

  
165
        for(Object[] object : result){
166
            UUID uuid = (UUID) object[0];
167
            Integer id = (Integer) object[1];
168
            String taxonTitleCache = (String) object[2];
169
            String classificationTitleCache = (String) object[3];
170
            if(taxonTitleCache!=null){
171
                list.add(new UuidAndTitleCache<TaxonNode>(uuid,id, taxonTitleCache));
172
            }
173
            else{
174
                list.add(new UuidAndTitleCache<TaxonNode>(uuid,id, classificationTitleCache));
175
            }
176
        }
177
        if(list.size()==1){
178
            return list.iterator().next();
179
        }
180
        return null;
181
    }
182

  
150 183
    @Override
151 184
    public List<TaxonNode> listChildrenOf(TaxonNode node, Integer pageSize, Integer pageIndex, List<String> propertyPaths, boolean recursive){
152 185
    	if (recursive == true){
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/persistence/dao/taxon/ITaxonNodeDao.java
49 49
     */
50 50
    public List<UuidAndTitleCache<TaxonNode>> listChildNodesAsUuidAndTitleCache(UuidAndTitleCache<TaxonNode> parent);
51 51

  
52
    /**
53
     * Retrieves the parent node of the {@link TaxonNode} represented by the given {@link UuidAndTitleCache}.
54
     * @param child the child for which the parent should be retrieved
55
     * @return an UuidAndTitleCache object representing the parent node
56
     */
57
    public UuidAndTitleCache<TaxonNode> getParentUuidAndTitleCache(UuidAndTitleCache<TaxonNode> child);
58

  
52 59
    public List<TaxonNode> listChildrenOf(TaxonNode node, Integer pageSize, Integer pageIndex, List<String> propertyPaths, boolean recursive);
53 60

  
54 61
    public abstract Long countChildrenOf(TaxonNode node, Classification classification, boolean recursive);
cdmlib-services/src/main/java/eu/etaxonomy/cdm/api/service/ITaxonNodeService.java
55 55
	 */
56 56
	public List<UuidAndTitleCache<TaxonNode>> listChildNodesAsUuidAndTitleCache(UuidAndTitleCache<TaxonNode> parent);
57 57

  
58
    /**
59
     * Retrieves the parent node of the child {@link TaxonNode}
60
     * @param child the child for which the parent should be retrieved
61
     * @return the parent taxon node
62
     */
63
	public UuidAndTitleCache<TaxonNode> getParentUuidAndTitleCache(ITaxonTreeNode child);
64

  
65
	/**
66
     * Retrieves the parent node of the {@link TaxonNode} represented by the given {@link UuidAndTitleCache}.
67
     * @param child the child for which the parent should be retrieved
68
     * @return an UuidAndTitleCache object representing the parent node
69
     */
70
	public UuidAndTitleCache<TaxonNode> getParentUuidAndTitleCache(UuidAndTitleCache<TaxonNode> child);
71

  
58 72
	/**
59 73
     * Lists all direct child nodes of the given {@link ITaxonTreeNode}
60 74
     * @param parent the parent ITaxonTreeNode
cdmlib-services/src/main/java/eu/etaxonomy/cdm/api/service/TaxonNodeServiceImpl.java
101 101
     * {@inheritDoc}
102 102
     */
103 103
    @Override
104
    public UuidAndTitleCache<TaxonNode> getParentUuidAndTitleCache(ITaxonTreeNode child) {
105
        UUID uuid = child.getUuid();
106
        int id = child.getId();
107
        UuidAndTitleCache<TaxonNode> uuidAndTitleCache = new UuidAndTitleCache<TaxonNode>(uuid, id, null);
108
        return getParentUuidAndTitleCache(uuidAndTitleCache);
109
    }
110

  
111
    /**
112
     * {@inheritDoc}
113
     */
114
    @Override
115
    public UuidAndTitleCache<TaxonNode> getParentUuidAndTitleCache(UuidAndTitleCache<TaxonNode> child) {
116
        return dao.getParentUuidAndTitleCache(child);
117
    }
118

  
119
    /**
120
     * {@inheritDoc}
121
     */
122
    @Override
104 123
    public List<UuidAndTitleCache<TaxonNode>> listChildNodesAsUuidAndTitleCache(UuidAndTitleCache<TaxonNode> parent) {
105 124
        return dao.listChildNodesAsUuidAndTitleCache(parent);
106 125
    }
cdmlib-services/src/test/java/eu/etaxonomy/cdm/api/service/TaxonNodeServiceImplTest.java
667 667
        assertNotNull("child UuidAndTitleCache list is null", childNodesUuidAndTitleCache);
668 668

  
669 669
        compareChildren(expectedChildTaxonNodes, childNodesUuidAndTitleCache);
670

  
671
        //test taxon parent of sub species
672
        Taxon abiesAlbaSubBrota = HibernateProxyHelper.deproxy(taxonService.load(abiesAlbaSubBrotaUuid), Taxon.class);
673
        TaxonNode abiesAlbaSubBrotaNode = abiesAlbaSubBrota.getTaxonNodes().iterator().next();
674
        TaxonNode expectedTaxonParent = HibernateProxyHelper.deproxy(abiesAlbaSubBrotaNode.getParent(), TaxonNode.class);
675
        UuidAndTitleCache<TaxonNode> taxonParent = taxonNodeService.getParentUuidAndTitleCache(abiesAlbaSubBrotaNode);
676
        assertEquals("Taxon Nodes do not match. ", expectedTaxonParent.getUuid(), taxonParent.getUuid());
677
        assertEquals("Taxon Nodes do not match. ", (Integer)expectedTaxonParent.getId(), taxonParent.getId());
678
        assertEquals("Taxon Nodes do not match. ", expectedTaxonParent.getTaxon().getTitleCache(), taxonParent.getTitleCache());
679
        assertEquals("Taxon Nodes do not match. ", expectedTaxonParent, taxonNodeService.load(taxonParent.getUuid()));
680

  
681
        //test classification parent
682
        Taxon abies = HibernateProxyHelper.deproxy(taxonService.load(abiesUuid), Taxon.class);
683
        TaxonNode abiesNode = abies.getTaxonNodes().iterator().next();
684
        TaxonNode expectedClassificationParent = HibernateProxyHelper.deproxy(abiesNode.getParent(), TaxonNode.class);
685
        UuidAndTitleCache<TaxonNode> classificationParent= taxonNodeService.getParentUuidAndTitleCache(abiesNode);
686
        assertEquals("Taxon Nodes do not match. ", expectedClassificationParent.getUuid(), classificationParent.getUuid());
687
        assertEquals("Taxon Nodes do not match. ", (Integer)expectedClassificationParent.getId(), classificationParent.getId());
688
        assertEquals("Taxon Nodes do not match. ", expectedClassificationParent.getClassification().getTitleCache(), classificationParent.getTitleCache());
689
        assertEquals("Taxon Nodes do not match. ", expectedClassificationParent, taxonNodeService.load(classificationParent.getUuid()));
670 690
    }
671 691

  
672 692
    private void compareChildren(List<TaxonNode> expectedChildTaxonNodes, List<UuidAndTitleCache<TaxonNode>> childNodesUuidAndTitleCache){
......
727 747
        BotanicalName abiesName = BotanicalName.NewInstance(Rank.GENUS());
728 748
        abiesName.setGenusOrUninomial("Abies");
729 749
        Taxon abies = Taxon.NewInstance(abiesName, null);
750
        abies.setUuid(abiesUuid);
730 751

  
731 752
        BotanicalName abiesAlbaName = BotanicalName.NewInstance(Rank.SPECIES());
732 753
        abiesAlbaName.setGenusOrUninomial("Abies");
733 754
        abiesAlbaName.setSpecificEpithet("alba");
734 755
        Taxon abiesAlba = Taxon.NewInstance(abiesAlbaName, null);
756
        abiesAlba.setUuid(abiesAlbaUuid);
735 757

  
736 758
        BotanicalName abiesAlbaSubBrotaName = BotanicalName.NewInstance(Rank.SUBSPECIES());
737 759
        abiesAlbaSubBrotaName.setGenusOrUninomial("Abies");
738 760
        abiesAlbaSubBrotaName.setSpecificEpithet("alba");
739 761
        abiesAlbaSubBrotaName.setInfraSpecificEpithet("brota");
740 762
        Taxon abiesAlbaSubBrota = Taxon.NewInstance(abiesAlbaSubBrotaName, null);
763
        abiesAlbaSubBrota.setUuid(abiesAlbaSubBrotaUuid);
741 764

  
742 765
        BotanicalName abiesPalmaName = BotanicalName.NewInstance(Rank.SPECIES());
743 766
        abiesPalmaName.setGenusOrUninomial("Abies");
744 767
        abiesPalmaName.setSpecificEpithet("palma");
745 768
        Taxon abiesPalma = Taxon.NewInstance(abiesPalmaName, null);
769
        abiesPalma.setUuid(abiesPalmaUuid);
746 770

  
747 771
        BotanicalName pinusName = BotanicalName.NewInstance(Rank.GENUS());
748 772
        pinusName.setGenusOrUninomial("Pinus");
749 773
        Taxon pinus = Taxon.NewInstance(pinusName, null);
774
        pinus.setUuid(pinusUuid);
750 775

  
751 776
        checklist.addChildTaxon(abies, null, null);
752 777
        checklist.addParentChild(abies, abiesAlba, null, null);
cdmlib-services/src/test/resources/eu/etaxonomy/cdm/api/service/TaxonNodeServiceImplTest.testGetUuidAndTitleCacheHierarchy.xml
1
<?xml version='1.0' encoding='UTF-8'?>
2
<dataset>
3
  <TAXONBASE DTYPE="Taxon" ID="5000" CREATED="2016-10-25 16:13:05.0" UUID="f8306fd3-9825-41bf-94aa-a7b5790b553e" UPDATED="[null]" LSID_AUTHORITY="[null]" LSID_LSID="[null]" LSID_NAMESPACE="[null]" LSID_OBJECT="[null]" LSID_REVISION="[null]" SECMICROREFERENCE="[null]" PROTECTEDTITLECACHE="false" TITLECACHE="Abies sec. ???" APPENDEDPHRASE="[null]" DOUBTFUL="false" PUBLISH="true" USENAMECACHE="false" EXCLUDED="false" TAXONSTATUSUNKNOWN="false" TAXONOMICCHILDRENCOUNT="0" UNPLACED="false" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" NAME_ID="5000" SEC_ID="[null]" TAXONOMICPARENTCACHE_ID="[null]"/>
4
  <TAXONBASE DTYPE="Taxon" ID="5001" CREATED="2016-10-25 16:13:05.0" UUID="c70f76e5-2dcb-41c5-ae6f-d756e0a0fae0" UPDATED="[null]" LSID_AUTHORITY="[null]" LSID_LSID="[null]" LSID_NAMESPACE="[null]" LSID_OBJECT="[null]" LSID_REVISION="[null]" SECMICROREFERENCE="[null]" PROTECTEDTITLECACHE="false" TITLECACHE="Abies alba sec. ???" APPENDEDPHRASE="[null]" DOUBTFUL="false" PUBLISH="true" USENAMECACHE="false" EXCLUDED="false" TAXONSTATUSUNKNOWN="false" TAXONOMICCHILDRENCOUNT="0" UNPLACED="false" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" NAME_ID="5001" SEC_ID="[null]" TAXONOMICPARENTCACHE_ID="[null]"/>
5
  <TAXONBASE DTYPE="Taxon" ID="5002" CREATED="2016-10-25 16:13:05.0" UUID="06d58161-7707-44b5-b720-6c0eb916b37c" UPDATED="[null]" LSID_AUTHORITY="[null]" LSID_LSID="[null]" LSID_NAMESPACE="[null]" LSID_OBJECT="[null]" LSID_REVISION="[null]" SECMICROREFERENCE="[null]" PROTECTEDTITLECACHE="false" TITLECACHE="Abies alba subsp. brota sec. ???" APPENDEDPHRASE="[null]" DOUBTFUL="false" PUBLISH="true" USENAMECACHE="false" EXCLUDED="false" TAXONSTATUSUNKNOWN="false" TAXONOMICCHILDRENCOUNT="0" UNPLACED="false" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" NAME_ID="5002" SEC_ID="[null]" TAXONOMICPARENTCACHE_ID="[null]"/>
6
  <TAXONBASE DTYPE="Taxon" ID="5003" CREATED="2016-10-25 16:13:05.0" UUID="6dfd30dd-e589-493a-b66a-19c4cb374f92" UPDATED="[null]" LSID_AUTHORITY="[null]" LSID_LSID="[null]" LSID_NAMESPACE="[null]" LSID_OBJECT="[null]" LSID_REVISION="[null]" SECMICROREFERENCE="[null]" PROTECTEDTITLECACHE="false" TITLECACHE="Abies palma sec. ???" APPENDEDPHRASE="[null]" DOUBTFUL="false" PUBLISH="true" USENAMECACHE="false" EXCLUDED="false" TAXONSTATUSUNKNOWN="false" TAXONOMICCHILDRENCOUNT="0" UNPLACED="false" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" NAME_ID="5003" SEC_ID="[null]" TAXONOMICPARENTCACHE_ID="[null]"/>
7
  <TAXONBASE DTYPE="Taxon" ID="5004" CREATED="2016-10-25 16:13:05.0" UUID="5d8e8341-f5e9-4616-96cf-f0351dda42f4" UPDATED="[null]" LSID_AUTHORITY="[null]" LSID_LSID="[null]" LSID_NAMESPACE="[null]" LSID_OBJECT="[null]" LSID_REVISION="[null]" SECMICROREFERENCE="[null]" PROTECTEDTITLECACHE="false" TITLECACHE="Pinus sec. ???" APPENDEDPHRASE="[null]" DOUBTFUL="false" PUBLISH="true" USENAMECACHE="false" EXCLUDED="false" TAXONSTATUSUNKNOWN="false" TAXONOMICCHILDRENCOUNT="0" UNPLACED="false" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" NAME_ID="5004" SEC_ID="[null]" TAXONOMICPARENTCACHE_ID="[null]"/>
8
  <TAXONNAMEBASE DTYPE="BotanicalName" ID="5000" CREATED="2016-10-25 16:13:05.0" UUID="6042e52f-54a5-4a77-a45b-18104dbf1b7a" UPDATED="[null]" LSID_AUTHORITY="[null]" LSID_LSID="[null]" LSID_NAMESPACE="[null]" LSID_OBJECT="[null]" LSID_REVISION="[null]" PROTECTEDTITLECACHE="false" TITLECACHE="Abies" APPENDEDPHRASE="[null]" FULLTITLECACHE="Abies" NOMENCLATURALMICROREFERENCE="[null]" PARSINGPROBLEM="0" PROBLEMENDS="-1" PROBLEMSTARTS="-1" PROTECTEDFULLTITLECACHE="false" AUTHORSHIPCACHE="" BINOMHYBRID="false" GENUSORUNINOMIAL="Abies" HYBRIDFORMULA="false" INFRAGENERICEPITHET="[null]" INFRASPECIFICEPITHET="[null]" MONOMHYBRID="false" NAMECACHE="Abies" PROTECTEDAUTHORSHIPCACHE="false" PROTECTEDNAMECACHE="false" SPECIFICEPITHET="[null]" TRINOMHYBRID="false" NAMEAPPROBATION="[null]" SUBGENUSAUTHORSHIP="[null]" ANAMORPHIC="false" CULTIVARNAME="[null]" ACRONYM="[null]" BREED="[null]" ORIGINALPUBLICATIONYEAR="[null]" PUBLICATIONYEAR="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" HOMOTYPICALGROUP_ID="5000" NOMENCLATURALREFERENCE_ID="[null]" RANK_ID="774" BASIONYMAUTHORSHIP_ID="[null]" COMBINATIONAUTHORSHIP_ID="[null]" EXBASIONYMAUTHORSHIP_ID="[null]" EXCOMBINATIONAUTHORSHIP_ID="[null]"/>
9
  <TAXONNAMEBASE DTYPE="BotanicalName" ID="5001" CREATED="2016-10-25 16:13:05.0" UUID="163c51c4-cead-401a-9dfb-ca0b604d6a7c" UPDATED="[null]" LSID_AUTHORITY="[null]" LSID_LSID="[null]" LSID_NAMESPACE="[null]" LSID_OBJECT="[null]" LSID_REVISION="[null]" PROTECTEDTITLECACHE="false" TITLECACHE="Abies alba" APPENDEDPHRASE="[null]" FULLTITLECACHE="Abies alba" NOMENCLATURALMICROREFERENCE="[null]" PARSINGPROBLEM="0" PROBLEMENDS="-1" PROBLEMSTARTS="-1" PROTECTEDFULLTITLECACHE="false" AUTHORSHIPCACHE="" BINOMHYBRID="false" GENUSORUNINOMIAL="Abies" HYBRIDFORMULA="false" INFRAGENERICEPITHET="[null]" INFRASPECIFICEPITHET="[null]" MONOMHYBRID="false" NAMECACHE="Abies alba" PROTECTEDAUTHORSHIPCACHE="false" PROTECTEDNAMECACHE="false" SPECIFICEPITHET="alba" TRINOMHYBRID="false" NAMEAPPROBATION="[null]" SUBGENUSAUTHORSHIP="[null]" ANAMORPHIC="false" CULTIVARNAME="[null]" ACRONYM="[null]" BREED="[null]" ORIGINALPUBLICATIONYEAR="[null]" PUBLICATIONYEAR="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" HOMOTYPICALGROUP_ID="5001" NOMENCLATURALREFERENCE_ID="[null]" RANK_ID="765" BASIONYMAUTHORSHIP_ID="[null]" COMBINATIONAUTHORSHIP_ID="[null]" EXBASIONYMAUTHORSHIP_ID="[null]" EXCOMBINATIONAUTHORSHIP_ID="[null]"/>
10
  <TAXONNAMEBASE DTYPE="BotanicalName" ID="5002" CREATED="2016-10-25 16:13:05.0" UUID="f14cefff-06d6-47e1-bae1-0bf55f0e50e9" UPDATED="[null]" LSID_AUTHORITY="[null]" LSID_LSID="[null]" LSID_NAMESPACE="[null]" LSID_OBJECT="[null]" LSID_REVISION="[null]" PROTECTEDTITLECACHE="false" TITLECACHE="Abies alba subsp. brota" APPENDEDPHRASE="[null]" FULLTITLECACHE="Abies alba subsp. brota" NOMENCLATURALMICROREFERENCE="[null]" PARSINGPROBLEM="0" PROBLEMENDS="-1" PROBLEMSTARTS="-1" PROTECTEDFULLTITLECACHE="false" AUTHORSHIPCACHE="" BINOMHYBRID="false" GENUSORUNINOMIAL="Abies" HYBRIDFORMULA="false" INFRAGENERICEPITHET="[null]" INFRASPECIFICEPITHET="brota" MONOMHYBRID="false" NAMECACHE="Abies alba subsp. brota" PROTECTEDAUTHORSHIPCACHE="false" PROTECTEDNAMECACHE="false" SPECIFICEPITHET="alba" TRINOMHYBRID="false" NAMEAPPROBATION="[null]" SUBGENUSAUTHORSHIP="[null]" ANAMORPHIC="false" CULTIVARNAME="[null]" ACRONYM="[null]" BREED="[null]" ORIGINALPUBLICATIONYEAR="[null]" PUBLICATIONYEAR="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" HOMOTYPICALGROUP_ID="5002" NOMENCLATURALREFERENCE_ID="[null]" RANK_ID="763" BASIONYMAUTHORSHIP_ID="[null]" COMBINATIONAUTHORSHIP_ID="[null]" EXBASIONYMAUTHORSHIP_ID="[null]" EXCOMBINATIONAUTHORSHIP_ID="[null]"/>
11
  <TAXONNAMEBASE DTYPE="BotanicalName" ID="5003" CREATED="2016-10-25 16:13:05.0" UUID="fda2d071-2703-43a7-a433-9744b3dcac59" UPDATED="[null]" LSID_AUTHORITY="[null]" LSID_LSID="[null]" LSID_NAMESPACE="[null]" LSID_OBJECT="[null]" LSID_REVISION="[null]" PROTECTEDTITLECACHE="false" TITLECACHE="Abies palma" APPENDEDPHRASE="[null]" FULLTITLECACHE="Abies palma" NOMENCLATURALMICROREFERENCE="[null]" PARSINGPROBLEM="0" PROBLEMENDS="-1" PROBLEMSTARTS="-1" PROTECTEDFULLTITLECACHE="false" AUTHORSHIPCACHE="" BINOMHYBRID="false" GENUSORUNINOMIAL="Abies" HYBRIDFORMULA="false" INFRAGENERICEPITHET="[null]" INFRASPECIFICEPITHET="[null]" MONOMHYBRID="false" NAMECACHE="Abies palma" PROTECTEDAUTHORSHIPCACHE="false" PROTECTEDNAMECACHE="false" SPECIFICEPITHET="palma" TRINOMHYBRID="false" NAMEAPPROBATION="[null]" SUBGENUSAUTHORSHIP="[null]" ANAMORPHIC="false" CULTIVARNAME="[null]" ACRONYM="[null]" BREED="[null]" ORIGINALPUBLICATIONYEAR="[null]" PUBLICATIONYEAR="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" HOMOTYPICALGROUP_ID="5003" NOMENCLATURALREFERENCE_ID="[null]" RANK_ID="765" BASIONYMAUTHORSHIP_ID="[null]" COMBINATIONAUTHORSHIP_ID="[null]" EXBASIONYMAUTHORSHIP_ID="[null]" EXCOMBINATIONAUTHORSHIP_ID="[null]"/>
12
  <TAXONNAMEBASE DTYPE="BotanicalName" ID="5004" CREATED="2016-10-25 16:13:05.0" UUID="30fb69d6-fc94-4e83-bb38-8ab045425321" UPDATED="[null]" LSID_AUTHORITY="[null]" LSID_LSID="[null]" LSID_NAMESPACE="[null]" LSID_OBJECT="[null]" LSID_REVISION="[null]" PROTECTEDTITLECACHE="false" TITLECACHE="Pinus" APPENDEDPHRASE="[null]" FULLTITLECACHE="Pinus" NOMENCLATURALMICROREFERENCE="[null]" PARSINGPROBLEM="0" PROBLEMENDS="-1" PROBLEMSTARTS="-1" PROTECTEDFULLTITLECACHE="false" AUTHORSHIPCACHE="" BINOMHYBRID="false" GENUSORUNINOMIAL="Pinus" HYBRIDFORMULA="false" INFRAGENERICEPITHET="[null]" INFRASPECIFICEPITHET="[null]" MONOMHYBRID="false" NAMECACHE="Pinus" PROTECTEDAUTHORSHIPCACHE="false" PROTECTEDNAMECACHE="false" SPECIFICEPITHET="[null]" TRINOMHYBRID="false" NAMEAPPROBATION="[null]" SUBGENUSAUTHORSHIP="[null]" ANAMORPHIC="false" CULTIVARNAME="[null]" ACRONYM="[null]" BREED="[null]" ORIGINALPUBLICATIONYEAR="[null]" PUBLICATIONYEAR="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" HOMOTYPICALGROUP_ID="5004" NOMENCLATURALREFERENCE_ID="[null]" RANK_ID="774" BASIONYMAUTHORSHIP_ID="[null]" COMBINATIONAUTHORSHIP_ID="[null]" EXBASIONYMAUTHORSHIP_ID="[null]" EXCOMBINATIONAUTHORSHIP_ID="[null]"/>
13
  <HOMOTYPICALGROUP ID="5000" CREATED="2016-10-25 16:13:05.0" UUID="bdecb086-5b99-40dd-92ad-da0144bcc1df" UPDATED="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]"/>
14
  <HOMOTYPICALGROUP ID="5001" CREATED="2016-10-25 16:13:05.0" UUID="d65b2fe4-3278-4183-808c-ca28ccbc9549" UPDATED="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]"/>
15
  <HOMOTYPICALGROUP ID="5002" CREATED="2016-10-25 16:13:05.0" UUID="e6f44a24-367f-45a3-bc99-3fc822e757ac" UPDATED="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]"/>
16
  <HOMOTYPICALGROUP ID="5003" CREATED="2016-10-25 16:13:05.0" UUID="cff5b2d9-a537-449c-b45a-9527049ac7b2" UPDATED="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]"/>
17
  <HOMOTYPICALGROUP ID="5004" CREATED="2016-10-25 16:13:05.0" UUID="eccf90e0-fe60-4337-93fa-dca56ec3d1f6" UPDATED="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]"/>
18
  <CLASSIFICATION ID="5000" CREATED="2016-10-25 16:13:05.0" UUID="029b4c07-5903-4dcf-87e8-406ed0e0285f" UPDATED="2016-10-25 16:13:05.413" LSID_AUTHORITY="[null]" LSID_LSID="[null]" LSID_NAMESPACE="[null]" LSID_OBJECT="[null]" LSID_REVISION="[null]" PROTECTEDTITLECACHE="false" TITLECACHE="Checklist" MICROREFERENCE="[null]" TIMEPERIOD_START="[null]" TIMEPERIOD_FREETEXT="[null]" TIMEPERIOD_END="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" NAME_ID="5000" REFERENCE_ID="[null]" ROOTNODE_ID="5001"/>
19
  <TAXONNODE ID="5000" CREATED="2016-10-25 16:13:05.0" UUID="f686e39a-2aaf-47e3-a488-34e9e71d4540" UPDATED="[null]" SORTINDEX="0" TREEINDEX="#t5000#5001#5000#" COUNTCHILDREN="2" MICROREFERENCEFORPARENTCHILDRELATION="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" CLASSIFICATION_ID="5000" PARENT_ID="5001" REFERENCEFORPARENTCHILDRELATION_ID="[null]" SYNONYMTOBEUSED_ID="[null]" TAXON_ID="5000"/>
20
  <TAXONNODE ID="5001" CREATED="2016-10-25 16:13:05.0" UUID="adb86c10-8411-4b94-973e-813400343662" UPDATED="2016-10-25 16:13:05.414" SORTINDEX="-1" TREEINDEX="#t5000#5001#" COUNTCHILDREN="2" MICROREFERENCEFORPARENTCHILDRELATION="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" CLASSIFICATION_ID="5000" PARENT_ID="[null]" REFERENCEFORPARENTCHILDRELATION_ID="[null]" SYNONYMTOBEUSED_ID="[null]" TAXON_ID="[null]"/>
21
  <TAXONNODE ID="5002" CREATED="2016-10-25 16:13:05.0" UUID="e0c69b90-859d-439c-b958-4969ba329dc6" UPDATED="2016-10-25 16:13:05.415" SORTINDEX="0" TREEINDEX="#t5000#5001#5000#5002#" COUNTCHILDREN="1" MICROREFERENCEFORPARENTCHILDRELATION="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" CLASSIFICATION_ID="5000" PARENT_ID="5000" REFERENCEFORPARENTCHILDRELATION_ID="[null]" SYNONYMTOBEUSED_ID="[null]" TAXON_ID="5001"/>
22
  <TAXONNODE ID="5003" CREATED="2016-10-25 16:13:05.0" UUID="0e4187fe-4d26-43ed-bc49-b3f1525038b9" UPDATED="[null]" SORTINDEX="0" TREEINDEX="#t5000#5001#5000#5002#5003#" COUNTCHILDREN="0" MICROREFERENCEFORPARENTCHILDRELATION="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" CLASSIFICATION_ID="5000" PARENT_ID="5002" REFERENCEFORPARENTCHILDRELATION_ID="[null]" SYNONYMTOBEUSED_ID="[null]" TAXON_ID="5002"/>
23
  <TAXONNODE ID="5004" CREATED="2016-10-25 16:13:05.0" UUID="e8d081c7-1833-41d2-a7ee-b481d11178c2" UPDATED="2016-10-25 16:13:05.415" SORTINDEX="1" TREEINDEX="#t5000#5001#5000#5004#" COUNTCHILDREN="0" MICROREFERENCEFORPARENTCHILDRELATION="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" CLASSIFICATION_ID="5000" PARENT_ID="5000" REFERENCEFORPARENTCHILDRELATION_ID="[null]" SYNONYMTOBEUSED_ID="[null]" TAXON_ID="5003"/>
24
  <TAXONNODE ID="5005" CREATED="2016-10-25 16:13:05.0" UUID="5fff3711-fac9-4de9-81ce-84d0085ab561" UPDATED="2016-10-25 16:13:05.415" SORTINDEX="1" TREEINDEX="#t5000#5001#5005#" COUNTCHILDREN="0" MICROREFERENCEFORPARENTCHILDRELATION="[null]" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" CLASSIFICATION_ID="5000" PARENT_ID="5001" REFERENCEFORPARENTCHILDRELATION_ID="[null]" SYNONYMTOBEUSED_ID="[null]" TAXON_ID="5004"/>
25
  <LANGUAGESTRING ID="5000" CREATED="2016-10-25 16:13:05.0" UUID="7f7fb54b-759b-4453-9098-7abaa4179d1d" UPDATED="[null]" TEXT="Checklist" CREATEDBY_ID="[null]" UPDATEDBY_ID="[null]" LANGUAGE_ID="406"/>
26
  <HIBERNATE_SEQUENCES SEQUENCE_NAME="AuditEvent" NEXT_VAL="5003"/>
27
  <HIBERNATE_SEQUENCES SEQUENCE_NAME="CdmMetaData" NEXT_VAL="5003"/>
28
  <HIBERNATE_SEQUENCES SEQUENCE_NAME="Classification" NEXT_VAL="5001"/>
29
  <HIBERNATE_SEQUENCES SEQUENCE_NAME="GrantedAuthorityImpl" NEXT_VAL="5011"/>
30
  <HIBERNATE_SEQUENCES SEQUENCE_NAME="HomotypicalGroup" NEXT_VAL="5005"/>
31
  <HIBERNATE_SEQUENCES SEQUENCE_NAME="LanguageString" NEXT_VAL="5001"/>
32
  <HIBERNATE_SEQUENCES SEQUENCE_NAME="PermissionGroup" NEXT_VAL="5002"/>
33
  <HIBERNATE_SEQUENCES SEQUENCE_NAME="TaxonBase" NEXT_VAL="5005"/>
34
  <HIBERNATE_SEQUENCES SEQUENCE_NAME="TaxonNameBase" NEXT_VAL="5005"/>
35
  <HIBERNATE_SEQUENCES SEQUENCE_NAME="TaxonNode" NEXT_VAL="5006"/>
36
  <HIBERNATE_SEQUENCES SEQUENCE_NAME="UserAccount" NEXT_VAL="5001"/>
37
</dataset>

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)