From owner-svn-ports-head@freebsd.org Thu Jul 4 19:13:02 2019 Return-Path: Delivered-To: svn-ports-head@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 0E72715DC1AC; Thu, 4 Jul 2019 19:13:02 +0000 (UTC) (envelope-from pi@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) server-signature RSA-PSS (4096 bits) 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 A895B6E431; Thu, 4 Jul 2019 19:13:01 +0000 (UTC) (envelope-from pi@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 83CEF273AE; Thu, 4 Jul 2019 19:13:01 +0000 (UTC) (envelope-from pi@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id x64JD14q017801; Thu, 4 Jul 2019 19:13:01 GMT (envelope-from pi@FreeBSD.org) Received: (from pi@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id x64JD02Y017798; Thu, 4 Jul 2019 19:13:00 GMT (envelope-from pi@FreeBSD.org) Message-Id: <201907041913.x64JD02Y017798@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: pi set sender to pi@FreeBSD.org using -f From: Kurt Jaeger Date: Thu, 4 Jul 2019 19:13:00 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r505863 - head/databases/cego X-SVN-Group: ports-head X-SVN-Commit-Author: pi X-SVN-Commit-Paths: head/databases/cego X-SVN-Commit-Revision: 505863 X-SVN-Commit-Repository: ports MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Rspamd-Queue-Id: A895B6E431 X-Spamd-Bar: -- Authentication-Results: mx1.freebsd.org X-Spamd-Result: default: False [-2.98 / 15.00]; local_wl_from(0.00)[FreeBSD.org]; NEURAL_HAM_MEDIUM(-1.00)[-0.999,0]; NEURAL_HAM_SHORT(-0.98)[-0.978,0]; NEURAL_HAM_LONG(-1.00)[-1.000,0]; ASN(0.00)[asn:11403, ipnet:2610:1c1:1::/48, country:US] X-BeenThere: svn-ports-head@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: SVN commit messages for the ports tree for head List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 04 Jul 2019 19:13:02 -0000 Author: pi Date: Thu Jul 4 19:13:00 2019 New Revision: 505863 URL: https://svnweb.freebsd.org/changeset/ports/505863 Log: databases/cego: upgrade 2.44.14 -> 2.45.0 - Added table alias feature to grammar definition. Table aliases allow alternate table name and attribute name definitions for a table ( create alias ... ) - Added classes CegoAliasObject and CegoAttrAlias for table alias handling - Implemented base semantic actions for creating, listing and describe alias objects ( still no usage ) - In CegoDistManager::registerObjects, added registration for fkey, check, trigger and alias - Added alias mapping for insert, update and delete queries ( CegoQueryHelper::mapAliasPredicate still to implement ) - Basic alias mapping for select works, here's a sample SQL script drop if exists table t1; list alias; desc alias a1; drop if exists alias a1; create table t1 ( a int, b string(30)); create alias a1 on t1 ( a as ax, b as bx ); insert into a1 ( ax, bx ) values ( 1, 'XXX'); insert into a1 ( ax, bx ) values ( 2, 'YYY'); insert into a1 ( ax, bx ) values ( 3, 'ZZZ'); select ax from a1; - More work on table alias handling. Now works with more sophisticated select queries ( e.g. select ax from a1 aa where aa.ax = 1; ) For this, some fixes had to be done in CegoContentObject, since the the table alias attribute ( _tabAlias ) was not setup in constructor and other methods - Added alias and trigger xml export and import feature ( trigger xport was still not implemented ) Fix in CegoDbThread::loadObjects for trigger reload, instead of triggerList.Next(), triggerList.First() was called, which result in an infinite loop in case of existing trigger objects - Added trigger and alias object handling to CegoXPorter binary export and import Submitted by: Bjoern Lemke Modified: head/databases/cego/Makefile head/databases/cego/distinfo head/databases/cego/pkg-plist Modified: head/databases/cego/Makefile ============================================================================== --- head/databases/cego/Makefile Thu Jul 4 18:48:15 2019 (r505862) +++ head/databases/cego/Makefile Thu Jul 4 19:13:00 2019 (r505863) @@ -1,7 +1,7 @@ # $FreeBSD$ PORTNAME= cego -PORTVERSION= 2.44.14 +PORTVERSION= 2.45.0 CATEGORIES= databases MASTER_SITES= http://www.lemke-it.com/ Modified: head/databases/cego/distinfo ============================================================================== --- head/databases/cego/distinfo Thu Jul 4 18:48:15 2019 (r505862) +++ head/databases/cego/distinfo Thu Jul 4 19:13:00 2019 (r505863) @@ -1,3 +1,3 @@ -TIMESTAMP = 1560945238 -SHA256 (cego-2.44.14.tar.gz) = 778f6094e4f72f4afca7d44e7bb6b4360a3e1b60ef1cfd23d6eca8eca61c925e -SIZE (cego-2.44.14.tar.gz) = 3140497 +TIMESTAMP = 1562162318 +SHA256 (cego-2.45.0.tar.gz) = 7b8dad4815d621a0daec9b811d61a7be50aabf7998c1088620283d8c27244550 +SIZE (cego-2.45.0.tar.gz) = 3148710 Modified: head/databases/cego/pkg-plist ============================================================================== --- head/databases/cego/pkg-plist Thu Jul 4 18:48:15 2019 (r505862) +++ head/databases/cego/pkg-plist Thu Jul 4 19:13:00 2019 (r505863) @@ -24,7 +24,9 @@ include/cego/CegoAdminHandler.h include/cego/CegoAdminThread.h include/cego/CegoAdminThreadPool.h include/cego/CegoAggregation.h +include/cego/CegoAliasObject.h include/cego/CegoAlterDesc.h +include/cego/CegoAttrAlias.h include/cego/CegoAttrComp.h include/cego/CegoAttrCond.h include/cego/CegoAttrDesc.h