| Port details |
- p5-SQL-Abstract Perl extension to generate SQL from Perl data structures
- 2.000001 databases
 =5      2.000001Version of this port present on the latest quarterly branch. - Maintainer: perl@FreeBSD.org
- Port Added: 2003-06-19 14:31:19
- Last Update: 2022-09-07 21:58:51
- Commit Hash: fb16dfe
- People watching this port, also watch:: p5-DBD-mysql, glib, p5-IO-Multiplex, zip, p5-Cache-Cache
- Also Listed In: perl5
- License: ART10 GPLv1+
- WWW:
- https://metacpan.org/release/SQL-Abstract
- Description:
- This module was inspired by the excellent DBIx::Abstract. However, in
using the module I found that what I wanted to do was generate SQL, but
still retain complete control over my statement handles and use the DBI
interface. So, I set out to create an abstract SQL generation module.
This module is based largely on DBIx::Abstract. However, there are
several important differences, especially when it comes to WHERE
clauses. I have modified the concepts used to make the SQL easier to
generate from Perl data structures and, IMO, more intuitive.
  ¦  ¦  ¦  ¦ 
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- p5-SQL-Abstract>0:databases/p5-SQL-Abstract
- To install the port:
- cd /usr/ports/databases/p5-SQL-Abstract/ && make install clean
- To add the package, run one of these commands:
- pkg install databases/p5-SQL-Abstract
- pkg install p5-SQL-Abstract
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: p5-SQL-Abstract
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1612101716
SHA256 (SQL-Abstract-2.000001.tar.gz) = 35a642662c349420d44be6e0ef7d8765ea743eb12ad14399aa3a232bb94e6e9a
SIZE (SQL-Abstract-2.000001.tar.gz) = 134560
Packages (timestamps in pop-ups are UTC):
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- p5-Hash-Merge>=0.12 : textproc/p5-Hash-Merge
- p5-MRO-Compat>=0.12 : devel/p5-MRO-Compat
- p5-Moo>=2.000001 : devel/p5-Moo
- p5-Sub-Quote>=2.000001 : devel/p5-Sub-Quote
- p5-Test-Deep>=0.101 : devel/p5-Test-Deep
- perl5>=5.32.r0<5.33 : lang/perl5.32
- perl5>=5.32.r0<5.33 : lang/perl5.32
- Runtime dependencies:
-
- p5-Hash-Merge>=0.12 : textproc/p5-Hash-Merge
- p5-MRO-Compat>=0.12 : devel/p5-MRO-Compat
- p5-Moo>=2.000001 : devel/p5-Moo
- p5-Sub-Quote>=2.000001 : devel/p5-Sub-Quote
- p5-Test-Deep>=0.101 : devel/p5-Test-Deep
- perl5>=5.32.r0<5.33 : lang/perl5.32
- This port is required by:
- for Build
-
- databases/p5-Class-DBI-AbstractSearch
- databases/p5-Class-DBI-Plugin-AbstractCount
- databases/p5-Class-DBI-Plugin-DeepAbstractSearch
- databases/p5-Class-DBI-Plugin-Pager
- databases/p5-Class-DBI-Sweet
- databases/p5-Oryx
- databases/p5-SQL-Abstract-Classic
-
Deleted ports which required this port:
- for Run
-
- databases/p5-Class-DBI-AbstractSearch
- databases/p5-Class-DBI-Plugin-AbstractCount
- databases/p5-Class-DBI-Plugin-DeepAbstractSearch
- databases/p5-Class-DBI-Plugin-Pager
- databases/p5-Class-DBI-Sweet
- databases/p5-Oryx
- databases/p5-SQL-Abstract-Classic
-
Deleted ports which required this port:
- * - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...
Configuration Options:- No options to configure
- Options name:
- databases_p5-SQL-Abstract
- USES:
- perl5
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|
| Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
| Commit | Credits | Log message |
|---|
07 Sep 2022 21:58:51
 |
