= Assignments for fixing bugs 596, 688, and 785 =
[[https://gforge.statsbiblioteket.dk/tracker/index.php?func=detail&aid=596&group_id=7&atid=105|Bug 596: domains are treated case-sensitive]] (JIRA: https://sbforge.org/jira/browse/NAS-1315)

[[https://gforge.statsbiblioteket.dk/tracker/index.php?func=detail&aid=688&group_id=7&atid=105|Bug 688: hosts-report should be IDNA decoded when writing harvestInfo to the DB]] (JIRA: https://sbforge.org/jira/browse/NAS-1316)

[[https://gforge.statsbiblioteket.dk/tracker/index.php?func=detail&aid=785&group_id=7&atid=105|Bug 785: invalid domains in PROD system]] (JIRA: https://sbforge.org/jira/browse/NAS-1322)

These bugs are all related to how domains are ingested, and represented in the DB, and should be fixed at the same time,  and bug 785 should be fixed first of all.

== Assignment A - Remove invalid domains from the DB (bug 785) ==
Subtasks:

 * A.1: Find a list of invalid domains (identified with id) by examining a copy of the Production-database (1-2 MD)
 * A.2: Make a script deletedomain.sh that given an id of a domain deletes every entry related to this domain. This script more or less already exists:
{{{
#!/bin/bash
DOMAIN=$1
if [ -z "$DOMAIN" ]; then
    echo "Must give domain id as argument"
    exit 1
fi
echo "Note: Some warnings will probably appear."
java org.apache.derby.tools.ij <<EOF
connect 'jdbc:derby:fullhddb';
delete from job_configs where config_id in ( select config_id from configurations where domain_id = '$DOMAIN' ) ;
delete from harvest_configs where config_id in ( select config_id from configurations where domain_id = '$DOMAIN' ) ;
delete from job_configs where config_id in ( select config_id from configurations where domain_id = '$DOMAIN' ) ;
delete from config_passwords where config_id in ( select config_id from configurations where domain_id = '$DOMAIN' ) ;
delete from config_seedlists where config_id in ( select config_id from configurations where domain_id = '$DOMAIN' ) ;
delete from historyinfo where config_id in ( select config_id from configurations where domain_id = '$DOMAIN' ) ;
delete from seedlists where domain_id='$DOMAIN'  ;
delete from passwords where domain_id='$DOMAIN'  ;
delete from ownerinfo where domain_id='$DOMAIN'  ;
delete from configurations where domain_id='$DOMAIN';
delete from domains where domain_id='$DOMAIN';
EOF
}}}