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

AUTHOR

Sugama Keita, <sugama@jamadam.com>

COPYRIGHT AND LICENSE

Copyright (C) 2011 by Sugama Keita.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.