[B! dbi] hibomaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hiboma id:hiboma

dbiã«é–¢ã™ã‚‹hibomaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

YappoLogs: DSN ã« sql-mode=... ä»˜ã‘ã¦ã‚‚ãªã‚“ã‚‚ãªã‚“ãªã„ã‚“ã ã‚ˆç³žãŒï¼
DSN ã« sql-mode=... ä»˜ã‘ã¦ã‚‚ãªã‚“ã‚‚ãªã‚“ãªã„ã‚“ã ã‚ˆç³žãŒï¼ æœ€åˆã®æ–¹ã«è¿½è¨˜ã—ã¦ãŠãã¨ç”ŸDBIé™å®šã®è©±ã§ã™ã€‚åƒ•ã®ã—ã‚‰ãªã„ wrapper ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã ã¨å‹•ãã®ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã‘ã©ã€ã“ã†ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’åƒ•ãŒæ›¸ã„ã¦ã‚‹æ™‚ç‚¹ã§ã€ãã†ã„ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ç‹æ‚ªã„ã‚“ã ã¨ãŠã‚‚ã„ã¾ã™ã€‚ äººã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ã‚³ãƒ¼ãƒ‰ã‚’è¦‹ã¦ãŸã‚‰ my $dbh = DBI->connect('dbi:mysql:dbname=geekdb;sql-mode=STRICT_TRANS_TABLES', 'yappo', 'moneyfriend', %attr); ã¿ãŸã„ãªæ„Ÿã˜ã® DSN ãŒã‚ã£ãŸã‚“ã§ã™ã‚ˆãã€‚ ä»–ã«ã‚‚ attribute ã¦ã‚“ã“ã‚‚ã‚Šã ã£ãŸã‚“ã§ã€ãã‚Œã‚³ãƒŸãƒƒãƒˆã—ãŸäººã«èžã„ã¦è¦‹ãŸã‚‰ã€Œç§˜ä¼ã®ã‚¿ãƒ¬ã§ã™ã€çš„ãªã®ãŒå¸°ã£ã¦ããŸã®ã§ã€åƒ•ã‚‚ä½•ã‚‚è€ƒãˆãªã„ã§ã€Œã“ã‚Œã§STRICT_TRANS_TABLESåŠ¹ã„ãŸã‚‰ã€ã¾ãæ—ã‚‹ã‹ã‚‰ä»˜ã‘ã¨ã“
hiboma 2012/11/28
perl

dbi
ãƒªãƒ³ã‚¯
ãã‚ŒCallbacksã§ - DBIxã‚’ä½œã‚Šã ã™å‰ã« - Articles Advent Calendar 2011 Dbix
ã©ã†ã‚‚kazeburoã§ã™ã€‚DBIx Trackãªã®ã«ã€DBIxã‚’ä½œã‚‰ãªã„è©±ã€‚ myfinderã•ã‚“ãŒDBIxã‚’ä½œã‚‹ç¬¬ä¸€æ©ã¨ã—ã¦DBIã®ã‚µãƒ–ã‚¯ãƒ©ã‚¹ã®ä½œã‚Šæ–¹ã‚’ç´¹ä»‹ã—ã¾ã—ãŸãŒã€å®Ÿéš›ã«DBIxã‚’ä½œã‚Šå‡ºã™å‰ã«ã€ãã®æ©Ÿèƒ½ãŒDBIã®æ¨™æº–æ©Ÿèƒ½ã§ã§ããªã„ã‹èª¿ã¹ã‚‹ã®ãŒã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚ Callbacksã®åŸºæœ¬ Callbacksã¯DBIã«æ¨™æº–ã§ç”¨æ„ã•ã‚Œã¦ã„ã‚‹Hookæ©Ÿèƒ½ã§ã™ã€‚ my $dbh = DBI->connect('dbi:SQLite:dbname=test.db','','', { RaiseError => 1, PrintError => 0, Callbacks => { connected => sub { ... } } }); æŽ¥ç¶šæ™‚ã®Attributesã«Callbacksã‚’è¿½åŠ ã—ã¾ã™ã€‚ä¸Šã§ã¯æŽ¥ç¶šãŒå®Œäº†(connected)ã—ãŸã‚‰coderefãŒå‘¼ã³å‡ºã•ã‚Œã¾ã™ã€‚ æŽ¥ç¶šæ™‚ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œ
hiboma 2011/12/06
perl

