DrumRobot

set DRIVER="EPSON L6170 Series"
set IP=192.168.0.11
set PRINTER="EPSON L6170 Series"
@echo off
cd "C:\Windows\System32\Printing_Admin_Scripts\ko-KR"
Cscript Prnmngr.vbs -d -p %PRINTER%
Cscript Prnport.vbs -d -r IP_%IP%
Cscript Prnport.vbs -a -r IP_%IP% -h %IP% -o raw
Cscript Prnmngr.vbs -a -p %PRINTER% -m %DRIVER% -r IP_%IP%
Cscript Prnmngr.vbs -t -p %PRINTER%

DrumRobot

Fetch data via go-gecko

Go Generic features require version 1.18

# go 구버전이 설치된 상태에서 1.18버전 설치
go install golang.org/dl/go1.18.3@latest
~/go/bin/go1.18.3 download
ln -s ~/go/bin/go1.18.3 ~/bin/go # 또는 ~/bin/go.exe(윈10), PATH 우선순위가 기존 go 보다 높아야함

DrumRobot

TempFile=$(mktemp)
Version=$(dpkg -s google-chrome-stable | grep '^Version' | grep -o -E '[0-9.]+' | grep -m1 '.')
echo ${TempFile}
wget -O ${TempFile} https://chromedriver.storage.googleapis.com/${Version}/chromedriver_linux64.zip
unzip -u ${TempFile} -d ~/bin
rm ${TempFile}

DrumRobot

DROP PROCEDURE IF EXISTS modify_fk;
DELIMITER $$
CREATE PROCEDURE modify_fk (IN $table TEXT, IN $constraint TEXT, IN $column TEXT, IN $references TEXT)
BEGIN
  SET @st1 = CONCAT_WS(" ",
    "ALTER TABLE", $table,
    "DROP FOREIGN KEY", $constraint);
  PREPARE ncv_st1 FROM @st1;
  EXECUTE ncv_st1;