iberianpig’s gists

iberianpig / character_set_and_collation.rb

Last active August 29, 2015 14:15

db/schemaを読み取って、default charset/collation, 既存DBのcharset/collationを変換するとき用。migrationファイルのchangeメソッドに使う。

	class ChangeCollationOption < ActiveRecord::Migration
	def up
	execute "ALTER TABLE access_counters DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"
	execute "ALTER TABLE access_counters CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"
	execute "ALTER TABLE access_tokens DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"
	execute "ALTER TABLE access_tokens CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"
	execute "ALTER TABLE activities DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"
	execute "ALTER TABLE activities CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"
	execute "ALTER TABLE admin_featured_users DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"
	execute "ALTER TABLE admin_featured_users CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;"

iberianpig / .ideavimrc

Created March 30, 2015 14:23

IdeaVIM用のキーマップ

iberianpig / hybrid-pantheon.sh

Last active May 15, 2019 18:33

hybrid-theme for pantheon-terminal

	#!/bin/bash -x

	# ====================CONFIG THIS =============================== #

	BACKGROUND_COLOR="#262626" # Background Color
	FOREGROUND_COLOR="#94a3a5" # Text
	COLOR_01="#282a2e" # HOST
	COLOR_03="#8C9440" # COMMAND
	COLOR_04="#de935f" # COMMAND_COLOR2
	COLOR_10="#cc6666" # COMMAND_ERROR

iberianpig / ec2_ssh.sh

Last active December 10, 2015 01:23

Connect to EC2 with adding/removing IP from Security Group

	#!/bin/sh

	if [ $# -lt 2 ]; then
	echo "give HOST(~/.ssh/config), GROUP_ID(sg-xxxx) [, PROFILE(~/.aws/config)] as arguments" 1>&2
	echo "$ ssh_ec2 Hostname sg-groupid default" 1>&2
	exit 1
	fi

	HOST=$1
	GROUP_ID=$2

iberianpig / id_hash.rb

Last active August 29, 2015 14:23

3桁"/"区切りのurlを生成する。paperclipで生成されるurlをidから作る。

	#NOTE: create id_hash for paperclip's url
	# e.g) photo_id = 14721; format("%09d", photo_id).split("").each_slice(3).map{ \|array\| array.join("") }.join("/")
	# # => "000/014/721"


	id_hash = format("%09d", photo_id).split("").each_slice(3).map{ \|array\| array.join("") }.join("/")

iberianpig / prepare-commit-msg

Last active August 29, 2015 14:23

ブランチ名がNUMBER_TITLEの時に、自動でコミットメッセージに[#NUMBER]を付与するフックスクリプト

	#!/bin/sh

	# set to repository/.git/hooks/prepare-commit-msg
	# chmod +x prepare-commit-msg

	COMMIT_EDITMSG=$1
	mv $COMMIT_EDITMSG $COMMIT_EDITMSG.tmp

	number=`git branch \| grep "" \| awk '{print $2}' \| sed -e "s/^$[0-9]$.*/\1/g"`
	msg=""

iberianpig / commit-msg

Created August 18, 2015 13:06

IssueID_xxxxなブランチ名の時に自動でコミットメッセージの先頭に[#IssueID]を付与するrubyスクリプト

	#!/usr/bin/env ruby
	message_file = ARGV[0]
	message = File.read(message_file, :encoding => Encoding::UTF_8)

	# remove prefix issue number like [#1234] from COMMIT_EDITMSG
	message = message.sub(/^\[#[0-9A-Za-z_].*\]/, "")

	# remove comment
	message = message.gsub(/^#(?! ------------------------ >8 ------------------------).*\n\|^\n/, "")

iberianpig / .cvimrc

Last active September 19, 2017 09:22

cvimrc

	" Settings
	set hud
	set smoothscroll
	"set noautofocus "The opposite of autofocus; this setting stops sites from focusing on an input box when they load
	set typelinkhints
	"chrome://extensions --> shortcut --> set ctrl+n as cvim's shortcut
	set cncpcompletion
	let searchlimit = 30
	let scrollstep = 150
	let barposition = "top"

iberianpig / image_optim

Last active May 21, 2016 21:59

image_optim option

	BASE = "image_optim"
	BASE_OPT = "--allow-lossy --recursive --no-progress"
	JPEG_OPT = "--jpegrecompress-quality 0 --jpegoptim-max-quality 60"
	PNG_OPT = "--no-pngout --no-pngcrush --no-optipng --no-advpng --pngquant-quality 20-40"
	OTHER_OPT = "--gifsicle-level 3 --gifsicle-careful true --no-svgo"


	image_optim ./* --allow-lossy --recursive --no-progress --jpegrecompress-quality 0 --jpegoptim-max-quality 60 --no-pngout --no-pngcrush --no-optipng --no-advpng --pngquant-quality 20-40 --gifsicle-level 3 --gifsicle-careful true --no-svgo

iberianpig / image_optim.sh

Created March 13, 2016 14:09

iamge_optimでカレントディレクトリ以下を圧縮するときのコマンド

	image_optim ./* \
	--allow-lossy --recursive --no-progress \
	--jpegrecompress-quality 0 --jpegoptim-max-quality 60 \
	--no-pngout --no-pngcrush --no-optipng --no-advpng \
	--pngquant-quality 20-40 \
	--gifsicle-level 3 --gifsicle-careful true --no-svgo

Kohei Yamada iberianpig