| #!/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 | |
| # |
| 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() |
$ 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
| #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"; |
| 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; } }}' |
| #!/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' |
| # `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 *** |
| 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 |