[B! DBI] seamlessbiasã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

seamlessbias id:seamlessbias

DBIã«é–¢ã™ã‚‹seamlessbiasã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

${{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}}

Perlã®DBIx::Classåˆ©ç”¨ä¸Šã®æ³¨æ„ç‚¹
ã“ã®è¨˜äº‹ã¯ã€Perl 5 Advent Calendarã®17æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ Redis::Fast ã® reconnect ã«ã¤ã„ã¦ã®ä¸ã§ DBIx::Classã®reconnectã«ã¤ã„ã¦ã‚‚è§¦ã‚Œã¦ã„ã¾ã™ã€‚ DBIx::Classã®å®‰å…¨ã«reconnectionãŒè¡Œãˆã‚‹ã‚ˆã†ã«è€ƒæ…®ã•ã‚Œã¦ã„ã¾ã™ãŒã€è‰²ã€…ã¨æ³¨æ„ç‚¹ãŒã‚ã‚Šã¾ã™ã€‚ reconnectionå‘¨ã‚Šã§èª¿ã¹ã¦ã¿ãŸã®ã§ã€Advent Calendarã®æž ã‚’å€Ÿã‚Šã¦ã¾ã¨ã‚ãŸã„ã¨æ€ã„ã¾ã™ã€‚ DBIx::Classã¨ã¯ DBIx::Classã¯Perlã®O/Rãƒžãƒƒãƒ”ãƒ³ã‚°ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«é–“ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’å®šç¾©ã§ãã€JOINå¥ã®å…¥ã£ãŸã‚¯ã‚¨ãƒªã‚‚ã‚µãƒãƒ¼ãƒˆã™ã‚‹ç‰ã€ã‹ãªã‚Šé«˜æ©Ÿèƒ½ãªãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã™ã€‚ ã‚‚ã†åƒ•ã¯JOINå¥ã‚’DBIx::Classä»¥å¤–ã§æ›¸ã‘ã‚‹æ°—ãŒã—ã¾ã›ã‚“ã€‚ è©³ã—ãã¯typesterå…ˆç”Ÿã®è§£èª¬è¨˜äº‹ã‚’ã©ã†ãžã€‚ Perl Hackers Hub ç¬¬
seamlessbias 2015/12/17
Perl

DBIx

Class

DBI
ãƒªãƒ³ã‚¯
ç¬¬36å›žã€€SQL::Abstractï¼šç°¡å˜ãªSQLã¯ã‚ˆã‚Šç°¡å˜ã« | gihyo.jp
DBIã®æ³£ãæ‰€ ã„ã‚ã‚†ã‚‹LAMPãªã„ã—ãã‚Œã«ä¼¼ãŸç’°å¢ƒã§ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹ã°ã‹ã‚Šæ›¸ã„ã¦ã„ã‚‹æ–¹ã«ã¯ã‚ã¾ã‚Šå®Ÿæ„ŸãŒãªã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€ã‚ã¡ã‚‰ã®ç¾å ´ã§ã¯Oracleã‚’ã€ã“ã¡ã‚‰ã®ç¾å ´ã§ã¯Microsoft SQL Serverã‚’ã€ã¯ãŸã¾ãŸåˆ¥ã®ç¾å ´ã§ã¯çµ„ã¿è¾¼ã¿ã®SQLiteã‚’ã€ã¨ã„ã£ãŸå—è¨—ç³»ã®ä»•äº‹ã‚’ã—ã¦ã„ã‚‹äººã«ã¨ã£ã¦ã€SQLã®æ–¹è¨€å•é¡Œã¯é¿ã‘ã¦ã¯é€šã‚Œãªã„ã‚‚ã®ã®ã²ã¨ã¤ã§ã™ã€‚ å…¸åž‹çš„ãªã¨ã“ã‚ã§ã¯ã€ãŸã¨ãˆã°SELECTã§å–å¾—ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã®ä»¶æ•°ã‚’åˆ¶é™ã—ãŸã„å ´åˆã€PostgreSQLãªã©ã§ã¯ã€ŒLIMIT ... OFFSET ...ã€ã®ã‚ˆã†ã«æ›¸ãã¾ã™ãŒã€Oracleã§ã¯ROWNUMã‚’ä½¿ã„ã¾ã™ã—ã€MS SQL serverãªã‚‰SET ROWCOUNTã‚„TOPã‚’ä½¿ã„ã¾ã™ã€‚ã¾ãŸã€ã„ã¾ã§ã“ãPostgreSQLã¨ã®äº’æ›æ€§ã‚’ç¢ºä¿ã™ã‚‹ãŸã‚ã€ŒLIMIT ... OFFSET ...ã€ã¨æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã‚‹MySQLã«ã—ãŸã¨ã“ã‚ã§ã€
seamlessbias 2010/09/22
Perl

