From owner-svn-ports-all@freebsd.org Fri Jul 24 07:07:49 2020 Return-Path: Delivered-To: svn-ports-all@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id D5850372301; Fri, 24 Jul 2020 07:07:49 +0000 (UTC) (envelope-from sunpoet@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "Let's Encrypt Authority X3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4BCgJP5G85z3WSY; Fri, 24 Jul 2020 07:07:49 +0000 (UTC) (envelope-from sunpoet@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 988E025FF2; Fri, 24 Jul 2020 07:07:49 +0000 (UTC) (envelope-from sunpoet@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id 06O77nJ0041212; Fri, 24 Jul 2020 07:07:49 GMT (envelope-from sunpoet@FreeBSD.org) Received: (from sunpoet@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id 06O77m5t041208; Fri, 24 Jul 2020 07:07:48 GMT (envelope-from sunpoet@FreeBSD.org) Message-Id: <202007240707.06O77m5t041208@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: sunpoet set sender to sunpoet@FreeBSD.org using -f From: Sunpoet Po-Chuan Hsieh Date: Fri, 24 Jul 2020 07:07:48 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r543008 - in head/databases: . p5-SQL-Abstract-Classic X-SVN-Group: ports-head X-SVN-Commit-Author: sunpoet X-SVN-Commit-Paths: in head/databases: . p5-SQL-Abstract-Classic X-SVN-Commit-Revision: 543008 X-SVN-Commit-Repository: ports MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: svn-ports-all@freebsd.org X-Mailman-Version: 2.1.33 Precedence: list List-Id: SVN commit messages for the ports tree List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 24 Jul 2020 07:07:49 -0000 Author: sunpoet Date: Fri Jul 24 07:07:48 2020 New Revision: 543008 URL: https://svnweb.freebsd.org/changeset/ports/543008 Log: Add p5-SQL-Abstract-Classic 1.91 SQL::Abstract::Classic was inspired by the excellent DBIx::Abstract. However, in using that module I found that what I really 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. While based on the concepts used by DBIx::Abstract, 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. The underlying idea is for this module to do what you mean, based on the data structures you provide it. The big advantage is that you don't have to modify your code every time your data changes, as this module figures it out. WWW: https://metacpan.org/release/SQL-Abstract-Classic Added: head/databases/p5-SQL-Abstract-Classic/ head/databases/p5-SQL-Abstract-Classic/Makefile (contents, props changed) head/databases/p5-SQL-Abstract-Classic/distinfo (contents, props changed) head/databases/p5-SQL-Abstract-Classic/pkg-descr (contents, props changed) head/databases/p5-SQL-Abstract-Classic/pkg-plist (contents, props changed) Modified: head/databases/Makefile Modified: head/databases/Makefile ============================================================================== --- head/databases/Makefile Fri Jul 24 07:07:25 2020 (r543007) +++ head/databases/Makefile Fri Jul 24 07:07:48 2020 (r543008) @@ -472,6 +472,7 @@ SUBDIR += p5-Rose-DBx-Object-MoreHelpers SUBDIR += p5-Rose-DBx-Object-Renderer SUBDIR += p5-SQL-Abstract + SUBDIR += p5-SQL-Abstract-Classic SUBDIR += p5-SQL-Abstract-Limit SUBDIR += p5-SQL-Abstract-More SUBDIR += p5-SQL-Abstract-Plugin-InsertMulti Added: head/databases/p5-SQL-Abstract-Classic/Makefile ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/p5-SQL-Abstract-Classic/Makefile Fri Jul 24 07:07:48 2020 (r543008) @@ -0,0 +1,25 @@ +# Created by: Po-Chuan Hsieh +# $FreeBSD$ + +PORTNAME= SQL-Abstract-Classic +PORTVERSION= 1.91 +CATEGORIES= databases perl5 +MASTER_SITES= CPAN +PKGNAMEPREFIX= p5- + +MAINTAINER= sunpoet@FreeBSD.org +COMMENT= Generate SQL from Perl data structures + +LICENSE= ART10 GPLv1+ +LICENSE_COMB= dual + +BUILD_DEPENDS= ${RUN_DEPENDS} +RUN_DEPENDS= p5-MRO-Compat>=0.12:devel/p5-MRO-Compat \ + p5-SQL-Abstract>=1.79:databases/p5-SQL-Abstract + +USES= perl5 +USE_PERL5= configure + +NO_ARCH= yes + +.include Added: head/databases/p5-SQL-Abstract-Classic/distinfo ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/p5-SQL-Abstract-Classic/distinfo Fri Jul 24 07:07:48 2020 (r543008) @@ -0,0 +1,3 @@ +TIMESTAMP = 1595416503 +SHA256 (SQL-Abstract-Classic-1.91.tar.gz) = 4e3d1dfd095b2123268586bb06b86929ea571388d4e941acccbdcda1e108ef28 +SIZE (SQL-Abstract-Classic-1.91.tar.gz) = 78466 Added: head/databases/p5-SQL-Abstract-Classic/pkg-descr ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/p5-SQL-Abstract-Classic/pkg-descr Fri Jul 24 07:07:48 2020 (r543008) @@ -0,0 +1,14 @@ +SQL::Abstract::Classic was inspired by the excellent DBIx::Abstract. However, in +using that module I found that what I really 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. + +While based on the concepts used by DBIx::Abstract, 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. The underlying idea is for this module to do what you mean, +based on the data structures you provide it. The big advantage is that you don't +have to modify your code every time your data changes, as this module figures it +out. + +WWW: https://metacpan.org/release/SQL-Abstract-Classic Added: head/databases/p5-SQL-Abstract-Classic/pkg-plist ============================================================================== --- /dev/null 00:00:00 1970 (empty, because file is newly added) +++ head/databases/p5-SQL-Abstract-Classic/pkg-plist Fri Jul 24 07:07:48 2020 (r543008) @@ -0,0 +1,4 @@ +%%SITE_PERL%%/SQL/Abstract/Classic.pm +%%SITE_PERL%%/SQL/Abstract/Util.pm +%%PERL5_MAN3%%/SQL::Abstract::Classic.3.gz +%%PERL5_MAN3%%/SQL::Abstract::Util.3.gz