The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

SQL::DMLGenerator - Data Manipulation Language SQL generator.

SYNOPSIS

    use SQL::DMLGenerator;

DESCRIPTION

Represent DML SQL generator.(insert/update/delete)

EXPORT

None

METHODS

insert

Returns insert sql statements, bind variables as array ref. Takes entity object, filed values as hash ref

    my ($sql, $bind_variables) = SQL::DMLGenerator->insert($entity, $field_values)
update

Returns update sql statements, bind variables as array ref. Takes entity object, filed values as hash ref, condition - that may be hash ref or condition object

    my ($sql, $bind_variables) = SQL::DMLGenerator->update($entity, $field_values, $codition)
delete

Returns delete sql statements, bind variables as array ref. Takes entity object, filed values as hash ref, condition - that may be hash ref or condition object

    my ($sql, $bind_variables) = SQL::DMLGenerator->delete($entity, $codition);

SEE ALSO

SQL::Entity

COPYRIGHT AND LICENSE

The SQL::DMLGenerator module is free software. You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file.

AUTHOR

Adrian Witas, adrian@webapp.strefa.pl