Docker コンテナ㧠MySQL を使ã£ãŸãƒ†ã‚¹ãƒˆã®é«˜é€ŸåŒ– - stfuawsc
全国1å„„2000万㮠Docker ファンã®çš†ã•ã‚“ã“ã‚“ã«ã¡ã¯ã€‚ MySQL ã®èµ·å‹•ãŒã¨ã¦ã¤ã‚‚ãªãé…ã„ã®ã¯æœ‰åãªè©±ã€‚ ã¨ã“ã‚㌠Docker コンテナã®èµ·å‹•ã¯ãªã‹ãªã‹æ—©ã„ã®ã§ã€ MySQL を使ã£ã¦ã„るよã†ãªãƒ†ã‚¹ãƒˆã‚’高速化ã™ã‚‹ã‚±ãƒ¼ã‚¹ã§æœ‰ç”¨æ€§ãŒèªã‚られるã®ã§ã¯ãªã„ã‹ã¨æ€ã£ã¦ PoC を書ã„ã¦ã¿ãŸã€‚ （宣ä¼ï¼‰ã“ã†ã„ã£ãŸè©±ã‚‚å«ã‚㦠YAPC ã§ãƒˆãƒ¼ã‚¯ã—ãŸã„ã®ã§ SNS ç‰ã§ upvote ãŠé¡˜ã„ã—ã¾ã™ï¼š ( ✌'ω')✌ 楽ã—ã„モデル層開発 - YAPC::Asia Tokyo 2014 （宣ä¼ãŠã‚り） MySQL を使ã£ãŸãƒ†ã‚¹ãƒˆ MySQL を使ã£ãŸãƒ†ã‚¹ãƒˆã‚’ã™ã‚‹å ´åˆã€ã ã„ãŸã„次㮠2 パターンã«ãªã‚‹ã€‚ MySQL をテストã®ãŸã³ã«èµ·å‹•ã—ã¦ã‚¯ãƒªãƒ¼ãƒ³ãªçŠ¶æ…‹ã§ä½¿ã† ãƒãƒ¼ã‚«ãƒ«ã«ãƒ‡ãƒ¼ãƒ¢ãƒ³ã¨ã—ã¦èµ·å‹•ã—㟠MySQL ã«æŽ¥ç¶šã—㦠DROP TABLE ã‚„ TRUNCATE ã§ã‚¯ãƒªãƒ¼ãƒ³ãªçŠ¶æ…‹ã«ã—ã¦ä½¿ã† ã ã‘ã©ã€
MySQL::Partition has been released! | ãŠãらãã¯ãã‚Œã•ãˆã‚‚平凡ãªæ—¥ã€…
MySQL::Partitionをリリースã—ã¦ã„ãŸã®ã§ãŠçŸ¥ã‚‰ã›ã§ã™ã€‚パーティションを切る用ã®SQLを生æˆã—ã¦ãれるクエリビルダーã§ã™ã€‚ Webサービスã§ã¯å¦‚何ã«ãƒ‡ãƒ¼ã‚¿ã‚’増やã•ãªã„ã‹ã€DBを分割ã—ãªã„ã§ä¸€ç³»çµ±ã«æŠ‘ãˆã‚‹ã‹ã€DBをメモリã«å¦‚何ã«è¼‰ã›ãã‚‹ã‹ã£ã¦ã®ãŒã‚†ã‚‹ãµã‚サービスé‹ç”¨ã‚’ã—ã¦ã„ã上ã§é‡è¦ã§ã™ã€‚MySQLを使ã£ã¦ã„ã‚‹å ´åˆã€ãã®ãŸã‚ã«éžå¸¸ã«æœ‰ç”¨ãªã®ãŒãƒ‘ーティションã§ã€é©åˆ‡ã«ãƒ‘ーティションを切りã€å¤ã„データをéšæ™‚Dropã—ã¦ã„ã‘ã‚‹é‹ç”¨ã«è½ã¨ã—ã“ã‚€ã®ãŒéžå¸¸ã«å¤§åˆ‡ãªã‚ã‘ã§ã™ã€‚ 社内ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã‚‚Partitionを活用ã—ã¦ã„ã‚‹ã‚ã‘ã§ã™ãŒã€ã„ã¾ã„ã¡ä»•çµ„ã¿åŒ–ã•ã‚Œã¦ãŠã‚‰ãšã€å¤ã„プãƒã‚¸ã‚§ã‚¯ãƒˆã‹ã‚‰ã‚³ãƒ”ペをé‡ãã¦ç§˜ä¼ã®ã‚¿ãƒ¬åŒ–ã—ã¦ãŠã‚Šã€ä¾‹ãˆã°ãƒ‡ã‚¤ãƒªãƒ¼ã§ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã‚’åˆ‡ã‚‹å ´åˆã€MySQL5.5ã‹ã‚‰ã¯RANGE COLUMNSパーティションãŒä½¿ãˆã‚‹ã«ã‚‚é–¢ã‚らãšã€TO_DAYS()ã¨ã‹ã‚’未ã ã«ã‚³ãƒ”ペã—ã¦ä½¿ã„
SQL::Translator::Diffã§DBスã‚ーマã«è¿½å¾“ã•ã›ã‚‹æ–¹æ³• - ã™ãŽã‚ƒãƒ¼ã‚“メモ
#5「GitDDLã¾ã˜ã‚¤ãƒŽãƒ™ãƒ¼ãƒ†ã‚£ãƒ–〠tech.kayac.com Advent Calendar 2012 | tech.kayac.com - KAYAC engineers' blog ãŒä¾¿åˆ©ãã†ã ãªãƒ¼ã¨æ€ã£ã¦ã€‚ ã§ã‚‚Gitã¨çµ¡ã‚ãªãã¦ã‚‚ã€Webアプリã«ãŠã„ã¦ã€Œç¾åœ¨ã®ç’°å¢ƒã§ä½¿ç”¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ã¨ã€Œæœ‰ã‚‹ã¹ãスã‚ーマã®çŠ¶æ…‹ã‚’示ã™DDLファイルã€ã®å·®åˆ†ã‚’å–ã£ã¦åŸ‹ã‚ã‚‹ã“ã¨ãŒã§ãã‚Œã°ãã‚Œã ã‘ã§å分使ãˆã‚‹æ°—ãŒã™ã‚‹ã€ã¨æ€ã£ã¦ä¸€ã¤ã®é‹ç”¨æ–¹æ³•ã‚’考ãˆã¦ã¿ãŸã€‚ ã‚‚ã¡ã‚ã‚“GitDDL使ã£ã¦ã‚‚良ã„ã®ã ã‘ã©ã€SQL::Translatorを使ã†ã ã‘ã§ã‚‚ã‚る程度ã¯ã€ã¨ã„ã†ã“ã¨ã§ã€‚ Amon2プãƒã‚¸ã‚§ã‚¯ãƒˆã®ä¾‹ã§ã€‚ åˆæœŸè¨å®š $ amon2-setup.pl MyAppã¨ã‹ã§é››å½¢ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’作るã¨ã€sqlディレクトリãŒä½œã‚‰ã‚Œã¦ã€ãã“ã«DDLã‚’ä¿å˜ã™ã‚‹é›°å›²æ°—ã«ãªã‚‹ã€‚ãã®ã¾ã¾sql/mysql.sqlを使ã£ã¦ã„ãã“
DBD::mysqlã®DBI->connect()ã§å°‘ã—嵌る - 開発ã‚ã‚‚ï¼’
環境 ubuntu lampp perl DBI DBD::mysql perl㧠DBI->connect()ã—よã†ã¨ã—ãŸã‚‰ failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at insert.pl line 11 ã¨ã„ã†ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã¦è»½ãã¤ã¾ã£ãŸã€‚ 多ãã®äººãŒ 「DBIã§Can't connect to local MySQL server through socket '/tmp/mysql.sock'〠http://diary.lampetty.net/20060926.html ã«ã¦è§£æ±ºã—ã¦ã‚‹ãŒã€è‡ªåˆ†ã¯ãƒ€ãƒ¡ã ã£ãŸã€‚ my.cnfを書ãç›´ã—ã¦ã‚‚〠perlã®å‡ºåŠ›ã™ã‚‹ã‚¨ãƒ©ãƒ¼ã¯ä¾ç„¶ã¨ã—㦠failed: Can't connect to l
ãŠãらãã¯ãã‚Œã•ãˆã‚‚平凡ãªæ—¥ã€…: carton execã§Test::mysqldãŒèµ·å‹•ã§ããªãã¦æ³£ã„ãŸ
% carton exec -Ilib — prove -lv t/mysqld.t *** mysqlinstalldb failed *** Can’t locate lib/core/only.pm in @INC (… çµè«–ã‹ã‚‰è¨€ã†ã¨ã€carton execã—ãŸperlã¨åˆ¥ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®perlãŒã©ã“ã‹ã§ä½¿ã‚ã‚Œã¦ã€ ãã®Perlã«local::lib(lib::core::only)ãŒå…¥ã£ã¦ã„ãªã„ã¨æ»ã¬ã€‚ Test::mysqldã ã¨ã€mysql_install_dbã£ã¦ã„ã†MySQLã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ã‚ックã—ã¦ã„ã‚‹ ã‚“ã ã‘ã©ã€ãã‚ŒãŒå®Ÿã¯perlスクリプトã§ã€/usr/bin/perlã£ã¦shebangã«æ›¸ã‹ã‚Œã¦ã„㦠System perlå‰æã«ã—ã¦ã„ã‚‹ã®ã ã‘ã©ã€ãã‚Œã«local::libãŒå…¥ã£ã¦ã„ãªã„ã¨ã‚³ã‚±ã‚‹ã€‚ Carton:CLI#cmd_execã®ä¸ã§PERL5OPTを以下ã®ã‚ˆã†ã«ã‚»
DBIã®ãƒ—レースホルダーã§èµ·ã“ã£ãŸè¬ŽãªæŒ™å‹• - $shibayu36->blog;
先日DBIを使ã£ã¦ã„ã¦ã€è¬ŽãªæŒ™å‹•ã«éé‡ã—ãŸã®ã§æ›¸ã„ã¦ã¿ã‚‹ã€‚LIMIT, OFFSETå¥ã§ãƒ—レースホルダーを用ã„ãŸæ™‚ã«èµ·ã“ã£ãŸã€‚DBI + DBD::mysqlを使ã£ã¦ã„ãŸã€‚ DBI: 1.616 DBD::mysql: 4.022 LIMITã¨OFFSETを両方ã«ãƒ—レースホルダーを使ㆠLIMITã¨OFFSETを両方を?ã«ã™ã‚‹ã®ã¯ã†ã¾ãã„ã。 $res = $dbh->prepare_cached(q[ SELECT * FROM user WHERE name = ? LIMIT ? OFFSET ? ])->execute('shiba_yu36', 1, 1); LIMITã®ã¿ãƒ—レースホルダー LIMITã®ã¿?ã§ã‚‚ã†ã¾ãã„ã。 $res = $dbh->prepare_cached(q[ SELECT * FROM user WHERE name = ? LIMIT ? OFFSET
Nagios 㨠derived ã§MySQLã®ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã®é‡ã‚’監視ã™ã‚‹ - blog.nomadscafe.jp
æ–°ã—ã„機能をリリースã—ãŸéš›ã«ã€MySQLã«å¯¾ã—ã¦åŠ¹çŽ‡çš„ã§ã¯ãªã„クエリãŒç™ºè¡Œã•ã‚Œã¦ã—ã¾ã£ã¦ã€ãã‚ŒãŒç©ã‚‚ã£ã¦ã‚µãƒ¼ãƒ“ス全体ã«å½±éŸ¿ãŒå‡ºã¦ã—ã¾ã†å‰ã«ç™ºè¦‹ã—ã¦ã‚¢ãƒ©ãƒ¼ãƒˆã‚’ã‚ã’ãŸã„。 発見ã™ã‚‹æ‰‹ç«‹ã¦ã¨ã—ã¦ã¯CPU使用率やInnoDBã®ROW OPERATIONSãŒè€ƒãˆã‚‰ã‚Œã‚‹ã¨ã“ã‚ã§ã™ãŒã€ä»Šå›žã¯ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãŒç™ºç”Ÿã—ãŸå›žæ•°ã‚’監視ã™ã‚‹ã“ã¨ã«ã—ãŸã€‚ã¡ãªã¿ã«ã„ã¤ã‚‚ã®ã“ã¨ãªãŒã‚‰å¯¾è±¡ã¨ã™ã‚‹MySQLã¯4.0系。long_query_timeãŒã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§å¤‰æ›´ã§ãã¾ã›ã‚“。。。ã¯ã„ MySQLã®ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãŒç™ºç”Ÿã—ãŸå›žæ•°ã¯ã€show status ã®Slow_queriesã¨ã„ã†é …ç›®ã§ã¿ã‚‹ã“ã¨ãŒã§ã㦠mysql> show status like 'Slow_queries'; +---------------+-------+ | Variable_name | Value | +---------------+---
Test::mysqld + perl -d を使ã†ã¨ SQLãŒãã®ã¾ã¾å©ã‘ã¦ä¾¿åˆ© - k12uã®ã‚¢ãƒ¬
id:zigorou 先生ã«æ•™ãˆã¦ã‚‚らã£ãŸæŠ€ã‚’メモ。 (ã‚ã¨ã§èª¿ã¹ã¦ã¿ãŸã‚‰ http://perl-users.jp/articles/advent-calendar/2010/hacker/1 ã§ã™ã§ã«è¨€åŠã•ã‚Œã¦ã„ã¾ã—ãŸãŒã€SQLå©ã‘ã‚‹ã¨ã„ã†ã¨ã“ã‚ã ã‘強調ã—ã¦å†æŽ²) ã¾ãšãƒ†ã‚¹ãƒˆã‚’用æ„ã—ã¾ã™ã€‚ [kawamoto.m@mm1:~]$ cat 01.t use Test::More; use Test::mysqld; my $mysqld = Test::mysqld->new( my_cnf => { 'skip-networking' => '', # no TCP socket } ) or plan skip_all => $Test::mysqld::errstr; ok(1); done_testing;perl -d ã§testを走らã›ã¾ã™ã€‚ [kawamoto.m@mm1:
DBI->connect 時ã«ä½¿ã†é‰„æ¿ã‚ªãƒ—ションを教ãˆã¦ï¼ - blog.nomadscafe.jp
perlã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’使ã†æ™‚ã«èª°ã‚‚ãŒå¿…ãšä½¿ã†DBI。ãã®æŽ¥ç¶šæ™‚ã«ä½¿ã†connectメソッドã®ç¬¬4引数ã«è¨å®šã—ã¦ã„るオプションãŒã‚µãƒ¼ãƒ“スã«ã‚ˆã‚Šã¾ã¡ã¾ã¡ãªã‚“ã ã‘ã©ã€ã ã‚Œã‹é‰„æ¿è¨å®šã‚’æ•™ãˆã¦ãã ã•ã„。 僕ãŒä½¿ã†ã®ãŒã€ my $dbh = DBI->connect($dsn, $user, $password, { AutoCommit => 1, PrintError => 0, RaiseError => 1, ShowErrorStatement => 1, AutoInactiveDestroy => 1, }); ã“れ。 åŠ ãˆã¦ã€mysqlã§ã‚れ㰠mysql_enable_utf8 => 1 mysql_auto_reconnect => 0, SQLiteã 㨠sqlite_unicode => 1 sqlite_use_immediate_transaction => 1 ã‚’è¿½åŠ ã—
テストã®ãŸã‚ã«ãƒ‡ãƒ¼ãƒ¢ãƒ³ã‚’自動的ã«èµ·å‹•ã™ã‚‹ã‚„ã‚Šã‹ãŸ2011年版 - Articles Advent Calendar 2011 Test
ã¯ã˜ã¾ã‚Šã¯ãƒ‘クり 最近ã‚ã‚“ã¾ã‚Šã‚³ãƒ¼ãƒ‰æ›¸ã„ã¦ã¾ã›ã‚“ã€lestrratã§ã™ã€‚ テストを走らã›ã‚‹æ™‚ã«ã„ã‚ã‚“ãªä»–ã®ãƒ‡ãƒ¼ãƒ¢ãƒ³ã‚’ç«‹ã¡ä¸Šã’ãŸã‚Šã€ãã®ãƒ†ã‚¹ãƒˆã®ãŸã‚ã ã‘ã®è¨å®šã‚’å…ˆã«ã—ãªã„ã¨ã„ã‘ãªã‹ã£ãŸã‚Šã¨ã‹è‰²ã€…ã‚ã‚Šã¾ã™ã‚ˆã。çµæ§‹é•·ã„é–“Makefile.PLã¯Module::Installã§æ›¸ã„ã¦ã„ãŸã›ã„ã‚‚ã‚ã£ã¦ã€ã¡ã‚‡ã£ã¨å‰ã«xaicronã•ã‚“ãŒæ›¸ã„ã¦ãŸModule::Install::TestTargetã§ã”ã«ã‚‡ã”ã«ã‚‡ã‚„ã£ã¦ãŸã®ã§ã™ãŒã€ã¡ã‚‡ã£ã¨å‰ã«Yappo/tokuhiromã•ã‚“ãŒproveã§æ›¸ã„ã¦ãŸã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãŒã¾ã‚‹ã£ã¨è‡ªåˆ†ã®æ¬²ã—ã„用途ã«ã‚‚使ãˆã‚‹äº‹ã«æ°—ã¥ã„ãŸã®ã§ã„ã‚ã‚“ãªã‚¢ãƒ—リケーションã®ãƒ†ã‚¹ãƒˆã‚’ãã®ã‚ˆã†ã«å¤‰ãˆã¦ã¿ã¾ã—ãŸã€‚ æµã‚Œ proveã§ãƒ†ã‚¹ãƒˆã‚’ã™ã‚‹ã¨ã€proveã®ãƒ—ラグインを呼ã³å‡ºã™è¨å®šãŒã§ãã‚‹ã®ã§ã™ãŒã€ã“れをプラグインã¨ã„ã†ã‚ˆã‚Šãƒ†ã‚¹ãƒˆå‰ã«å®Ÿè¡Œã•ã‚Œã‚‹ãƒ•ãƒƒã‚¯ã¨ã—ã¦åˆ©ç”¨ã™ã‚‹äº‹ã«ã‚ˆã£ã¦ä»»æ„ã®è¨å®šç”¨ã®ã‚³ãƒ¼ãƒ‰
Testing Web Application 2011秋 - tokuhirom's blog
ã¨ã«ã‹ã楽ã«ã€ãŠæ°—軽ã«ã€‚ãŠæ°—軽ã«ãƒ†ã‚¹ãƒˆã‚’è¿½åŠ ã§ãã¦ã€ãŠæ°—軽ã«ãƒ†ã‚¹ãƒˆã‚’実行ã§ãる。ã¨ã„ã†ã®ãŒãªã«ã‚ˆã‚Šã‚‚é‡è¦ã§ã™ã€‚ è¿½åŠ ã—よã†ã¨ãŠã‚‚ã£ãŸã¨ãã«ã€Œã©ã†è¿½åŠ ã—ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã„ã€ã¨ã„ã†çŠ¶æ³ã«ãªã‚ŠãŒã¡ãªã®ã§ã€ã‚らã‹ã˜ã‚ã„ã‚ã„ã‚ãªæ§‹æˆè¦ç´ ã”ã¨ã«ãƒ†ã‚¹ãƒˆã‚’ã²ã¨ã¨ãŠã‚Šã‹ã„ã¦ã¿ã‚‹ã¨ã„ã†ã®ã‚‚é‡è¦ã ã¨ãŠã‚‚ã„ã¾ã™ã€‚O/R Mapper ã®ã‚¯ãƒ©ã‚¹ã®ãƒ†ã‚¹ãƒˆã¨ã‹ã€model ã®ãƒ†ã‚¹ãƒˆã¨ã‹ã€ã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ©ã®ãƒ†ã‚¹ãƒˆã¨ã‹ã€JSON API ã®ãƒ†ã‚¹ãƒˆã¨ã‹ã€‚。 ExtUtils::MakeMaker ã§ãƒ†ã‚¹ãƒˆã‚’ã†ã”ã‹ã•ãªã„ExtUtils::MakeMaker ã‚’ç´ ã§ã¤ã‹ã†ã¨ blib/ ã¨ã‹ã¤ã‹ã£ã¦ãã¦ã†ã–ã„ã®ã§ã€Makefile.PL ã«ä»¥ä¸‹ã®ã‚ˆã†ãª hack ã‚’ã»ã©ã“ã—ã¦ã‚ã‚Šã¾ã™ã€‚ウェブアプリケーション㧠blib/ ã¨ã‹ã«ã‚³ãƒ”ーã™ã‚‹å¿…è¦ãªã„ã§ã™ã‚ˆã。実é‹ç”¨ã§ã‚‚ blib/ ã§ã†ã”ã‹ã•ãªã„ã—ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚‚ã—ã¾ã›ã‚“ã—。 #
Test::mysqldã¨ã‹ã§ãƒ†ã‚¹ãƒˆèµ°ã‚‰ã›ã‚‹æ™‚ã«éš›è¡Œã£ãŸã„ã‚ã‚“ãªäº‹ã€‚ - D-6 [相変ã‚らãšæ ¹ç„¡ã—]
Test::mysqldã¨ã‹ã§ãƒ†ã‚¹ãƒˆèµ°ã‚‰ã›ã‚‹æ™‚ã«éš›è¡Œã£ãŸã„ã‚ã‚“ãªäº‹ã€‚ Test::mysqldを使ã†ã¨ã‚¯ãƒ¼ãƒ«ã«MySQLã‚’èµ·å‹•ã•ã›ã‚‰ã‚Œã‚‹ã®ã§ã€ãれを使ãŠã†ã¨ã—ãŸã‚“ã 。ã§ã‚‚ãŠã„らã®ãƒãƒ¼ã‚«ãƒ«ã«ã‚ã‚‹mysqlã‚’MacPortsã®mysqlã§ã€ãƒ•ã‚¡ã‚¤ãƒ«ãƒ¬ã‚¤ã‚¢ã‚¦ãƒˆãŒãƒ¡ã‚¿ãƒ¡ã‚¿ãªã‚“ã 。ã ã‹ã‚‰ã¾ãšã“ã‚“ãªæ„Ÿã˜ã§ã€Test::mysqldを継承ã™ã‚‹MyApp::Test::mysqldを書ã„ãŸã‚ã‘ã•ï¼ å¿…è¦ã¨ã‚ã‚Œã°MacPortsã¨ã‹ã®ç’°å¢ƒã˜ã‚ƒãªãã¦ã‚‚MYSQL_INSTALL_DBã¨MYSQLDã‚’è¨å®šã™ã‚Œã°ãƒ†ã‚¹ãƒˆæ™‚ã«Test::mysqldãŒè¦‹ã‚‹ãƒã‚¤ãƒŠãƒªã‚’変更ã§ãã‚‹ã®ãŒãƒŸã‚½ã ãï¼ ã•ã¦ã€ã“れを使ã£ã¦ã‚‚ã€ä½•å€‹ã‚‚テストスクリプトãŒã‚る時ã«ä¸€å›žä¸€å›žmysqlã‚’ç«‹ã¡ä¸Šã’ç›´ã—ã¦ã¡ã‚ƒæ„味ãŒãªã„。é…ã„ã—ã€æ¯Žå›žDBã®è¨å®šã‚’ã—ãªãã¡ã‚ƒã„ã‘ãªã„ã˜ã‚ƒãªã„ã‹ï¼ ã ã‚‚ã‚“ã§ã€ã¾ãšmake testãŒèµ°ã‚‹ã¨ãã«å‰ã‚‚ã£ã¦Test::mys
DBD::mysql 4.020ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—㟠| ã¸ã¼ã„日記
DBD::mysqlã®4.020ãŒæ˜¨æ—¥ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸã€‚ ã“ã®ãƒªãƒªãƒ¼ã‚¹ã«ã¯mysql_server_prepare=1を使ã£ã¦ã„ã‚‹å ´åˆã®ãƒã‚°ã®ä¿®æ£ãŒ5件ã»ã©å«ã¾ã‚Œã¦ã„ã¾ã™ã€‚(ChangeLog) DBD::mysql 㧠mysql_server_prepare=1 ã®ã¨ã TEXT åž‹ã®æ¬„ãŒè‡ªå‹• utf8::decode ã•ã‚Œãªããªã‚‹ ã“ã¡ã‚‰ã®ãƒ–ãƒã‚°ã§æŒ‡æ‘˜ã•ã‚Œã¦ã„ãŸä»¶ã‚’ç›´ã—ã¦ãƒ‘ッãƒã‚’é€ã‚ã†ã¨æ€ã£ã¦ãŠã‚‚ã‚€ã‚ã«mysql_server_prepare=1ã®çŠ¶æ…‹ã§DBD::mysqlã®ãƒ†ã‚¹ãƒˆã‚’実行ã—ãŸã‚‰å¤±æ•—ã—ã¾ãã£ãŸãŸã‚ã€ã‚‚ã†é§„ç›®ã‹ã‚‚ã—ã‚Œãªã„ã¨æ€ã£ãŸã®ã§ã™ãŒã€ä½•æ•…ã‹mysql_server_prepareã¨å¿ƒä¸ã™ã‚‹è…¹ã‚’ããり一応ã™ã¹ã¦ã®ãƒ†ã‚¹ãƒˆã‚’通ã™ã‚ˆã†ã«ãƒ‘ッãƒã‚’é€ã‚Šã¾ãã£ã¦ã¿ãŸã¨ã“ã‚å–ã‚Šè¾¼ã¾ã‚ŒãŸã¨ã„ã†æ„Ÿã˜ã«ãªã‚Šã¾ã—ãŸã€‚(リリース後ã«2ã¤ã»ã©ã•ã‚‰ã«pull reqã—ã¦ã„ã¾ã™ãŒâ€¦ã€‚) TEXTåž‹
DBIx::Skinny::Pager - walf443's blog
DBIx::Skinnyã§ç°¡å˜ã«ä½¿ãˆã‚‹pagerãŒå®Ÿè£…ã•ã‚Œã¦ã„ãªã„主ãªç†ç”±ã¯ã€ http://perl-users.jp/articles/advent-calendar/2009/dbix-skinny/19.html ã¨ã‹ã«æ›¸ã„ã¦ã„ã‚‹ã‚“ã§ã™ãŒã€ 管ç†ç”»é¢ã«ã‚ã‚ŠãŒã¡ãª データを様々ãªæ¡ä»¶ã§æ¤œç´¢ã™ã‚‹ãƒšãƒ¼ã‚¸ã¿ãŸã„ãªã®ã‚’書ãã¨ãã«ã¯SQLを直書ãã™ã‚‹ã®ã¯ã¤ã‚‰ãã¦ã€DBICã¿ãŸã„ã«resultsetã‚’æ¡ä»¶ã«ã‚ˆã£ã¦whereç¯€ã‚’è¿½åŠ ã™ã‚‹ã®ãŒæ¥½ãªã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ãã†ã„ã†ãƒšãƒ¼ã‚¸ã«é™ã£ã¦pagingã®å‡¦ç†ã¯å¿…è¦ã«ãªã‚‹ã‘ã©ã€ã²ã¨ã¤ã²ã¨ã¤SQLを直接書ã„ã¦Pagerを生æˆã™ã‚‹ã¨ã‹ãªã£ã¦ãã‚‹ã¨ãªã‹ãªã‹ã‚ã‚“ã©ãã•ã„ã§ã™ã€‚ http://d.hatena.ne.jp/nekokak/20090924/1253761408 ã¨ã‹ã„ã†ã®ã‚’selectã™ã‚‹ãŸã³ã«æ›¸ã„ã¦ã‚‹ã¨ã€ã¡ã‚‡ã£ã¨ã”ã¡ã‚ƒã”ã¡ã‚ƒã—ã¦è¦‹ã«ãã„ã—ã€çµæ§‹é•·ãã¦
Test::mysqld を別ウィンドウã§ç«‹ã¡ä¸Šã’ãŸã‚‰é–‹ç™ºæ™‚ã® prove ãŒå¿«é©éŽãŽã‚‹ä»¶ - Craftworks Tech Blog - Branch
id:xaicron æ°ãŒç´¹ä»‹ãªã•ã‚Œã¦ã„ã¾ã—㟠make test 㧠Test::mysqld を永続化ã•ã›ã‚‹æ–¹æ³• を早速導入ã—ã¦ã„ãŸã®ã§ã™ãŒã€make test ã¯é€Ÿããªã£ã¦ä¾¿åˆ©ãªã®ã§ã™ãŒã€prove 㧠1 ã¤ãšã¤ãƒ†ã‚¹ãƒˆã‚’ã™ã‚‹ã¨ãã¯ã€ç›¸å¤‰ã‚ら㚠mysqld を毎回ã€èµ·å‹•ãƒ»çµ‚了ã™ã‚‹ã®ã§æ™‚é–“ãŒã‹ã‹ã£ã¦é–‹ç™ºæ™‚ã®ã‚¹ãƒˆãƒ¬ã‚¹ã«ãªã‚Šã¾ã™ã€‚ ãã“ã§ã€é–‹ç™ºæ™‚ã«ã¯åˆ¥ã‚¦ã‚£ãƒ³ãƒ‰ã‚¦ã§ mysqld ã‚’ç«‹ã¡ä¸Šã’ã¦ãŠã„ã¦ã€ãã“ã«æŽ¥ç¶šã—ã«è¡Œãよã†ã«ã™ã‚Œã°å¤§åˆ†å¿«é©ã«ãªã‚‹ã¨æ€ã„ã€å®Ÿè£…ã—ã¦ã¿ã¾ã—ãŸã€‚ #!/usr/bin/env perl use strict; use warnings; use FindBin; use lib "$FindBin::Bin/../lib"; use File::Spec; use JSON; use Test::MyApp::mysqld; my $tempfile = File:
ã«ã²ã‚Šãšã‚€::ã—ã‚“ã·ã‚‹ - make test 㧠Test::mysqld を永続化ã•ã›ã‚‹æ–¹æ³•
実際ã«ã©ã†ã‚„ã£ã¦ã‚“ã®ã‹ãªãƒ¼ã£ã¦è©±ã‚’ã‚ã‚“ã¾ã‚Šã—ã¦ãªã‹ã£ãŸã®ã§ã€‚ ã¾ãšã€ã“ã‚“ãªæ„Ÿã˜ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ t/lib/Test/MyApp/mysqld.pm ã¨ã‹ã§ä½œã£ã¦ M::I::TestTarget ã® default_test_target() 㧠`make test` を書ãæ›ãˆã¦ã‚„ã‚Šã€t/script/setup_mysqld.pl ã« ã¨ã‹æ›¸ã„ã¦ã‚ã’ã¾ã™ã€‚ ãã‚Œãžã‚Œã®ãƒ†ã‚¹ãƒˆã§ã¯ã€Test::MyApp::mysqld->setup 㧠mysqld ã‚’ç«‹ã¡ä¸Šã’るよã†ã«ã—ã¦ç½®ã‘ã°ã€ prove ã§å€‹åˆ¥ã«ã‚„ã£ãŸæ™‚ã¯ã€ãã‚Œãžã‚Œç«‹ã¡ä¸ŠãŒã‚‹ make test ã—ãŸã¨ãã¯ã€æœ€åˆã«ç«‹ã¡ä¸Šã’ã¦ã€ã‚ã¨ã¯ä½¿ã„ã¾ã‚ã™ ã¨ã„ã†æ„Ÿã˜ã«ãªã‚Šã¾ã™ã€‚ ãƒã‚¤ãƒ³ãƒˆã¨ã—ã¦ã¯ã€ $ENV{TEST_MYSQLD} ã« Test::mysqld ã®ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚’ãã®ã¾ã¾ JSON ã«ã—ã¦çªã£è¾¼ã‚€ Test::MyApp::m
SQL::Abstract 㧠LIKE ã® ESCAPE を指定ã™ã‚‹ - daily dayflower
æ£è¦è¡¨ç¾ã§ã„ㆠ^a_c.* ã¿ãŸã„ãªã®ã‚’ã²ã£ã‹ã‘よã†ã¨æ€ã£ã¦ï¼Œ my ($sql, @binds) = SQL::Abstract->new()->select( # table 'foo', # fields [ '*' ], # where { id => { LIKE => 'a_c%' }, }, ); ã¿ãŸãã‚„ã‚‹ã¨ï¼Œa_code ã ã‘ã§ãªã abc もマッãƒã—ã¦ã—ã¾ã†ç½ 。 PostgreSQL ã ã¨ï¼Œãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ–‡å—㌠\ ã«ãªã£ã¦ã‚‹ã®ã§ï¼Œ # where { id => { LIKE => 'a\\_c%' }, }, ã®ã‚ˆã†ã«ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚Œã°ã„ã„（MySQL ã ã¨ã©ã†ãªã‚“ã ã‚）。 ã§ã‚‚，ãŸã¨ãˆã° SQLite ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ–‡å—ãŒè¨å®šã•ã‚Œã¦ãªã„。ã ã‹ã‚‰ LIKE ãªã©ã®ã‚ã¨ã« ESCAPE を指定ã™ã‚‹ã®ãŒæœ¬ç‹ã€‚ãªã‚“ã ã‘ã©ï¼ŒSQL::Abstract ã§ãµ
myfinder's blog: DBD::mysqlã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒã§ããªã„ã¨ãŠå˜†ãã®æ–¹ã¸
ã‚‚ã—ã“ã®è¨˜äº‹ã‚’èªã‚“ã æ–¹ãŒä¸‹è¨˜ã®ã‚ˆã†ãªã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ããªã„ã§ã„ã‚‹ã®ã§ã‚ã‚Œã°ã€ãã£ã¨å¾Œè¿°ã®è§£æ±ºç–ã§ã†ã¾ãã„ãã§ã—ょã†t/80procs.t ................. 1/29 DBD::mysql::db do failed: alter routine command denied to user ''@'localhost' for routine 'test.testproc' at t/80procs.t line 41.DBD::mysql::db do failed: alter routine command denied to user ''@'localhost' for routine 'test.testproc' at t/80procs.t line 41.ã“ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã¯ã€ãƒ†ã‚¹ãƒˆã‚¹ã‚¯ãƒªãƒ—トãŒDBã«æŽ¥ç¶šã—ã«ã„ãéš›ã®ãƒ¦ãƒ¼ã‚¶åãŒè¨å®šã•ã‚Œã¦ã„
DBD::mysqlã®installã¯ã€mysql_configã‚„testuserを指定ã—ã¾ã—ょㆠ- end0tknr's kipple - web写経開発
DBD:a:mysqlã‚’installã™ã‚‹éš›ã€å˜ç´”ã«å®Ÿè¡Œã™ã‚‹ã¨ã€ã‚¨ãƒ©ãƒ¼ã§æ€’られã¦ã—ã¾ã„ã¾ã™ã€‚ 例ãˆã°ã€perl Makefile.PLã§ã¯... $ cd DBD-mysql-4.010 $ /usr/local/bin/perl Makefile.PL Can't exec "mysql_config": No such file or directory at Makefile.PL line 76. ＜略＞例ãˆã°ã€make testã§ã¯... $ make test ＜略＞ t/76multi_statement.........ok t/80procs...................ok 1/29DBD::mysql::db do failed: execute command denied to user ''@'localhost' for routine 'test.t
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
http://masteries.papix.net/entry/2014-03-15-mysql.html
{{#tags}}- {{label}}
{{/tags}}