*/*: update several cego related ports

devel/lfcbase 1.18.11 -> 1.19.0
- Changed Datetime::asLong to return signed long values ( long long ).
  This is needed to support timestamp values before 01.01.1970,
  which are signed negative

databases/cego 2.50.6 -> 2.51.0
- consolidate grammar productions for query conditions and
  procedure conditions
- Since CegoPredicate::CompType has received new type EXPRONLY,
  this requires a tableset export/import for upgrading to this version
  ( for predicate encoding / decoding )
- Several changed in CegoFieldValue to switch from Datetime integer
  type unsigned long long to long long. This is required to support
  datetime comparison for values before 01.01.1970

databases/cegobridge 1.8.1 -> 1.9.0
- adapt to cego 2.51.0

databases/cego{bridge}: 2.49.22 -> 2.50.2, 1.7.0 -> 1.8.1

cego:
- Added syntax expansion for group having clause to support
  advanced having conditions, e.g.
  SELECT a, sum(b), max(c) FROM t1
  GROUP BY a HAVING sum(b) > 10 AND max(c) = 100;
- Patch added for 'view condition evaluation' in
  CegoAttrCond::asConjunctionList, CegoSelect::setViewCond and
  CegoDistCursor::distSetup.
- Additional check added to CegoObjectManager to avoid duplicate
  table objects of different type ( e.g. Table t1 and View t1 ). Table
  objects are either native tables, views or aliases.
- For predicate export structure, changed from XML representation
  to native SQL syntax. This requires a dedicated Parser in CegoXPorter,

databases/cego: update 2.48.48 -> 2.49.0, cegobridge 1.6.5 -> 1.7.0

- In CegoCaseCond, added getPlanList method to retrieve execution plan
  for nested selects. The planlist then is catched in CegoFactor::getPlanList
- Consolidation done for data types decimal and fixed.
  This version just supports the decimal datatype which originally was
  the fixed datatype. The original decimal datatype was useless.
  IMPORTANT: To migrate to version 2.49, you have to xml export
  the databases and rename the datatype strings "fixed" and "FIXED"
  to "decimal" and "DECIMAL"
- cegobridge needs to be rebuild

databases/cegobridge: update 1.6.4 -> 1.6.5

- Fix for renamed scandate function added

Author:    Björn Lemke <lemke@lemke-it.com>

databases/cegobridge: 1.6.3 -> 1.6.4

Fixes for new dateformat function ( cego-2.48.13 and up )
and more sophisticated database procedure use ( select in procedure )

devel/lfcbase: update 1.17.2 -> 1.18.0

- Fix for some geometries in Screen::showFormBox
- Further improvements for Screen::showFormBox and showInfoBox
  ( selected rows and newline treatment )
- integrate Screen2 interface

databases/cego: update 2.48.2 -> 2.48.10

- Introduced Backup branch id for online backup verification. Due
  to datafile page id constraints, just online backups can be recovered
  inside one backup branch. Creation of a tableset and adding a
  datafile to a tableset violates this contraint, so a new backup
  branch is created.
- Added backup branch option for backup manager. So just valid

Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)

Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.

databases/cegobridge: 1.6.1 -> 1.6.2

- better MySQL grammar support, escape character handling for
  several special characters ( \\, \n,\t etc )

databases/cegobridge: update 1.6.0 -> 1.6.1

Also update databases/cego: update 2.47.1 -> 2.47.2

cego:
- Fix in CegoQueryHelper::checkIndexForPredicate, wrong tabSetId
  was used for getObjectListByTable, must be table specific

cegobridge:
- In method void MySQLAction::storeVarcharType, dimension value was
  doubled, since MySQL calculates visible length for varchars and
  cego length in bytes. So for multibyte character encodings, length
  might exceed ...

One more small cleanup, forgotten yesterday.
Reported by:	lwhsu

Remove # $FreeBSD$ from Makefiles.

devel/lfcbase: update 1.14.6 -> 1.15.0
devel/lfcxml: update 1.2.11 -> 1.3.0
databases/cego: update 2.45.35 -> 2.46.0
databases/cegobridge: update 1.5.4 -> 1.6.0

Please note: database updates from 2.45.x to version 2.46.x require
a xml tableset export and import, since table structure information
has been changed!

lfcbase:
- Added template class GraphT for dependency graph implementations
- Fix in BigInteger::mul and BigInteger::div, signing was not treated
  ( e.g. -12 * 12 => -144 ( was 144 ) )

lfcxml: get in sync with lfcbase

databases/cegobridge: upgrade 1.5.3 -> 1.5.4

- Fixes in MySQLFormatter to treat several datatypes and default values

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

databases/cegobridge: upgrade 1.5.2 -> 1.5.3

- MySQL SET lines are no longer parsed, the scanner ignores these lines now

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

databases/cegobridge: upgrade 1.5.1 -> 1.5.2

- Fix in MySQLAction::storeAttrColumn, _defaultOptString.length() and
  _nullOptString.length() must be equal or greater 1 ( not 0 )

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

databases/cegobridge: upgrade 1.5.0 -> 1.5.1

- Added MySQL type support for type date and type bigint
- Activated append mode in CegoBridge::main, which speeds up import
  performance significantly
- In MySQLAction::storeKey, changed btreename to _ since MySQL
  allows non unique key names
- Added stored procedure grammar defintions to MySQLParser.def.
  Semantic actions still not implemented

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

devel/lfcbase: update 1.11.9 -> 1.13.0
devel/lfcxml: update 1.2.6 -> 1.2.10
databases/cego: update 2.39.16 -> 2.44.1
databases/cegobridge: update 1.4.0 -> 1.5.0
databases/p5-DBD-cego: update 14.0 -> 1.5.0

- Warning: storage format has changed
  Export to xml format before upgrade and re-import after the upgrade
  See UPDATING
- recompile all applications linked to libcego
- Lots of changes, among them:
  o improved crash recovery
  o fixes to SQL expected behaviour
  o better CDATA handling
  o fixes primary key handling design issue
  o changes to serialisation for export/import, XML export/import is still
    possible

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>
Changelog:	http://www.lemke-it.com/litexec?request=pubnews&user=&lang=en&numlog=1000

databases/cego: update 2.39.1 -> 2.39.2
databases/cegobridge: update 1.3.0 -> 1.4.0

cego:
- Fix in CegoTableManager::updateTuple, while setting up expression
  list, field list array must be setup BEFORE block ist set, since
  field list is needed by block setup ( in case of subqueries for
  prepare )

cegobridge:
- Adaptions for cego-2.39

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

databases/cego: update 2.37.3 -> 2.38.0
databases/cegobridge: update 1.2.1 -> 1.3.0

cego:
- Fix in CegoSelect::clone, pUnionSelect was not cloned, which might
  lead to seg faults
- Introduced predicate clause for select .. in ( expr, expr, ... ),
  e.g. select * from t1 where a in ( 1, 2, 3 ); This was still not
  implemented but is part of standard SQL.

cegobridge:
- Adaptions made for modified cego-2.38.0 API with extended
  CegoDatabaseFormatter::formatPred method ( exprList was added for
  new introduced select in ( expr list ) predicate )

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

devel/lfcbase: update 1.11.0 -> 1.11.1
devel/lfcxml: update 1.2.5 -> 1.2.6
databases/cego: update 2.37.0 -> 2.37.1
databases/cegobridge: update 1.2.0 -> 1.2.1

- New generated configure script with libtool-2.4.6

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

devel/lfcbase: update 1.10.3 -> 1.11.0
databases/cego: update 2.36.4 -> 2.37.0
databases/p5-DBD-cego: update 1.3.0 -> 1.4.0
databases/cegobridge: update 1.1.6 -> 1.2.0

lfcbase:
- Layout improvements in Pager class
- Changed constructor for Net and NetHandler class to setup maxSendLen.
  Since this changes the API, minor release level has been increased

cego:
- Improvements for cgblow simulation mode added
- Improvements for cgclt, added pipe mode to read input from stdin
  Now comments are allowed also after delimiter token, e.g.
  create table t1(a int); -- a sample table

devel/lfcbase: update 1.10.1 -> 1.10.2
databases/cego: update 2.36.3 -> 2.36.4
databases/cegobridge: update 1.1.5 -> 1.1.6

cego:
- Fix in CegoSelect::nextTuple, before adding an entry to the query
  cache, it has to be checked, if any tables from foreign tableset
  are referenced in the query. If so, no cache entry is made, since
  table changes for foreign tables are not detected.
- Improved error messages for invalid database objects
- Decreased shutdown delay time by reducing net delays for all
  thread pools and optimized mediator thread wait procedure
- Completely removed the nologging option for import actions.
  Logging is disabled in any case now.
- Optimization added for log handling. During ( xml ) import,
  logging is completely deactivated, after import is completed,
  log is started again and a checkpoint is written.
  Since import can be repeated in case of a system during import,
  nothing gets lost. Deactivating logging increases import speed and
  avoids side effects

cegobridge:
- Speed up imports by changing the way the parser reads the input

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

databases/cegobridge: update 1.1.4 -> 1.1.5

- Add some compat hooks to parse mysql 5.0 exports

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

databases/cegobridge: update 1.1.3 -> 1.1.4

- fixes build problem due to invalid pointer arithmetic

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

databases/cegobridge: fix backChar() for Oracle/Postgres, too

devel/lfcbase: update 1.8.12 -> 1.9.0
databases/cego: update 2.32.8 -> 2.32.11
databases/cegobridge: update 1.1.2 -> 1.1.3, fix build with clang 4.0

devel/lfcbase:
- Added Monitor class for ncurses based GUI utility implementation.
  This class provides GUI layout and event handling to simply ncurses
  based GUI tool implementaton.
- Added class Pager for curses based pager implementation

databases/cego:
- Include stdlib.h added in CegoNet ( still missing forLinux compiles )
- Added CegoFieldValue::getDim method required for arithmetic operations
  on fixed values
- Fix in CegoTableManager::getPoolInfo, readdelay and writedelay was

Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight

devel/lfcbase: 1.7.0 -> 1.7.2
databases/cego: 2.28.3 -> 2.29.1
databases/cegobridge: 1.1.1 -> 1.1.2

Please note: Updating cego databases needs an export/import
             cycle for 2.28 -> 2.29

lfcbase:
- Fix in Datetime.cc, added include config.h, otherwiese the local
  implementation of strptime ist used. This should just be done, if
  the system API does not provide this call ( e.g. MINGW ) .
- Memory leak fixed in File::readLine

cego:
- Started with clob datatype implementation

databases/cegobridge: 1.1.0 -> 1.1.1, fixes build

devel/lfcbase: 1.6.7 -> 1.7.0
devel/lfcxml: 1.1.8 -> 1.2.2
databases/cego: 2.27.2 -> 2.28.3
databases/p5-DBD-cego: bump portrevision
databases/cegobridge: bump portrevision

IMPORTANT: Upgrades of cego 2.27.x to 2.28.x databases has to be done by
export and import.

lfcbase:
- Adaptions made for build with msys2 / mingw64. Many windows
  specific stuff could be eliminated, since mingw64 provides better
  POSIX support ( e.g. pthreads, timer functions .. )

lfcxml:

databases/cegobridge: 1.0.1 -> 1.1.0

- adaptions for cego-2.25.0 API change

Submitted by:	Bjoern Lemke <lemke@lemke-it.com>

databases/cegobridge: 1.0.0 -> 1.0.1

- Fixes for MySQL import

Submitted by:	lemke@lemke-it.com

New port: databases/cegobridge (replaces databases/my2cego)

cegobridge is a tool to import/export database dumps into Cego, a
Relational Database Management System (RDBMS). Currently it supports
MySQL, other database systems to import/export can be added.

Many more details are available at:

WWW: http://www.lemke-it.com/

Submitted by:	Bjorn Lemke <lemke@lemke-it.com>