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

vkgtaro id:vkgtaro

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

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

DBICx::Modeler::Generatorã§ã‚¹ã‚ãƒ¼ãƒžã‚¯ãƒ©ã‚¹ç¾¤ã¨ãƒ¢ãƒ‡ãƒ«ã‚¯ãƒ©ã‚¹ç¾¤ã‚’ä¸€ç™ºç”Ÿæˆã—ã‚ˆã† - JPerl Advent Calendar 2009
DBICx::Modeler::Generatorã§ã‚¹ã‚ãƒ¼ãƒžã‚¯ãƒ©ã‚¹ç¾¤ã¨ãƒ¢ãƒ‡ãƒ«ã‚¯ãƒ©ã‚¹ç¾¤ã‚’ä¸€ç™ºç”Ÿæˆã—ã‚ˆã† - JPerl Advent Calendar 2009 Perl ã«é–¢ã™ã‚‹ã¡ã‚‡ã£ã¨ã—ãŸ Tips ã‚’ã®ã£ã‘ã¦ã¿ã‚‹ã‚ˆã€‚ã¡ã‚ƒã‚“ã¨ç¶šãã‹ãªï¼Ÿ ã”æŒ¨æ‹¶ ã¯ã˜ã‚ã¾ã—ã¦ã€gardejoã“ã¨å®ˆå±‹ã¨ç”³ã—ã¾ã™ã€‚é‡‘èžãƒ¦ãƒ¼åã§åƒã„ã¦ã„ã¾ã™ã€‚YAPC::Asia 2009ã®ç‰¹åˆ¥ç ”ä¿®ã§ã€ï¼ˆ16æ—¥ç›®ã‚’åŸ·ç†ã•ã‚ŒãŸï¼‰dankogaiã•ã‚“ã®ç ”ä¿®ã®å¾Œã«ã€ï¼ˆ15æ—¥ç›®ã‚’åŸ·ç†ã•ã‚ŒãŸï¼‰lestrratã•ã‚“ãªã©ã®ç‰¹åˆ¥è£œè¬›ã‚’å—ã‘ã‚‹æ©Ÿä¼šã«æµã¾ã‚ŒãŸã®ã§ã™ãŒã€ã€Œæ¥å‹™ã§COBOLã‚’ä½¿ã£ã¦ã„ã‚‹äººï¼Ÿã€ã¨ã„ã†è³ªå•ã«ãŸã ç‹¬ã‚ŠæŒ™æ‰‹ã—ã¦ã€ãŸã„ãã†æ¥ãšã‹ã—ã„æ€ã„ã‚’ã—ã¾ã—ãŸã€‚ ãã‚“ãªå‹¤ã‚å…ˆã§ã¯å®šä¾‹ä½œæ¥æ’²æ»…ã®ãŸã‚ãªã©ã«Perlã‚’ã‚²ãƒªãƒ©çš„ã«æ´»ç”¨ã—ã¦ã„ã¾ã™ãŒã€ç¾å ´ãƒ¬ãƒ™ãƒ«ã§ã®å¯¾ç—‡ç™‚æ³•ã§ã‚ã‚‹ã«éŽãŽã¾ã›ã‚“ã€‚ç§ã«ã¨ã£ã¦ã®Perlã¨ã¯ã€ã‚¨ã‚¹ãƒšãƒ©ãƒ³ãƒˆæ—¥æœ¬èªžç¿»è¨³ã‚·ã‚¹ãƒ†ãƒ ã®é–‹ç™ºãª
vkgtaro 2009/12/22
super! DBIC::Schema::Loader ã® schema ç¾¤ã¨ DBICx::Modelar ã®ãƒ¢ãƒ‡ãƒ«ç¾¤ã‚’ç”Ÿæˆã€‚

dbic

perl

