NAME

DBI::Easy::SQL - handling sql for DBI::Easy

ABSTRACT

This module is a SQL expressions constructor for DBI::Easy. So DBI::Easy::SQL is a wrapper between SQL and the rest part of DBI::Easy

SYNOPSIS

SYNOPSIS

FUNCTIONS

sql_column_list

returns a list of SQL columns

sql_delete, sql_delete_by_pk

creates a SQL DELETE query

sql_insert

creates a SQL INSERT query

sql_limit

adds limits to SQL query

sql_names_range

TODO

sql_order

add ORDER BY to SQL query

sql_range

create placeholders for ranged sql statements, as example by

        ... where column in (?, ?) ...
        insert into table (col1, col2) values (?, ?) ...

receive number of placeholders to generate or arrayref, returns

        join ', ', ('?' x $num)

sql_select, sql_select_by_pk, sql_select_count

creates SELECT SQL query

sql_set

creates SET SQL expression (for UPDATE query as an example)

sql_update, sql_update_by_pk

creates UPDATE SQL query

sql_where

creates WHERE SQL expression

AUTHOR

Ivan Baktsheev, <apla at the-singlers.us>

BUGS

Please report any bugs or feature requests to my email address, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

SUPPORT

ACKNOWLEDGEMENTS

COPYRIGHT & LICENSE

Copyright 2008-2009 Ivan Baktsheev

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