GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  DBIX::SKINNY::MANUAL::JA::RESULTSET (3)

.ds Aq ’

NAME

DBIx::Skinny::Manual::JA::Resultset - DBIx::SkinnyXresultsetXXXX

CONTENTS

DESCRIPTION

XXXSQLXXXXXXresultsetXXXXXXXXXXXXXXXXXX

Please translate and read the person in the sphere in English.

resultsetXXXXXXX

CGIXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXSQLXXXXXXXXXXXXXXXXXXX

XXXXXresultsetXXXXXXXXXXSQLXXXXXXXXXXXXXXXXXX

XXXXXresultsetXXXXXXXXXXXXX



    my $rs = Proj::Model->resultset;



resultsetXXXXXXXselectXXXXXXXXXXXXXXXX



    $rs->add_select(user.id => user_id);



XXXXXXXSELECTXXXXXXXXXXXXXXXXXXX XXXXXXXASXXXXXXXXXXXXXX

XXXXX



    SELECT user.id
    FROM



XXXXXX

resultsetXSQLXXXXXXXXXXXXXSQLXXXXXXXXXXXXXXXXXXXXXX



    warn $rs->as_sql;



XXXXXXXXXXXXXXXSQLXXXXXXXXXXXXXXX

XXselectXXXXXXXXXXXX



    $rs->from([user]);

    SELECT user.id
    FROM user



XXXarrayrefXXXXXXXXXXXXXX



    $rs->from([user, hoge]);

    SELECT user.id
    FROM user, hoge



XXwhereXXXXXXXXXX whereXXXXXXXXadd_whereXXXXXXXXXXX



    user.name = ?
   
    # bind = nekokak



XwhereXXXXXXXXXXXXXXXXXXX



    $rs->add_where(user.name => nekokak);

    SELECT user.id
    FROM user
    WHERE (user.name = ?)



bindXXXXXXXXXXXXXbindXXXXXXXXXXX



    use Data::Dumper;
    warn Dumper $rs->bind;

    $VAR1 = [
            nekokak
            ];



XXXXXSQLXXXXXXXretrieveXXXXXXXXXXX retrieveXXXXXXXXXXXXXXXXXXXXXXXXXXXXX



    my $itr = $rs->retrieve;



XXXXXXXXXXXXXXXXXX

resultsetXXXXXXXXXXXXfromXselectXXXXXXXXXXXXXXX resultsetXXXXXXXXXXXXXXXXXXX



    my $rs = Proj::Model->resultset(
        {
            select => [
                         user.name,
                         user.id AS user_id,
                      ],
            from   => [user],
        }
    );



resultsetXXXXXXXXXXXselectXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX selectXXXXXXXXXXXXXXXXXXXXXXXXXXX

XXXSQLXXXXXX

SkinnyXXXXXXXXXSQLXXXXXXXXXXXXXX

XXXwhereXXXXXX

IN/NOT INXXXXX



    $rs->add_where(user.id => {IN => \@user_ids});
    $rs->add_where(user.id => {NOT IN => \@user_ids});



INXXXXXXXXXXXXXXXXXXXX



    $rs->add_where(user.id => \@user_ids);



XXXXXXXXXX



    $rs->add_where(user.id => {< => 1});
    $rs->add_where(user.id => {> => 1});
    $rs->add_where(user.id => {!= => 1});



IS NULL/ IS NOT NULLXXXXXXXXXscalarXXXXXXXXXXXX



    $rs->add_where(user.id => \IS NULL);
    $rs->add_where(user.id => \IS NOT NULL);



XXXXXorXXXXXXXXXXXXXXXXXX



    $rs->add_where(user.id => [{> => 10}, {< => 100}]);



XXXXXXXXXXXandXXXXXXXX



    $rs->add_where(user.id => [-and => {> => 10}, {< => 100}]);



XXXXXXXXXXX

XXXXXXXXXXXX



    $rs->add_where(user.id => [-and => 1,2,3]);



XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

XXXXJOINXXXX



    $rs->from([]);
    $rs->add_join(
        user => [
            {
                type  => inner,
                table => bookmark,
                condition => user.id = bookmark.user_id,
            },
        ],
    );

    FROM user INNER JOIN bookmark ON user.id = bookmark.user_id



XXXXXJOINXXXXXXXXXXX

XXX$rs->from([]);XXXXXXXfrom XXXXXXXXX add_joinXXXXXXXXXXXXXXXXXXXXXX

XXXtypeXjoinXXXXX

tableXjoinXXXXXXX

conditionXJOINXXXXXXXXXX

Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 DBIX::SKINNY::MANUAL::JA::RESULTSET (3) 2010-11-08

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.