[B! dbic] acotieã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

acotie id:acotie

dbicã«é–¢ã™ã‚‹acotieã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (23)

${{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ãªã©ã®è£œåŠ©æ©Ÿèƒ½ã‚’ä½¿ãˆ
acotie 2011/11/18
Perl

dbic
ãƒªãƒ³ã‚¯
DBICx::Deploy
NAME DBICx::Deploy - deploy a DBIx::Class schema SYNOPSIS use DBICx::Deploy; DBICx::Deploy->deploy('My::Schema' => 'DBI:SQLite:root/database'); or $ dbicdeploy -Ilib My::Schema DBI:SQLite:root/database METHODS deploy($schema, $dsn, @args) Loads the DBIC schema $schema, connects to $dsn (with extra args @args like username, password, and options), and deploys the schema. Dies on failure. If $dsn do
acotie 2010/06/25
perl

cpan

dbic
ãƒªãƒ³ã‚¯
http://blog.eorzea.asia/2009/10/post_76.html
acotie 2010/06/25
perl

orm

dbic
ãƒªãƒ³ã‚¯
SQL::Translator ã‚’ä½¿ã£ã¦ï¼ŒDBIC ã®ã‚¹ã‚ãƒ¼ãƒžã‚¯ãƒ©ã‚¹ã‚’è‡ªå‹•ä½œæˆ - daily dayflower
Catalyst::Model::DBIC::Schema ã‚’ä½¿ã„ã“ãªã™ã®ã¯ã‚„ã‚„ã‚ã‚“ã©ãã•ã„çŠ¶æ³ã§ã™ãŒï¼ŒSQL::Translator ã¨ã„ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒã‚ã‚Šï¼Œã“ã‚Œã«ä»˜å±žã™ã‚‹ sqlt ã¨ã„ã†ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã‚’ä½¿ã†ã¨ï¼Œã‚¹ã‚ãƒ¼ãƒžã‚’ DB ã‹ã‚‰ãƒãƒ¼ãƒ‰ã—ã¦ DBIC ã‚¯ãƒ©ã‚¹ã‚’ç”Ÿæˆã—ã¦ãã‚Œã¾ã™ã€‚ ãŸã¨ãˆã° SQLite ã® DB ãƒ•ã‚¡ã‚¤ãƒ« testdb ãŒã‚ã£ãŸã¨ã—ã¦ï¼Œ % sqlt -f DBI --dsn DBI:SQLite:testdb -t DBIx-Class-File > MyDBIC.pmã¨ã™ã‚‹ã¨ï¼Œtestdb ã«å«ã¾ã‚Œã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã‚¹ã‚ãƒ¼ãƒžãŒä¸€ã¤ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¨ã—ã¦ç”Ÿæˆã•ã‚Œã¾ã™ï¼ˆDBIC ã¨ DBIC::Schama ç”±æ¥ã®ã‚¯ãƒ©ã‚¹ã¨ã—ã¦ï¼‰ã€‚ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã‚¯ãƒ©ã‚¹åã¯ My::Schema ã¨ã„ã†åå‰ç©ºé–“ã§ã™ãŒï¼Œ--prefix ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§æ˜Žç¤ºçš„ã«æŒ‡å®šã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚
acotie 2010/06/21
perl

dbic

sql
ãƒªãƒ³ã‚¯
Plack+Catalystã§Webã‚¢ãƒ—ãƒªï¼ˆã¨CLIï¼‰ã‚’ä½œã£ã¦ã¿ã‚‹ - As a Futurist...
1 å¹´é–“ã‚¤ãƒ³ãƒ•ãƒ©ä¿®è¡Œã°ã£ã‹ã‚Šã‚„ã£ã¦ã¦ã€ã‚«ã‚¿ãƒ ãƒ¼ã‚¹ã¨ã‹ãƒ—ãƒ©ãƒƒã‚¯ä¼æ¥ã®æµã‚Œã«ä¹—ã‚Šåˆ‡ã‚Œãªã‹ã£ãŸã®ã§ ä¸€å¿µç™ºèµ·ã—ã¦æœ€è¿‘è¶£å‘³ã§ Plack ã¨ Catalyst ã§ Web ã‚¢ãƒ—ãƒªã‚’æ›¸ã“ã†ã¨ã—ã¦ã„ã¾ã™ã€‚ ãŸã ã€ã‚¢ãƒ—ãƒªã®ãƒã‚¸ãƒƒã‚¯ã«å…¥ã‚‹å‰ã«ã€ãã‚‚ãã‚‚ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®æ§‹é€ ã‚’ã©ã†ã—ã‚ˆã†ã‹ã¨ è©¦è¡ŒéŒ¯èª¤ã™ã‚‹ã ã‘ã§æ•°é€±ã€‚ã€‚ã€‚ä¸€æ—¦ã“ã“ã¾ã§ã®ã¾ã¨ã‚ã‚’ã—ã¦ãŠããŸã„ã¨æ€ã„ã¾ã—ãŸã€‚ Perl ç•Œéšˆã®æ–¹ã€…ã¯æœ¬å½“ã«ã‚¨ãƒãã¦ã™ã°ã‚‰ã—ã„ãªã¨æ”¹ã‚ã¦æ„Ÿã˜ã¾ã—ãŸã€‚ è‡ªåˆ†ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‚»ãƒ³ã‚¹ã®ç„¡ã•ã‚’ã²ã—ã²ã—ã¨æ„Ÿã˜ã¦ã¾ã™ãŒã€ ä»Šå›žã®ã‚¢ãƒ—ãƒªã®é–‹ç™ºã‚’é€šã˜ã¦ä½•ã‹ CPAN ã«ä¸Šã’ã¦ã€åƒ•ã‚‚ã‚¨ãƒããªã‚ŒãŸã‚‰ã„ã„ãªã ã¨ã‹å¯†ã‹ã«æ€ã£ã¦ãŸã‚Šã—ã¦ã¾ã™ã€‚ ãã‚Œã¯ MyApp::Web ã‹ã‚‰å§‹ã¾ã£ãŸ ã¨ã‚Šã‚ãˆãšãƒ¢ãƒ€ãƒ³ Perl å…¥é–€ã«ã‚ã‚‹ã‚ˆã†ã«ã€ä»¥ä¸‹ã®æ§˜ãªã‚³ãƒžãƒ³ãƒ‰ã§ Catalyst ç”¨ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ ä¸€æ®µåå‰ã‚’æŽ˜ã£ã¦ä½œã‚Šã¾ã—ãŸã€‚ catalyst MyApp::We
acotie 2010/06/15
perl

plack

catalyst

dbic
ãƒªãƒ³ã‚¯
Don't use DBIx::Class::UTF8Columns - JPerl Advent Calendar 2009
Don't use DBIx::Class::UTF8Columns - JPerl Advent Calendar 2009 Perl ã«é–¢ã™ã‚‹ã¡ã‚‡ã£ã¨ã—ãŸ Tips ã‚’ã®ã£ã‘ã¦ã¿ã‚‹ã‚ˆã€‚ã¡ã‚ƒã‚“ã¨ç¶šãã‹ãªï¼Ÿ è‡ªåˆ†ã®ã¤ãã£ãŸã‚‚ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ç´¹ä»‹ã™ã‚‹ãƒãƒƒã‚«ãƒ¼ãƒˆãƒ©ãƒƒã‚¯ã¨ã„ã†ã“ã¨ã§ã€åƒ•ã¯ DBIx::Class ã«åŒå°ã•ã‚Œã¦ã„ã‚‹ DBIx::Class::UTF8Columns ã«ã¤ã„ã¦æ›¸ãã¾ã™ã€‚ ã¾ãšæœ€åˆã«ã€ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ã¤ã‹ã‚ãªã„ã§ãã ã•ã„ã€‚ DBIx::Class::UTF8Columns ã¯ DBIx::Class ã®ã‚³ã‚¢ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«ãªã£ã¦ã‹ã‚‰ã€utf8 ã‚’æ‰±ã†å ´åˆã¯ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã†ã¨ã„ã„ã‚ˆã¨ã„ã†è¨˜è¿°ã‚’ã„ã‚ã„ã‚ãªã¨ã“ã‚ã§ç›®ã«ã—ã¾ã™ã€‚ã—ã‹ã—ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒã—ã¦ã„ã‚‹ã“ã¨ã‚’ç†è§£ã›ãšã«ä½¿ç”¨ã™ã‚‹ã¨äºˆæœŸã›ã¬ä¸å…·åˆã«æ‚©ã¾ã•ã‚Œã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ä»Šæ—¥ã¯ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã‚ãªã„æ–¹ãŒè‰¯ã„ç†ç”±ã¨ã€ãã®ä»£æ›¿æ¡ˆã‚’ç¤º
acotie 2009/12/08
perl

event

tips

dbic
ãƒªãƒ³ã‚¯
Wiki - TrainingHome: YAPC::Asia 2009 - Sep 10-11 in Tokyo, JAPAN
Wiki - TrainingHome YAPC::Asiaã®ç‰¹åˆ¥ç ”ä¿®é–‹å‚¬ã®ãŠçŸ¥ã‚‰ã› æ¦‚è¦ YAPC::Asia Tokyo 2009ã®é–‹å‚¬ã«åˆã‚ã›ã¦ã€Perlã«é–¢ã™ã‚‹ç ”ä¿®ã‚’åŸ·ã‚Šè¡Œã„ã¾ã™ã€‚å†…å®¹ã¯æœ€è¿‘è„šå…‰ã‚’æµ´ã³ã¦ã„ã‚‹æœ€æ–°ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã€ŒMooseã€ã®ã‚¤ãƒãƒã€MySQLã¨DBIx::Classã‚’ä½¿ã£ãŸéš›ã®ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚°ã‚„ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç‰ã€ãã—ã¦ã‚ã®å°é£¼å¼¾æ°ã®Perl / Ajaxã«ã¤ã„ã¦ã®è¬›æ¼”ã‚’äºˆå®šã—ã¦ã„ã¾ã™ã€‚ å¿œå‹ŸåŠã³å‚åŠ æ–¹æ³• ä»¥ä¸‹ã®æ¡ˆå†…ã‹ã‚‰å‚åŠ å¸Œæœ›ã®ç ”ä¿®ï¼ˆï¼‘æ—¥ã‹ã‚‰å‚åŠ å¯èƒ½ï¼‰ã‚’ç ”ä¿®ã®é¡Œåã¨ä»¥ä¸‹ã®å†…å®¹ã‚’kenshu@perlassociation.orgã¾ã§ã”é€£çµ¡ãã ã•ã„ã€‚ 1. ã”æ°å 2. å‚åŠ å¸Œæœ›ã®ç ”ä¿®é¡Œå 3. é›»è©±ç•ªå· 4. é ˜åŽè¨¼ã®å®›å é–‹å‚¬å ´æ‰€ JRç§‹è‘‰åŽŸä»˜è¿‘ã®UDXã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ http://udx.jp/conference/ é–‹å‚¬æ—¥æ™‚ 9æœˆï¼‘ï¼”æ—¥ã‹ã‚‰ï¼‘ï¼–æ—¥ å„
acotie 2009/08/05
å‚åŠ ã—ãŸã„ã‘ã©1ãƒ¶æœˆå‰ãªã®ã§ä¼šç¤¾çš„ã«ã©ã†ã ã‚ã†ã€‚ã€‚ã€‚

JPA

perl

event

moose

dbix-class

dbic
ãƒªãƒ³ã‚¯
DBIx::Class - Japan Perl Association Wiki
ãƒˆãƒ¬ãƒ¼ã‚¹ DBIx::Classã§è¤‡é›‘ãªã‚¯ã‚¨ãƒªã‚’è¡Œã£ã¦ã„ã‚‹å ´åˆã€å®Ÿéš›ã«ç™ºè¡Œã•ã‚Œã¦ã„ã‚‹ã‚¯ã‚¨ãƒªã‚’ã¿ã‚‹å¿…è¦ãŒã‚ã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ãã®ã‚ˆã†ãªå ´åˆã¯ç’°å¢ƒå¤‰æ•°DBIC_TRACEã‚’è¨å®šã—ã¦ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’å®Ÿè¡Œã™ã‚‹ã¨å®Ÿè¡Œã•ã‚Œã¦ã„ã‚‹ã‚¯ã‚¨ãƒªã‚’ã¿ã‚‹ã“ã¨ãŒã§ãã¾ã™ï¼š DBIC_TRACE=1Â myscript.pl ã‚¯ã‚¨ãƒªãŒå¤šãã¦ä¸€åº¦ã«è¿½ã†ã®ãŒé›£ã—ã„å ´åˆã¯ã“ã®å‡ºåŠ›ã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã«å‘ã‘ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ DBIC_TRACE=1=/path/to/query.logÂ myscript.pl ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ DBIx::Class 0.08100ä»¥ä¸Šã‚’ãŠä½¿ã„ã§ã‚ã‚Œã°ã€æ˜Žç¤ºçš„ã«ä½•ã‚‚æŒ‡å®šã—ãªãã¦ã‚‚DBIx::Class::Storage::TxnScopeGuardã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ #!/usr/bin/perl useÂ strict; useÂ MyApp::Schema; myÂ $schemaÂ =Â MyApp::
acotie 2009/06/29
"DBIx::Class 0.08100ä»¥ä¸Šã‚’ãŠä½¿ã„ã§ã‚ã‚Œã°ã€æ˜Žç¤ºçš„ã«ä½•ã‚‚æŒ‡å®šã—ãªãã¦ã‚‚DBIx::Class::Storage::TxnScopeGuardã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚"

dbic

perl

JPA
ãƒªãƒ³ã‚¯
namespaceã‚’ä½¿ã£ãŸDBIx::Classã®ã‚¹ã‚ãƒ¼ãƒžæ§‹æˆ - hide-k.net#blog
è‰¯ãã‚ã‚‹DBICã®ã‚µãƒ³ãƒ—ãƒ«ã§ã¯DBIx::Class::Schema::load_classes()ã‚’ä½¿ã£ã¦ã‚¯ãƒ©ã‚¹ã®ãƒãƒ¼ãƒ‰ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ CD.pm package CD; use strict; use warnings; use base 'DBIx::Class::Schema'; __PACKAGE__->load_classes; 1; load_classes()ã¯ã‚¯ãƒ©ã‚¹ã‚’æŒ‡å®šã—ãªã„ã¨ CD Album Track ã¨ã„ã†æ§‹æˆã«ãŠã„ã¦è‡ªå‹•çš„ã«ã‚¯ãƒ©ã‚¹ã‚’ãƒãƒ¼ãƒ‰ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã“ã“ã§ResultSetã®æ‹¡å¼µã‚’ã—ãŸã„ã¨è€ƒãˆã¾ã™ã€‚ä¾‹ãˆã° CD/ResultSet/Album.pm package CD::ResultSet::Album; use strict; use warnings; use base 'DBIx::Class::ResultSet'; sub search
acotie 2009/06/03
"CD::ResultSet::*ã«ã—ã¦ã—ã¾ã†ã¨ã€load_classes()ã§warningãŒå‡ºã‚‹ç¾½ç›®ã«ãªã‚Šã¾ã™ã€‚"ã€€å€‹äººçš„ã«ã™ã£ã”ã„ã‚¿ã‚¤ãƒ ãƒªãƒ¼ãªæƒ…å ±ã§ã—ãŸã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ï¼

dbic

perl
ãƒªãƒ³ã‚¯
https://hibinokoto.jp/archives/2008/05/post-263.html
acotie 2009/05/29
dbic
ãƒªãƒ³ã‚¯
unknownplace.org - Tags: dbic
acotie 2009/05/29
dbic
ãƒªãƒ³ã‚¯
http://hibinokoto.jp/archives/2008/05/post-265.html
acotie 2009/05/29
dbic
ãƒªãƒ³ã‚¯
catalyst:dbic [paulownia.jp]
DBIx::Class::Schema::Loaderã‚’å…¥ã‚Œã‚Œã°ã€ãã®ä¸Šã®ï¼“ã¤ã‚‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹ã€‚DBDã¯ã©ã‚Œã‚’ä½¿ã†ã‹èžã‹ã‚Œã‚‹ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ã€Œã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãªã„ã€ãªã®ã§ãƒªã‚¿ãƒ¼ãƒ³é€£æ‰“ã—ãªã„ã‚ˆã†ã«æ³¨æ„ã—ã¦ã€‚ã»ã‹ã«ã‚‚ç‰©å‡„ã„å¤§é‡ã®ä¾å˜ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã€‚ Catalystã®DBIã‚µãƒãƒ¼ãƒˆé–¢é€£ã‚¯ãƒ©ã‚¹ã‚’CPANã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« é©å½“ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ã€‚ CREATE TABLE books ( id INTEGER NOT NULL AUTO_INCREMENT, isbn VARCHAR(13), title VARCHAR(255) NOT NULL, author VARCHAR(255), summary TEXT, PRIMARY KEY(id) ) character SET utf8 type=innoDB; ãƒ†ã‚¹ãƒˆç”¨ã«é©å½“ãªãƒ‡ãƒ¼ã‚¿ã‚‚ãƒ–ãƒƒè¾¼ã‚“ã§ãŠã insert into boo
acotie 2009/05/27
catalyst

dbic

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
Using DBIx::Class to Version Your Schema
Intro to DBIx::Class In my opinion DBIx::Class is one of the best ORM solutions out there. Not only can it model your database, including mapping out any foreign key relationships, it can also be used as a canonical point of reference for your schema.Â Â This means we can use it not only as an application layer interface to the database, but can also defineÂ a versioned database structure using the
acotie 2009/05/21
migration

dbic

perl
ãƒªãƒ³ã‚¯
DBIx::Classã®è¦šæ›¸ - Ktat's Wiki
[ã‚«ãƒ†ã‚´ãƒª:Perl] ãŠæ‰‹è»½ã«Shcemaã‚’ä½œã‚‹ ä½œã‚‰ã‚Œã‚‹SQLã‚’è¦‹ãŸã„ â—¯â—¯ã§ãªã‘ã‚Œã°ä½œæˆ è¦‹ä»˜ã‹ã‚‰ãªã‘ã‚Œã°ä½œæˆ æ›´æ–°ã§ãªã‘ã‚Œã°ä½œæˆ find_or_new is null / is not null transaction update_or_create ã§ id => "" ã‚’æ¸¡ã™ã¨ï¼Ÿ countã¨group_by ãŠæ‰‹è»½ã«Shcemaã‚’ä½œã‚‹use DBIx::Class::Schema::Loader DBIx::Class::Schema::Loader::make_schema_at ( "DB::Schema", {debug => 1, relationships => 1}, ["dbi:mysql:dbname"] ); ä½œã‚‰ã‚Œã‚‹SQLã‚’è¦‹ãŸã„$ENV{DBIC_TRACE} = 1; ã¨ã™ã‚Œã°ã€STDERRã«å‡ºåŠ›ã•ã‚Œã‚‹ã€‚ $ENV{DBIX_CLASS_STORA
acotie 2009/05/07
dbic

mysql

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
æ¨ªã®ãƒžãƒ¼ã‚¯ - DBIx::Classã‚’ä½¿ã£ã¦MySQLã§ä»Šæ—¥ãŒèª•ç”Ÿæ—¥ã®äººã‚’å–å¾—ã™ã‚‹æ–¹æ³•
acotie 2009/05/07
dbic

mysql
ãƒªãƒ³ã‚¯
DBIx::Class::Manual::Cookbook - æ§˜ã€…ãªãƒ¬ã‚·ãƒ”
æ¤œç´¢ æ¤œç´¢çµæžœã®ãƒšãƒ¼ã‚¸åˆ†ã‘ å•ã„åˆã‚ã›ã«å¯¾ã—ã¦å¤§é‡ã®çµæžœãŒè¿”ã•ã‚Œã‚‹ã“ã¨ãŒäºˆæƒ³ã•ã‚Œã‚‹æ™‚ã¯ã€DBIx::Classã«å¯¾ã—ã¦çµæžœã‚»ãƒƒãƒˆã‚’ãƒšãƒ¼ã‚¸åˆ†ã‘ï¼ˆä¸€åº¦ã«å°‘ã—ãšã¤å–å¾—ï¼‰ã™ã‚‹ã‚ˆã†è¦æ±‚ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ï¼š my $rs = $schema->resultset('Artist')->search( undef, { page => 1, # å–å¾—ã—ãŸã„ãƒšãƒ¼ã‚¸ç•ªå·ï¼ˆãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯1ï¼‰ rows => 10, # ãƒšãƒ¼ã‚¸æ¯Žã®ä»¶æ•° }, ); return $rs->all(); # 1ãƒšãƒ¼ã‚¸ç›®ã‚’å…¨ã¦å–å¾—ã™ã‚‹ pageå±žæ€§ã¯ã€æ¤œç´¢ã«ãŠã„ã¦å¿…ãšã—ã‚‚æŒ‡å®šã™ã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ï¼š my $rs = $schema->resultset('Artist')->search( undef, { rows => 10, } ); return $rs->page(1); # æœ€åˆã®10ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å«ã‚€DBIx::Class
acotie 2009/05/01
"æ¤œç´¢ã‚’ã‚ã‚‰ã‹ã˜ã‚å®šç¾©ã™ã‚‹"

dbic

perl

perldoc
ãƒªãƒ³ã‚¯
Re: [Dbix-class] outer join with explicit criteria rears its ugly head (again)
acotie 2009/05/01
LEFT OUTER

dbic

FAQ
ãƒªãƒ³ã‚¯
DBIx::Class::ResultSet
NAME DBIx::Class::ResultSet - Responsible for fetching and creating resultset. SYNOPSIS my $rs = $schema->resultset('User')->search(registered => 1); my @rows = $schema->resultset('CD')->search(year => 2005); DESCRIPTION The resultset is also known as an iterator. It is responsible for handling queries that may return an arbitrary number of rows, e.g. via "search" or a has_many relationship. In th
acotie 2009/05/01
dbic

dbix-class

perldoc
ãƒªãƒ³ã‚¯
2007-11-01
PostgreSQLã§ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã¤ãã‚‹ã€‚ CREATE TABLE table1( c1 integer PRIMARY KEY ); INSERT INTO table1 VALUES(1),(2),(3),(4),(5); % createdb testdb % psql -f testdb.sql -d testdbPRIMARY KEYã«æŒ‡å®šã—ãŸãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®å€¤ã‚’ä½¿ã£ã¦æ¤œç´¢ã™ã‚‹ã€‚ package TestDB::Schema; use base qw/DBIx::Class::Schema::Loader/; __PACKAGE__->loader_options( relationships => 1, ); 1; package main; my $db_schema = TestDB::Schema->connect("dbi:Pg:dbname=testdb","","",u
acotie 2009/04/14
dbic

dbix-class
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