CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Beginner: Re: [PapaGeek] My first Perl Database!: Edit Log



Zhris
Enthusiast

Aug 24, 2013, 11:00 PM


Views: 3176
Re: [PapaGeek] My first Perl Database!

Just to throw in another link ( to look into once you are familiar with DBI ):

DBIx::Class - Extensible and flexible object <-> relational mapper ~ http://search.cpan.org/~ribasushi/DBIx-Class-0.08250/lib/DBIx/Class.pm

Personally, I have created a wrapper around DBI, simplifying executions, i.e.


Code
my $data = $databaseObj->read 
(
query => q#select ;columns from ;table where ;where#,
clause_placeholders => { columns => q#id, value#, table => q#test#, where => q#id = :1# },
value_placeholders => { 1 => q#2# },
fetch_handler => [ FETCH_HANDLERS->{rows_hash_of_list}, q#id# ],
error_handler => ERROR_HANDLERS->{fatal},
cache => 0
);


But thats another story!

Chris


(This post was edited by Zhris on Aug 24, 2013, 11:10 PM)


Edit Log:
Post edited by Zhris (Enthusiast) on Aug 24, 2013, 11:01 PM
Post edited by Zhris (Enthusiast) on Aug 24, 2013, 11:02 PM
Post edited by Zhris (Enthusiast) on Aug 24, 2013, 11:02 PM
Post edited by Zhris (Enthusiast) on Aug 24, 2013, 11:02 PM
Post edited by Zhris (Enthusiast) on Aug 24, 2013, 11:02 PM
Post edited by Zhris (Enthusiast) on Aug 24, 2013, 11:03 PM
Post edited by Zhris (Enthusiast) on Aug 24, 2013, 11:07 PM
Post edited by Zhris (Enthusiast) on Aug 24, 2013, 11:10 PM


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives