NAME

SQL::Bibliosoph::CatalogFile - Bibliosoph SQL Statements Parser

VERSION

2.0

DESCRIPTION

Reads a SQL library statements file, using the BB format (SEE below)

BB Format

--[ Query_name1 ] SQL statement

The query name must be a simple string, case sensitive, with no spaces. The file can have comment in every line, starting with #. Statements can include bind params denoted with question mark `?`. Optionally, parameters can be numbered: 1?, 2?, 3? ... This allows to reuse paraments, like in:

                SELECT * 
                        FROM user
                         WHERE name = 1? OR nick = 1?

The bind parameter number can be preceded by a `#`. This force the parameter to be strictly numeric. This is useful for using bind parameters with the LIMIT clause.

==head1 Examples

A simple query, using two bind parament

        --[ GET_T1 ]
        # A very nice commentA
                SELECT          t1.*
                FROM            table1 t1
        # A other comment
        LEFT JOIN   table2 t2
        ON                      t1.id = t2.t1_fk
        WHERE           t2.id = ? 
                LIMIT #?

An insert statement. This returns the last inserted ID.

        --[ INSERT_USER ]
        # This returns LAST_INSERT_ID if `user` has a auto_increment column
                INSERT 
                        INTO user (name,country) 
                        VALUES 
                        (?, IFNULL(?,'US') )

An update statement. Returns modifed rows.

        --[ AGE_USERS ]
        # This returns the modified rows
                UPDATE user
                        SET age = age + 1
                        WHERE birthday = ? 

The select using numeric and ordered params

        --[ GET_USERS ]
        # Example using numeric and ordered params
                SELECT * 
                        FROM user 
                        WHERE 
                                (1? IS NULL OR country = 1? )
                                AND (2? IS NULL OR state =  2?)
                        LIMIT #3?,#4?

AUTHORS

SQL::Bibliosoph by Matias Alejo Garcia (matiu at cpan.org) and Lucas Lain (lucas at confronte.com).

COPYRIGHT

Copyright (c) 2007-2009 Matias Alejo Garcia. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SUPPORT / WARRANTY

The SQL::Bibliosoph is free Open Source software. IT COMES WITHOUT WARRANTY OF ANY KIND.

SEE ALSO

        SQL::Bibliosoph
        SQL::Bibliosoph::CatalogFile

At http://nits.com.ar/bibliosoph you can find: * Examples * VIM syntax highlighting definitions for bb files * CTAGS examples for indexing bb files.

ACKNOWLEDGEMENTS

To Confronte.com and its associates to support the development of this module.