notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

Port details on branch 2022Q3
p5-SQL-Abstract Perl extension to generate SQL from Perl data structures
2.000001 databases on this many watch lists=5 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 2.000001Version of this port present on the latest quarterly branch.
Maintainer: perl@FreeBSD.org search for ports maintained by this maintainer
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.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (27 items)
Collapse this list.
  1. /usr/local/share/licenses/p5-SQL-Abstract-2.000001/catalog.mk
  2. /usr/local/share/licenses/p5-SQL-Abstract-2.000001/LICENSE
  3. /usr/local/share/licenses/p5-SQL-Abstract-2.000001/ART10
  4. /usr/local/share/licenses/p5-SQL-Abstract-2.000001/GPLv1+
  5. lib/perl5/site_perl/DBIx/Class/SQLMaker/Role/SQLA2Passthrough.pm
  6. lib/perl5/site_perl/DBIx/Class/Storage/Debug/PrettyPrint.pm
  7. lib/perl5/site_perl/SQL/Abstract.pm
  8. lib/perl5/site_perl/SQL/Abstract/Formatter.pm
  9. lib/perl5/site_perl/SQL/Abstract/Parts.pm
  10. lib/perl5/site_perl/SQL/Abstract/Plugin/BangOverrides.pm
  11. lib/perl5/site_perl/SQL/Abstract/Plugin/ExtraClauses.pm
  12. lib/perl5/site_perl/SQL/Abstract/Reference.pm
  13. lib/perl5/site_perl/SQL/Abstract/Role/Plugin.pm
  14. lib/perl5/site_perl/SQL/Abstract/Test.pm
  15. lib/perl5/site_perl/SQL/Abstract/Tree.pm
  16. lib/perl5/site_perl/man/man3/DBIx::Class::SQLMaker::Role::SQLA2Passthrough.3.gz
  17. lib/perl5/site_perl/man/man3/DBIx::Class::Storage::Debug::PrettyPrint.3.gz
  18. lib/perl5/site_perl/man/man3/SQL::Abstract.3.gz
  19. lib/perl5/site_perl/man/man3/SQL::Abstract::Plugin::BangOverrides.3.gz
  20. lib/perl5/site_perl/man/man3/SQL::Abstract::Plugin::ExtraClauses.3.gz
  21. lib/perl5/site_perl/man/man3/SQL::Abstract::Reference.3.gz
  22. lib/perl5/site_perl/man/man3/SQL::Abstract::Role::Plugin.3.gz
  23. lib/perl5/site_perl/man/man3/SQL::Abstract::Test.3.gz
  24. lib/perl5/site_perl/man/man3/SQL::Abstract::Tree.3.gz
  25. @owner
  26. @group
  27. @mode
Collapse this list.
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):
p5-SQL-Abstract
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest2.0000012.0000011.872.0000012.000001-1.87-
FreeBSD:13:quarterly2.0000012.0000012.0000012.0000012.0000012.0000012.0000012.000001
FreeBSD:14:latest2.0000012.0000012.0000012.0000012.0000012.000001-2.000001
FreeBSD:14:quarterly2.0000012.000001-2.0000012.0000012.0000012.0000012.000001
FreeBSD:15:latest2.0000012.000001n/a2.000001n/a2.0000012.0000012.000001
FreeBSD:15:quarterly--n/a-n/a---
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. p5-Hash-Merge>=0.12 : textproc/p5-Hash-Merge
  2. p5-MRO-Compat>=0.12 : devel/p5-MRO-Compat
  3. p5-Moo>=2.000001 : devel/p5-Moo
  4. p5-Sub-Quote>=2.000001 : devel/p5-Sub-Quote
  5. p5-Test-Deep>=0.101 : devel/p5-Test-Deep
  6. perl5>=5.32.r0<5.33 : lang/perl5.32
  7. perl5>=5.32.r0<5.33 : lang/perl5.32
