Traian Nedelea > SQL-Abstract-Builder > SQL::Abstract::Builder

Download:
SQL-Abstract-Builder-v0.1.1.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Module Version: v0.1.1   Source  

NAME ^

SQL::Abstract::Builder - Builds and executers relational queries

SYNOPSIS ^

    my @docs = query {"dbi:mysql:$db",$user} build {
        -columns => [qw(id foo bar)],
        -from => 'table1',
        -key => 'id',
    } include {
        -columns => [qw(id baz glarch)],
        -from => 'table2',
        -key => 'table1_id',
    } include {
        -columns => [qw(id alfa)],
        -from => 'table3',
        -key => 'table1_id',
    };

DESCRIPTION ^

It gives you a very simple way to define fetch documents (rows and related children) from your relational DB (instead of just rows).

METHODS ^

query

Executes the built query. Takes either a DBIx::Simple connection or the same arguments that are valid for DBIx::Simple-connect>.

Usage

    my @docs = query {"dbi:mysql:$db",$user} ...
    # OR
    my @docs = query {$dbh} ...

build

Builds the query assuming the given table is the base.

Usage

    my @refs = build { ... } ...

include

Includes the results of a JOIN on the given table when built.

Usage

    my @refs = build { ... } include { ... }
syntax highlighting: