databases/p5-SQL-Interp 1.28
Interpolate Perl variables into SQL with DBI
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- License
- ART10, GPLv1+
- Categories
- databases, perl5
- Package size
- 30.4 KiB, 67.1 KiB installed
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-Interpolate distribution includes the optional DBIx::Interp module.
Install
As a binary package — by origin, or by package name:
pkg install databases/p5-SQL-Interp
pkg install p5-SQL-InterpFrom the ports tree:
cd /usr/ports/databases/p5-SQL-Interp/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= p5-SQL-Interp>0:databases/p5-SQL-InterpPackages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 1.28 | 1.28 | 1.27 | 1.28 | 1.28 |
| FreeBSD:14:quarterly | 1.28 | 1.28 | n/a | 1.28 | 1.28 |
| FreeBSD:15:latest | 1.28 | 1.28 | n/a | 1.28 | 1.28 |
| FreeBSD:15:quarterly | 1.28 | 1.28 | n/a | n/a | n/a |
| FreeBSD:16:latest | 1.28 | 1.28 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Build 1
p5-DBI>=1: databases/p5-DBI
Runtime 1
p5-DBI>=1: databases/p5-DBI
The full lists below include those, and their dependencies in turn.
All build dependencies 2
All run dependencies 2
Required by 1
Configuration
No options to configure.
- USES
- perl5
- Service scripts
- none
Files
pkg-plist 4
- %%SITE_PERL%%/DBIx/Interp.pm
- %%SITE_PERL%%/SQL/Interp.pm
- %%PERL5_MAN3%%/DBIx::Interp.3.gz
- %%PERL5_MAN3%%/SQL::Interp.3.gz
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| SQL-Interp-1.28.tar.gz | 47121 | 21ef24256842ca43c6942c63bba692f288c0a173c1fd3beeb4b30f037439839b |
Master sites 1
- CPAN
Commit history 0
No commits in the history this site was built from.