dbicx
ãƒªãƒ³ã‚¯
DBIC ã§ç”Ÿã® SQL ã‚’å®Ÿè¡Œã—ãŸã„ã¨ãã¯ $storage->dbh_do() ã¨ $storage->dbh() ã©ã¡ã‚‰ãŒé©åˆ‡ï¼Ÿ - @kyanny's blog
DBIC ã§ç”Ÿã® SQL ã‚’å®Ÿè¡Œã—ãŸã„ã¨ãã¯ $storage->dbh_do() ã‚’ä½¿ãˆã°è‰¯ã„ã¨ã„ã†ã“ã¨ã‚’çŸ¥ã£ãŸã€‚ my @stuff = $schema->storage->dbh_do( sub { my ($storage, $dbh, @args) = @_; $dbh->do("DROP TABLE authors"); }, @column_list ); http://search.cpan.org/~frew/DBIx-Class-0.08114/lib/DBIx/Class/Storage/DBI.pm#dbh_do ã‚‚ã†ã„ã£ã“ $storage->dbh() ã¦ã®ã‚‚ã‚ã‚Šã€ã“ã¡ã‚‰ã¯è¦‹ãŸé€šã‚Š $dbh ã‚’è¿”ã™ã€‚ã“ã‚Œã‚’ãµã¤ã†ã« DBI ã‚’æ‰±ã†ã¨ãã®ã‚ˆã†ã«ä½¿ã£ã¦ã‚‚ã„ã‘ã‚‹ã‚ˆã†ã ã€‚ http://search.cpan.org/~frew/DBIx-Class-0.08114/l
vkgtaro 2009/12/09
è‡ªåˆ†ã¯ $storage->dbh(); ã§ DBI ãƒãƒ³ãƒ‰ãƒ«å–ã‚‹æ´¾ã§ã—ãŸã€‚ã‚ã¾ã‚Šæ·±ãè€ƒãˆãšã«ä½¿ã£ã¦ãŸ >_<

dbic
ãƒªãƒ³ã‚¯
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
vkgtaro 2009/06/03
nrhd

