Sugama Keita > SQL-OOP-0.21 > SQL::OOP::ID

Download:
SQL-OOP-0.21.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  1
Open  0
View/Report Bugs
Source  

NAME ^

SQL::OOP::ID - IDs for SQL

SYNOPSIS ^

    ### field
    my $field = SQL::OOP::ID->new(@path_to_field);
    $field->to_string # e.g. "tbl"."col"
    
    ### from
    my $from = SQL::OOP::ID->new(@path_to_table);
    $from->to_string # e.g. "schema"."tbl"

DESCRIPTION ^

SQL::OOP::ID class represents IDs for such as table, schema fields.

SQL::OOP::ID CLASS ^

This class represents IDs such as table names, schema, field names. This class inherits SQL::OOP::Array class.

SQL::OOP::ID->new(@ids)

$instance->as($str)

Here is some examples.

    my $id_obj = SQL::OOP::ID->new('public', 'tbl1'); 
    $id_obj->to_string; # "public"."tbl1"
    
    $id_obj->as('TMP');
    $id_obj->to_string; # "public"."tbl1" AS TMP

$instance->append($elems)

Appends elements into existing instance.

$instance->generate

This method generates SQL. This is automatically called by to_string so you don't have to call it directly.

SQL::OOP::ID::Parts CLASS ^

This class is for internal use.

SEE ALSO ^

syntax highlighting: