Tyzoh.jp

CREATE TABLE user_tags ( 
        user_tag_id     SERIAL, 
        user_id                 INTEGER, 
        tag_id                  INTEGER, 
        PRIMARY KEY(user_tag_id), 
        FOREIGN KEY(user_id) REFERENCES users(user_id), 
        FOREIGN KEY(tag_id) REFERENCES tags(tag_id) 
);

sub updateFromVersion02 : Local {
    my ( $self, $c ) = @_;

    my $num = 0;
    $c->stash->{pagetitle} = 'Secure-SBM Users-Tags Update';
    $c->stash->{template} = 'admin/updatefromversion02.tt';

    $c->model('SecureSBMDB::UserTag')->delete_all;
    foreach my $udb ($c->model('SecureSBMDB::User')->all){
        my $uid = $udb->user_id;
        foreach my $ubdb ($udb->user_bookmarks->all){
            foreach my $ubtdb ($ubdb->user_bookmark_tags->all){
                my $tid = $ubtdb->tag_id;
                if( $c->model('SecureSBMDB::UserTag')->find_or_create({
                        user_id => $uid,
                        tag_id  => $tid
                    })
                ){
                    $num++;
                }
            }
        }
    }

    $c->stash->{resultnum} = $num;

} # end of updateFromVersion02()

       $c->model('SecureSBMDB::UserTag')-> 
             find_or_create( 
                        { 
                             user_id => $uid, 
                             tag_id  => $tid 
                         } 
                    );