[sr-dev] git:pd/crocodile: core, srdb1, modules/db_*, modules_k/db_*: Added support for configuring SQL buffer size and mediumblob/ mediumtext in MySQL

[Peter Dunkley]

Module: sip-router
Branch: pd/crocodile
Commit: 5cd87175faa97161023c37e2cc0f0c064e08d571
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=5cd87175faa97161023c37e2cc0f0c064e08d571

Author: pd <peter.dunkley at crocodile-rcs.com>
Committer: pd <peter.dunkley at crocodile-rcs.com>
Date:   Wed Jul 27 11:50:20 2011 +0100

core, srdb1, modules/db_*, modules_k/db_*: Added support for configuring SQL buffer size and mediumblob/mediumtext in MySQL

- Currently the SQL buffer size is hard-coded to 64k.  This isn't
  enough in some cases.  For example, it is easily possible for
  resource lists (which can be Network Address Books) to be larger
  than 64k.
- The default buffer size is still 64k, but this can be overriden
  with the new "sql_buffer_size" configuration option.
- Support added for mediumblob/mediumtext in MySQL as the blob/text
  types that are currently supported are limited to 64k.
- Feature added by Andrew Miller at Crocodile RCS

---

 cfg.lex                                        |    2 +
 cfg.y                                          |    3 +
 doc/cfg_list/docbook/cfg_core.xml              |   12 +++
 doc/stylesheets/dbschema_k/xsl/db_berkeley.xsl |    4 +-
 doc/stylesheets/dbschema_k/xsl/db_sqlite.xsl   |    6 +-
 doc/stylesheets/dbschema_k/xsl/dbtext.xsl      |    4 +-
 doc/stylesheets/dbschema_k/xsl/mysql.xsl       |   12 +++
 doc/stylesheets/dbschema_k/xsl/oracle.xsl      |    6 +-
 doc/stylesheets/dbschema_k/xsl/postgres.xsl    |    6 +-
 globals.h                                      |    1 +
 lib/srdb1/db_query.c                           |  102 ++++++++++++++----------
 lib/srdb1/db_query.h                           |    9 ++
 lib/srdb1/db_ut.h                              |    5 -
 main.c                                         |    2 +
 modules/db_berkeley/km_db_berkeley.c           |    3 +-
 modules/db_mysql/km_db_mysql.c                 |    2 +-
 modules/db_mysql/km_dbase.c                    |   42 ++++++++---
 modules/db_postgres/km_db_postgres.c           |    3 +-
 modules_k/db_oracle/db_oracle.c                |    3 +-
 modules_k/db_sqlite/db_sqlite.c                |    2 +-
 modules_k/db_unixodbc/db_unixodbc.c            |   25 ++++--
 21 files changed, 175 insertions(+), 79 deletions(-)

Diff:   http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commitdiff;h=5cd87175faa97161023c37e2cc0f0c064e08d571