notbugIf you buy from Amazon USA, please support us by using this link.
Port details
p5-SQLite-Work Report on and update an SQLite database
0.16.01_1 databases on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port
Maintainer: perl@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2005-10-27 14:08:15
Last Update: 2018-10-06 14:06:45
SVN Revision: 481365
Also Listed In: www perl5
License: ART10 GPLv1+
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.

WWW: https://metacpan.org/release/SQLite-Work
SVNWeb : Homepage : PortsMon
    Pseudo-pkg-plist information, but much better, from make generate-plist
    Expand this list (16 items)
  1. /usr/local/share/licenses/p5-SQLite-Work-0.16.01_1/catalog.mk
  2. /usr/local/share/licenses/p5-SQLite-Work-0.16.01_1/LICENSE
  3. /usr/local/share/licenses/p5-SQLite-Work-0.16.01_1/ART10
  4. /usr/local/share/licenses/p5-SQLite-Work-0.16.01_1/GPLv1+
  5. bin/sqlreport
  6. bin/sqlw_import
  7. bin/sqlw_mail
  8. lib/perl5/site_perl/SQLite/Work.pm
  9. lib/perl5/site_perl/SQLite/Work/CGI.pm
  10. lib/perl5/site_perl/SQLite/Work/Mail.pm
  11. lib/perl5/site_perl/man/man3/SQLite::Work.3.gz
  12. lib/perl5/site_perl/man/man3/SQLite::Work::CGI.3.gz
  13. lib/perl5/site_perl/man/man3/SQLite::Work::Mail.3.gz
  14. lib/perl5/site_perl/man/man1/sqlreport.1.gz
  15. lib/perl5/site_perl/man/man1/sqlw_import.1.gz
  16. lib/perl5/site_perl/man/man1/sqlw_mail.1.gz
  17. Collapse this list.

Dependency line: p5-SQLite-Work>0:databases/p5-SQLite-Work


To install the port: cd /usr/ports/databases/p5-SQLite-Work/ && make install clean
To add the package: pkg install p5-SQLite-Work

PKGNAME: p5-SQLite-Work

There is no flavor information for this port.

distinfo:

SHA256 (SQLite-Work-0.1601.tar.gz) = 98d4feecd530a9f0f2577c0d882211bf040667784444bbfd7aa87b3e2e497af8
SIZE (SQLite-Work-0.1601.tar.gz) = 183801


NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. p5-DBD-SQLite>=0 : databases/p5-DBD-SQLite
  2. p5-DBI>=0 : databases/p5-DBI
  3. p5-Getopt-ArgvFile>=0 : devel/p5-Getopt-ArgvFile
  4. p5-Text-NeatTemplate>=0 : textproc/p5-Text-NeatTemplate
  5. perl5>=5.26<5.27 : lang/perl5.26
  6. p5-Module-Build>=0.4206 : devel/p5-Module-Build
  7. perl5>=5.26<5.27 : lang/perl5.26
Runtime dependencies:
  1. p5-DBD-SQLite>=0 : databases/p5-DBD-SQLite
  2. p5-DBI>=0 : databases/p5-DBI
  3. p5-Getopt-ArgvFile>=0 : devel/p5-Getopt-ArgvFile
  4. p5-Text-NeatTemplate>=0 : textproc/p5-Text-NeatTemplate
  5. perl5>=5.26<5.27 : lang/perl5.26
There are no ports dependent upon this port

Configuration Options
     No options to configure

USES:
perl5

Master Sites:
  1. ftp://ftp.auckland.ac.nz/pub/perl/CPAN/authors/id/R/RU/RUBYKAT/
  2. ftp://ftp.cpan.org/pub/CPAN/authors/id/R/RU/RUBYKAT/
  3. ftp://ftp.cpan.org/pub/CPAN/modules/by-module/SQLite/
  4. ftp://ftp.funet.fi/pub/languages/perl/CPAN/authors/id/R/RU/RUBYKAT/
  5. ftp://ftp.kddlabs.co.jp/lang/perl/CPAN/authors/id/R/RU/RUBYKAT/
  6. ftp://ftp.mirrorservice.org/sites/cpan.perl.org/CPAN/authors/id/R/RU/RUBYKAT/
  7. http://backpan.perl.org/authors/id/R/RU/RUBYKAT/
  8. http://ftp.jaist.ac.jp/pub/CPAN/authors/id/R/RU/RUBYKAT/
  9. http://ftp.twaren.net/Unix/Lang/CPAN/authors/id/R/RU/RUBYKAT/
  10. https://cpan.metacpan.org/authors/id/R/RU/RUBYKAT/
  11. https://cpan.metacpan.org/modules/by-module/SQLite/
  12. https://www.cpan.org/authors/id/R/RU/RUBYKAT/

Number of commits found: 38

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
06 Oct 2018 13:06:45
Original commit files touched by this commit  0.16.01_1
Revision:481365
des search for other commits by this committer
Fix every instance of RUN_DEPENDS:=${BUILD_DEPENDS} in p5 ports, except
for where it resulted in a change in output from build-depends-list or
run-depends-list.

Approved by:	portmgr (adamw)
27 May 2018 20:15:20
Original commit files touched by this commit  0.16.01_1
Revision:470993
sunpoet search for other commits by this committer
Update WWW

search.cpan.org is shutting down.
It will redirect to metacpan.org after June 25, 2018.

With hat:	perl
15 Sep 2017 08:58:50
Original commit files touched by this commit  0.16.01_1
Revision:449893
mat search for other commits by this committer
Fix license information for portgs that use "the same license as Perl".

Sponsored by:	Absolight
11 Mar 2017 15:58:13
Original commit files touched by this commit  0.16.01_1
Revision:435912
sunpoet search for other commits by this committer
Add LICENSE_FILE
31 Jan 2017 16:21:46
Original commit files touched by this commit  0.16.01_1
Revision:432932
mat search for other commits by this committer
Bump PORTREVISION for ports affected by the fix the last commit.

Done with:	Tools/scripts/bump-revision.sh
Sponsored by:	Absolight
01 Apr 2016 14:00:57
Original commit files touched by this commit  0.16.01
Revision:412346
mat search for other commits by this committer
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
12 Jan 2016 21:38:16
Original commit files touched by this commit  0.16.01
Revision:405934
sunpoet search for other commits by this committer
- Update to 0.1601
- Add NO_ARCH

Changes:	http://search.cpan.org/dist/SQLite-Work/Changes
14 Sep 2015 12:19:50
Original commit files touched by this commit  0.16
Revision:396892
mat search for other commits by this committer
Make it so that the default Perl is always called perl5.

- Move Perl's man1 files along with its man3 files.
- Move where Perl installs its modules man1 pages.
- Convert the ports installing man1 pages.
- Make different Perl versions installable at the same time.
  Though you should note that only the default version can be used to
  install Perl modules, and the non default Perl versions cannot use the
  modules installed via ports if they contain .so as they are installed
  in a version specific directory.

Reviewed by:	bapt (the Mk bits)
Exp-run by:	antoine
Sponsored by:	Absolight
Differential Revision:	https://reviews.freebsd.org/D3542
18 Jan 2015 10:35:11
Original commit files touched by this commit  0.16
Revision:377302
sunpoet search for other commits by this committer
- Update PORTSCOUT
13 Jan 2015 19:06:07
Original commit files touched by this commit  0.16
Revision:376981
sunpoet search for other commits by this committer
- Update to 0.16
- Add LICENSE
- Add PORTSCOUT
- Sort PLIST

Changes:	http://search.cpan.org/dist/SQLite-Work/Changes
26 Nov 2014 13:08:38
Original commit files touched by this commit  0.14_1
Revision:373448
mat search for other commits by this committer
Change the way Perl modules are installed, update the default Perl to 5.18.

Before, we had:

  site_perl :           lib/perl5/site_perl/5.18
  site_perl/perl_arch : lib/perl5/site_perl/5.18/mach
  perl_man3 :           lib/perl5/5.18/man/man3

Now we have:

  site_perl : lib/perl5/site_perl
  site_arch : lib/perl5/site_perl/mach/5.18
  perl_man3 : lib/perl5/site_perl/man/man3

Modules without any .so will be installed at the same place regardless of the
(Only the first 15 lines of the commit message are shown above View all of this commit message)
20 Oct 2014 10:41:13
Original commit files touched by this commit  0.14
Revision:371255
bapt search for other commits by this committer
Cleanup plist
15 Jul 2014 06:23:19
Original commit files touched by this commit  0.14
Revision:361875
leeym search for other commits by this committer
- update to 0.14
03 Nov 2013 06:53:55
Original commit files touched by this commit  0.13
Revision:332592
vanilla search for other commits by this committer
Support STAGEDIR.
20 Sep 2013 16:13:49
Original commit files touched by this commit  0.13
Revision:327717
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
15 Sep 2013 05:53:34
Original commit files touched by this commit  0.13
Revision:327328
sunpoet search for other commits by this committer
- Sort *_DEPENDS and MAN*
- Use CPAN as primary WWW
29 Aug 2013 17:16:53
Original commit files touched by this commit  0.13
Revision:325610
sunpoet search for other commits by this committer
- Add WWW
- Use single space after WWW:
- Remove Author line
21 Aug 2013 09:27:34
Original commit files touched by this commit  0.13
Revision:325101
mat search for other commits by this committer
Update to 0.13
02 Aug 2013 18:52:11
Original commit files touched by this commit  0.10.02
Revision:324174
mat search for other commits by this committer
- Convert to new perl framework
- Trim Makefile header
- Remove MAKE_JOBS_SAFE=yes, it's the default.
17 Dec 2012 08:50:54
Original commit files touched by this commit  0.10.02
Revision:309071
az search for other commits by this committer
Cleanup supporting perl version 5.8 and 5.10,
lang/perl5.8 and lang/5.10 will be removed from ports tree soon.
10 Jun 2012 18:42:48
Original commit files touched by this commit  0.10.02
swills search for other commits by this committer
- Convert all remaining instances of BUILD_DEPENDS=${RUN_DEPENDS} or
  RUN_DEPENDS=${BUILD_DEPENDS} to use := which portlint has warned
  about for a while.

PR:             ports/168208
Approved by:    portmgr (miwi)
03 Jun 2012 18:57:30
Original commit files touched by this commit  0.10.02
crees search for other commits by this committer
SITE_PERL --> package dependencies, chunks 2-3

Submitted by:   az
01 May 2012 01:47:10
Original commit files touched by this commit  0.10.02
swills search for other commits by this committer
- Assign clsung's p5- ports to perl@

Approved by:    clsung via IRC
13 Mar 2012 16:15:36
Original commit files touched by this commit  0.10.02
pgollucci search for other commits by this committer
- Revert ports/165605 as requested by portmgr@

Note: devel/p5-B-Size and devel/p5-Devel-Arena
where intentionally not restored.

PR:             ports/165605
Approved by:    portmgr (bapt)
Feature safe:   yes (I sure hope so)
08 Mar 2012 18:45:38
Original commit files touched by this commit  0.10.02
pgollucci search for other commits by this committer
- Remove ports that only work with < perl 5.12 (devel/p5-B-Size,
devel/p5-Devel-Arena)
- Remove conditionals for PERL_LEVEL < 501200
- Remove regression-test targets b/c this will be centralized in Mk/bsd.perl.mk
- Other minor cleanups
  RUN_DEPENDS = ${BUILD_DEPENDS} -> RUN_DEPENDS:= ${BUILD_DEPENDS}

PR:             ports/165605
Submitted by:   pgollucci (myself)
Approved by:    portmgr (linimon)
Exp Run by:     linimon
Tested by:      make index
08 Sep 2011 08:36:43
Original commit files touched by this commit  0.10.02
az search for other commits by this committer
- Replace ../../authors in MASTER_SITE_SUBDIR with CPAN:CPANID macro.
  See http://wiki.freebsd.org/Perl for details.
- Change maintainership from ports@ to perl@ for ports in this changeset.

With perl@ hat
20 Mar 2011 12:54:45
Original commit files touched by this commit  0.10.02
miwi search for other commits by this committer
- Get Rid MD5 support
24 Sep 2010 02:03:44
Original commit files touched by this commit  0.10.02
pgollucci search for other commits by this committer
- only 13% of the p5- ports embed @comment $FreeBSD$:
  so standarize and remove it

With Hat:   perl@
22 Jul 2009 16:27:08
Original commit files touched by this commit  0.10.02
pgollucci search for other commits by this committer
- lang/perl5.6 is dead, remove PERL_LEVEL/PERL_VERSION < 500801 checks

PR:             ports/135398
Tested by:      2 -exp runs by pav
Approved by:    portmgr (pav)
03 Feb 2009 08:58:12
Original commit files touched by this commit  0.10.02
clsung search for other commits by this committer
- Update to 0.10.02
- improve MASTER_SITES resilience
- fix -fetch-original failure

PR:             ports/131267
Submitted by:   lth
14 Aug 2007 03:52:13
Original commit files touched by this commit  0.09
clsung search for other commits by this committer
- Update to 0.1001
01 May 2007 07:33:15
Original commit files touched by this commit  0.09
clsung search for other commits by this committer
- remove ".if ${PERL_LEVEL} < 500600 ..." stuff.
20 Sep 2006 05:30:22
Original commit files touched by this commit  0.09
clsung search for other commits by this committer
- refine Makefile, pkg-plist [1]
- buildable
- I'll maintain it

PR:             ports/102281 [1]
Submitted by:   Gea-Suan Lin <gslin_AT_gslin dot org> [1]
04 Sep 2006 09:42:17
Original commit files touched by this commit  0.05
linimon search for other commits by this committer
Reset inactive maintainer who has not responded to email.  Also mark as
deprecated, since the listed version is no longer available from the
mastersite.

Hat:            portmgr
06 Jun 2006 10:24:49
Original commit files touched by this commit  0.05
erwin search for other commits by this committer
Update to 0.05

PR:             97626
Submitted by:   miwi
Approved by:    maintainer timeout
22 Jan 2006 08:23:41
Original commit files touched by this commit  0.03
edwin search for other commits by this committer
SHA256ify

Approved by:    krion@
22 Jan 2006 01:29:10
Original commit files touched by this commit  0.03
edwin search for other commits by this committer
Replace ugly "@unexec rmdir %D... 2>/dev/null || true" with @dirrmtry

Approved by:    krion@
PR:             ports/88711 (related)
27 Oct 2005 14:07:21
Original commit files touched by this commit  0.03
tobez search for other commits by this committer
Add p5-SQLite-Work 0.03, report on and update an SQLite database.

PR:             88068
Submitted by:   Chris Larsen <darth@vader.dk>

Number of commits found: 38

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
jenkinsJan 16
jenkins-ltsJan 16
py-matrix-synapseJan 15
irssiJan 10
giteaJan 06
uriparserJan 06
chromiumJan 05
chromiumJan 05
openjpeg*Jan 05
py-django111Jan 05
py-django20Jan 05
py-django21Jan 05
gitlab-ceJan 02
rpm4Dec 26
gitlab-ceDec 22

10 vulnerabilities affecting 54 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-01-16 17:44:00


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 35984
Broken 115
Deprecated 412
Ignore 328
Forbidden 3
Restricted 162
No CDROM 74
Vulnerable 33
Expired 5
Set to expire 385
Interactive 0
new 24 hours 2
new 48 hours7
new 7 days28
new fortnight80
new month152

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2019 Dan Langille. All rights reserved.