dbic
ãƒªãƒ³ã‚¯
resultset_attributes ã‚’åˆ©ç”¨ã—ã¦ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã® alias ã‚’ me ã‹ã‚‰å¤‰æ›´ã™ã‚‹ with DBIC - (ï¾Ÿâˆ€ï¾Ÿ)oå½¡ sasata299's blog
2009å¹´05æœˆ19æ—¥02:17 Perl resultset_attributes ã‚’åˆ©ç”¨ã—ã¦ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã® alias ã‚’ me ã‹ã‚‰å¤‰æ›´ã™ã‚‹ with DBIC ã“ã‚“ã°ã‚“ã‚ã€‚ã•ã•ãŸã¤ã§ã™ã€‚ãƒ¾(oï¾ŸÏ‰ï¾Ÿo)ï¾‰ï¾ž ä»Šæ—¥ã¯DBICã®è©±ã§ã™ã€‚æœ€è¿‘perlã®O/Rãƒžãƒƒãƒ‘ãƒ¼ã§ã‚ã‚‹DBICã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ç°¡å˜ãªSQLã ã¨ã¨ã¦ã‚‚ä¾¿åˆ©ãªã‚“ã§ã™ãŒã€è¤‡é›‘ãªSQLã«ãªã‚‹ã¨ã€‚ã€‚ã€‚ã™ãã«ã‚¹ã‚«ãƒ©ãƒ¼ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã«é ¼ã£ã¦ã—ã¾ã„ã¾ã™ï¼ˆã‚ˆãï¼Ÿï¼žï¼œï¼‰ ã•ã¦ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã¯ delete_flag ã‚’å¿…ãšç½®ãã‚ˆã†ã«è¨è¨ˆã—ã¦ã„ã¦ã€findã¨ã‹searchã—ãŸã¨ãã« delete_flag = 0 ã‚’ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®æ¤œç´¢æ¡ä»¶ã¨ã—ã¦åˆ©ç”¨ã™ã‚‹ãŸã‚ã€Schemaãƒ•ã‚¡ã‚¤ãƒ«ã«ã“ã®ã‚ˆã†ãªè¨å®šã‚’æ›¸ã„ã¦ã„ã¾ã—ãŸã€‚ __PACKAGE__->resultset_attributes({ where => {delete_flag => 0} }); ãŸã
vkgtaro 2009/05/19
dbic
ãƒªãƒ³ã‚¯
catalystã®ã‚µãƒ³ãƒ—ãƒ«ã‚¢ãƒ—ãƒªã¨ã‚½ãƒ¼ã‚¹ã‚’å…¬é–‹ã—ã¦ã¿ã‚‹ - æ–°ã ã‚‹ã‚ãè·¡åœ°
ãƒ¢ãƒ€ãƒ³Perlå…¥é–€ã‚’èªã‚“ã§è‰²ã€…å‹‰å¼·ã—ãŸã®ã§ã€ã‚µãƒ³ãƒ—ãƒ«ã‚¢ãƒ—ãƒªã‚’ä½œã£ã¦è‡ªå®…ã‚µãƒ¼ãƒã§å…¬é–‹ã—ã¦ã¿ã‚‹ã€‚ http://niget.net/ ã‚½ãƒ¼ã‚¹ã¯githubã§æ™’ã—ä¸ã€‚ http://github.com/hirafoo/niget/tree/master èª°ã‹ã®å‚è€ƒã«ãªã£ãŸã‚Šã€disã‚‰ã‚ŒãŸã‚Šã€ã‚ã‚Œã“ã‚Œè°è«–ã—ãŸã‚Šã€ä½•ã‹ãŒèµ·ã“ã£ãŸã‚Šã™ã‚‹ã®ã‚’æœŸå¾…ä¸ã€‚ ã¨ã‚Šã‚ãˆãšã€ã“ã®ã‚¢ãƒ—ãƒªã®ä½¿ã„æ–¹ã¨ã‹ã€‚ ãƒ‹ã‚³ãƒ‹ã‚³å‹•ç”»ã®ä»»æ„ã®å‹•ç”»ã®URLã‚’å…¥åŠ› é©å½“ãƒãƒªãƒ‡ãƒ¼ãƒˆã‚’é€šã£ãŸã‚‰DBã«ä¿å˜ 5åˆ†ã«1å›žcronãŒèµ°ã‚‹ã€‚å†…å®¹ã¯ã€ãƒ‹ã‚³ãƒ‹ã‚³å‹•ç”»ã®APIã‚’å©ã„ã¦ã€å‹•ç”»æœ¬ä½“ã®URLã¨å‹•ç”»ã®åå‰ã‚’å–å¾— APIã¯2å€‹ã‚ã‚‹ã€‚æœ¬ä½“ã®URLã‚’å–å¾—ã™ã‚‹éƒ¨åˆ†ã¯å°é£¼ å¼¾ã•ã‚“ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’ä½¿ã‚ã›ã¦ã‚‚ã‚‰ã£ãŸ å–å¾—ã—ãŸå†…å®¹ã‚’DBã«ä¿å˜ã€‚å–å¾—æ¸ˆã¿ã®å‹•ç”»ã¯å‰Šé™¤ã€‚ ã‚ã¨ã¯å‹•ç”»æœ¬ä½“ã‚’è½ã¨ã›ã°ã„ã„ã˜ã‚ƒãªã„ ä»¥ä¸Šã€‚ ã¾ãƒ¼ã‚µãƒ³ãƒ—ãƒ«ã‚¢ãƒ—ãƒªã ã—ãï¼ ã§ã‚‚ã€æœ¬ä½“URLã‚’å–å¾—ã§ãã‚‹w
vkgtaro 2009/04/14
catalyst

dbic
ãƒªãƒ³ã‚¯
Using Unicode - Catalyst::Wiki
Prior to version 5.90040 it was required that you load the Catalyst::Plugin::Unicode::Encoding plugin to ensure proper decoding/encoding of incoming request parameters and the outgoing body response respectively. This is done in your MyApp.pm: use Catalyst qw/ -Debug ConfigLoader Unicode::Encoding /; Since that version the Unicode support was added to core by shipping the plugin with Catalyst and
vkgtaro 2009/02/03
mysql_enable_utf8 => 1 ã§ BIC::UTF8Columns è¦ã‚‰ãªããªã‚‹ã£ã½ã„

perl

