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

mogwaing id:mogwaing

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

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

SQL::Abstract ã‹ã—ã“ã™ - daily dayflower
ä»¥å‰ã€ŒDBICã§æœ¬å½“ã«å›°ã£ãŸã‚‰ SCALAR REFERNCE ã‚’ä½¿ãˆ - daily dayflowerã€ã«ã¦ï¼Œ DBIC ã§ WHERE field1 IS NOT NULL ãªæ¤œç´¢ã‚’ã—ã‚ˆã†ã¨æ€ã£ã¦ï¼Œ â€¦â€¦ $resultset->search({ field1 => \'IS NOT NULL' }); ã¨ã‹æ›¸ã„ã¦ã„ãŸã‚“ã§ã™ãŒï¼Œ $resultset->search({ field1 => { '!=', undef } });ã§ã‚ˆã‹ã£ãŸã®ã§ã—ãŸã€‚ $resultset->search({ field1 => undef });ãŒ WHERE field1 IS NULLã¨ã„ã†ã®ã¯çŸ¥ã£ã¦ã„ãŸã‚“ã§ã™ãŒï¼Œ'!=' ã‚’ã¤ã‘ã‚‹ã¨ãã¡ã‚“ã¨ã€ŒIS NOT NULLã€ã«å¤‰æ›ã—ã¦ãã‚Œã‚‹ã¨ã¯ï¼ˆSQL::Abstract ã® 714 è¡Œç›®ã‚ãŸã‚Šã®ãƒã‚¸ãƒƒã‚¯ã¨ã—ã¦ã¡ã‚ƒã‚“ã¨ã‚ã‚Šã¾ã—ãŸï¼‰ã€‚ã“ã‚Œã§ã‚¹ã‚«ãƒ©ãƒ¼ãƒªãƒ•ã‚¡ãƒ¬
mogwaing 2007/08/22
is null, is not null ç‰ã®ã‚„ã‚Šæ–¹

perl

