[B! dbix] sugarbabe335ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

sugarbabe335 id:sugarbabe335

dbixã«é–¢ã™ã‚‹sugarbabe335ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

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

DBIx::ObjectMapperã§Data Mapperãƒ‘ã‚¿ãƒ¼ãƒ³! - Articles Advent Calendar 2010 Hacker
ã“ã‚“ã«ã¡ã‚ã€‚nekokakã•ã‚“ã‚’ã¯ã˜ã‚#dbi-ja@irc.perl.orgã®Perl ãƒãƒƒã‚«ãƒ¼ã®ã¿ãªã•ã¾ã«ãƒ ãƒãƒ£æŒ¯ã‚Šå£°ã‚’ã‹ã‘ã¦ã„ãŸã ãã€çªç„¶hacker trackã§æ›¸ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚eisukeoishiã¨ã‚‚ã†ã—ã¾ã™ã€‚ã¯ã˜ã‚ã¾ã—ã¦ã€‚ ä»Šå›žã¯ã€ç§ãŒä½œæˆã—ãŸDBIx::ObjectMapperã¨ã„ã†O/Rãƒžãƒƒãƒ‘ãƒ¼ã«ã¤ã„ã¦ç´¹ä»‹ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ DBIx::ObjectMapperã¨ã¯ ã¿ã‚“ãªå¤§å¥½ããªã€ŒPofEAAã€ã®Data Mapperãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’å®Ÿè£…ã—ãŸã‚‚ã®ã§ã™ã€‚ Data Mapperãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ã”ãç°¡å˜ã«èª¬æ˜Žã™ã‚‹ã¨ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚„O/Rãƒžãƒƒãƒ‘ãƒ¼ã«ä¾å˜ã›ãšã«ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨é€£æºã•ã›ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ DBIx::ObjectMapperã§ä½¿ç”¨ã™ã‚‹ã‚¯ãƒ©ã‚¹ã¯POPO(Plain Old Perl Object)ã§ã‚ã‚Šã€O/Rãƒžãƒƒãƒ‘ãƒ¼ã ã‘ã§ä½¿ç”¨ã™ã‚‹å¿…è¦ã‚‚ã‚ã‚Šã¾ã›ã‚“ã€‚ ä»–è¨€èªžã§
sugarbabe335 2010/12/15
dbix

perl
ãƒªãƒ³ã‚¯
http://blog.eorzea.asia/2010/12/post_94.html
sugarbabe335 2010/12/13
dbix

*atode

perl
ãƒªãƒ³ã‚¯
DBIx::Inspector ã§ DB ã®ä¸ã‚’ã®ãžãã¿ã‚‹ - Articles Advent Calendar 2010 Hacker
ãƒ™ã‚¹ãƒˆã‚¹ãƒ”ãƒ¼ã‚«ãƒ¼è³žã‚’ã‚‚ã‚‰ã£ãŸ tokuhirom ã§ã™ã€‚ 1981å¿˜å¹´ä¼šã§ã®ã¿ã™ãŽã¦ã€äºŒæ—¥é…”ã„ãŒå¤§å¤‰ã²ã©ã„ã§ã™ã€‚ ã•ã¦ã€ä»Šå›žã¯è£ã‚’ã‹ã„ã¦ã€DBIx::Inspector ã®è©±ã‚’ã‹ã“ã†ã‹ãŠã‚‚ã„ã¾ã™ã€‚æœ€è¿‘ã‚ãŸãã—ã¯ã€Web ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®7ã¤ã®ã¯ã—ã‹ã®ã†ã¡ã®ä¸€ã¤ã§ã‚ã‚‹ O/R Mapper ã‚’æ›¸ã„ã¦ã¾ã™ã€‚ ã“ã‚Œã¯ã€é«˜é€Ÿã§ã€ãƒŸãƒ‹ãƒžãƒªã‚¹ãƒ†ã‚£ãƒƒã‚¯ã§ã€å®‰å®šã—ã¦ã„ã¦ã€DBI ã‚’ãƒªã‚¹ãƒšã‚¯ãƒˆã—ã¦ã„ã¦ã€ã¿ãŸã„ãªã€ãã‚“ãªã®ã‚’ã‚ã–ã—ã¦ã¾ã™ã€‚ O/R Mapper ã‹ãäººã£ã¦ã€O/R Mapper ã‚’ã‹ãã¨ãã«å¿…è¦ãªã‚‚ã®ã¨ã‹ã‚’ã€ã¾ã‚‹ã£ã¨åŒæ¢±ã—ãŸãŒã‚ŠãŒã¡ãªã‚“ã§ã™ãã€‚ ãã†ã„ã†ã¤ãã‚Šã«ã—ã¦ã—ã¾ã†ã¨ã€åˆ¥å€‹ãªã‹ã‚“ã˜ã® O/R Mapper ã‚’ã‹ã“ã†ã¨ã—ãŸã¨ãã«ã€ã¤ã‹ã„ã¾ã‚ã—ãŒãã‹ãªãã¦ã„ã£ã±ã„ã‚³ãƒ”ãƒšã—ãªãã¡ã‚ƒã„ã‘ãªã„ã§ã™ã€‚ ãã‚Œã‹ãªã—ã„ã‚ˆãã£ã¦ã“ã¨ã§ã€ã¿ã‚“ãªãŒå…±é€šã«ã¤ã‹ãˆã‚‹ãƒ‘ãƒ¼ãƒ„ã‚’ã¡ã‚‡ã£ã¨ãšã¤ã‹ã„ã¦ã¿ã‚ˆã†ã‹ãªã€ã¨ãŠã‚‚ã£ã¦ã¾ã™
sugarbabe335 2010/12/05
perl

dbix
ãƒªãƒ³ã‚¯
DBIx::Inspector - introspection for DBI - tokuhirom's blog
use DBIx::Inspector; my $dbh = DBI->connect(...) or die; my $inspector = DBIx::Inspector->new(dbh => $dbh); my @tables = $inspector->tables; for my $table (@tables) { print " pk:\n"; for my $pk ($table->primary_key) { print " ", $pk->name, "\n"; } print " columns:\n"; for my $column ($table->columns) { print " ", $column->name, "\n"; } }DBI supports introspection, but it is a too generic and funct
sugarbabe335 2010/11/29
perl

dbix
ãƒªãƒ³ã‚¯
Perlãƒ¡ãƒ¢/DBIx::Classãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ« - Walrus, Digit.
ä»¥ä¸‹ãŒã“ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹ãŸã‚ã®éš›ã®SQLã§ã™ã€‚ã“ã®SQLã‚’UTF8ã§ä¿å˜ã—ã€mysqlã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä½œæˆæ¨©é™ã®ã‚ã‚‹ãƒ¦ãƒ¼ã‚¶ï¼ˆç®¡ç†è€…ãªã©ï¼‰ã§å®Ÿè¡Œã—ã¾ã™ã€‚ /* ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ãƒ¦ãƒ¼ã‚¶ã‚’ä½œæˆ */ DROP DATABASE IF EXISTS blog; CREATE DATABASE blog CHARACTER SET utf8; GRANT ALL ON blog.* TO blog_user IDENTIFIED BY 'blog_pass'; /* ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆ */ use blog; DROP TABLE IF EXISTS blog_site; CREATE TABLE blog_site ( site_id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, url TEXT, description TEXT, dat
sugarbabe335 2009/12/05
perl

dbix
ãƒªãƒ³ã‚¯
1