BSD Portsdatabases/p5-SQLite-Work 0.16.01_1 FreeBSD
Report on and update an SQLite database
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- License
- ART10, GPLv1+
- Categories
- databases, www, perl5
- Package size
- 55.8 KiB, 193.8 KiB installed
Description
This generates HTML (and non-HTML) reports from an SQLite database, taking care of the query-building and the report formatting. This also has methods for adding and updating the database.
Reports can have nested headers which depend on the sort-order given. One can select the columns and order in which the values are displayed. The HTML page generated can be customized with templates.
The SQLite::Work::CGI module has extra methods which deal with CGI using the CGI module.
The sqlreport script uses SQLite::Work to generate reports from the command-line.
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/p5-SQLite-Work | 0.16.01_1 |
| DragonFly | databases/p5-SQLite-Work | 0.16.01_1 |
| HardenedBSD | databases/p5-SQLite-Work | 0.16.01_1 |
| GhostBSD | databases/p5-SQLite-Work | 0.16.01_1 |
Install
Binary package:
pkg install p5-SQLite-WorkFrom the ports tree:
cd /usr/ports/databases/p5-SQLite-Work/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= p5-SQLite-Work>0:databases/p5-SQLite-WorkPackages
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 | 0.16.01_1 | 0.16.01_1 | 0.16.01_1 | 0.16.01_1 | 0.16.01_1 |
| FreeBSD:14:quarterly | 0.16.01_1 | 0.16.01_1 | n/a | 0.16.01_1 | 0.16.01_1 |
| FreeBSD:15:latest | 0.16.01_1 | 0.16.01_1 | n/a | 0.16.01_1 | 0.16.01_1 |
| FreeBSD:15:quarterly | 0.16.01_1 | 0.16.01_1 | n/a | n/a | n/a |
| FreeBSD:16:latest | 0.16.01_1 | 0.16.01_1 | 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 4
p5-DBD-SQLite>=0: databases/p5-DBD-SQLitep5-DBI>=0: databases/p5-DBIp5-Getopt-ArgvFile>=0: devel/p5-Getopt-ArgvFilep5-Text-NeatTemplate>=0: textproc/p5-Text-NeatTemplate
Runtime 4
p5-DBD-SQLite>=0: databases/p5-DBD-SQLitep5-DBI>=0: databases/p5-DBIp5-Getopt-ArgvFile>=0: devel/p5-Getopt-ArgvFilep5-Text-NeatTemplate>=0: textproc/p5-Text-NeatTemplate
The full lists below include those, and their dependencies in turn.
Build dependencies 6
Run dependencies 5
No port depends on this one.
Configuration
No options to configure.
- USES
- perl5
- Service scripts
- none
Files
pkg-plist 12
- bin/sqlreport
- bin/sqlw_import
- bin/sqlw_mail
- %%SITE_PERL%%/SQLite/Work.pm
- %%SITE_PERL%%/SQLite/Work/CGI.pm
- %%SITE_PERL%%/SQLite/Work/Mail.pm
- %%PERL5_MAN3%%/SQLite::Work.3.gz
- %%PERL5_MAN3%%/SQLite::Work::CGI.3.gz
- %%PERL5_MAN3%%/SQLite::Work::Mail.3.gz
- %%PERL5_MAN1%%/sqlreport.1.gz
- %%PERL5_MAN1%%/sqlw_import.1.gz
- %%PERL5_MAN1%%/sqlw_mail.1.gz
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| SQLite-Work-0.1601.tar.gz | 183801 | 98d4feecd530a9f0f2577c0d882211bf040667784444bbfd7aa87b3e2e497af8 |
Master sites 1
- CPAN
Commit history 0
No commits in the history this site was built from.