dbic
ãƒªãƒ³ã‚¯
Sub::Autoã§DBICã«findByã»ã’ã»ã’ã‚’ç”Ÿã‚„ã—ã¦ã¿ãŸ - Lism.in * blog - nekoya (id:studio-m)
Sub::Autoã§AUTOLOADã‚’éš è”½ - dann@webdev - dann's portal ãŒé¢ç™½ãã†ã ã£ãŸã®ã§DBIC::ResultSetã«findByã€œã‚’ç”Ÿã‚„ã—ã¦ã¿ãŸã€‚ perldocè¦‹ã¦ã‚‚$selfãŒã©ã“ã«å…¥ã£ã¦ãã‚‹ã®ã‹åˆ†ã‹ã‚‰ã‚“ã‹ã£ãŸã‘ã©ã€@_ã«é–¢æ•°åã®ãƒžãƒƒãƒãŒå…¥ã£ã¦ã€ãã®æ¬¡ã«æ¥ã‚‹ã¿ãŸã„ã€‚ #!/usr/bin/perl use strict; use warnings; package DBIx::Class::ResultSet; use Sub::Auto; autosub /^findBy(\w+)$/ { my ( $method, $self, $value ) = @_; $method = lc $method; return undef unless grep /^$method$/, $self->result_source->columns; $s
vkgtaro 2008/10/01
dbic
ãƒªãƒ³ã‚¯
Many-worlds interpretation
vkgtaro 2008/08/24 22:05 DBIC ã® as ã¯ SQL ã® as ã¨ã¯é–¢ä¿‚ãªã„ã£ã¦ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«ã¯æ›¸ã„ã¦ã‚ã‚‹ã‚“ã ã‘ã©é–“é•ã†ã‚ˆãã€‚ neutrino303 2008/08/25 00:03 O/R ãƒžãƒƒãƒ‘è‹¦æ‰‹ï¼ã€‚ ã‚„ã£ã±ã‚Šã€DBIx::Class::Manual::Cookbook ã¯èªã‚“ã©ã‹ãªã„ã¨ã€ã€ã ã‚ã™ã‹ï¼Ÿã€‚ ã§ã‚‚ã€ãã£ã¨ã¹ã‚“ã‚Šã ã‚ãªã¨ãŠã‚‚ã†ã€‚
vkgtaro 2008/08/24
dbic
ãƒªãƒ³ã‚¯
DBIC ã§ä»¶æ•°é †ã«ä¸¦ã³å¤‰ãˆã‚‹(count ã—ãŸã‚‚ã®ã«order by) | ãƒ–ãƒã‚°ãŒç¶šã‹ãªã„ã‚ã‘
count ã‚’å–ã£ã¦ãã‚Œã‚’è¡¨ç¤ºã™ã‚‹ã®ã¯æ¬¡ã®ã‚³ãƒ¼ãƒ‰ã§å•é¡Œãªã„ã§ã™ã€‚ã¾ã‚ã€æƒ³åƒã©ãŠã‚Šã§ã™ãã€‚my @ranking_posts = $c->model('DBIC::TranMatchTrackBack')->search( $query_ref, { select => [ 'user_id', { count => 'user_id' } ], as => [qw/ user_id posts_count /], group_by => ['user_id'], }, ); foreach(@ranking_posts){ $_->{posts_count} = $_->get_column('posts_count'); } ã“ã‚Œã‚’posts_countã§ä¸¦ã³å¤‰ãˆãŸã„ã¨ã„ã†è¦æœ›ã¯ã‚ˆãã‚ã‚‹è©±ã§ã™ã€‚ã¨ã„ã†ã‹ã€ä¸¦ã³å¤‰ãˆãªã„ã¨æ„å‘³ãªã„ã“ã¨ã®æ–¹ãŒå¤šã„ã€‚ ã¨ã“ã‚ãŒã€ã“ã‚ŒãŒãªã‹ãªã‹é›£ã—ã„ã€‚æƒ³åƒã™ã‚‹ã¨ã€
vkgtaro 2008/08/21
dbic
ãƒªãƒ³ã‚¯
DBIC::Schema::Loaderã¨ç§ - kamipo
1000speakers:5 (2008-05-24) (kamipo)first: sm3416957(Xaky) mylist: mylist/68280951000speakers: http://ja.doukaku.org/wiki/index.php/1000speakers:5ã“ã®å‹•ç”»ã¯å¼•ç”¨éƒ¨åˆ†ã‚’é™¤ãCreative Commonsã€Œè¡¨ç¤ºã€ã‚’é©ç”¨ã—ã¾ã™ http://creativecommons.org/licenses/by/2.1/jp/å‹•ç”»ã®æœ€å¾Œã®ã»ã†ã€ustreamã«è’ã‚‰ã—ãŒç¾ã‚Œã¦é…ä¿¡ãƒžã‚·ãƒ³ãŒãƒ•ãƒªãƒ¼ã‚ºã—ãŸãŸã‚ã«é–“ãŒ5åˆ†ã»ã©æŠœã‘ã¦ã—ã¾ã£ã¦ã„ã¾ã™ã€‚ã”ã‚ã‚“ãªã•ã„ã€‚
vkgtaro 2008/06/02
kamipo ã•ã‚“ä¼šã£ãŸã“ã¨ã‚ã‚‹ã²ã¨ã ã£ãŸï½—

