jifty::dbi::handle::oracle(3pm) [debian man page]

Jifty::DBI::Handle::Oracle(3pm) 			User Contributed Perl Documentation			   Jifty::DBI::Handle::Oracle(3pm)

NAME

	 Jifty::DBI::Handle::Oracle - An oracle specific Handle object

SYNOPSIS

DESCRIPTION

       This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.

METHODS

   connect PARAMHASH: Driver, Database, Host, User, Password
       Takes a paramhash and connects to your DBI datasource.

   database_version
       Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.

   insert
       Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.

   build_dsn PARAMHASH
       Takes a bunch of parameters:

       Required: Driver, Database or Host/SID, Optional: Port and RequireSSL

       Builds a dsn suitable for an Oracle DBI connection

   blob_params column_NAME column_type
       Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type.  The current
       Oracle implementation only supports ORA_CLOB types(112).

   apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
       takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;

   distinct_query STATEMENTREF
       takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.

AUTHOR

       Jesse Vincent, jesse@fsck.com

SEE ALSO

       Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle

perl v5.14.2							    2011-04-26					   Jifty::DBI::Handle::Oracle(3pm)

Jifty::DBI::Filter(3pm) 				User Contributed Perl Documentation				   Jifty::DBI::Filter(3pm)

NAME

       Jifty::DBI::Filter - base class for Jifty::DBI filters

SYNOPSIS

	 # To implement your own filter
	 package MyApp::Filter::Uppercase;
	 use base qw/ Jifty::DBI::Filter /;

	 # Setup for DB storage, store in lowercase
	 sub encode {
	     my $self = shift;

	     my $value_ref = $self->value_ref;
	     return unless defined $$value_ref; # don't blow up on undef

	     $$value_ref = lc $$value_ref;
	 }

	 # Setup for Perl code to use, always sees uppercase
	 sub decode {
	     my $self = shift;

	     my $value_ref = $self->value_ref;
	     return unless defined $$value_ref; # don't blow up on undef

	     $$value_ref = uc $$value_ref;
	 }

	 # To use a filter
	 use MyApp::Record schema {
	     column filtered =>
		 type is 'text',
		 filters are qw/ MyApp::Filter::Uppercase /;
	 };

DESCRIPTION

       A filter allows Jifty::DBI models to tweak data prior to being stored and/or loaded. This is useful for marshalling and unmarshalling
       complex objects.

METHODS

   new
       Takes three arguments in a parameter hash:

       value_ref
	   A reference to the current value you're going to be massaging. "encode" works in place, massaging whatever value_ref refers to.

       column
	   A Jifty::DBI::Column object, whatever sort of column we're working with here.

       handle
	   A Jifty::DBI::Handle object, because some filters (i.e.  Jifty::DBI::Filter::Boolean) depend on what database system is being used.

   encode
       "encode" takes data that users are handing to us and marshals it into a form suitable for sticking it in the database. This could be
       anything from flattening a DateTime object into an ISO date to making sure that data is utf8 clean.

   decode
       "decode" takes data that the database is handing back to us and gets it into a form that's OK to hand back to the user. This could be
       anything from inflating an ISO date to a DateTime object to making sure that the string properly has the utf8 flag.

SEE ALSO

       Jifty::DBI::Filter::Date, Jifty::DBI::Filter::DateTime, Jifty::DBI::Filter:SaltHash, Jifty::DBI::Filter::Storable,
       Jifty::DBI::Filter::Time, Jifty::DBI::Filter::Truncate, Jifty::DBI::Filter::YAML, Jifty::DBI::Filter::base64, Jifty::DBI::Filter::utf8

LICENSE

       Jifty::DBI is Copyright 2005-2007 Best Practical Solutions, LLC.  Jifty::DBI is distributed under the same terms as Perl itself.

perl v5.14.2							    2010-12-09						   Jifty::DBI::Filter(3pm)