DBI
ãƒªãƒ³ã‚¯
ç¬¬35å›žã€€DBIï¼šç”Ÿã®SQLãŒæ•£ã‚‰ã°ã‚‹ã¨è¨€ã†å‰ã« | gihyo.jp
Perlã¨dbm ã„ã¾ã§ã¯çœã¿ã‚‰ã‚Œã‚‹ã“ã¨ã‚‚å°‘ãªããªã‚Šã¾ã—ãŸãŒã€Perlã«ã¯1989å¹´ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³3.0ä»¥é™ã€dbmã¨å‘¼ã°ã‚Œã‚‹ã‚·ãƒ³ãƒ—ãƒ«ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹æ©Ÿæ§‹ãŒæ¨™æº–ã§çµ„ã¿è¾¼ã¾ã‚Œã¦ã„ã¾ã™ã€‚ã“ã®dbmã¯ã€ã„ã‚ã‚†ã‚‹ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯é•ã£ã¦ã‚ãƒ¼ã¨å€¤ã®çµ„ã¿åˆã‚ã›ã‚’ãƒ‡ã‚£ã‚¹ã‚¯ã«ä¿å˜ã§ãã‚‹ã ã‘ã®ã‚‚ã®ã§ã™ãŒã€ãƒãƒƒã‚·ãƒ¥ï¼ˆå½“æ™‚ã¯ã¾ã é€£æƒ³é…åˆ—ã¨å‘¼ã‚“ã§ã„ã¾ã—ãŸï¼‰ã¨çµã³ã¤ã‘ã‚‹ã“ã¨ã§ã‚¿ãƒ–åŒºåˆ‡ã‚Šãƒ•ã‚¡ã‚¤ãƒ«ãªã©ã‚’èªã‚“ã§ã„ãã‚ˆã‚Šé«˜é€Ÿã«æ¤œç´¢ãŒã§ããŸãŸã‚ã€ãƒ¦ãƒ¼ã‚¶ç’°å¢ƒã«æ°¸ç¶šçš„ãªãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹æ‰‹æ®µã®ã²ã¨ã¤ã¨ã—ã¦é‡å®ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚Perl 3ï¼4ã®æ™‚ä»£ã«ã¯dbmopenã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãŒä½¿ã‚ã‚Œã¦ã„ã¾ã—ãŸãŒã€ã“ã®æ©Ÿæ§‹ã¯Perl 5ã«ãªã£ã¦ä¸€æ–°ã•ã‚Œã€ã„ã¾ã§ã¯ã‚ˆã‚Šæ±Žç”¨çš„ãªtieã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã†ã“ã¨ã«ãªã£ã¦ã„ã¾ã™ã€‚ã“ã®ä»²é–“ã¨ã—ã¦ã¯å¤ãã‹ã‚‰ã‚ã‚‹Berkeley DBã‚„GDBMãªã©ã®ã»ã‹ã€æœ€è¿‘ã§ã¯å¹³æž—å¹¹é›„æ°ã®T
seamlessbias 2010/08/09
ShowErrorStatement

Perl

