Steg 2
Skapa översättningsfil
Gå till katalogen där hidesense-core är installerat. Kopiera filen load_employees.dump till den katalogen. Skapa översättningsfilen med följande innehåll:
{
"rules": [
{
"name": "Empoyees-lastName",
"fieldSeparator": ",",
"terminatedBy": ";",
"start": " VALUES",
"groupStop": ")",
"end": ";",
"groupStart": "(",
"groupSeparator": ",",
"mandatory": "INSERT INTO `employees`",
"quotation": "'",
"escape": "\\",
"compoundLinesBytesLimit": "100000",
"fieldNumber": "4",
"to": "${value}",
"type": "DbColumnSubstituter",
"substituter": {
"name": "LIST LASTNAMES",
"from": "'(.*)'",
"groupNumber": "1",
"to": "${value}",
"file": "files\\enamn.txt",
"type": "ListSubstituter"
}
},
{
"name": "Empoyees-firtsName",
"fieldSeparator": ",",
"terminatedBy": ";",
"start": " VALUES",
"groupStop": ")",
"end": ";",
"groupStart": "(",
"groupSeparator": ",",
"mandatory": "INSERT INTO `employees`",
"quotation": "'",
"escape": "\\",
"compoundLinesBytesLimit": "100000",
"fieldNumber": "3",
"to": "${value}",
"type": "DbColumnSubstituter",
"substituter": {
"name": "LIST FIRSTNAMES",
"from": "'(.*)'",
"groupNumber": "1",
"to": "${value}",
"file": "files\\fnamn.txt",
"type": "ListSubstituter"
}
},
{
"name": "Employees-birthDate",
"fieldSeparator": ",",
"terminatedBy": ";",
"start": " VALUES",
"groupStop": ")",
"end": ";",
"groupStart": "(",
"groupSeparator": ",",
"mandatory": "INSERT INTO `employees`",
"quotation": "'",
"escape": "\\",
"compoundLinesBytesLimit": "100000",
"fieldNumber": "2",
"to": "${value}",
"type": "DbColumnSubstituter",
"substituter": {
"name": "Datum",
"stopOnNoSubstitution": "false",
"unique": "false",
"valueNotEqualToKey": "false",
"surrounding": "(\\D|^)${from}(\\D|$)",
"format": "yyyy-MM-dd",
"random.high": "200",
"random.low": "-100",
"from": "\\d{4}-(0|1)\\d-[0-3]\\d",
"type": "DateSubstituter"
}
}
]
}
Notera att files/fnamn.txt och files/enamn.txt måste finnas och innehålla förnamn respektive efternamn. Ett namn per rad. Spara översättningsfilen med namn employees.properties. Kör översättningen genom följande kommando.
$ java -jar hidesense-core.jar -c employees.properties -n db load_employees.dump
Undersök den filtrerade dump-filen så att den inte innehåller några namn. Den översatta filen sparas nu under logs/oppen/load_employees.filtered.dump. Spara original-filen load_employees.dump cd till katalogen där dump-filerna finns.
mv load_employees.dump load_employees.dump.original
cp ……../logs/oppen/load_employees.filtered.dump load_employees.dump