Draft: provide sqlite for catalog

Context

jp ask to provide sqlite support for catalog

Idea

It’s not possible to make SQLite support all BT5s in one fell swoop. It need to support them one by one in an easy way.

Since ERP5 already supports multiple catalogs, I modify BusinessTemplate.py to support multiple catalogs as well.

When installing a BT5, if the SQL methods in the BT5 are not related to the current catalog, we can still install the BT5 but without effect.

To support it, we would need to create the corresponding catalog SQL methods.

Steps to provide minimal support of erp5 core functionnality

• move sql method from erp5_core to erp5_mysql_innodb_catalog
• Complete support for installing different catalog storage when creating ERP5
• add product/ZMySQLiteDA, load related DA according to storage choose
• add CMFActivity/Activity/MySQLite, load related activity according to storage choose
• add erp5_sqlite_catalog to hold sql sqlite version
• make BusinessTemplate support multi catalog
• add sqlite version in erp5_base
• make ZSQLCatalog support sqlite
• add sqlite full text version
• make ERP5Catalog support sqlite
• generalise sqlquote in product/ZSQLCatalog/Utils

test result:

ERP5 with SQLite

ERP5 with MySQL