BSD Portsdatabases/p5-SQL-Abstract 2.000001 FreeBSD
Perl extension to generate SQL from Perl data structures
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- License
- ART10, GPLv1+
- Categories
- databases, perl5
- Package size
- 104.9 KiB, 288.6 KiB installed
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.
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/p5-SQL-Abstract | 2.000001 |
| OpenBSD | databases/p5-SQL-Abstract | 2.000001 |
| NetBSD | databases/p5-SQL-Abstract | 2.000001nb6 |
| DragonFly | databases/p5-SQL-Abstract | 2.000001 |
| MidnightBSD | databases/p5-SQL-Abstract | 2.000001_1 |
Install
Binary package:
pkg install p5-SQL-AbstractFrom the ports tree:
cd /usr/ports/databases/p5-SQL-Abstract/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= p5-SQL-Abstract>0:databases/p5-SQL-AbstractPackages
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 | 2.000001 | 2.000001 | 2.000001 | 2.000001 | 2.000001 |
| FreeBSD:14:quarterly | 2.000001 | 2.000001 | n/a | 2.000001 | 2.000001 |
| FreeBSD:15:latest | 2.000001 | 2.000001 | n/a | 2.000001 | 2.000001 |
| FreeBSD:15:quarterly | 2.000001 | 2.000001 | n/a | n/a | n/a |
| FreeBSD:16:latest | 2.000001 | 2.000001 | 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 5
p5-Hash-Merge>=0.12: textproc/p5-Hash-Mergep5-MRO-Compat>=0.12: devel/p5-MRO-Compatp5-Moo>=2.000001: devel/p5-Moop5-Sub-Quote>=2.000001: devel/p5-Sub-Quotep5-Test-Deep>=0.101: devel/p5-Test-Deep
Runtime 5
p5-Hash-Merge>=0.12: textproc/p5-Hash-Mergep5-MRO-Compat>=0.12: devel/p5-MRO-Compatp5-Moo>=2.000001: devel/p5-Moop5-Sub-Quote>=2.000001: devel/p5-Sub-Quotep5-Test-Deep>=0.101: devel/p5-Test-Deep
Test 4
p5-DBIx-Class>=0: databases/p5-DBIx-Classp5-Data-Dumper-Concise>=0: devel/p5-Data-Dumper-Concisep5-Test-Exception>=0.31: devel/p5-Test-Exceptionp5-Test-Warn>=0: devel/p5-Test-Warn
The full lists below include those, and their dependencies in turn.
Build dependencies 13
Run dependencies 13
Required by 85
- 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-SAK
- databases/p5-Class-DBI-Sweet
- databases/p5-DBICx-Deploy
- databases/p5-DBICx-MapMaker
- databases/p5-DBICx-Sugar
- databases/p5-DBICx-TxnInsert
- databases/p5-DBIx-Class
- databases/p5-DBIx-Class-AsFdat
- databases/p5-DBIx-Class-AuditLog
- databases/p5-DBIx-Class-BitField
- databases/p5-DBIx-Class-Candy
- databases/p5-DBIx-Class-Cursor-Cached
- databases/p5-DBIx-Class-CustomPrefetch
- databases/p5-DBIx-Class-DateTime-Epoch
- databases/p5-DBIx-Class-DeploymentHandler
- databases/p5-DBIx-Class-DigestColumns
- databases/p5-DBIx-Class-DynamicDefault
- databases/p5-DBIx-Class-DynamicSubclass
- databases/p5-DBIx-Class-EncodeColumns
- databases/p5-DBIx-Class-EncodedColumn
- databases/p5-DBIx-Class-Fixtures
- databases/p5-DBIx-Class-FrozenColumns
- databases/p5-DBIx-Class-Helpers
- databases/p5-DBIx-Class-InflateColumn-Authen-Passphrase
- databases/p5-DBIx-Class-InflateColumn-FS
- databases/p5-DBIx-Class-InflateColumn-IP
- databases/p5-DBIx-Class-InflateColumn-Serializer
- databases/p5-DBIx-Class-IntrospectableM2M
- databases/p5-DBIx-Class-Loader
- databases/p5-DBIx-Class-Migration
- databases/p5-DBIx-Class-PassphraseColumn
- databases/p5-DBIx-Class-QueryLog
- databases/p5-DBIx-Class-QueryProfiler
- databases/p5-DBIx-Class-ResultSet-HashRef
- databases/p5-DBIx-Class-ResultSet-RecursiveUpdate
- databases/p5-DBIx-Class-Schema-Config
- databases/p5-DBIx-Class-Schema-Loader
- databases/p5-DBIx-Class-Storage-TxnEndHook
- databases/p5-DBIx-Class-TimeStamp
- databases/p5-DBIx-Class-Tree
- databases/p5-DBIx-Class-Tree-NestedSet
- databases/p5-DBIx-Class-UUIDColumns
- databases/p5-DBIx-Class-VirtualColumns
- databases/p5-DBIx-Class-WebForm
- databases/p5-DBIx-Lite
- databases/p5-DBIx-NoSQL
- databases/p5-Dancer-Plugin-DBIC
- databases/p5-Dancer2-Plugin-DBIC
- databases/p5-Dancer2-Session-DBIC
- databases/p5-HTML-FormHandler-Model-DBIC
- databases/p5-Interchange6-Schema
- databases/p5-Mojo-Pg
- databases/p5-Oryx
- databases/p5-SQL-Abstract-Classic
- databases/p5-SQL-Abstract-Limit
- databases/p5-SQL-Abstract-More
- databases/p5-SQL-Abstract-Pg
- databases/p5-SQL-Abstract-Plugin-InsertMulti
- databases/p5-Test-Fixture-DBI
- devel/p5-AnyEvent-DBI-Abstract
- devel/p5-Test-DBIC-ExpectedQueries
- devel/p5-Test-DBIx-Class
- devel/p5-Test2-Harness-UI
- security/p5-Dancer2-Plugin-Auth-Extensible-Provider-DBIC
- security/p5-openxpki
- textproc/p5-Plagger
- www/p5-Apache-AuthTicket
- www/p5-Bigtop
- www/p5-Catalyst-Authentication-Store-DBIx-Class
- www/p5-Catalyst-Model-CDBI-Sweet
- www/p5-Catalyst-Model-DBIC-Plain
- www/p5-Catalyst-Model-DBIC-Schema
- www/p5-Catalyst-Model-Oryx
- www/p5-Catalyst-Plugin-AutoCRUD
- www/p5-Catalyst-Plugin-Session-Store-DBIC
- www/p5-Catalyst-TraitFor-Controller-DBIC-DoesPaging
- www/p5-HTML-FormFu-Model-DBIC
- www/p5-Maypole
- www/p5-MojoMojo
- www/p5-Reaction
- www/p5-Task-Catalyst
Configuration
No options to configure.
- USES
- perl5
- Service scripts
- none
Files
pkg-plist 20
- %%SITE_PERL%%/DBIx/Class/SQLMaker/Role/SQLA2Passthrough.pm
- %%SITE_PERL%%/DBIx/Class/Storage/Debug/PrettyPrint.pm
- %%SITE_PERL%%/SQL/Abstract.pm
- %%SITE_PERL%%/SQL/Abstract/Formatter.pm
- %%SITE_PERL%%/SQL/Abstract/Parts.pm
- %%SITE_PERL%%/SQL/Abstract/Plugin/BangOverrides.pm
- %%SITE_PERL%%/SQL/Abstract/Plugin/ExtraClauses.pm
- %%SITE_PERL%%/SQL/Abstract/Reference.pm
- %%SITE_PERL%%/SQL/Abstract/Role/Plugin.pm
- %%SITE_PERL%%/SQL/Abstract/Test.pm
- %%SITE_PERL%%/SQL/Abstract/Tree.pm
- %%PERL5_MAN3%%/DBIx::Class::SQLMaker::Role::SQLA2Passthrough.3.gz
- %%PERL5_MAN3%%/DBIx::Class::Storage::Debug::PrettyPrint.3.gz
- %%PERL5_MAN3%%/SQL::Abstract.3.gz
- %%PERL5_MAN3%%/SQL::Abstract::Plugin::BangOverrides.3.gz
- %%PERL5_MAN3%%/SQL::Abstract::Plugin::ExtraClauses.3.gz
- %%PERL5_MAN3%%/SQL::Abstract::Reference.3.gz
- %%PERL5_MAN3%%/SQL::Abstract::Role::Plugin.3.gz
- %%PERL5_MAN3%%/SQL::Abstract::Test.3.gz
- %%PERL5_MAN3%%/SQL::Abstract::Tree.3.gz
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| SQL-Abstract-2.000001.tar.gz | 134560 | 35a642662c349420d44be6e0ef7d8765ea743eb12ad14399aa3a232bb94e6e9a |
Master sites 1
- CPAN
Commit history 0
No commits in the history this site was built from.