Skip to content

Instantly share code, notes, and snippets.

@suya55
suya55 / execute_groovy_jenkins_sample.groovy
Created May 25, 2020 04:50 — forked from rhuss/execute_groovy_jenkins_sample.groovy
How to execute some shell scripting on Groovy with environment variables and redirection
def exec(cmd) {
println cmd
def process = new ProcessBuilder([ "sh", "-c", cmd])
.directory(new File("/tmp"))
.redirectErrorStream(true)
.start()
process.outputStream.close()
process.inputStream.eachLine {println it}
process.waitFor();
return process.exitValue()
@suya55
suya55 / check_row_size.sh
Created April 16, 2020 13:27
mysql row size checker
#!/bin/bash
#
# usage: mysqldump --no-data | check_row_size.sh
#
#
#
# https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html#row-size-limits
#
@suya55
suya55 / rails_sql.md
Last active November 22, 2019 08:46
Rails select query 추출.
$ yum install cargo; cargo install sd
egrep '(SELECT|UPDATE)' production.log | awk -F']' '{ print $3 }'  | awk -F"ms)" '{ print $2 }' | sd "'[a-z0-9/ \.\-:]+'" '?'  | sd '= [0-9]+' '= ?'  | sd '[0-9]+ ?(, ?[0-9]+)+' '?' | sd '(, ?\?+)' '' | sd "'%.+%'" '?'  | sd 'LIMIT [0-9]+' 'LIMIT ?' | sd 'OFFSET [0-9]+' 'OFFSET ?'  | sort | uniq
@suya55
suya55 / co2.ino
Created July 26, 2019 05:03 — forked from gerald-kim/co2.ino
home air
#include "MHZ19.h" // include main library
#include "SoftwareSerial.h"
#include "EspMQTTClient.h"
#define RX_PIN D6 // Rx pin which the MHZ19 Tx pin is attached to
#define TX_PIN D7 // Tx pin which the MHZ19 Rx pin is attached to
#define BAUDRATE 9600
char* ID = "sensor_1";
String TOPIC = "sensors/sensor_1";
@suya55
suya55 / gist:d057f9880bb8273f3971c2a3f7f02ffe
Created June 5, 2019 06:18 — forked from khakimov/gist:3558086
Matrix Effect in you terminal
echo -e "\e[1;40m" ; clear ; while :; do echo $LINES $COLUMNS $(( $RANDOM % $COLUMNS)) $(( $RANDOM % 72 )) ;sleep 0.05; done|awk '{ letters="abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789@#$%^&*()"; c=$4; letter=substr(letters,c,1);a[$3]=0;for (x in a) {o=a[x];a[x]=a[x]+1; printf "\033[%s;%sH\033[2;32m%s",o,x,letter; printf "\033[%s;%sH\033[1;37m%s\033[0;0H",a[x],x,letter;if (a[x] >= $1) { a[x]=0; } }}'
@suya55
suya55 / git-clean-branches.sh
Last active February 13, 2019 04:46 — forked from asit-dhal/git-clean-local-branches
오래된 브랜치를 지우기 위한 스크립트. master, develop,HEAD은 제외됨. 자세한건 -h 로 확인.
#!/bin/bash
#
# Copyright(c) 2018 Asit Dhal.
# Distributed under the MIT License (http://opensource.org/licenses/MIT)
#
LIGHT_BLUE='\033[1;34m'
COLOR_YELLOW='\e[1;33m'
COLOR_CYAN='\e[0;36m'
COLOR_PURPLE='\e[0;35m'
@suya55
suya55 / nokogiri_install
Created August 1, 2018 10:01 — forked from sobstel/nokogiri_install
nokogiri -> ERROR: cannot discover where libxml2 is located on your system
# `ERROR: Error installing nokogiri:
# ERROR: Failed to build gem native extension.
#
# current directory: /usr/local/var/rbenv/versions/2.3.1/lib/ruby/gems/2.3.0/gems/nokogiri-1.7.0/ext/nokogiri
# /usr/local/var/rbenv/versions/2.3.1/bin/ruby -r ./siteconf20170103-68488-r71c9j.rb extconf.rb --with-xml=/usr/local/Cellar/libxml2/ --use-system-libraries
# checking if the C compiler accepts ... yes
# checking if the C compiler accepts -Wno-error=unused-command-line-argument-hard-error-in-future... no
# Building nokogiri using system libraries.
# ERROR: cannot discover where libxml2 is located on your system. please make sure `pkg-config` is installed.
# *** extconf.rb failed ***
@suya55
suya55 / test.rake
Created July 9, 2018 04:52
rspec by name
require 'open3'
namespace :test do
rule '' do |t|
# rake test:league
if /test:(.*)(:([^.]+))?$/.match(t.name)
arguments = t.name.split(':')[1..-1]
file_name = arguments.first
path = Dir["spec/**/*#{file_name}*_spec.rb"].join(' ')
unless path.strip.empty?
curl -#LO https://rvm.io/mpapis.asc
gpg --import mpapis.asc
curl -sSL https://get.rvm.io | bash -s stable --rails
source /usr/local/rvm/scripts/rvm
@suya55
suya55 / resume.md
Last active November 8, 2018 02:17
resume

김 성 수

WORK EXPERIENCE

카카오

  • 부서 : 게임사업부, 카카오톡부문, AI서비스개발
  • 근무 기간 : 2013년 4월 ~ 재직중