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 / MysqldumpslowResult2Csv.php
Last active October 12, 2016 01:32 — forked from rysk92/MysqldumpslowResult2Csv.php
mysqldumpslow to csv for MySQL 5.5
<?php
#how to use, mysqldumpslow mysql-slow.log > hoge
# php MysqldumpslowResult2Csv hoge > hoge.csv
$log_filename = $argv[1];
echo 'SQL, Count, Time, Time(total), Lock, Lock(total), Rows_sent, Rows_sent(total), Rows_examined, Rows_examined(totao), Src'."\n";
if (file_exists($log_filename))
{
$contents = file_get_contents($log_filename);
@nanasess
nanasess / plugin_load_timer.patch
Created October 5, 2016 09:57
プラグインロードの時間計測
diff --git a/src/Eccube/Application.php b/src/Eccube/Application.php
index a32eb1b..f6f103a 100644
--- a/src/Eccube/Application.php
+++ b/src/Eccube/Application.php
@@ -114,17 +114,27 @@ class Application extends ApplicationTrait
return;
}
+ $start = microtime(true);
// init locale
@nanasess
nanasess / product.json
Last active September 29, 2016 12:13
EC-CUBE API の JSON フォーマット例
{
"product": {
"id": "...snip",
"id": 1,
"name": "ディナーフォーク",
"description_list": null,
"ProductCategories": "...snip",
"ProductCategories": "プロパティがコレクションの場合は, キー情報のみの配列を返す",
"ProductCategories": [
{
@nanasess
nanasess / parseConfigBench.php
Created August 22, 2016 05:17
benchmark of YamlParse vs PHP array
<?php
require __DIR__.'/../autoload.php';
$app = \Eccube\Application::getInstance(array('output_config_php' => false));
$start = microtime(true);
for ($i = 0; $i < 1000; $i++) {
$configAll = array();
$app->parseConfig('constant', $configAll)
@nanasess
nanasess / YamlDrive.php.patch
Last active August 10, 2016 07:01
YamlDriver.php patch for Doctrine ORM 2.4
--- ./vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/YamlDriver.php.orig 2015-08-31 22:19:01.000000000 +0900
+++ ./vendor/doctrine/orm/lib/Doctrine/ORM/Mapping/Driver/YamlDriver.php 2016-08-04 15:06:37.603199820 +0900
@@ -709,6 +709,6 @@
*/
protected function loadMappingFile($file)
{
- return Yaml::parse($file);
+ return Yaml::parse(file_get_contents($file));
}
}
@nanasess
nanasess / DbalSessionHandler.php
Created July 28, 2016 08:46
[Expeirmental] DbalSessionHandler of reconnected
<?php
/*
* This file is part of the Symfony package.
*
* (c) Fabien Potencier <[email protected]>
*
* For the full copyright and license information, please view the LICENSE
* file that was distributed with this source code.
*/
@nanasess
nanasess / webapi-beta.md
Last active June 22, 2016 11:25
EC-CUBE Web API ベータ版定義について
  • EC-CUBEプラグインとして実装
  • PHP5.4～7.0にて動作確認
  • PostgreSQL9.2, MySQL5.5, SQLite3 にて動作確認
  • 全テーブルの CRUD が可能なこと
    • DELETE は del_flg が存在するテーブルのみ
    • public アクセス可能なテーブル, Customer 認証時に参照/更新可能なテーブル、 フィールドは別途定める
    • API定義は、テーブル構成に依存する
    • パスワード等、暗号化されるデータは変換しない
  • パフォーマンスは考慮しない
  • 試験的な実装のため、正式リリースまでに仕様が変更される可能性あり
@nanasess
nanasess / Bar.java
Created June 19, 2016 03:44
Use BeanUtils
/*
* $Id$
*/
package net.nanasess.examples;
import java.sql.Timestamp;
/**
* Bar クラス.
*
* @author Kentaro Ohkouchi
* @version $Revision$ $Date$
@nanasess
nanasess / example.js
Created June 7, 2016 15:51
JavaScript スケルトン
/* -*- mode: js2 -*- */
;(function($, window, document, undefined) {
var com = {};
com.example = function() {};
com.example.prototype = {
someMethod: function() {
console.log('some-method');
},
foobarMethod: function() {
console.log('foobar-method');
@nanasess
nanasess / product_class_price.patch
Created June 7, 2016 05:09
EC-CUBE2.13 規格ごとに価格を表示するパッチ
diff --git a/data/Smarty/templates/default/products/list.tpl b/data/Smarty/templates/default/products/list.tpl
index a2b8e3d..8cc72ac 100644
--- a/data/Smarty/templates/default/products/list.tpl
+++ b/data/Smarty/templates/default/products/list.tpl
@@ -197,6 +197,13 @@
<!--▼買い物カゴ-->
<div class="cart_area clearfix">
+ <!--{if $tpl_classcat_find1[$id]}-->
+ <!--{foreach from=$classCategory1[$id] item=classcate}-->