DBIx::Class::SQLMaker man page on Darwin

Man page or keyword search:  
man Server   23457 pages
apropos Keyword Search (all sections)
Output format
Darwin logo
[printable version]

DBIx::Class::SQLMaker(User Contributed Perl DocumentatDBIx::Class::SQLMaker(3)

NAME
       DBIx::Class::SQLMaker - An SQL::Abstract-based SQL maker class

DESCRIPTION
       This module is a subclass of SQL::Abstract and includes a number of
       DBIC-specific workarounds, not yet suitable for inclusion into the
       SQL::Abstract core. It also provides all (and more than) the
       functionality of SQL::Abstract::Limit, see
       DBIx::Class::SQLMaker::LimitDialects for more info.

       Currently the enhancements to SQL::Abstract are:

       ·   Support for "JOIN" statements (via extended "table/from" support)

       ·   Support of functions in "SELECT" lists

       ·   "GROUP BY"/"HAVING" support (via extensions to the order_by
	   parameter)

       ·   Support of "...FOR UPDATE" type of select statement modifiers

       ·   The "-ident" operator

       ·   The "-value" operator

OPERATORS
   -ident
       Used to explicitly specify an SQL identifier. Takes a plain string as
       value which is then invariably treated as a column name (and is being
       properly quoted if quoting has been requested). Most useful for
       comparison of two columns:

	   my %where = (
	       priority => { '<', 2 },
	       requestor => { -ident => 'submitter' }
	   );

       which results in:

	   $stmt = 'WHERE "priority" < ? AND "requestor" = "submitter"';
	   @bind = ('2');

   -value
       The -value operator signals that the argument to the right is a raw
       bind value.  It will be passed straight to DBI, without invoking any of
       the SQL::Abstract condition-parsing logic. This allows you to, for
       example, pass an array as a column value for databases that support
       array datatypes, e.g.:

	   my %where = (
	       array => { -value => [1, 2, 3] }
	   );

       which results in:

	   $stmt = 'WHERE array = ?';
	   @bind = ([1, 2, 3]);

AUTHORS
       See "CONTRIBUTORS" in DBIx::Class.

LICENSE
       You may distribute this code under the same terms as Perl itself.

perl v5.16.2			  2012-08-23	      DBIx::Class::SQLMaker(3)
[top]

List of man pages available for Darwin

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net