Stefan Eßer (se) |
Remove WWW entries moved into port Makefiles
Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.
This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.
Approved by: portmgr (tcberner) |
2.000001
07 Sep 2022 21:10:59
|
Stefan Eßer (se) |
Add WWW entries to port Makefiles
It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.
Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.
There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above  ) |
2.000001
20 Jul 2022 14:21:07
|
Tobias C. Berner (tcberner) |
databases: remove 'Created by' lines
A big Thank You to the original contributors of these ports:
* "Choe, Cheng-Dae" whitekid
* "Mahdi Mokhtari <mokhi64@gmail.com>"
* "Meikel Brandmeyer" <ocaml-sqlite3-port@kotka.de>
* <hvo.pm@xs4all.nl>
* <jsmith@resonatingmedia.com>
* <ports@c0decafe.net>
* Aaron Dalton <aaron@FreeBSD.org>
* Adam Weinberger <adamw@FreeBSD.org>
* Ade Lovett <ade@FreeBSD.org>
* Akinori MUSHA aka knu <knu@idaemons.org>
* Alan Snelson <Alan@Wave2.org> (Only the first 15 lines of the commit message are shown above ) |
2.000001
06 Apr 2021 14:31:07
|
Mathieu Arnold (mat) |
Remove # $FreeBSD$ from Makefiles. |
2.000001
01 Feb 2021 19:44:49
 |
