NAME
DBIx::SearchBuilder::Handle - Perl extension which is a generic DBI handle
SYNOPSIS
use DBIx::SearchBuilder::Handle;
my $Handle = DBIx::SearchBuilder::Handle->new();
$Handle->Connect( Driver => 'mysql',
Database => 'dbname',
Host => 'hostname',
User => 'dbuser',
Password => 'dbpassword');
DESCRIPTION
Jesse's a slacker.
Blah blah blah.
AUTHOR
Jesse Vincent, jesse@fsck.com
new
Generic constructor
Insert $TABLE_NAME @KEY_VALUE_PAIRS
Takes a table name and a set of key-value pairs in an array. splits the key value pairs, constructs an INSERT statement and performs the insert. Returns the row_id of this row.
Connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
RaiseError [MODE]
Turns on the Database Handle's RaiseError attribute.
PrintError [MODE]
Turns on the Database Handle's PrintError attribute.
Disconnect
Disconnect from your DBI datasource
dbh [HANDLE]
Return the current DBI handle. If we're handed a parameter, make the database handle that.
UpdateTableValue TABLE COLUMN NEW_VALUE RECORD_ID IS_SQL
Update column COLUMN of table TABLE where the record id = RECORD_ID. if IS_SQL is set, don\'t quote the NEW_VALUE
SimpleQuery QUERY_STRING
Execute the SQL string specified in QUERY_STRING
FetchResult
Takes a SELECT query as a string. Returns the first row as an array
safe_quote IN_VAL
If IN_VAL is null, turn it into an empty quoted string. otherwise, use the DBI quote function. Returns the new string.
SEE ALSO
perl(1), DBIx::SearchBuilder