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

penalty id:penalty

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

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

ãã‚Œ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ãŒå‘¼ã³å‡ºã•ã‚Œã¾ã™ã€‚ æŽ¥ç¶šæ™‚ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œ
penalty 2014/01/08
dbi

perl
ãƒªãƒ³ã‚¯
http://www.lost-season.jp/mt/2005/11/2005112322.html
penalty 2007/10/17
perl

DBI
ãƒªãƒ³ã‚¯
ORãƒžãƒƒãƒ”ãƒ³ã‚°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« Class::DBI ã‚’ãƒ†ã‚¹ãƒˆï½œPerlãƒ—ãƒã‚°ãƒ©ãƒ ãƒ¡ãƒ¢ï½œãƒ—ãƒã‚°ãƒ©ãƒ ãƒ¡ãƒ¢
==================================== â– ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ãƒ‡ãƒ¼ã‚¿ã®INSERT my $obj = Class->insert(?%data); â– ãƒ‡ãƒ¼ã‚¿ã®SELECTï¼ˆã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’è¿”ã™ï¼‰ $obj = Class->retrieve( $id ); $obj = Class->retrieve( %key_values ); â– ãƒ‡ãƒ¼ã‚¿ã®SELECTï¼ˆå…¨ä»¶ã®é…åˆ—ã‚’è¿”ã™ã€€â€»ä½¿ã£ã¦ã¯ãƒ€ãƒ¡ï¼‰ @cds = Music::CD->search(year => 1990); @cds = Music::CD->search(title => "Greatest Hits", year => 1990); â– Pagerã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿ã®SELECT use Class::DBI::Pager; my $pager = Object->pager(20,1);#
penalty 2007/10/02
Class::DBI

perl

dbi

ORMapping
ãƒªãƒ³ã‚¯
Class::DBI::mysql - Extensions to Class::DBI for MySQL - perldoc.jp
åå‰Â¶ Class::DBI::mysql - Extensions to Class::DBI for MySQL Class::DBI::mysql - MySQLç”¨ã®Class::DBIæ‹¡å¼µ æ¦‚è¦Â¶ package Film; use base 'Class::DBI::mysql'; __PACKAGE__->set_db('Main', 'dbi:mysql:dbname', 'user', 'password'); __PACKAGE__->set_up_table("film"); __PACKAGE__->autoinflate(dates => 'Time::Piece'); # Somewhere else ... my $type = $class->column_type('column_name'); my @allowed = $class->enum_vals
penalty 2007/10/02
class::DBI::mysql

perl

dbi
ãƒªãƒ³ã‚¯
search.cpan.org: The Ultimate CPAN Search
ã“ã®æ–‡æ›¸ã¯Class::DBIã®åˆæœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’è¨³ã—ãŸã‚‚ã®ã§ã€ç¾åœ¨ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ã¯æ•´åˆæ€§ãŒã‚ã‚Šã¾ã›ã‚“ã€‚CPAN ã‹ã‚‰æœ€æ–°ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ ã‚’å–å¾—ã—ã¦å†…å®¹ã‚’ç¢ºèªã—ã¦ãã ã•ã„ã€‚ åå‰ Class::DBI - ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ã‚·ãƒ³ãƒ—ãƒ«ãªæ°¸ç¶š æ¦‚è¦ package Film; use base qw(Class::DBI); # Class::DBI ã«ã‚ãªãŸã®ã‚¯ãƒ©ã‚¹ã®ã“ã¨ã‚’æ•™ãˆã¦ã‚ã’ã‚‹ Film->table('Movies'); Film->columns(All => qw( Title Director Rating NumExplodingSheep )); Film->columns(Primary => qw( Title )); Film->set_db('Main', 'dbi:mysql', 'me', 'noneofyourgoddamnedbusiness', {
penalty 2007/10/02
class::DBIã®æ–¹

perl

