Home

Some admin commands

List failed

xquery doc('pending-geokrety.xml')/gkxml/errors
xquery count(doc('pending-geokrety.xml')/gkxml/errors/geokret)

Show sync queue

xquery doc('pending-geokrety.xml')/gkxml/geokrety
xquery count(doc('pending-geokrety.xml')/gkxml/geokrety/geokret)

Integrity checks

No missing

xquery doc('geokrety.xml')//geokret[@missing=""]
xquery count(doc('geokrety.xml')//geokret[@missing=""])

No ownername

xquery doc('geokrety.xml')//geokret[not(@ownername)]
xquery count(doc('geokrety.xml')//geokret[not(@ownername)])

Repairs

Reprocess errors

xquery for $i in doc('pending-geokrety.xml')/gkxml/errors/geokret return (insert node $i as last into doc('pending-geokrety.xml')/gkxml/geokrety, delete node $i)

Force missing in geokrety from geokrety-details

xquery let $db := doc('geokrety-details.xml')/gkxml/geokrety/geokret return for $a in doc('geokrety.xml')/gkxml/geokrety/geokret return replace value of node $a/@missing with $db[@id=$a/@id]/missing/string()

Reprocess ALL

xquery for $i in doc('geokrety.xml')/gkxml/geokrety/geokret return insert node $i as last into doc('pending-geokrety.xml')/gkxml/geokrety
xquery delete node doc('pending-geokrety.xml')//geokret/@date