[B! perl][database] gfxã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

gfx id:gfx

perlã¨databaseã«é–¢ã™ã‚‹gfxã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ç¬¬39å›žã€€DBIx::Skinnyï¼šDBIx::Classã«ä¸æº€ã‚’æ„Ÿã˜ãŸã‚‰ | gihyo.jp
DBICä»¥é™ã®é¸æŠžè‚¢ ä»Šå›žã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è©±ã®ç· ã‚ããã‚Šã¨ã—ã¦ã€DBIx::Classä»¥é™ã«ç™»å ´ã—ãŸã„ãã¤ã‹ã®é¸æŠžè‚¢ã«ã¤ã„ã¦ã–ã£ãã‚Šã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ã“ã‚Œã‚‰ã¯ã„ãšã‚Œã‚‚è‹¥ãã€DBICã«æ¯”ã¹ã¦ãƒ¦ãƒ¼ã‚¶æ•°ã‚‚å°‘ãªã„ãŸã‚ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãªã©ã®æ•´å‚™ãŒé…ã‚Œã¦ã„ã‚‹éƒ¨åˆ†ã‚‚ã‚ã‚Šã¾ã™ãŒã€ä»Šå›žã¨ã‚Šã‚ã’ã‚‹ã‚‚ã®ã®å¤šãã¯æ—¥æœ¬äººãŒã¤ãã£ã¦ã„ã‚‹ã‚‚ã®ã§ã™ã‹ã‚‰ã€è‹±èªžåœã§é–‹ç™ºãŒé€²ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã‚‚ã®ã‚ˆã‚Šç–‘å•ã‚„è¦æœ›ã¯é€ã‚Šã‚„ã™ã„ã¯ãšã€‚æ°—ã«ãªã‚‹ã“ã¨ãŒã‚ã£ãŸã‚‰ãœã²ãã‚Œãžã‚Œã®ä½œè€…æ°ã«ä¼ãˆã¦ã„ãŸã ã‘ã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ DBIx::Skinny nekokakã“ã¨å°æž—ç¯¤æ°ã®DBIx::Skinnyã¯ã€ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚‚ã®ã®ãªã‹ã§ã¯ã‚‚ã£ã¨ã‚‚å®Ÿç¸¾è±Šå¯Œãªã‚‚ã®ã¨ã„ã£ã¦ã‚ˆã„ã§ã—ã‚‡ã†ã€‚é–‹ç™ºã®å‹•æ©Ÿã«ã¤ã„ã¦ã¯æ°ã®ãƒ–ãƒã‚°ã«ã‚ˆãã¾ã¨ã¾ã£ã¦ã„ã¾ã™ãŒã€æ¨™æº–ã§ç”¨æ„ã•ã‚Œã¦ã„ã‚‹CRUDãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ã†ã¨ãã ã‘ã§ãªãã€é€Ÿåº¦ã‚’ç¨¼ããŸã‚ã«ç”Ÿã®SQLã‚’æ›¸ã„ãŸã¨ãã§ã‚‚inflateãªã©ã®è£œåŠ©æ©Ÿèƒ½ã‚’ä½¿ãˆ
gfx 2011/02/01
orm

database

perl
ãƒªãƒ³ã‚¯
MySQL ã¨ SQLite ã«å¯¾å¿œã—ãŸ DBIx ãªãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ PostgreSQL ã«å¯¾å¿œã•ã›ã‚‹ Tips ã„ãã¤ã‹ - Articles Advent Calendar 2010 Casual
ã“ã‚“ã«ã¡ã¯ã€‚PostgreSQL ã‚’ã‚ˆãä½¿ã£ã¦ã„ã‚‹ id:sfujiwara (@fujiwara) ã§ã™ã€‚ ä¸–é–“ã§ã¯ MySQL ã®ã»ã†ãŒ PostgreSQL ã‚ˆã‚Šäººæ°—ã®ã‚ˆã†ã§ã™ã (ç‰¹ã« Web æ¥ç•Œã§ã¯)ã€‚ãªã®ã§ã€DBIx ãªä¾¿åˆ©ãªãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚‚é–‹ç™ºå½“åˆã¯ MySQL ã¨ SQLite ã§ã—ã‹å‹•ã‹ãªã‹ã£ãŸã‚Šã—ã¦æ‚²ã—ã„æ€ã„ã‚’ã™ã‚‹ã“ã¨ãŒã‚ã‚Šã€ã“ã¡ã‚ƒã“ã¡ã‚ƒ patch ã‚’æ›¸ã„ãŸã‚Šã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ ãã“ã§æºœã¾ã£ãŸã„ãã¤ã‹ã® Tips ã‚’ã“ã“ã§å…¬é–‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ 1. auto increment ã®æ‰±ã„ ã¾ãšã€ã„ã‚ã‚†ã‚‹è‡ªå‹•ç™ºç•ªãªã‚«ãƒ©ãƒ ã®æ‰±ã„ã«ã¤ã„ã¦ã€‚MySQL ã§ã¯ã‚«ãƒ©ãƒ å®šç¾©ã§ AUTO_INCREMENT æŒ‡å®šã€SQLite ã§ã¯æœ€åˆã®ã‚«ãƒ©ãƒ ã®åž‹ã‚’ INTEGER ã«ã—ã¦ PRIMARY KEY æŒ‡å®šã€ã§ã§ãã‚‹ã‚„ã¤ã§ã™ãã€‚PostgreSQL ã§ã¯ SERIAL åž‹ã‚’ä½¿ç”¨ã—ã¦å®šç¾©ã—ã¾ã™
gfx 2010/12/06
perl