dbi
ãƒªãƒ³ã‚¯
Class::DBIé–¢é€£ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« : blog.nomadscafe.jp
Class::DBIé–¢é€£ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« ã„ã¾ä½œã£ã¦ã„ã‚‹Webã‚¢ãƒ—ãƒªã§ã€Class:DBIã‚’ã¯ã˜ã‚ã¦ãã¡ã‚“ã¨ä½¿ã£ãŸã€‚ ã„ã‚ã„ã‚ã¨Pluginã‚’ä½¿ã£ãŸã®ã§ãƒ¡ãƒ¢ã€‚ ãƒ™ãƒ¼ã‚¹ã‚¯ãƒ©ã‚¹ã«ã¯ã€ package Object; use strict; use base qw(Class::DBI::mysql); use Class::DBI::AbstractSearch; use Class::DBI::Plugin::NoCache; use Class::DBI::Plugin::AbstractCount; use Class::DBI::Plugin::RetrieveAll; use Class::DBI::Plugin::Iterator qw(prefetch=>10); use Class::DBI::Pager; __PACKAGE__->nocache(1); __PACKAGE__->
penalty 2007/10/02
perl

dbi
ãƒªãƒ³ã‚¯
DBIãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
Perlã§ã€DBIãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä½œæˆæ–¹æ³•ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã‚ã‚Šã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€PostgreSQLã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ DBI/DBDã«ã¤ã„ã¦ DBI/DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ã€Perlã§å„ç¨®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã™ã€‚ DBIãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ä¾å˜ã—ãªã„å‡¦ç†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã€DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ã€å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ¯Žã«ä¾å˜ã™ã‚‹å‡¦ç†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã™ã€‚ ã“ã“ã§ã¯ã€PostgreSQLã®DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ Perlã‚¹ã‚¯ãƒªãƒ—ãƒˆ | DBIãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« | +--------+--------+ | | PostgreSQLå¯¾å¿œ ORACLEå¯¾å¿œ DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« | | PostgreSQL ORACLE ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
penalty 2007/10/02
perl

dbi
ãƒªãƒ³ã‚¯
DBI-DBDã«ã¤ã„ã¦
DBI/DBDã®ä½¿ã„æ–¹ ã“ã®æ–‡ç« ã¯ã€perlã§cgiç‰ã®ãƒ—ãƒã‚°ãƒ©ãƒ ãŒã§ãã€SQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã‚’çŸ¥ã£ã¦ã„ã‚‹ã²ã¨ã‚’å¯¾è±¡ã«æ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ ã¾ãŸã€DBI/DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹ã«ã¯ã€perl5ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ï¼ˆé¢¨ï¼‰ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã®çŸ¥è˜ã‚‚ã‚ã‚‹ç¨‹åº¦ä»¥ä¸Šã¯å¿…è¦ã§ã™ã€‚ DBI/DBDã¨ã¯ã€perlã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é–“ã‚’ã¨ã‚Šã‚‚ã£ã¦ãã‚Œã‚‹æ±Žç”¨ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ã§ã™ã€‚ DBIãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¨DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‹ã‚‰ã§ãã¦ãŠã‚Šã€DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ã€å„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã«å˜åœ¨ã—ã¾ã™ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒžã¯ã€DBIãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ãƒ«ãƒ¼ãƒ«ã«ã—ãŸãŒã£ã¦ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã™ã‚‹ã“ã¨ã§ã€ã©ã®ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚‚ã€åŒã˜ã‚ˆã†ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ãã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã“ã§ã¯ã€DBD/pgï¼ˆPostgreSQLç”¨DBDãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ï¼‰ã‚’ä½¿ã£ãŸä¾‹ã‚’æç¤ºã—ã¾ã™ãŒã€åŸºæœ¬çš„ã«ã¯ã€ã©ã®ã‚ˆã†ãªDBç›¸æ‰‹ã§ã‚‚åŒæ§˜ã®ã“ã¨ãŒã§ãã¾ã™ã€‚
penalty 2007/10/01
perl

dbi
ãƒªãƒ³ã‚¯
1