Skip to content

Instantly share code, notes, and snippets.

View k12u's full-sized avatar
🏠
Working from home

Minoru KAWAMOTO k12u

🏠
Working from home
28 followers · 43 following
View GitHub Profile
@k12u
k12u / switch_branch
Created August 9, 2011 12:05
svn switch helper
#!/usr/bin/perl
use strict;
#use warnings;
use Getopt::Std;
my $svn_info = `svn info|grep URL`;
die "not http repository: $svn_info" unless $svn_info =~ /^URL: https?.+$/sm;
die "trunk/branches directory not found in svn info: $svn_info" unless $svn_info =~ m#^URL: https?.+/(branches|tags|trunk)#sm;
@k12u
k12u / make_branch
Created August 9, 2011 12:06
svn copy helper
#!/usr/bin/perl
use strict;
use warnings;
use Getopt::Std;
my %opts;
Getopt::Std::getopts('b:t:', \%opts);
@k12u
k12u / list_branch
Created August 9, 2011 12:06
svn ls helper
#!/usr/bin/perl
use strict;
#use warnings;
use Getopt::Std;
my $svn_info = `svn info|grep URL`;
die "not http repository: $svn_info" unless $svn_info =~ /^URL: https?.+$/sm;
die "trunk/branches directory not found in svn info: $svn_info" unless $svn_info =~ m#^URL: https?.+/(branches|tags|trunk)#sm;
@k12u
k12u / term.txt
Created August 10, 2011 05:02
mysql: 意外な挙動
mysql> show create table m\G
*************************** 1. row ***************************
Table: m
Create Table: CREATE TABLE `m` (
`id` int(11) NOT NULL,
`status` varchar(64) DEFAULT NULL,
`value` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
@k12u
k12u / gist:1162161
Created August 22, 2011 11:20
ログインセッションの SSH_AUTH_SOCKを 取得する (macのcrontabからssh)
$ ps -ef -E |grep ssh-a[g]ent | perl -lne 'm/SSH_AUTH_SOCK=([^ ]+)/;print $1'
/tmp/launch-aaaaaa/Listeners
@k12u
k12u / memo
Created December 21, 2011 13:49
partial mysqldump
$ mysqldump -t -n --compact -hdbserver -uuser_id \
db_name table_name -w 'row_id = 111'
--
-- Not dumping tablespaces as no INFORMATION_SCHEMA.FILES (ry
--
INSERT INTO `table_name` VALUES (111,0,0,0);
@k12u
k12u / memo
Created December 21, 2011 13:50
partial mysqldump2
# dbserver から new_serverへのコピー
$ mysqldump -t -n --compact -hdbserver -uuser_id \
db_name table_name -w 'row_id = 111' \
| mysql -hnew_server -uuser_id
@k12u
k12u / sh
Created December 22, 2011 12:59
Test::mysqld のmysqlにつなぐときにいちいち x $mysqld しなくてもよかったかもしれない
mysql -uroot dbname -S `ls -1t /var/folders/*/*/-TMP-/*/tmp/mysql.sock |head -1`
@k12u
k12u / gist:10449594
Last active August 29, 2015 13:59
つらい
[vagrant@localhost setup]$ gem install chef --version 11.10
ERROR: While executing gem ... (Gem::RemoteFetcher::FetchError)
bad response Service Unavailable 503 (https://api.rubygems.org/api/v1/dependencies?gems=highline)
[vagrant@localhost setup]$ gem install chef --version 11.10
^CERROR: Interrupted
[vagrant@localhost setup]$ gem install chef --version 11.10
ERROR: While executing gem ... (Gem::RemoteFetcher::FetchError)
bad response Service Unavailable 503 (https://api.rubygems.org/api/v1/dependencies?gems=puma)
[vagrant@localhost setup]$ gem install chef --version 11.10
@k12u
k12u / Vagrantfile
Last active August 29, 2015 14:00
VAGRANTFILE_API_VERSION = "2"
Vagrant.configure(VAGRANTFILE_API_VERSION) do |config|
config.vm.box = "base"
config.vm.box_url = "http://opscode-vm-bento.s3.amazonaws.com/vagrant/virtualbox/opscode_centos-6.5_chef-provisionerless.box"
config.vm.network "forwarded_port", guest: 80, host: 8080
config.vm.network "private_network", ip: "192.168.33.10"
config.vm.synced_folder ".", "/var/www/html"