Runtime dependencies:
  1. p5-Hash-Merge>=0.12 : textproc/p5-Hash-Merge
  2. p5-MRO-Compat>=0.12 : devel/p5-MRO-Compat
  3. p5-Moo>=2.000001 : devel/p5-Moo
  4. p5-Sub-Quote>=2.000001 : devel/p5-Sub-Quote
  5. p5-Test-Deep>=0.101 : devel/p5-Test-Deep
  6. perl5>=5.32.r0<5.33 : lang/perl5.32
This port is required by:
for Build
  1. databases/p5-Class-DBI-AbstractSearch
  2. databases/p5-Class-DBI-Plugin-AbstractCount
  3. databases/p5-Class-DBI-Plugin-DeepAbstractSearch
  4. databases/p5-Class-DBI-Plugin-Pager
  5. databases/p5-Class-DBI-Sweet
  6. databases/p5-Oryx
  7. databases/p5-SQL-Abstract-Classic
Expand this list (15 items / 8 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. databases/p5-SQL-Abstract-Limit
  3. databases/p5-SQL-Abstract-More
  4. databases/p5-SQL-Abstract-Pg
  5. databases/p5-SQL-Abstract-Plugin-InsertMulti
  6. databases/p5-Test-Fixture-DBI
  7. devel/p5-AnyEvent-DBI-Abstract
  8. www/p5-Apache-AuthTicket
  9. Collapse this list.

Deleted ports which required this port:

Expand this list of 1 deleted port
  1. databases/p5-Class-DBI-Lite*
  2. Collapse this list of deleted ports.
for Run
  1. databases/p5-Class-DBI-AbstractSearch
  2. databases/p5-Class-DBI-Plugin-AbstractCount
  3. databases/p5-Class-DBI-Plugin-DeepAbstractSearch
  4. databases/p5-Class-DBI-Plugin-Pager
  5. databases/p5-Class-DBI-Sweet
  6. databases/p5-Oryx
  7. databases/p5-SQL-Abstract-Classic
Expand this list (15 items / 8 hidden - sorry, this count includes any deleted ports)
  1. Collapse this list).
  2. databases/p5-SQL-Abstract-Limit
  3. databases/p5-SQL-Abstract-More
  4. databases/p5-SQL-Abstract-Pg
  5. databases/p5-SQL-Abstract-Plugin-InsertMulti
  6. databases/p5-Test-Fixture-DBI
  7. devel/p5-AnyEvent-DBI-Abstract
  8. www/p5-Apache-AuthTicket
  9. Collapse this list.

Deleted ports which required this port:

Expand this list of 1 deleted port
  1. databases/p5-Class-DBI-Lite*
  2. Collapse this list of deleted ports.
* - 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:
Expand this list (12 items)
Collapse this list.
  1. ftp://ftp.auckland.ac.nz/pub/perl/CPAN/modules/by-module/SQL/
  2. ftp://ftp.cpan.org/pub/CPAN/modules/by-module/
  3. ftp://ftp.cpan.org/pub/CPAN/modules/by-module/SQL/
  4. ftp://ftp.funet.fi/pub/languages/perl/CPAN/modules/by-module/SQL/
  5. ftp://ftp.kddlabs.co.jp/lang/perl/CPAN/modules/by-module/SQL/
  6. ftp://ftp.mirrorservice.org/sites/cpan.perl.org/CPAN/modules/by-module/SQL/
  7. http://backpan.perl.org/modules/by-module/SQL/
  8. http://ftp.jaist.ac.jp/pub/CPAN/modules/by-module/SQL/
  9. http://ftp.twaren.net/Unix/Lang/CPAN/modules/by-module/SQL/
  10. https://cpan.metacpan.org/modules/by-module/
  11. https://cpan.metacpan.org/modules/by-module/SQL/
  12. https://www.cpan.org/modules/by-module/SQL/
Collapse this list.

There are no commits on branch 2022Q3 for this port