Christopher Brown > DBIx-MyParseX-0.06 > DBIx::MyParseX::Query

Download:
DBIx-MyParseX-0.06.tar.gz

Dependencies

Annotate this POD

View/Report Bugs
Module Version: 0.06   Source  

NAME ^

DBIx::MyParseX::Query - Extended methods to DBIx::MyParse::Query

SYNOPSIS ^

    use DBIx::MyParseX;
    my $p = DBIx::MyParse->new();
    my $q = $p->parse( "select ..." );

  # Query Manipulation methods
    $q->renameTable( 'old_table', 'new_table' );  

DESCRIPTION ^

This extension provides exteneded functionality for the DBIx::MyParse::Query module. Calls DBIx::MyParse::Query and DBIx::MyParseX. Extends DBIx::MyParse::Query.

All methods are defined in the DBIx::MyParse::Query package space

METHODS ^

hasSelect

    $query->hasSelect

Indicates that the Query contains a SELECT clause

hasWhere

Indicates that the query has a WHERE clause.

hasHaving

Indicates that the query has a HAVING clause.

hasOrder

Indicates that the query has a ORDER (BY) clause.

hasLimit

Indicates that the query has a LIMIT clause.

hasTable / hasTables

Indicates that the query has tables. The two forms are identical.

hasFrom

Indicates that the query has a FROM clause

hasGroup

Indicates that the query has a GROUP (BY) clause

getItems

    my @items = $query->getItems;

Returns an array of DBIx::MyParse::Items from the query, in effect flatttening the parse tree.

renameTable

    $query->renameTable( 'old_name', 'new_name' );

Calls getItems and calls renameTable on each of the items. All occurences of 'old_name' are changed to 'new_name'.

EXPORT

None by default.

SEE ALSO ^

DBIx::MyParse, DBIx::MyParse::Query, DBIx::MyParseX,

http://www.mysql.com

http://www.opendatagroup.com

AUTHOR ^

Christopher Brown, <ctbrown@cpan.org<gt>

COPYRIGHT AND LICENSE ^

Copyright 2008 by Open Data Group

This library is free software; you can redistribute it and/or modify it under the terms of the GNU General Public Licence.

syntax highlighting: