[Erp5-dev] New catalog storage seleciton

[Pelletier Vincent]

Hi.

I just commited the new catalog storage selection system.

This system will ultimately allow to choose how to store the ERP5 SQL catalog.
For now, only MySQL InnoDB was supported, but this will allow to develop
specific SQL queries for other kinds of storages, fitting specific needs.

For example, there is one new (beta version) SQLCatalog using MySQL NDB as a
main storage.

It is for now disabled by default : even if you install a storage-specific
catalog business template (such as erp5_mysql_innodb_catalog) it will *not*
be used, since the default one is still present in erp5_core. The old
behaviour is kept for the moment because potential incompatibilities in
current code have not been investigated yet.

To enable the use of the new catalog storage systems, you must change the
default_sql_catalog_id property on portal_catalog, clear the catalog and
reindex your site.

Please make sure that when accessing ZSQL methods directly you honor this
property, otherwise an error will appear when the classic "erp5_mysql"
SQLCatalog will disapear. This does not apply to the valid
portal_catalog(...) syntax, because it internaly checks which SQLCatalog to
use.

[Pelletier Vincent]

Post by Pelletier Vincent
Please make sure that when accessing ZSQL methods directly you honor this
property, otherwise an error will appear when the classic "erp5_mysql"
SQLCatalog will disapear. This does not apply to the valid
portal_catalog(...) syntax, because it internaly checks which SQLCatalog to
use.

portal_catalog.getSQLCatalog() returns the default catalog object.