DBI
ãƒªãƒ³ã‚¯
ç”Ÿ DBI ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãŸã‚ã® DBI Cookbook (2) - æ—¥å‘å¤ç‰¹æ®Šå¿œæ´éƒ¨éšŠ
ã•ã¦ã€ã¾ã•ã‹ç¶šç·¨æ›¸ãã¨æ€ã‚ãªã‹ã£ãŸã‘ã©ã€d:id:ZIGOROu:20090731:1249050735 ã®ç¶šãã§ã™ã€‚ è¿½è¨˜ (2009-08-15T00:30:56+09:00) ã¡ãªã¿ã«ã€ä¸‹è¨˜ã§ç´¹ä»‹ã—ã¦ã‚‹æ–¹æ³•ã¯ä¸€èˆ¬çš„ã«ã¯ DBI ã®è³‡ç”£ãŒãŸãã•ã‚“åˆã£ã¦ãƒ¢ã‚´ãƒ¢ã‚´ãªçŠ¶æ³ã‚’ã©ã†ã™ã‚‹ã‹â€¦ã¿ãŸã„ãªçŠ¶æ³ã®äººå‘ã‘ã§ã™ã€‚ ä¸€èˆ¬çš„ã«ã¯å®œã—ããªã„ã§ã™ã€ã¨è¨€ã†ã“ã¨ã‚’è¸ã¾ãˆã¦ã©ã†ãžã€‚ DBI ã®æ‹¡å¼µã‚’ã‚µãƒ–ã‚¯ãƒ©ã‚¹ã‚’ç”¨ã„ã¦è¡Œã† Subclassing the DBI ã«ã¡ã‚ƒã‚“ã¨æ›¸ã„ã¦ã‚ã‚‹ã‚“ã§ã™ãŒã€DBI ã¯ã‚µãƒ–ã‚¯ãƒ©ã‚¹ã‚’ä½œã‚‹ç‚ºã®ç’°å¢ƒãŒæ•´ã£ã¦ã„ã¾ã™ã€‚ è«–ã‚ˆã‚Šè¨¼æ‹ ã€å®Ÿéš›ã®ä¾‹ã§ã™ã€‚ #!/usr/bin/perl use strict; use warnings; use DBI; use YAML; { package DBIx::Hideki; use base qw(DBI); package DBIx::Hide
seamlessbias 2009/08/15
Perl

DBI
ãƒªãƒ³ã‚¯
ç”Ÿ DBI ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãŸã‚ã® DBI Cookbook (1) - Yet Another Hackadelic
ã¡ã‚‡ã£ã¨å‰ã¾ã§ DBI ã§éžåŒæœŸã‚¢ã‚¯ã‚»ã‚¹ãªã‚¨ãƒ³ãƒˆãƒªãŒå„æ‰€ã§ä¸ŠãŒã£ã¦ã„ã¾ã—ãŸãŒçš†ã•ã‚“å¦‚ä½•ãŠéŽã”ã—ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã•ã¦ã¨ã€ã€ã€æ´å²çš„ãªçµŒç·¯ã¨ã‹æ´å²çš„ãªçµŒç·¯ã¨ã‹ã§ç”Ÿ DBI ç›¸å½“ã‚’ä½¿ã£ã¦ã‚‹æ–¹ã‚‚ãã‚Œãªã‚Šã«ã„ã‚‹ã§ã—ã‚‡ã†ã€‚å¥¥ã•ã‚“ã€å¤§äº‹ãªäº‹ãªã‚“ã§äºŒåº¦è¨€ã„ã¾ã—ãŸã‚ˆï¼ DBI ã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã£ã¦ã¾ããã‚“ãªä½¿ã„ã‚„ã™ã„ç‰©ã˜ã‚ƒãªã„ã‚“ã§ã™ãŒã€å·¥å¤«æ¬¡ç¬¬ã§å‡ºæ¥ã‚‹äº‹ã‚‚ã‚ã‚Šã¾ã™ã€‚ ã¡ãªã¿ã«ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã€MySQL Documentation - Example Databases ã® world ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ fetchall_arrayref ã§ãƒ‡ãƒ¼ã‚¿æ•´å½¢ ã¾ãšä»¥ä¸‹ã®ã‚ˆã†ã«ä½¿ã£ã¦ã¿ã¾ã™ã€‚ #!/usr/bin/perl use strict; use warnings; use Data::Dump qw(dump); use DBI; use Perl6::Say; my $dbh =
seamlessbias 2009/07/31
Perl

