#!/bin/bash


insert()
{
DB="$1"
ACRONYM="$2"
URL="$3"

#CREATE TABLE `interwiki` (
#  `iw_prefix` varbinary(32) NOT NULL,
#  `iw_url` blob NOT NULL,
#  `iw_local` tinyint(1) NOT NULL,
#  `iw_trans` tinyint(4) NOT NULL DEFAULT '0',
#  `iw_api` blob NOT NULL,
#  `iw_wikiid` varbinary(64) NOT NULL,
#  UNIQUE KEY `iw_prefix` (`iw_prefix`)
#)

#echo "---process " $DB $ACRONYM $URL

mysql -uroot -pver1amt $DB <<END_TEXT
LOCK TABLES interwiki WRITE;
DELETE FROM interwiki WHERE iw_prefix = '$ACRONYM';
INSERT INTO interwiki VALUES ('$ACRONYM','$URL',1,1,'','');
UNLOCK TABLES;
END_TEXT

}



WIKIS=`mysqlshow -uroot -pver1amt | fgrep _12 | sed "s/|//g" `
echo "Wikis=$WIKIS"

#################################################################################
for db in $WIKIS
do
echo "------------------- process $db -------------------"

#      database acronym       url
insert $db      mantis        'http://leup-mantis01.lmsintl.com/view.php?id=$1'
insert $db      notes         'Notes://LEUP-DOMINO01b/$1'
insert $db      area51        'http://info.net.plm.eds.com/area51/$1'
insert $db      autonomiewiki 'http://info.net.plm.eds.com/autonomiewiki/$1'
insert $db      autonomie     'http://info.net.plm.eds.com/autonomiewiki/$1'
insert $db      cswiki        'http://info.net.plm.eds.com/cswiki/$1'
insert $db      farm          'http://info.net.plm.eds.com/farm/$1'
insert $db      g2mwiki       'http://info.net.plm.eds.com/g2mwiki/$1'
insert $db      ilwiki        'http://info.net.plm.eds.com/ilwiki/$1'
insert $db      lmscorporate  'http://info.net.plm.eds.com/lmscorporate/$1'
insert $db      lmswiki       'http://info.net.plm.eds.com/lmscorporate/$1'
insert $db      nxcaewiki     'http://info.net.plm.eds.com/nxcaewiki/$1'
insert $db      rwiki         'http://info.net.plm.eds.com/rwiki/$1'
insert $db      samtechwiki   'http://info.net.plm.eds.com/samtechwiki/$1'
insert $db      systemsynthesiswiki     'http://info.net.plm.eds.com/systemsynthesiswiki/$1'
insert $db      tlwiki        'http://info.net.plm.eds.com/tlwiki/$1'
insert $db      twwiki        'http://info.net.plm.eds.com/twwiki/$1'
insert $db      vlwiki        'http://info.net.plm.eds.com/vlwiki/$1'
insert $db      tac           'https://webtac.industrysoftware.automation.siemens.com/webpr/webpr.php?objtype=shortcut&startlink=view&startdata=$1&startoption'
insert $DB      wikipedia     'http://en.wikipedia.org/w/index.php?title=$1'
insert $DB      jira          'http://hq-srv28.lmsintl.com:8080/browse/$1'

done

exit

echo "------------------> $db <--------------------"
mysql -uroot -pver1amt $db < defineinterwiki.sql

done