dbic
ãƒªãƒ³ã‚¯
https://hibinokoto.jp/archives/2008/05/post-267.html
vkgtaro 2008/05/31
irc

dbic
ãƒªãƒ³ã‚¯
https://hibinokoto.jp/archives/2008/05/post-264.html
vkgtaro 2008/05/14
ã‚¦ã‚±ã‚¿ï½—

perl

dbic
ãƒªãƒ³ã‚¯
Catalyst::Model::DBIC::Schemaã‚’ãã®ã¾ã¾ãƒ™ãƒ¼ã‚¹ã«ä½¿ãˆã°ã„ã„ã®ã« - Charsbar::Note
ãœã‚“ãœã‚“*ipotterã¨ã¯é–¢ä¿‚ãªã„ã‘ã©ã€Catalyst::Model::DBIC::Schemaã®ä¾‹ã¨ã—ã¦ã€‚ http://coderepos.org/share/browser/lang/perl/Jipotter/branches/Dipotter ãªã‚“ã¨ã„ã†ã‹ã€åå‰ã«ã ã¾ã•ã‚Œã¦ã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ã¨ã„ã†æ°—ãŒã—ã¾ã™ãŒã€Catalyst::Model::DBIC::Schemaã¯ã€NEXTã‚„COMPONENTã§å‘³ä»˜ã‘ã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†ã ã‘ã§ã€æ‰€è©®ã¯Class::Accessor::Fastã¨Class::Data::InheritableãŒãƒ™ãƒ¼ã‚¹ã«å…¥ã£ã¦ã„ã‚‹ã ã‘ãªã‚“ã ã‹ã‚‰ã€ãã®ã¾ã¾POPOã¨ã—ã¦ä½¿ãˆã°ã„ã„ã‚“ã§ãªã„ã‹ã¨ã€‚ ãã‚Šã‚ƒã‚ã€ãŸã—ã‹ã«CatalystãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚‹ã€ã¨ã„ã†æ„å‘³ã§ã¯Catalystä¾å˜ã«ãªã‚Šã¾ã™ã—ã€è¨å®šã®ã¨ã“ã‚ã«MyApp->path_toã®ã‚ˆã†ãªã‚‚ã®ã‚’
vkgtaro 2008/04/25
ã€ŒNEXTã‚„COMPONENTã§å‘³ä»˜ã‘ã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†ã ã‘ã§ã€æ‰€è©®ã¯Class::Accessor::Fastã¨Class::Data::InheritableãŒãƒ™ãƒ¼ã‚¹ã«å…¥ã£ã¦ã„ã‚‹ã ã‘ãªã‚“ã ã‹ã‚‰ã€ãã®ã¾ã¾POPOã¨ã—ã¦ä½¿ãˆã°ã„ã„ã‚“ã§ãªã„ã‹ã¨ã€‚ã€

catalyst

dbic

