Adrian Witas > DBIx-Connection-0.13 > DBIx::Connection::MySQL::SQL

Download:
DBIx-Connection-0.13.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Module Version: 0.06   Source  

NAME ^

DBIx::Connection::MySQL::SQL - MySQL catalog sql abstract action layer.

SYNOPSIS ^

    use DBIx::Connection::MySQL::SQL;

DESCRIPTION ^

    Represents sql abstractaction layer

EXPORT ^

None

METHODS

sql

Stores definition of the following sql

 - column_info
 - index_info
 - unique_index_column
 - foreign_key_info
 - trigger_info
 - routine_info
sequence_value

Returns sql statement that returns next sequence value

reset_sequence

Returns sql statement that restarts sequence.

set_session_variables

Iniitialise session variable. It uses the following command pattern:

    SET @@local.variable = value;
update_lob

Updates lob. (Large Object) Takes connection object, table name, lob column_name, lob content, hash_ref to primary key values. optionally lob size column name.

fetch_lob

Retrieves lob. Takes connection object, table name, lob column_name, hash_ref to primary key values

tables_info
index_info
table_indexes_info
column_info
unique_index_column
foreign_key_info
table_foreign_key_info
trigger_info
routine_info

Returns array of function info for the specified function name.

_parse_routine_argument

SEE ALSO ^

DBIx::PLSQLHandler

COPYRIGHT AND LICENSE ^

The DBIx::Connection::MySQL::SQL 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

syntax highlighting: