Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P11280
zarcillo-add
Archived
Public
Actions
Authored by
Kormat
on May 22 2020, 9:00 AM.
Edit Paste
Activate Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F31836769: raw.txt
May 22 2020, 9:00 AM
2020-05-22 09:00:45 (UTC+0)
Subscribers
None
#!/bin/bash
if
[
$#
-eq
0
]
;
then
echo
"Usage:"
echo
"
${
0
##*/
}
FQDN PORT RACK SECTION [SECTION ..]"
exit
0
fi
fqdn
=
${
1
:?
}
;
shift
port
=
${
1
:?
}
;
shift
rack
=
${
1
:?
}
;
shift
sections
=
"
$@
"
hostname
=
${
fqdn
%%.*
}
name
=
$hostname
[
$port
-eq
3306
]
||
name
=
$hostname
:
$port
dc
=
$(
echo
$fqdn
|
cut -f2 -d.
)
set
-exu
{
echo
"START TRANSACTION;"
echo
"INSERT INTO instances (name, server, port) VALUES ('
$name
', '
$fqdn
',
$port
);"
echo
"INSERT INTO servers (fqdn, hostname, dc, rack) VALUES ('
$fqdn
', '
$hostname
', '
$dc
', '
$rack
');"
for
i in
$sections
;
do
echo
"INSERT INTO section_instances (instance, section) VALUES ('
$name
', '
$i
');"
done
echo
"COMMIT;"
}
|
sudo -i mysql.py -BE -h db2093 zarcillo
Event Timeline
Kormat
created this paste.
May 22 2020, 9:00 AM
2020-05-22 09:00:45 (UTC+0)
Kormat
archived this paste.
Sep 23 2020, 12:48 PM
2020-09-23 12:48:56 (UTC+0)
Log In to Comment