dbic
ãƒªãƒ³ã‚¯
DBICã§æœ¬å½“ã«å›°ã£ãŸã‚‰ SCALAR REFERNCE ã‚’ä½¿ãˆ - daily dayflower
è¿½è¨˜ 2006/12/06 ä¸‹è¨˜ã§ IS NOT NULL ã‚’å®Ÿç¾ã™ã‚‹ã®ã«ã‚¹ã‚«ãƒ©ãƒ¼ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’ä½¿ç”¨ã—ã¦ã„ã¾ã™ãŒï¼ŒIS NULL / IS NOT NULL ã‚’å‡ºã™ãŸã‚ã«ã¯å¿…ãšã—ã‚‚ã‚¹ã‚«ãƒ©ãƒ¼ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹å¿…è¦ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã¨ã„ã†ã“ã¨ã§è¨‚æ£ã‚’å…¥ã‚Œã‚ˆã†ã¨æ€ã£ãŸã‚“ã§ã™ãŒã¡ã‚‡ã£ã¨é•·ã„ã®ã§ã€Œãƒ•ã‚©ãƒãƒ¼ã‚¢ãƒƒãƒ—è¨˜äº‹ã€ã‚’æ›¸ãã¾ã—ãŸã€‚ æœ¬é¡Œ typester ã•ã‚“ã«ä»¥å‰æ•™ãˆã¦é ‚ã„ãŸã‚“ã§ã™ãŒï¼Œä¼¼ãŸã‚ˆã†ãªã“ã¨ã«ä»Šæ—¥éé‡ã—ãŸã®ã§ãƒ¡ãƒ¢ã€‚ WHERE field1 IS NOT NULL ãªæ¤œç´¢ã‚’ã—ã‚ˆã†ã¨æ€ã£ã¦ï¼Œ $resultset->search({ field1 => 'IS NOT NULL' });ã¨æ›¸ãã¨ï¼Œå†…éƒ¨çš„ã«ã¯ SELECT ... WHERE field1 = ?ã¨å±•é–‹ã•ã‚Œã¦ï¼Œãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ã«ã€ŒIS NOT NULLã€ãŒæ¸¡ã•ã‚Œã‚‹ã®ã§ï¼Œãƒãƒ„ã€‚ $resultset->search({ field
mogwaing 2007/08/22
perl

dbic
ãƒªãƒ³ã‚¯
10åˆ†(ï¼Ÿ)ã§å‡ºæ¥ã‚‹DBIx::Class ã®å°Žå…¥ï½œPerlãƒ—ãƒã‚°ãƒ©ãƒ ãƒ¡ãƒ¢ï½œãƒ—ãƒã‚°ãƒ©ãƒ ãƒ¡ãƒ¢
â– 1. DBIx::Classã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ä¾‹ã«ã‚ˆã£ã¦CPANã‚³ãƒžãƒ³ãƒ‰ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ unixã®ã‚·ã‚§ãƒ«ã‹ã‚‰ perl -MCPAN -e shell cpan > install DBIx::Class cpan > install DBIx::Class::Schema::Loader ã§OKã€‚ ï¼ˆä½•ã‹å…¥åŠ›ãŒä¿ƒã•ã‚ŒãŸã‚‰ãã®ã¾ã¾Enterã‚’æŠ¼ã›ã°ã„ã„ã§ã™ï¼‰ â– 2.ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ¼ãƒžã®è‡ªå‹•ç”Ÿæˆ unixã®ã‚·ã‚§ãƒ«ã§ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ä½œæˆã™ã‚‹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ç§»ã£ã¦ã‹ã‚‰ perl -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:./lib -e 'make_schema_at "Hoge::Schema", {relationships => 1, debug => 1}, ["dbi:mysql:hoge","user","pa
mogwaing 2007/08/17
perl

dbic
ãƒªãƒ³ã‚¯
[O] DBICã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒè‰¯ãã‚ã‹ã‚‰ãªã„ã®ã§ãƒ¡ãƒ¢ - 1å¯¾1
Â«Â æ¨ªæµœè¥¿å£ ã‚¹ã‚¿ãƒ¼ãƒãƒƒã‚¯ã‚¹ | ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ | DBICã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒè‰¯ãã‚ã‹ã‚‰ãªã„ã®ã§ãƒ¡ãƒ¢ - 1å¯¾å¤šÂ Â» DBICã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒè‰¯ãã‚ã‹ã‚‰ãªã„ã®ã§ãƒ¡ãƒ¢ - 1å¯¾1 [Perl] [2007-01-08]:è¿½è¨˜ [2007-01-07-1]ã§ã€DBICã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ãƒƒãƒ—ã«ã¤ã„ã¦ã®ã‚¨ãƒ³ãƒˆãƒªã‚’ æ›¸ãã¾ã—ãŸã€‚ä»¥ä¸‹ã¯éžå¸¸ã«ã„ã„åŠ æ¸›ãªã®ã§[2007-01-07-1]ã‚’ã©ã†ãžã€‚ ã‚ˆãåˆ†ã‹ã‚‰ãªã„ã¨ã„ã†ã‹ã€has_oneã¨might_haveã¨belong_toã®æ˜Žç¢ºãªé•ã„ ãŒåˆ†ã‹ã‚‰ãªãã¦ã€ã©ã†ã™ã‚Œã°ä¸€ç”Ÿé–“é•ã„ãªãç†è§£ã§ãã‚‹ã‹ãªã¨ã€ ã“ã‚Œã‚‰ã‚’è¦‹ã¦ã€ç†è§£ã™ã‚‹ã“ã¨ã‹ã‚‰å§‹ã‚ãŸã€‚ 101å·å®¤ã‚ˆã‚Šæ„›ã‚’ã“ã‚ã¦: [DBIx::Class][DBIC][perl] DBIx::Classã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ Perl/DBIC - Nekokak's core dump DBIx::Class::
mogwaing 2007/08/02
perl

dbic

relationship
ãƒªãƒ³ã‚¯
2007/05/07 - memo - unknownplace.org
æ›¸ãå¿˜ã‚ŒãŸã‘ã©ã•ã£ãã® update_schema.pl ã¯ ./script/myapp_update_schema.pl dbi:mysql:tablename username password è¦‹ãŸã„ãªæ„Ÿã˜ã§ DSN ã‚’æ¸¡ã™å¿…è¦ãŒã‚ã‚‹ã€‚ã‚ã‚“ã©ã†ã€‚ ã“ã“ã‚‰è¾ºãŒã‚ã‚Œã§ã¾ã ãƒ˜ãƒ«ãƒ‘ãƒ¼ã«ã¯ãªã£ã¦ãªã„ã€‚ mizzy.org : Re: DBICã¨DBIx::Class::Schema::Loader åƒ•ã®ã„ã‚ã„ã‚ãªå‹˜é•ã„ åƒ•ã®ä¸ã§æµè¡Œã£ã¦ã‚‹ä½¿ã„æ–¹ãŒã‚ã‚‹ã®ã§ã‹ã¶ã›ã¦æ›¸ã„ã¦ãŠã„ã¦ã¿ã‚‹ã€‚mizzy ã•ã‚“ã®äºŒå€‹ç›®ã®ä¾‹ã‚’è‡ªåˆ†ãƒ«ãƒ¼ãƒ«åŒ–ã•ã›ãŸæ„Ÿã˜ï¼Ÿ ä½œæ¥ã¯ä¸€èˆ¬çš„ãªCatalystã‚¢ãƒ—ãƒªã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªæ§‹é€ ä¸Šã§ã‚ã‚‹ã¨ã—ã¦ã€ãã“ã«æ–°ã—ã schema ã¨ã„ã†ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ä½œæˆã€‚ ãã‚“ã§ã€ schema/lib/Schema/{TableName}.pm ã«å„ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³å®šç¾©ã¨ã‹ãƒ¡ã‚½ãƒƒãƒ‰ã¨ã‹ã‚’è‡ªåˆ†ã§æ›¸ãã€‚
mogwaing 2007/06/09
perl

dbic

to see
ãƒªãƒ³ã‚¯
[O] DBICã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ãƒƒãƒ—
Â«Â TaskPadã‚’ä½¿ã„ãªãŒã‚‰ä½œæ¥ä½œæ¥ | ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ | æ–°å®¿ ç£¯å–„Â Â» DBICã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ãƒƒãƒ— [Perl] ã‚„ã£ã±ã‚Šã€DBIx::Class::Relationshipã‚’èªã¿ç›´ã™ã“ã¨ã«ã—ãŸã€‚ ã“ã†ã„ã†ã®ã‚’ã¡ã‚ƒã‚“ã¨ç†è§£ã—ã¦ãŠã‹ãªã„ã¨è¶³ã‚’ã™ãã‚ã‚Œã‚‹ã—ã€‚ ã¡ã‚‡ã£ã¨ã¥ã¤æ›¸ã„ãŸã‚‰ã€ä½•æ—¥ã‚‚ã‹ã‹ã£ãŸã€‚ã‚·ãƒ§ãƒ³ãƒœãƒªã€‚ ã¾ãšã¯å‰æã¨ãªã‚‹ãƒ‡ãƒ¼ã‚¿ ã“ã‚“ãªæ„Ÿã˜ã§ã€Authorãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã€Bookãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚‹ã¨ã™ã‚‹ã€‚ ID | Name | Age ------------------ 1 | Fred | 30 2 | Joe | 32 ID | Author | Name -------------------- 1 | 1 | Rulers of the universe 2 | 1 | Rulers of the galaxy ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ãƒƒãƒ—ãªã—ã®å ´åˆ ã‚‚ã—ã‚‚ãƒª
mogwaing 2007/04/20
perl

dbic

relationship
ãƒªãƒ³ã‚¯
DBIx::Class::Schema::Loader ã§ 34 ç§’ãã‚‰ã„ã§ Schema ã‚¯ãƒ©ã‚¹ç”Ÿæˆ - ITæˆ¦è¨˜
æ—¢å˜ DB ã‹ã‚‰ä»¥ä¸‹ã®ãƒ¯ãƒ³ãƒ©ã‚¤ãƒŠãƒ¼ä¸€ç™ºã§ DBIx::Class ã® Schema ãŒç”Ÿæˆã§ãã‚‹ $ perl -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:./lib -e 'make_schema_at "Hoge::Schema", {relationships => 1, debug => 1}, ["dbi:mysql:hoge","user","password"]' ã‚„ã‚Šã‹ãŸã€‚ ã¾ãšã€ã‚¯ãƒ©ã‚¹ã‚’ä½œã‚ŠãŸã„ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªä»˜è¿‘ã«ç§»å‹• ã•ã£ãã®ã‚³ãƒžãƒ³ãƒ‰ã® dump_to_dir: ã®ç®‡æ‰€ã«ã‚¯ãƒ©ã‚¹ãƒ„ãƒªãƒ¼ã®èµ·ç‚¹ã¨ãªã‚‹ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’æŒ‡å®š make_schema_at ã®ç¬¬ä¸€å¼•æ•°ã«ç”Ÿæˆã™ã‚‹ Schema ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸åã‚’æŒ‡å®š å¤–éƒ¨ã‚ãƒ¼åˆ¶ç´„ã¨ã‹ã‚’è€ƒæ…®ã—ã¦ has_many ã¨ã‹ belongs_to ã¨ã‹ã‚’è‡ªå‹•ã§è¨å®šã—ã¦æ¬²ã—ã„å ´åˆ
mogwaing 2007/04/19
[DBIx::Class] schema loader

perl

dbic
ãƒªãƒ³ã‚¯
1