model
ãƒªãƒ³ã‚¯
DBIx::Class::Schema::Loader ã® RelBuilder ãŒä½œã£ã¦ãã‚Œã‚‹ belongs_to ã‚’ãƒãƒ§ãƒƒãƒˆå¤‰ãˆã¦ã¿ã‚‹ - woremacxã®æ—¥è¨˜
ä»¥ä¸‹ã®ã‚ˆã†ãªé–¢ä¿‚ã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚Šã¾ã™ã€‚ create table user ( id int(11) NOT NULL auto_increment, username varchar(255), password varchar(255), unique key (username), primary key (id) ) ENGINE=InnoDB; create table tag ( id int(11) NOT NULL auto_increment, user_id int(11), foreign key (user_id) references user (id), primary key (id) ) ENGINE=InnoDB; ãµã¤ãƒ¼ã« foreign key ã‚’æŒ‡å®šã—ã¦ DBIx::Class::Schema::Loader ã«ãŠã¾ã‹ã›ã™ã‚‹ã¨ã€ MyApp::Sch
vkgtaro 2008/04/23
dbic
ãƒªãƒ³ã‚¯
DBIC::Schema::Loaderã®ã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚ºã¨è¨€ã†ãƒã‚¿ã§ãƒ—ãƒ¬ã‚¼ãƒ³ã™ã‚‹ã¯ãšã ã£ãŸä»¶ - æ—¥å‘å¤ç‰¹æ®Šå¿œæ´éƒ¨éšŠ
è©±ã—ã¦ãªã„ã‘ã©ã€è³‡æ–™ã¯ã‚ã‚‹ã®ã§å…¬é–‹ã—ã¾ã£ã™ã‚‹ã€‚ Customization of DBIC::Schema::Loader æ¦‚è¦ é–‹ç™ºä¸ã«ã‚¹ã‚ãƒ¼ãƒžã«å¤‰æ›´ãŒç™ºç”Ÿã—ã¦ã€make_schema_at()ã‚’ä½•åº¦ã‚‚å©ãéš›ã«å›°ã‚‹ã“ã¨ã¨ã€Schema::Loaderã§æ¯”è¼ƒçš„æ„å›³ã—ãŸé€šã‚Šã«Schema, Tableã‚¯ãƒ©ã‚¹ã‚’ç”Ÿæˆã™ã‚‹ç‚ºã«ã€ã“ã‚“ãªé¢¨ã«ã™ã‚‹ã¨ã„ã„ãŠã£ã¦å†…å®¹ã§ã™ã€‚ ã›ã£ã‹ã¡ãªäººå‘ã‘ ã“ã‚“ãªæ„Ÿã˜ã€‚ å†…å®¹ã®è§£èª¬ã¯ãƒ—ãƒ¬ã‚¼ãƒ³è³‡æ–™ã‚’è¦‹ã¦ãã ã—ã‚ã€‚ #!/usr/bin/perl use strict; use warnings; use FindBin; use File::Spec; use lib ( File::Spec->catfile( $FindBin::Bin, qw/.. lib/ ), File::Spec->catfile( $FindBin::Bin, qw/.. schema/ )
vkgtaro 2008/04/23
belongs_to ãŒã¡ã‚‡ã£ã¨ã‚¢ãƒ¬ãªã‚³ãƒ¼ãƒ‰ã«ãªã‚‹ã®ã§ã€å•é¡Œç®‡æ‰€ã‚’ redefine ã™ã‚‹ãªã©ã€‚

catalystcon