dbi
ãƒªãƒ³ã‚¯
DBIã¨forkã®é–¢ä¿‚ - heboi blog
å®Ÿéš›ã‚°ã‚°ã‚Œã°æ£è§£ã¯ã„ã£ã±ã„å‡ºã¦ãã‚‹ã—ã“ã“ã«è‡ªåˆ†ã‚‚ã‚³ãƒ¡ãƒ³ãƒˆã§æ›¸ã„ã¦ãŸã‚Šã—ã¦ã„ã¾ã•ã‚‰æ›¸ãå¿…è¦ã‚‚ãªã„ã‹ãªã¨æ€ã£ã¦ãŸã‘ã©ä¸€å¿œè‡ªåˆ†ã®ãƒ–ãƒã‚°ã§ã‚‚ã¾ã¨ã‚ã¦ãŠãã¨ã„ã†ã“ã¨ã§ã€‚ ä¸€èˆ¬çš„ãªè§£ DBIx::Connectorã¨ã‹DBIx::HandlerçµŒç”±ã§ã‹ãªã‚‰ãš$dbhã‚’å–å¾—ã—ã¦ã‹ã‚‰DBIã‚’ä½¿ã†ã€‚ ã‚‚ã—ãã¯fork-safeãªORM(DBIx::Class, DBIx::Skinny, Teng)ã‚’ä½¿ã†ã€‚ DBIã‚’ç›´æŽ¥ä½¿ã£ã¦ã„ã‚‹å ´åˆ ä¸€èˆ¬çš„ãªã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’ä¿æŒã™ã‚‹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨åŒæ§˜ã«DBIã‚‚forkã—ãŸåä¾›ãŒè¦ªã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’ãã®ã¾ã¾ä½¿ã†ã“ã¨ã¯ãƒã‚°ã®åŽŸå› ã«ãªã‚Šã¾ã™ã€‚ç‰¹ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®å‡¦ç†ç‰ã§é‡å¤§ãªå•é¡ŒãŒèµ·ã“ã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ è§£æ±ºç–ã¯ã€ DBIã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’è¦ªã§ä½œã‚‰ãªã„ã§ã€åä¾›ã§ç‹¬è‡ªã«ä½œã‚‹ è¦ªã§ä½œã£ã¦ã—ã¾ã£ãŸã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã‚’åä¾›ãŒå®‰å…¨ã«DESTROYã—ã€å†æŽ¥ç¶šã™ã‚‹ ã®ã©ã¡ã‚‰ã‹ã«ãªã‚Šã¾ã™ã€‚ã“ã“ã§å•é¡Œã¯2ã§
hiboma 2011/11/17
perl

dbi
ãƒªãƒ³ã‚¯
DBIx::TransactionManager
ã¨ã„ã†ã®ã‚’æ›¸ãã¾ã—ãŸã€‚ https://github.com/nekokak/p5-DBIx-TransactionManager ã¾ãã€DBIx::Skinnyã§ä½¿ã£ã¦ã„ã‚‹ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ä»•çµ„ã¿ã‚’åˆ¥ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«åˆ‡ã‚Šå‡ºã—ãŸæ„Ÿã˜ã§ã™ã€‚ use DBI; use DBIx::TransactionManager; my $dbh = DBI->connect('dbi:SQLite:'); my $tm = DBIx::TransactionManager->new($dbh); { my $txn = $tm->txn_scope; $dbh->do("insert into foo (id, var) values (1,'baz')"); { my $txn2 = $tm->txn_scope; $dbh->do("insert into foo (id, var) values (
hiboma 2010/12/03
perl

dbi
ãƒªãƒ³ã‚¯
hide-k.net#blog: ã„ã¤ã§ã‚‚ã©ã“ã§ã‚‚ã€ã™ãã« Class::DBI ã‚’ä½¿ã„ãŸã„
ãŠä»•äº‹ã§ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ä¸Šã§CGIã‚’æ›¸ãç¾½ç›®ã«ãªã£ãŸã®ã§ã™ãŒã€rootæ¨©é™ã¯ãŠã‚ã‹ã‚·ã‚§ãƒ«ã‚‚ä½¿ãˆãªã„ç’°å¢ƒãªã®ã§Catalystã«ã©ã£ã·ã‚Šã¤ã‹ã£ã¦ã„ãŸãƒœã‚¯ã¨ã—ã¦ã¯é¢å€’ãã•ãã¦æ°—ãŒç‹‚ã„ãã†ã§ã™ã€‚ ç‰¹ã«DBå‘¨ã‚Šã€‚ DBIç›´ãŸãŸããªã‚“ã¦éžäººé–“çš„ãªä½œæ¥ã‚’ã‚„ã£ã¦ã„ã‚‹ã¨ãƒã‚°ã¤ã¶ã—ã ã‘ã§é ãŒãŠã‹ã—ããªã‚Šãã†ã§ã™ã€‚ ã§ã€ãªã‚“ã¨ã‹Class::DBIã ã‘ã§ã‚‚ä½¿ãˆãªã„ã‹èª¿ã¹ã¦è¦‹ã¾ã—ãŸã€‚ CDBIãŒä¾å˜ã—ã¦ã„ã‚‹ã‚¯ãƒ©ã‚¹ã§XSã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã¯versionã¨Cloneã ã‘ã§ã™ã€‚ ãã‚Œãªã‚‰ã‚ã‚‹ç¨‹åº¦ç’°å¢ƒãŒæ•´ã£ã¦ã„ã‚‹ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ãªã‚‰ãªã‚“ã¨ã‹ãªã‚‹ã ã‚ã†ã£ã¦ã“ã¨ã§èª¿ã¹ã¦è¦‹ã‚‹ã¨ã€éƒ½åˆã®ã„ã„ã“ã¨ã«versionã¯--perl_onlyã‚ªãƒ—ã‚·ãƒ§ãƒ³ä»˜ãã§Makefile.PLã™ã‚Œã°Pure Perlãªã‚¯ãƒ©ã‚¹ã‚’ä½œæˆã—ã¦ãã‚Œã‚‹ã—ã€Cloneã¯Clone::PPãªã‚‹Pure PerlãªCloneã‚¯ãƒ©ã‚¹ãŒã‚ã‚Šã¾ã—ãŸã€‚ ã§ã€ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚
hiboma 2006/07/23
class

dbi
ãƒªãƒ³ã‚¯
http://www.lost-season.jp/mt/2005/11/2005112322.html
hiboma 2006/07/22
perl

dbi
ãƒªãƒ³ã‚¯
1