sunpoet |
Update to 2.000001
Changes: https://metacpan.org/changes/distribution/SQL-Abstract |
1.87
24 Jul 2020 07:20:22
|
sunpoet |
Sort *_DEPENDS |
1.87
19 Jul 2020 10:59:07
|
wen |
- Update to 1.87 |
1.86_2
06 Oct 2018 13:06:45
|
des |
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) |
1.86_2
23 Aug 2018 01:15:05
|
wen |
- Fix LICENSE_FILE
Spotted by: sunpoet@ |
1.86_1
22 Aug 2018 03:41:53
|
wen |
- Add LICENSE_FILE_*
- Update DEPENDS
PR: 229695
Submitted by: svysh.fbsd@gmail.com |
1.86
16 Jul 2018 23:27:50
|
wen |
- Update to 1.86
Changes: https://metacpan.org/release/SQL-Abstract |
1.85
27 May 2018 20:15:20
|
sunpoet |
Update WWW
search.cpan.org is shutting down.
It will redirect to metacpan.org after June 25, 2018.
With hat: perl |
1.85
28 Jan 2018 14:08:51
|
sunpoet |
Update to 1.85
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.84
15 Sep 2017 08:58:50
|
mat |
Fix license information for portgs that use "the same license as Perl".
Sponsored by: Absolight |
1.84
04 Apr 2017 07:37:58
|
sunpoet |
Update to 1.84
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.82
22 Mar 2017 21:36:04
|
sunpoet |
Update to 1.82
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.81_3
08 Jan 2017 20:43:34
|
sunpoet |
Fix *_DEPENDS
- Bump PORTREVISION for dependency change
SQL::Abstract::Test requires Test::Deep. |
1.81_2
01 Jan 2017 01:47:35
|
sunpoet |
Fix *_DEPENDS
- Move p5-Moo from TEST_DEPENDS to {BUILD|RUN}_DEPENDS
- Bump PORTREVISION for dependency change
- While I'm here, add NO_ARCH
PR: 215685
Submitted by: Sergei Vyshenski <svysh.fbsd@gmail.com> |
1.81_1
19 May 2016 10:21:25
|
amdmi3 |
- Fix trailing whitespace in pkg-descrs, categories [a-f]*
Approved by: portmgr blanket |
1.81_1
01 Apr 2016 14:00:57
|
mat |
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.
With hat: portmgr
Sponsored by: Absolight |
1.81_1
12 Mar 2015 23:00:03
|
adamw |
Some OCD cleanups on some of the perl@ ports.
- Remove dependencies in core
- Put testing depends in TEST_DEPENDS
- Remove unnecessary bsd.port.options.mk inclusions
- Remove checks for Perl versions that no longer exist in the ports tree
- Sort plists, some of which were so jumbled that I have to assume
the plist was randomized before committing
A lot of the plist changes in this commit are moving PERL5_MAN3 after
SITE_PERL. It's repo churn now, but it makes updating the ports later
far easier. |
1.81_1
26 Nov 2014 13:08:38
|
mat |
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 ) |
1.81
31 Oct 2014 09:17:15
|
culot |
- Update to 1.81
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.80
20 Oct 2014 10:41:13
|
bapt |
Cleanup plist |
1.80
15 Oct 2014 09:03:16
|
culot |
- Update to 1.80
- Remove unneeded dependencies
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.78
15 Jul 2014 05:04:43
|
leeym |
- update to 1.78 |
1.77
05 Feb 2014 07:37:34
|
culot |
- Update to 1.77
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.75
31 Dec 2013 00:59:16
|
sunpoet |
- Update to 1.75
- Add missing TEST_DEPENDS
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.74
03 Nov 2013 06:53:55
|
vanilla |
Support STAGEDIR. |
1.74
20 Sep 2013 16:13:49
|
bapt |
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases) |
1.74
02 Aug 2013 18:52:11
|
mat |
- Convert to new perl framework
- Trim Makefile header
- Remove MAKE_JOBS_SAFE=yes, it's the default. |
1.74
06 Jun 2013 09:55:34
|
mat |
Update to 1.74. |
1.73
17 Dec 2012 09:39:00
|
az |
Cleanup supporting perl version 5.8 and 5.10,
lang/perl5.8 and lang/5.10 will be removed from ports tree soon. |
1.73
11 Jul 2012 09:00:00
|
sunpoet |
- Update to 1.73
- Add LICENSE
- Sort MAN3 and PLIST
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.72
22 Sep 2011 03:08:38
|
swills |
- Update TEST_DEPENDS |
1.72
23 Dec 2010 01:12:58
|
wen |
- Update to 1.72
ChangeLog: http://cpansearch.perl.org/src/FREW/SQL-Abstract-1.72/Changes |
1.71
10 Nov 2010 07:21:26
|
wen |
- Update to 1.71
Changelog: http://search.cpan.org/src/RIBASUSHI/SQL-Abstract-1.71/Changes |
1.69
26 Oct 2010 05:32:20
|
culot |
- Update to 1.69
- Add TEST_DEPENDS
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes
Approved by: sahil@ (mentor) |
1.68
20 Sep 2010 00:23:50
|
wen |
- Update to 1.68
- Add missing depends
PR: ports/150639
Submitted by: Frederic Culot <frederic@culot.org> |
1.67
01 Jun 2010 01:51:01
|
wen |
- Update to 1.67 |
1.66
06 May 2010 06:58:05
|
az |
Update to 1.66
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.65
11 Apr 2010 23:32:45
|
wen |
- Update to 1.65 |
1.63
24 Mar 2010 12:23:43
|
tobez |
Update to 1.63.
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.62
15 Mar 2010 12:42:36
|
tobez |
Update to 1.62.
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.61
05 Feb 2010 21:02:38
|
tobez |
Update to 1.61.
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.60
22 Sep 2009 13:17:06
|
tobez |
Update to 1.60.
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes
Feature safe: yes |
1.58
04 Sep 2009 17:50:41
|
tobez |
Update to 1.58.
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.57
03 Sep 2009 21:55:58
|
tobez |
Update to 1.57.
Changes: http://search.cpan.org/dist/SQL-Abstract/Changes |
1.56
16 Aug 2009 09:22:05
|
linimon |
Reset lbr@FreeBSD.org due to maintainer-timeouts and no response to email.
Hat: portmgr |
1.56
19 Jun 2009 16:19:52
|
pgollucci |
- Update to 1.56
PR: ports/135730
Approved by: maintainer (lbr)
Submitted by: myself (pgollucci@) |
1.55
15 Jun 2009 21:10:02
|
pgollucci |
- Update to 1.55
PR: ports/135101
Approved by: maintainer timeout (lbr; 2 weeks 1 day)
Submitted by: pgollucci@ (myself) |
1.53
04 May 2009 04:16:57
|
lbr |
Update to 1.53 |
1.51
29 Mar 2009 11:21:44
|
lbr |
Update to 1.51 |
1.50
22 Mar 2009 00:22:12
|
lbr |
Update to 1.50
PR: 132617
Submitted by: Wen Heping <wenheping@gmail.com> |
1.24
09 Jul 2008 22:29:18
|
lbr |
Update to 1.24 (apparantly 1.23 was FUBAR:
http://search.cpan.org/src/MSTROUT/SQL-Abstract-1.24/Changes) |
1.23
09 Jul 2008 20:52:07
|
lbr |
Update to 1.23 |
1.22
17 Apr 2008 14:30:31
|
araujo |
- Take advantage of CPAN macro from bsd.sites.mk, change
${MASTER_SITE_PERL_CPAN} to CPAN.
PR: ports/122674
Submitted by: Philip M. Gollucci <pgollucci@p6m7g8.com>
Reworked by: araujo (myself)
Approved by: portmgr (pav) |
1.22
08 Sep 2007 00:54:37
|
linimon |
Welcome bsd.perl.mk. Add support for constructs such as USE_PERL5=5.8.0+.
Drop support for antique perl.
Work done by: gabor
Sponsored by: Google Summer of Code 2007
Hat: portmgr |
1.22
05 Jan 2007 17:55:38
|
lbr |
Update to 1.22 |
1.21
01 May 2006 13:52:00
|
lbr |
Changing email-address on my 80 ports.
Approved by: erwin (mental) |
1.21
26 Mar 2006 19:39:16
|
sem |
- Update to 1.21
PR: ports/94965
Submitted by: maintainer |
1.20
22 Jan 2006 08:23:41
|
edwin |
SHA256ify
Approved by: krion@ |
1.20
22 Jan 2006 01:29:10
|
edwin |
Replace ugly "@unexec rmdir %D... 2>/dev/null || true" with @dirrmtry
Approved by: krion@
PR: ports/88711 (related) |
1.20
02 Oct 2005 14:14:40
|
mnag |
Update to 1.20
PR: 86786
Submitted by: Emanuel Haupt <ehaupt@critical.ch>
Approved by: lars@balker.org (maintainer), pav (mentor) |
1.19
21 Sep 2005 19:31:43
|
fenner |
search.cpan.org redirect reduction canonicalization project, pass 1:
URLs automatically rewritten from /search?dist=Foo or /dist/Foo
to /dist/Foo/ (note trailing slash). After a 2002(!) reorganization,
this is the preferred way to refer to modules on search.cpan.org.
This pass brought to you by http://people.freebsd.org/~fenner/fix-search |
1.19
10 Jul 2005 05:50:51
|
novel |
Mark IGNORE for old perl versions.
Reported by: pointyhat via kris |
1.19
07 Jul 2005 04:33:34
|
novel |
- update to 1.19
- pass maintainership to Lars Balker Rasmussen (lars@balker.dk)
PR: 83072
Submitted by: Dominic Mitchell (former maintainer) |
1.13
31 Mar 2004 03:12:58
|
trevor |
SIZEify (maintainer timeout) |
1.13
04 Nov 2003 09:05:12
|
erwin |
Update to 1.13
PR: 58077
Submitted by: Cheng-Lung Sung <clsung@dragon2.net>
Approved by: maintainer timeout (almost 3 weeks) |
1.10
24 Oct 2003 12:05:09
|
ijliao |
utilize SITE_PERL
PR: 58166
Submitted by: Cheng-Lung Sung <clsung@dragon2.net> |
1.10
19 Jun 2003 14:30:46
|
erwin |
Add p5-SQL-Abstract 1.10,
perl extension to generate SQL from Perl
data structures.
PR: 48411
Submitted by: Dominic Mitchell <dom@happygiraffe.net> |
As an Amazon Associate I earn from qualifying purchases.