DBIx::MyParseX::Query - Extended methods to DBIx::MyParse::Query
use DBIx::MyParseX; my $p = DBIx::MyParse->new(); my $q = $p->parse( "select ..." ); # Query Manipulation methods $q->renameTable( 'old_table', 'new_table' );
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
$query->hasSelect
Indicates that the Query contains a SELECT clause
Indicates that the query has a WHERE clause.
Indicates that the query has a HAVING clause.
Indicates that the query has a ORDER (BY) clause.
Indicates that the query has a LIMIT clause.
Indicates that the query has tables. The two forms are identical.
Indicates that the query has a FROM clause
Indicates that the query has a GROUP (BY) clause
my @items = $query->getItems;
Returns an array of DBIx::MyParse::Items from the query, in effect flatttening the parse tree.
$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'.
None by default.
DBIx::MyParse, DBIx::MyParse::Query, DBIx::MyParseX,
http://www.mysql.com
http://www.opendatagroup.com
Christopher Brown, <ctbrown@cpan.org<gt>
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.
To install DBIx::MyParseX, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::MyParseX
CPAN shell
perl -MCPAN -e shell install DBIx::MyParseX
For more information on module installation, please visit the detailed CPAN module installation guide.