Project

General

Profile

task #7455

[Check] Check all markers for correctnes

Added by Andreas Müller 12 months ago. Updated about 2 months ago.

Status:
Resolved
Priority:
Highest
Category:
cdmadapter
Target version:
Start date:
06/07/2018
Due date:
% Done:

0%

Estimated time:
1.50 h
Severity:
normal
Tags:

Description

Check if all existing markers are still up-to-date with the current E+M import strategy.

SELECT flag, dtb.titleCache, count(*) as n
FROM Marker m INNEr JOIN DefinedTermBase dtb ON dtb.id = m.markerType_id 
GROUP BY flag, titleCache
ORDER BY n, titleCache, flag;

SELECT deb.DTYPE, deb.feature_id, dtb.titleCache
FROM DescriptionElementBase deb
 INNER JOIN DescriptionElementBase_Marker MN ON MN.DescriptionElementBase_id = deb.id
 INNER JOIN Marker m ON m.id = MN.markers_id
 INNEr JOIN DefinedTermBase dtb ON dtb.id = m.markerType_id 
 ORDER BY deb.DTYPE, dtb.titleCache

The most important decision is the publish flag on distributions. Is it needed?

picture714-1.png View (7.58 KB) Andreas Müller, 09/20/2018 07:18 PM

History

#1 Updated by Andreas Müller 12 months ago

  • Tags set to euro+med

#2 Updated by Andreas Müller 12 months ago

  • Estimated time set to 1.50 h

some interesting queries:

SELECT m.markerType_id, dtb.titleCache, count(*) as n
FROM Marker m 
INNER JOIN DefinedTermBase dtb ON dtb.id = m.markerType_id
GROUP BY m.markerType_id, dtb.titleCache
ORDER BY m.markerType_id

SELECT tb.publish, tb.titleCache, m.markerType_id, dtb.titleCache
FROM TaxonBase_Marker MN
INNER JOIN TaxonBase tb ON MN.TaxonBase_id = tb.id 
INNER JOIN Marker m ON m.id = MN.markers_id
INNER JOIN DefinedTermBase dtb ON dtb.id = m.markerType_id
ORDER BY m.markerType_id

SELECT m.markerType_id, dtb.titleCache
FROM DescriptionElementBase_Marker MN 
INNER JOIN Marker m ON m.id = MN.markers_id
INNER JOIN DefinedTermBase dtb ON dtb.id = m.markerType_id
GROUP BY m.markerType_id, dtb.titleCache
ORDER BY m.markerType_id

#3 Updated by Andreas Müller 12 months ago

  • Category changed from cdmlib to cdmadapter

#4 Updated by Andreas Müller 8 months ago

  • Status changed from New to In Progress
  • Priority changed from New to Highest

#5 Updated by Andreas Müller 8 months ago

  • Description updated (diff)

#6 Updated by Andreas Müller 8 months ago

  • Description updated (diff)

#7 Updated by Andreas Müller 8 months ago

#10 Updated by Andreas Müller 8 months ago

  • Priority changed from Highest to Priority14

The publish flag (=false) is related to distributions with no status in BM. This is handled now in #2764 and #4822

#11 Updated by Andreas Müller 8 months ago

  • Subject changed from E+M: Check all markers for correctnes to [Check] Check all markers for correctnes

#12 Updated by Andreas Müller 8 months ago

  • Priority changed from Priority14 to Highest

#13 Updated by Andreas Müller about 2 months ago

  • Status changed from In Progress to Resolved

After import we should still check if need those markers with small count. Therefore do not close completely.

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)