DBI
ãƒªãƒ³ã‚¯
DBD::SQLite 1.25 - Charsbar::Note
Adam KennedyãŒãã‚Œã„ã«ã¾ã¨ã‚ã¦ãã‚Œã¦ã„ã¾ã™ãŒã€å…ˆæ—¥æ¥æ´»ç™ºã«ã‚³ãƒŸãƒƒãƒˆã—ã¦ããŸDBD::SQLiteãŒ1.25ã®æ™‚ç‚¹ã§æ£å¼ã«amalgamationã‚’ä½¿ã†ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã®ã§ã€ã“ã‚Œã¾ã§DBD::SQLite::Amalgamationã‚’ä½¿ã£ã¦ã„ãŸæ–¹ã¯ã“ã®æ©Ÿä¼šã«ãœã²DBD::SQLiteã®æ–¹ã«åˆ‡ã‚Šæ›¿ãˆã¦ãã ã•ã„ã¾ã›ã€‚ http://use.perl.org/~Alias/journal/38859 http://search.cpan.org/dist/DBD-SQLite/ ç¾çŠ¶ã§éŽåŽ»æ•°å¹´é–“ã«å ±å‘Šã•ã‚Œã¦ããŸå¤§ããªå•é¡Œã¯ã‚ã‚‰ã‹ãŸè§£æ±ºã•ã‚Œã¦ã„ã¾ã™ãŒã€RTä¸Šã«å¯„ã›ã‚‰ã‚Œã¦ã„ã‚‹ã‚¹ãƒˆãƒ¬ã‚¹ãƒ†ã‚¹ãƒˆãªã©ã®çµæžœã‹ã‚‰ã€å®Ÿéš›ã«ã¯å¾®å¦™ãªãƒªãƒ¼ã‚¯ã‚„ä¸æ£ç¢ºãªãƒãƒƒã‚¯ã®å•é¡ŒãŒæ®‹ã£ã¦ã„ã‚‹ã“ã¨ãŒã‚ã‹ã£ã¦ã„ã¾ã™ã€‚ã¾ãŸã€DBIã®æ¬¡ã®ç‰ˆãŒå‡ºãŸã‚‰ã„ã¾funcã§å‘¼ã³å‡ºã—ã¦ã„ã‚‹ã‚‚ã‚ã‚‚ã‚ã®é–¢æ•°ã®å‘¼ã³å‡ºã—æ–¹ã‚’å¤‰ãˆã‚‹(install_me
seamlessbias 2009/04/24
DBD::SQLite::Amalgamationã‹ã‚‰åˆ‡ã‚Šæ›¿ãˆãŸã€‚

Perl

DBI

DBD

SQLite
ãƒªãƒ³ã‚¯
DBDã§UTF8 flaggedãªæ–‡å—åˆ—ã‚’è¿”ã™ - hide-k.net#blog
\mysql_enable_utf8 => 1 ã§ DBIC::UTF8Columns è¦ã‚‰ãªããªã‚‹ã£ã½ã„ - åƒ•ãƒˆäº‘ãƒ•äº‹ï¼ ã¯ã¦ãªå‡ºå¼µç‰ˆ æ¥ãšã‹ã—ãªãŒã‚‰çŸ¥ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ DBIx::Classã®å ´åˆã€DBIx::Class::UTF8Columnsã‚’ä½¿ã£ã¦utf8_columns()ã§UTF8ãƒ•ãƒ©ã‚°ã‚’ç«‹ã¦ãŸã„ã‚«ãƒ©ãƒ ã‚’æŒ‡å®šã™ã‚‹ã®ã§ã™ãŒã€ç‰¹å®šã®ã‚«ãƒ©ãƒ ã ã‘ã«UTF8ãƒ•ãƒ©ã‚°ã‚’ç«‹ã¦ã‚‹ã¨ã„ã†ã®ã¯ç¨€ã§ã€å…¨ã¦ã®æ–‡å—åˆ—ã®ã‚«ãƒ©ãƒ ã«ç«‹ã¦ã‚‹ã®ãŒå¤šãã®å ´åˆã ã¨æ€ã„ã¾ã™ã€‚ ã®ã§ã€DBDã®ãƒ¬ã‚¤ãƒ¤ãƒ¼ã§å¸åŽã™ã‚‹ã“ã®æ–¹æ³•ãŒå€‹äººçš„ã«ã‚‚ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã ã¨æ€ã„ã¾ã™ã€‚ vkgtaro++ å‚™å¿˜ã§ã¾ã¨ã‚ã¦ãŠãã¨å„DBDã®æŽ¥ç¶šã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§ mysql: mysql_enable_utf8 postgresql: pg_enable_utf8 sqlite: unicode ã«1ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã«ã‚ˆã‚Šã€å…¨ã¦ã®æ–‡å—åˆ—ã®ã‚«ãƒ©ãƒ ã®å€¤ã«UTF
seamlessbias 2009/02/07
Perl