dbic
ãƒªãƒ³ã‚¯
DBIx::Class::Service Released - Yet Another Hackadelic
ã¾ã CPANã«åæ˜ ã•ã‚Œã¦å±…ãªã„ã¨æ€ã„ã¾ã™ãŒã€DBIx::Class:Serviceã¨è¨€ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã¾ã—ãŸã€‚ /lang/perl/DBIx-Class-Service/trunk (CodeRepos) DBIx-Class-Service-0.02 - Aggregate DBIC processes between multiple tables. - metacpan.org ã©ã‚“ãªãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‹ è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«insertã—ãŸã‚Šã™ã‚‹å‡¦ç†ã‚’ã¾ã¨ã‚ã¦æ›¸ãç‚ºã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã§ã™ã€‚ å…·ä½“çš„ã«è¨€ãˆã°ã€ package MySchema::Service::User; use base qw(DBIx::Class::Service); sub add_user: Transaction { my ($class, $schema, $args) = @_; my $user_rs =
vkgtaro 2008/04/03
dbic
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
vkgtaro 2008/03/26
catalyst

dbic
ãƒªãƒ³ã‚¯
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ - ã¯ã¦ãªã®å‘ŠçŸ¥
ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®çµ‚äº†æ—¥ã‚’2020å¹´1æœˆ31æ—¥(é‡‘)ã«æ±ºå®šã—ã¾ã—ãŸ ä»¥ä¸‹ã®ã‚¨ãƒ³ãƒˆãƒªã®é€šã‚Šã€ä»Šå¹´æœ«ã‚’ç›®å‡¦ã«ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã‚’çµ‚äº†äºˆå®šã§ã‚ã‚‹æ—¨ã‚’ãŠçŸ¥ã‚‰ã›ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ 2019å¹´æœ«ã‚’ç›®å‡¦ã«ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®æä¾›ã‚’çµ‚äº†ã™ã‚‹äºˆå®šã§ã™ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã“ã®ãŸã³ã€æ£å¼ã«çµ‚äº†æ—¥ã‚’æ±ºå®šã„ãŸã—ã¾ã—ãŸã®ã§ã€ä»¥ä¸‹ã®é€šã‚Šã”ç¢ºèªãã ã•ã„ã€‚ çµ‚äº†æ—¥: 2020å¹´1æœˆ31æ—¥(é‡‘) ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆå¸Œæœ›ç”³è«‹æœŸé™:2020å¹´1æœˆ31æ—¥(é‡‘) çµ‚äº†æ—¥ä»¥é™ã¯ã€ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã®é–²è¦§ãŠã‚ˆã³æŠ•ç¨¿ã¯è¡Œãˆã¾ã›ã‚“ã€‚æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãŒå¿…è¦ãªæ–¹ã¯ä»¥ä¸‹ã®è¨˜äº‹ã«ã—ãŸãŒã£ã¦æ‰‹ç¶šãã‚’ã—ã¦ãã ã•ã„ã€‚ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—ã«æŠ•ç¨¿ã•ã‚ŒãŸæ—¥è¨˜ãƒ‡ãƒ¼ã‚¿ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã«ã¤ã„ã¦ - ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ ã”åˆ©ç”¨ã®ã¿ãªã•ã¾ã«ã¯ã”è¿·æƒ‘ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ 2020-06-25 è¿½è¨˜ ã¯ã¦ãªã‚°ãƒ«ãƒ¼ãƒ—æ—¥è¨˜ã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆãƒ‡ãƒ¼ã‚¿ã¯2020å¹´2æœˆ28
vkgtaro 2008/03/14
dbic
ãƒªãƒ³ã‚¯
I, newbie Â» ã‚‚ã£ã¨æ—©ãã«çŸ¥ã‚ŠãŸã‹ã£ãŸDBIx::Class::WebForm
ã¡ã‚‡ã£ã¨ç…®è©°ã¾ã£ãŸã®ã§ã€ä»–äººã®ã‚³ãƒ¼ãƒ‰ã‚’èªã‚€ã“ã¨ã«ã€‚Catalystã®Wikiã«ã¯Exampleãªã‚‹ã‚»ã‚¯ã‚·ãƒ§ãƒ³ãŒã‚ã£ã¦ã€ã„ãã¤ã‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã®ã ã‘ã©ã€ã“ã¨ã”ã¨ããƒ€ãƒ¡(å‹•ã‹ãªã„ã€ç¢ºã‹ã«Catalystä½¿ã£ã¦ã„ã‚‹ã‘ã©ãªã‚“ã‹é•ã†ã€ã‚½ãƒ¼ã‚¹ãŒãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ããªã„ã¨ã‹)ã€‚mojomojoãŒå‚è€ƒã«ãªã‚Šãã†ã€‚ ã§ã€èªã‚“ã§ã„ã‚‹ã¨ã‚³ãƒ¡ãƒ³ãƒˆã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«çªã£è¾¼ã‚€éš›ã« $c->model("DBIC::Comment")->create_from_form($c->form); ãªã‚“ã¦ã—ã¦ã‚‹ã€‚ãˆãƒ¼ã€ãã‚“ã ã‘ã§ã„ã„ã®ã‹ã€‚ DBIx::Class::WebForm - CRUD Methods For DBIx::Class FormValidatorã¨DBIx::Class::WebFormã®çµ„ã¿åˆã‚ã›ã¯ã„ã„ã€‚ ãªã‚“ã¤ãƒ¼ã‹ã€ã“ã†ã„ã†ã‚·ãƒ§ãƒƒã‚¯ã£ã¦Vimã«ä¼¼ã¦ã‚‹(Tip #1: the super
vkgtaro 2008/03/06
DBIx::Class::FromValidators ã‚’ãŠå‹§ã‚ã—ã¦ããŸã€‚

dbic
ãƒªãƒ³ã‚¯
ã¸ã¼ã¸ã¼CTOæ—¥è¨˜ - CodeReposã«DBIx::Class::Tree::NestedSetã‚’ã‚³ãƒŸãƒƒãƒˆã—ã¦ã¿ãŸ
ã¦ãªã‚ã‘ã§Rubyã¯ã‚„ã£ã¦ã¾ã›ã‚“ ãŒCodeReposã«DBIx::Class::Tree::NestedSetã‚’Commitã—ã¦ã¿ã¾ã—ãŸã€‚ã“ã‚Œã®ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã«é–¢ã—ã¦ã¯[mysql 12071] éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†ã‚’å‚ç…§ã¨ã„ã†ã“ã¨ã§çœç•¥ã€‚ã“ã“ã«æ›¸ã„ã¦ã‚ã‚‹ã®ã¨é•ã†ç‚¹ã¨ã—ã¦ã¯ã€è¦ªãƒŽãƒ¼ãƒ‰ã®ä»˜ã‘æ›¿ãˆç”¨ã«mvgãƒ•ãƒ©ã‚°ã‚’å¿…è¦ã¨ã—ã¦ã„ã¾ã™ã€‚(ã‚¤ãƒ³ã‚¹ãƒ‘ã‚¤ã‚¢ From DBIx::OO::Tree) ãƒ¡ã‚½ãƒƒãƒ‰ã¯DBIx-Class-Treeã‚’ãƒ‘ã‚¯ãƒªæº–æ‹ ã—ã¦ã„ã¾ã™ã®ã§ãƒ†ã‚¹ãƒˆã‚‚ãƒ‘ã‚¯ãƒªæº–æ‹ ã—ã¦ã¾ã£ãŸãåŒã˜(ã‚ã€mvgã‚«ãƒ©ãƒ ã¯è¿½åŠ ã—ã¦ã‚‹ã‘ã©)ãƒ†ã‚¹ãƒˆã‚’é€šã—ã¦ã„ã¾ã™ã€‚ ã‚ã¨ã¯DBIx::OO::Tree,DBIx::Tree::NestedSetã‚ãŸã‚Šã‚’ãƒ‘ã‚¯ãƒªå‚è€ƒã«ã—ã¦ã¿ã¾ã—ãŸã€‚ ã§ã‚‚ã£ã¦TODOã«ã‚‚æ›¸ã„ã¦ã‚‹ã®ã§ã™ãŒã€rootãƒŽãƒ¼ãƒ‰å–å¾—ç”¨ã«ResultSetManagerãªãƒ¡ã‚½ãƒƒãƒ‰ã‚’ç”Ÿã‚„ã—ãŸã„ã‚“ã§ã™ãŒ
vkgtaro 2008/02/27
nested set ãƒ¢ãƒ‡ãƒ«ã§éšŽå±¤æ§‹é€ ã‚’è¡¨ç¾ã™ã‚‹æ–¹ã® DBIC ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã€‚adjacency List ãƒ¢ãƒ‡ãƒ«ã®ã¯ CPAN ã«ã‚ã‚‹ã‚‰ã—ã„ã€‚DBIx::Class::Tree

dbic

coderepos
ãƒªãƒ³ã‚¯
1 2 3 4 æ¬¡ã®ãƒšãƒ¼ã‚¸