Mark Hedges > Apache2-Controller-v1.0.111 > Apache2::Controller::SQL::MySQL

Download:
A2C/Apache2-Controller-v1.0.111.tar.gz

Dependencies

Annotate this POD

CPAN RT

New  2
Open  0
View/Report Bugs
Module Version: v1.0.111   Source   Latest Release: Apache2-Controller-v1.1.1

NAME ^

Apache2::Controller::SQL::MySQL - useful database methods for MySQL

VERSION ^

Version 1.000.111

SYNOPSIS ^

 package UFP::SFC::Controller::Tools;
 use base qw( 
     Apache2::Controller 
     Apache2::Controller::SQL::MySQL
 );
 # ...

DESCRIPTION ^

Provides some useful methods for interacting with a MySQL database.

This isn't really standard or a necessary part of A2C, I just find it handy.

METHODS ^

insert_hash

 insert_hash( \%hashref )

Insert data into the database.

 # http://sfc.ufp/tools/register_crew/enterprise?captain=kirk&sci=spock&med=mccoy
 sub register_crew {
     my ($self, $ship) = @_; 
     my $crew = $self->param();
     $self->insert_hash({
         table    => "crew_$ship",
         data     => $crew,
     });
     $self->print("Warp factor 5, engage.\n");
     return Apache2::Const::HTTP_OK;
 }

Requires a database handle be assigned to $self->{dbh}. See Apache2::Controller::DBI::Connector.

Hashref argument supports these fields:

table

The SQL table to insert into.

data

The hash ref of field data to insert.

on_dup_sql

Optional string of SQL for after 'ON DUPLICATE KEY UPDATE'. Format it yourself.

on_dup_bind

Array ref of bind values for extra ? characters in on_dup_sql.

SEE ALSO ^

Apache2::Controller::DBI::Connector

Apache2::Controller

AUTHOR ^

Mark Hedges, hedges +(a t)- formdata.biz

COPYRIGHT AND LICENSE ^

Copyright 2008-2010 Mark Hedges. CPAN: markle

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

This software is provided as-is, with no warranty and no guarantee of fitness for any particular purpose.

syntax highlighting: