svn commit: r505863 - head/databases/cego
Kurt Jaeger
pi at FreeBSD.org
Thu Jul 4 19:13:02 UTC 2019
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 <lemke at lemke-it.com>
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
More information about the svn-ports-head
mailing list