™.. DBIx::Simple::Comparison - Online Linux Manual PageSection : 3
Updated : 2007-07-14
Source : perl v5.10.1
Note : User Contributed Perl Documentation
NAMEDBIx::Simple::Comparison − DBIx::Simple in DBI jargon
DESCRIPTIONThis is just a simple and inaccurate overview of what DBI things the DBIx::Simple things represent, or the other way around. This document can be useful to find the foo equivalent of bar. ​\*(C`?\*(C'\fR means that \s-1DBI\s0 doesn't have an equivalent or that I couldn't find one. ​\*(C`=\*(C'\fR means that DBIx::Simple provides a direct wrapper to the \s-1DBI\s0 function. ​\*(C`~\*(C'\fR means that DBIx::Simple's method does more or less the same, but usually in a more high level way: context sensitive, combining things, automatically taking care of something. Note that DBIx::Simple is a wrapper around DBI. It is not ‟better” than DBI. In fact, DBIx::Simple cannot work without DBI. Using DBI directly is always faster than using DBIx::Simple's equivalents. (For the computer, that is. For you, DBIx::Simple is supposed to be faster.)
Classes, common names​ use DBI ~ use DBIx::Simple ​ ​ $DBI::errstr = DBIx::Simple−>error ​ ​ DBI::db ~ DBIx::Simple ​ $dbh ~ $db ​ $dbh−>errstr = $db−>error ​ ​ connect ~ connect ​ connect ~ new ​ ​ DBI::st ~ DBIx::Simple::Result ​ <undef> ~ DBIx::Simple::Dummy ​ $sth ~ $result
Queries​DBI ​ my $sth = $dbh−>prepare_cached($query); ​ $sth−>execute(@values); ~ DBIx::Simple ​ my $result = $db−>query($query, $values);
Results​ DBI DBIx::Simple ​ ​ bind_columns ~ bind ​ ​ fetchrow_arrayref/fetch = fetch ​ fetchrow_array ~ list ​ *1 ~ flat ​ [@{fetchrow_arrayref}] = array ​ fetchall_arrayref ~ arrays ​ fetchrow_hashref() *2*3 = hash ​ fetchall_arrayref({}) *4 ~ hashes ​ ​ fetchall_hashref *2 = map_hashes ​ ? ? map_arrays ​ fetchall_hashref(1) *2 = map ​ ​ $sth−>{NAME_lc/NAME} = $result−>columns *1 There's no fetch variant, but you can do \*(C`{ @{ $dbh−>selectcol_arrayref('SELECT ...', { Slice => [] }) } }\*(C'\fR. *2 To receive the keys (column names) lowercased, use \*(C`$db\->{FetchHashKeyName} = \*(AqNAME_lc\*(Aq\*(C'\fR. DBIx::Simple lower cases them by default. *3 Or supply an argument, 'NAME_lc'. *4 No, arrayref isn't a typo. When supplied an empty hash reference, DBI's fetchall_arrayref actually returns hashrefs. This DBI method does not support lower casing of keys, DBIx::Simple does.
Direct access​ DBI DBIx::Simple ​ ​ $dbh = $db−>dbh ​ $sth−>{$foo} = $result−>attr($foo) ​ ​ func = func ​ ​ begin_work = begin_work ​ commit = commit ​ rollback = rollback ​ last_insert_id = last_insert_id ​ rows = rows ​ ​ disconnect ~ disconnect ​ finish ~ finish
DBIx::Simple specific (?)​ keep_statements ​ lc_columns ​ iquery (via SQL::Interp) ​ select, insert, update, delete (via SQL::Abstract) ​ abstract (via SQL::Abstract) ​ flat ​ hashes ​ map_arrays ​ map
LICENSEThere is no license. This software was released into the public domain. Do with it what you want, but on your own risk. The author disclaims any responsibility.
AUTHORJuerd Waalboer <juerd@cpan.org> <http://juerd.nl/>
SEE ALSO​DBI, DBIx::Simple 0
Johanes Gumabo
Data Size   :   12,278 byte
man-DBIx::Simple::Comparison.3pmBuild   :   2024-12-05, 20:55   :  
Visitor Screen   :   x
Visitor Counter ( page / site )   :   4 / 164,788
Visitor ID   :     :  
Visitor IP   :   3.12.34.211   :  
Visitor Provider   :   AMAZON-02   :  
Provider Position ( lat x lon )   :   39.962500 x -83.006100   :   x
Provider Accuracy Radius ( km )   :   1000   :  
Provider City   :   Columbus   :  
Provider Province   :   Ohio ,   :   ,
Provider Country   :   United States   :  
Provider Continent   :   North America   :  
Visitor Recorder   :   Version   :  
Visitor Recorder   :   Library   :  
Online Linux Manual Page   :   Version   :   Online Linux Manual Page - Fedora.40 - march=x86-64 - mtune=generic - 24.12.05
Online Linux Manual Page   :   Library   :   lib_c - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Online Linux Manual Page   :   Library   :   lib_m - 24.10.03 - march=x86-64 - mtune=generic - Fedora.40
Data Base   :   Version   :   Online Linux Manual Page Database - 24.04.13 - march=x86-64 - mtune=generic - fedora-38
Data Base   :   Library   :   lib_c - 23.02.07 - march=x86-64 - mtune=generic - fedora.36
Very long time ago, I have the best tutor, Wenzel Svojanovsky . If someone knows the email address of Wenzel Svojanovsky , please send an email to johanes_gumabo@yahoo.co.id .
If error, please print screen and send to johanes_gumabo@yahoo.co.id
Under development. Support me via PayPal.
ERROR : Need New Coding :         (parse_manual_page_|249|DBIx::Simple::Comparison.3pm|36/37|el══─{─══.|.el══─{─══. ds -- \|\(em\| )         (htmlprn|149|DBIx::Simple::Comparison.3pm|36/37|.el══─{─══. ds --  —  |.el══─{─══. ds -- \|\(em\| )         (parse_manual_page_|249|DBIx::Simple::Comparison.3pm|41|br══─}─══|'br══─}─══ )         (htmlprn|149|DBIx::Simple::Comparison.3pm|41|'br══─}─══ |'br══─}─══ )         (rof_nr_x|149|DBIx::Simple::Comparison.3pm|51/52|\nF|.ie \nF ══─{─══. de IX )         (rof_unit_scale_px|41|DBIx::Simple::Comparison.3pm|51/52|F|.ie \nF ══─{─══. de IX )         (rof_if|19|DBIx::Simple::Comparison.3pm|51/52|\nF|.ie \nF ══─{─══. de IX )         (htmlprn|149|DBIx::Simple::Comparison.3pm|51/52|.ie \nF ══─{─══. de IX|.ie \nF ══─{─══. de IX )         (rof_escape_sequence|91|DBIx::Simple::Comparison.3pm|53|\$1\t\\n%\t"\\$2" |. tm Index:\\$1\t\\n%\t"\\$2" )         (parse_manual_page_|249|DBIx::Simple::Comparison.3pm|57|══─}─══|.══─}─══ )         (htmlprn|149|DBIx::Simple::Comparison.3pm|57|.══─}─══ |.══─}─══ )         (rof_escape_sequence|91|DBIx::Simple::Comparison.3pm|141|\*(C`?\*(C'\fR means that \s-1DBI\s0 doesn't have an equivalent or that I couldn't find one. |\&\f(CW\*(C`?\*(C'\fR means that \s-1DBI\s0 doesn't have an equivalent or that I couldn't find one. )         (rof_escape_sequence|91|DBIx::Simple::Comparison.3pm|143|\*(C`=\*(C'\fR means that DBIx::Simple provides a direct wrapper to the \s-1DBI\s0 function. |\&\f(CW\*(C`=\*(C'\fR means that DBIx::Simple provides a direct wrapper to the \s-1DBI\s0 function. )         (rof_escape_sequence|91|DBIx::Simple::Comparison.3pm|145|\*(C`~\*(C'\fR means that DBIx::Simple's method does more or less the same, but usually |\&\f(CW\*(C`~\*(C'\fR means that DBIx::Simple's method does more or less the same, but usually )         (rof_escape_sequence|91|DBIx::Simple::Comparison.3pm|208|\*(C`{ @{ |*1 There's no fetch variant, but you can do \f(CW\*(C`{ @{ )         (rof_escape_sequence|91|DBIx::Simple::Comparison.3pm|209|\*(C'\fR. |$dbh\->selectcol_arrayref(\*(AqSELECT ...\*(Aq, { Slice => [] }) } }\*(C'\fR. )         (rof_escape_sequence|91|DBIx::Simple::Comparison.3pm|211|\*(C`$db\->{FetchHashKeyName} = \*(AqNAME_lc\*(Aq\*(C'\fR. DBIx::Simple lower cases them by |*2 To receive the keys (column names) lowercased, use \f(CW\*(C`$db\->{FetchHashKeyName} = \*(AqNAME_lc\*(Aq\*(C'\fR. DBIx::Simple lower cases them by )