| … | |
… | |
| 13 | my $st = sql_insertid |
13 | my $st = sql_insertid |
| 14 | sql_exec "insert into ... values (?, ?)", $v1, $v2; |
14 | sql_exec "insert into ... values (?, ?)", $v1, $v2; |
| 15 | my $a = sql_fetch "select a from ..."; |
15 | my $a = sql_fetch "select a from ..."; |
| 16 | sql_fetch \my($a, $b), "select a,b ..."; |
16 | sql_fetch \my($a, $b), "select a,b ..."; |
| 17 | |
17 | |
| 18 | sql_exists "name from table where name like 'a%'" |
18 | sql_exists "table where name like 'a%'" |
| 19 | or die "a* required but not existent"; |
19 | or die "a* required but not existent"; |
| 20 | |
20 | |
| 21 | my $db = new PApp::SQL::Database "", "DBI:mysql:test", "user", "pass"; |
21 | my $db = new PApp::SQL::Database "", "DBI:mysql:test", "user", "pass"; |
| 22 | local $PApp::SQL::DBH = $db->checked_dbh; # does 'ping' |
22 | local $PApp::SQL::DBH = $db->checked_dbh; # does 'ping' |
| 23 | |
23 | |
| … | |
… | |
| 44 | use DBI (); |
44 | use DBI (); |
| 45 | |
45 | |
| 46 | BEGIN { |
46 | BEGIN { |
| 47 | use base qw(Exporter DynaLoader); |
47 | use base qw(Exporter DynaLoader); |
| 48 | |
48 | |
| 49 | $VERSION = 0.1241; |
49 | $VERSION = 0.1242; |
| 50 | @EXPORT = qw( |
50 | @EXPORT = qw( |
| 51 | sql_exec sql_fetch sql_fetchall sql_exists sql_insertid $sql_exec |
51 | sql_exec sql_fetch sql_fetchall sql_exists sql_insertid $sql_exec |
| 52 | sql_uexec sql_ufetch sql_ufetchall sql_uexists |
52 | sql_uexec sql_ufetch sql_ufetchall sql_uexists |
| 53 | ); |
53 | ); |
| 54 | @EXPORT_OK = qw( |
54 | @EXPORT_OK = qw( |
| … | |
… | |
| 249 | } |
249 | } |
| 250 | |
250 | |
| 251 | C<sql_ufetchall> is similar to C<sql_fetchall> but upgrades all input |
251 | C<sql_ufetchall> is similar to C<sql_fetchall> but upgrades all input |
| 252 | values to utf8 and forces all result values to utf8. |
252 | values to utf8 and forces all result values to utf8. |
| 253 | |
253 | |
| 254 | =item sql_exists "<table> where ...", args... |
254 | =item sql_exists "<table_references> where <where_condition>...", args... |
| 255 | |
255 | |
| 256 | =item sql_uexists <see sql_exists> |
256 | =item sql_uexists <see sql_exists> |
| 257 | |
257 | |
| 258 | Check wether the result of the sql-statement "select xxx from |
258 | Check wether the result of the sql-statement "select xxx from |
| 259 | $first_argument" would be empty or not (that is, imagine the string |
259 | $first_argument" would be empty or not (that is, imagine the string |
