Skip to content

Instantly share code, notes, and snippets.

View nanasess's full-sized avatar
🍣
Sushi chef

Kentaro Ohkouchi nanasess

🍣
Sushi chef
41 followers · 47 following
View GitHub Profile
@nanasess
nanasess / gist:6025751
Last active December 19, 2015 22:09
mysqldump を使用して、 PostgreSQL で INSERT 可能な SQL を出力する
mysqldump5 --quick -c --user=username --password=password --skip-extended-insert sodastream_db tablename | grep INSERT | sed 's/`//g' | sed 's/\\"/"/g' | sed "s/\\\'/\'\'/g" | sed "s/'0000-00-00 00:00:00'/NULL/g" | perl -pe 's/\\r\\n/\r\n/g'
@nanasess
nanasess / file_upload.php
Created September 6, 2013 07:11
EC-CUBEファイルアップロードで tmpfile() を使う案
<?php
/**
* ファイルアップロードを行う.
*
* 以下のチェックを行い, ファイルを一時領域へアップロードする.
* 1. ファイルサイズチェック
* 2. 拡張子チェック
*
* ファイルアップロード後, 一時ファイルのファイルポインタを返す.
* アップロードに失敗した場合は, エラーメッセージを $this->arrErr に出力し, false を返す.
@nanasess
nanasess / config
Created October 2, 2013 01:00
multiple ssh connection ~/.ssh/config
Host target.host
ProxyCommand ssh -l user stepping.host nc %h %p
@nanasess
nanasess / solarized_light_itermcolor.xml
Created December 24, 2013 00:45
http://www.iterm2.com/hostedcolors/Solarized%20Light.itermcolors
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>Ansi 0 Color</key>
<dict>
<key>Blue Component</key>
<real>0.19370138645172119</real>
<key>Green Component</key>
<real>0.15575926005840302</real>
@nanasess
nanasess / gist:9022460
Created February 15, 2014 17:36
Example for jQuery.Deferrd()
var deferred = $.Deferred();
deferred
.then(function() {
var d = $.Deferred();
d.resolve();
return d;
})
.then(function() {
var d = $.Deferred();
@nanasess
nanasess / gist:9269850
Created February 28, 2014 11:55
example for map.
$(function() {
var $select = $('<select name="test" />');
var arr = [{'name':'Pizza'},{'name':'Pasta'},{'name':'Pizza2'}];
$select.append(arr.map(function(v, i, obj) {
return '<option value="' + i + '">' + v.name + '</option>';
}));
window.console.log($select);
});
@nanasess
nanasess / gist:10111224
Last active August 29, 2015 13:58
execute interval.
<?php
require_once("../../../require.php");
mb_http_output('pass');
header('Content-type: text/html');
$objWksConnMethod = new SC_WakasaConnectMethod();
$objWksConnMethod->setSalesClass($_POST["stype"]);
//$objWksConnMethod->parseXmlFlag = false;
//$objWksConnMethod->convertCharEncodeFlag = false;
@nanasess
nanasess / gist:10111849
Created April 8, 2014 11:28
jQuery.when()
$(function() {
var $message = $('#message');
$('#execute').click(function() {
var customer_ids = $('#customer_ids').val().split(/\n/);
var promises = [];
$.each(customer_ids, function(i, customer_id) {
var d = $.Deferred();
process(i, customer_id, $message, d);
promises.push(d);
})
@nanasess
nanasess / gist:10961450
Created April 17, 2014 07:38
INDEX of SQL Database for EC-CUBE
-- product_code を nvarchar(64) に変更しておくこと!
CREATE NONCLUSTERED INDEX product_category_category_id_idx ON [dbo].[dtb_product_categories] ([category_id]) INCLUDE ([product_id]);
CREATE NONCLUSTERED INDEX product_code_idx ON dtb_products_class (product_code) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX price01_idx ON dtb_products_class (price01) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX price02_idx ON dtb_products_class (price02) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX stock_idx ON dtb_products_class (stock) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX stock_unlimited_idx ON dtb_products_class (stock_unlimited) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX point_rate_idx ON dtb_products_class (point_rate) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX deliv_fee_idx ON dtb_products_class (deliv_fee) INCLUDE (product_id);
CREATE NONCLUSTERED INDEX product_id_idx ON dtb_products_class (product_id);
@nanasess
nanasess / file0.sh
Last active August 29, 2015 14:00
vi(vim) で文字エンコーディングを指定してファイルを開く ref: http://qiita.com/nanasess/items/d5e920137b29f2fcaa4f
vi -c ":e ++enc=euc-jp" filename