database

postgresql
ãƒªãƒ³ã‚¯
tokuhirom blog
Blog Search when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: ${entry.path} [in template "__entry.ftlh" at line 3, column 25] - Reached through: #include "__entry.ftlh" [in template "entry.ftlh" at
gfx 2009/05/29
database

perl
ãƒªãƒ³ã‚¯
tokuhirom blog
Blog Search when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: ${entry.path} [in template "__entry.ftlh" at line 3, column 25] - Reached through: #include "__entry.ftlh" [in template "entry.ftlh" at
gfx 2009/02/05
perl

database
ãƒªãƒ³ã‚¯
ORMã‚’ä½œã‚‹ãŸã‚ã«æœ€ä½Žé™å¿…è¦ãª4+1ã®ã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆ - Yappo::ã‚¿ãƒ¯ã‚·
çŸæœŸé–“ã§CPANã«ä¸ŠãŒã£ã¦ã‚‹åãŒé€šã£ãŸO/Rãƒžãƒƒãƒ‘+Î±ã‚’ç›®ã‚’é€šã—ã¦ã€ORMãƒžãƒƒãƒ‘ã®å¿…è¦æœ€ä½Žé™ãªã‚³ãƒ³ãƒãƒ¼ãƒãƒ³ãƒˆã‚’æ•´ç†ã—ãŸã€‚ã¶ã£ã¡ã‚ƒã‘ã‚‚ã£ã¨å‰Šã£ã¦ã‚‚è‰¯ã„ãŒä¸€èˆ¬çš„ã«ã™ã‚‹ãŸã‚ã«ã‚‚ãƒªã‚¹ãƒˆã‚¢ãƒƒãƒ—ã€‚ ORM åŸºå¹¹çš„ãªã‚¯ãƒ©ã‚¹ã§ä½¿ã„æ–¹ã¯ORMã«ã‚ˆã‚Šã‘ã‚Šã§ã€ç‰¹ã«ç„¡ãã¦ã‚‚è‰¯ã„ã€‚ ORM::Schema ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‚’è¡Œã†å ´æ‰€ã€‚ç‰©ã«ã‚ˆã£ã¦ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å®šç¾©ã ã‘è¡Œã£ã¦ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®šç¾©ã¯ORM::Tableçš„ãªç‰©ã§è¡Œã†ã€‚ ã©ã£ã¡ã«ã—ã‚ãƒ†ãƒ¼ãƒ–ãƒ«ã®å®šç¾©ã«ã¯å¤‰ã‚ã‚‰ãªã„ã€‚ å¤§ã–ã£ã±ã«è¨€ã†ã¨ã€ã“ã®ã‚¯ãƒ©ã‚¹ã‹ã‚‰selectç³»ã®ãƒ¡ã‚½ãƒƒãƒ‰ãŒç”Ÿãˆã¦ã„ã‚‹ã€‚ ORM::Iterator çµæžœã®è¡Œã‚’å–ã‚Šæ‰±ã†ã‚¤ãƒ†ãƒ¬ãƒ¼ã‚¿ã€‚ DBICãªã‚‰DBIx::Class::Cursorã«ãªã‚ŠMoCoãªã‚‰DBIx::MoCo::ListãŒæ‹…å½“ã€‚ ORM::Row çµæžœã®è¡Œã”ã¨ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã€‚ã ã„ãŸã„ã¯ORM::Schema or Table ã§å®šç¾©ã—ã¦ã‚‹co
gfx 2009/02/01
database

ORM

perl
ãƒªãƒ³ã‚¯
1