| Name : perl-SQL-Interp
| |
| Version : 1.27
| Vendor : obs://build_opensuse_org/devel:languages:perl
|
| Release : 1.39
| Date : 2024-08-05 19:09:04
|
| Group : Unspecified
| Source RPM : perl-SQL-Interp-1.27-1.39.src.rpm
|
| Size : 0.07 MB
| |
| Packager : (none)
| |
| Summary : Interpolate Perl variables into SQL statements
|
Description :
SQL::Interp converts a list of intermixed SQL fragments and variable
references into a conventional SQL string and _list of bind values_
suitable for passing onto DBI. This simple technique creates database calls
that are simpler to create and easier to read, while still giving you full
access to custom SQL.
SQL::Interp properly binds or escapes variables. This recommended practice
safeguards against \"SQL injection\" attacks. The DBI documentation has
several links on the topic.
Besides the simple techniques shown above, The SQL::Interp integrates
directly with DBIx::Simple for an excellent alternative to raw DBI access:
use DBIx::Simple;
...
my $rows = $db->iquery(\"
SELECT title
FROM threads
WHERE date > \",\\$x,\" AND subject IN \",\\AATTsubjects
)->arrays;
Since DBIx::Simple still allows you complete access to the DBI API, using
it as wrapper is recommended for most applications.
|
RPM found in directory: /packages/linux-pbone/ftp5.gwdg.de/pub/opensuse/repositories/devel:/languages:/perl:/CPAN-S/openSUSE_Tumbleweed/noarch |
