These are the easy uses, there are more to come.

* to quickly setup catalog_full_text table, you can use the following SQL.

  REPLACE INTO catalog_full_text SELECT uid, title, description FROM catalog;

* non fulltext queries like '=abc', '>abc', '%abc%' are supported.

* now erp5_full_text_mroonga_catalog is used for unit tests thus I recommend using it instead of erp5_full_text_myisam_catalog.

* to migrate existing MyISAM full_text table into Mroonga, you can use the following SQL.

  ALTER TABLE full_text DROP KEY SearchableText,
    ENGINE = mroonga,
    ADD FULLTEXT KEY SearchableText (`SearchableText`) COMMENT 'parser "TokenBigramSplitSymbolAlpha"';

* fulltext search score is no longer provided as (column_name) but now provided as (column_name)__score__.

* (category)_title, like source_title, related keys are automatically generated. (category)_description keys as well.

see http://docs.python.org/2/library/unittest.html#deprecated-aliases

This approach consists in treating each keys from the default group (the
one for sort on and select dict) as a left join if the key supports it, at
column mapping level.

Also update testERP5Catalog, the specification changed a bit.
Before, using a related key in select_dict had the side effect of not selecting
documents without related documents unless the key is explicitly passed in
select_dict. Now all documents are always returned.

Create a sql cache for getInventory call
Remove full-inventory optimisation as it now useless
Implement full-inventory feature directly into stock
Make erp5_pdm depends on this optimisation
Install optimisation for all unit tests

fixup: ERP5Site_reindexAll now reindexes everything all tools in portal and all ERP5 Python Scripts under portal_skins.

check only if the new catalog does not miss anything, because the original catalog before reindexAll can be imperfect by other tests, that are bad though...

fix ERP5Site_reindexAll so that it reindexes everything having getUid and also ERP5 Python Scripts under portal_skins.

and improve test_13_ERP5Site_reindexAll to check if list of paths is exactly same.

a new bt5 (erp5_security_uid_innodb_catalog) upon installation.
Add all generic ZSQL methods to this new bt5
so projects can adjust only the minimum required.

- PEP 308: Conditional Expressions
- PEP 341: Unified try/except/finally
- PEP 343: The ‘with’ statement

Checked following occurrences in comments:
- "Python 2.[456]"
- "Zope 2.[891]"
- "BBB"
- "BACK"

Checked uses of:
- email, hashlib, numpy & tarfile (modules)
- ImportError
- string.Template
- suppress_events (parameter of _setObject)

Excluded:
- some forked modules (MailTemplates, PortalTransforms...)
- some i18n compatibility code

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@45537 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@42961 20353a03-c40f-0410-a6d1-a30d3c3de9de

With MyISAM full text catalog bt5 we need to use deferred connection only for catalog / uncatalog methods.

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@42886 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@42818 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/sandbox/catalog_join@42348 20353a03-c40f-0410-a6d1-a30d3c3de9de

fix test_BackwardCompatibilityWithOldMethods failure that happened only when running multiple tests at the same time

git-svn-id: https://svn.erp5.org/repos/public/erp5/sandbox/catalog_join@42344 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/sandbox/catalog_join@42311 20353a03-c40f-0410-a6d1-a30d3c3de9de

git-svn-id: https://svn.erp5.org/repos/public/erp5/sandbox/catalog_join@42276 20353a03-c40f-0410-a6d1-a30d3c3de9de