DBI
ãƒªãƒ³ã‚¯
DBIx::Skinny - Hatena::Diary::Neko::kak 500 Internal Server Error
ã„ã¾ã•ã£ãcodereposã«DBix::Skinnyã¨ã„ã†ã‚‚ã®ã‚’importã—ã¾ã—ãŸã€‚ http://coderepos.org/share/browser/lang/perl/DBIx-Skinny æ˜¨ä»Šã®DBICãƒ–ãƒ¼ãƒ ã§åˆ©ç”¨è€…ã¯å¢—ãˆã¦ããŸã‚“ã§ã™ãŒã€ã„ã‚ã„ã‚ä½¿ã†ã«ã‚ãŸã£ã¦ã€ ã“ã“ã¾ã§ORãƒžãƒƒãƒ‘ãƒ¼ã§ã„ã‚ã„ã‚ï¼ˆJOINã—ãŸã‚Šã€ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ãŸã‚Šï¼‰ã‚„ã‚‹ã®ã¯ã©ã†ãªã‚“ã ã¨ã‹ã€ ã†ã‚“ãŸã‚‰ã‹ã‚“ãŸã‚‰è€ƒãˆãŸã‚‰è‡ªåˆ†ã§ä½œã£ã¦ã—ã¾ãˆã¦ã®ãŒå‹•æ©Ÿã§ã—ãŸã€‚ DBICã¯ã¯ã£ãã‚Šè¨€ã£ã¦ã©ã§ã‹ã„ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãªã®ã§ä¸€ã‹ã‚‰ã‚½ãƒ¼ã‚¹ã‚’èªã‚€ã®ãŒã‹ãªã‚Šå¤§å¤‰ã§ã™ã€‚ ä»•äº‹ã§ä½¿ã£ã¦ã‚‹é–¢ä¿‚ä¸Šã€ä»•æ–¹ãªãè¦‹ã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ãŒã€ã‚ãƒ„ã„ã€‚ ã‚ã¨ã€DBICã‚’ä½¿ã£ã¦ã„ã‚‹ã¨JOINã—ãŸSQLãŒã‚ã‚‹æ„å‘³ç°¡å˜ã«ç™ºè¡Œã§ãã‚‹ã®ã§ é‡å®ã™ã‚‹ã®ã§ã™ãŒã€ã¶ã£ã¡ã‚ƒã‘ã©ã†ã„ã†SQLãŒç™ºè¡Œã•ã‚Œã¦ã„ã‚‹ã‹å…¨éƒ¨ã¡ã‚ƒã‚“ã¨è¦‹ã¦ã‚‹äººã£ã¦ ã©ã‚Œãã‚‰ã„ã„ã‚‹ã®ã ã‚ã†ã¨æ€ã£ãŸã‚Šã€‚ DBICã«ã‚ˆã£ã¦
seamlessbias 2008/11/29
Perl

DBI

DBIx

Skinny
ãƒªãƒ³ã‚¯
DateTime-Format-DBI-0.041
seamlessbias 2007/01/21
Find a parser class for a database connection.

Perl

CPAN

DateTime

Format

DBI
ãƒªãƒ³ã‚¯
Jifty-DBI-0.46
seamlessbias 2006/11/05
An object-relational persistence framework

Perl

CPAN

Jifty

DBI
ãƒªãƒ³ã‚¯
1