[Erp5-report] r44421 ivan - in /erp5/trunk/bt5/erp5_km_sphinxse_full_text_search: SkinTempl...
nobody at svn.erp5.org
nobody at svn.erp5.org
Fri Mar 18 12:57:35 CET 2011
Author: ivan
Date: Fri Mar 18 12:57:35 2011
New Revision: 44421
URL: http://svn.erp5.org?rev=44421&view=rev
Log:
With sphinx based "full text" search full text table change its type from "MyISAM" to "InnoDB" (i.e. not possible use MySQL's built in full text search).
Adjust respective ZSQL Methods to use sphinx instead.
Added:
erp5/trunk/bt5/erp5_km_sphinxse_full_text_search/SkinTemplateItem/portal_skins/erp5_km_sphinxse_full_text_search/Base_zGetImplicitPredecessorValueList.xml
Modified:
erp5/trunk/bt5/erp5_km_sphinxse_full_text_search/bt/revision
Added: erp5/trunk/bt5/erp5_km_sphinxse_full_text_search/SkinTemplateItem/portal_skins/erp5_km_sphinxse_full_text_search/Base_zGetImplicitPredecessorValueList.xml
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_km_sphinxse_full_text_search/SkinTemplateItem/portal_skins/erp5_km_sphinxse_full_text_search/Base_zGetImplicitPredecessorValueList.xml?rev=44421&view=auto
==============================================================================
--- erp5/trunk/bt5/erp5_km_sphinxse_full_text_search/SkinTemplateItem/portal_skins/erp5_km_sphinxse_full_text_search/Base_zGetImplicitPredecessorValueList.xml (added)
+++ erp5/trunk/bt5/erp5_km_sphinxse_full_text_search/SkinTemplateItem/portal_skins/erp5_km_sphinxse_full_text_search/Base_zGetImplicitPredecessorValueList.xml [utf8] Fri Mar 18 12:57:35 2011
@@ -0,0 +1,116 @@
+<?xml version="1.0"?>
+<ZopeData>
+ <record id="1" aka="AAAAAAAAAAE=">
+ <pickle>
+ <global name="SQL" module="Products.ZSQLMethods.SQL"/>
+ </pickle>
+ <pickle>
+ <dictionary>
+ <item>
+ <key> <string>allow_simple_one_argument_traversal</string> </key>
+ <value>
+ <none/>
+ </value>
+ </item>
+ <item>
+ <key> <string>arguments_src</string> </key>
+ <value> <string>reference\n
+</string> </value>
+ </item>
+ <item>
+ <key> <string>cache_time_</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>class_file_</string> </key>
+ <value> <string>ZSQLCatalog.zsqlbrain</string> </value>
+ </item>
+ <item>
+ <key> <string>class_name_</string> </key>
+ <value> <string>ZSQLBrain</string> </value>
+ </item>
+ <item>
+ <key> <string>connection_hook</string> </key>
+ <value>
+ <none/>
+ </value>
+ </item>
+ <item>
+ <key> <string>connection_id</string> </key>
+ <value> <string>erp5_sql_connection</string> </value>
+ </item>
+ <item>
+ <key> <string>id</string> </key>
+ <value> <string>Base_zGetImplicitPredecessorValueList</string> </value>
+ </item>
+ <item>
+ <key> <string>max_cache_</string> </key>
+ <value> <int>100</int> </value>
+ </item>
+ <item>
+ <key> <string>max_rows_</string> </key>
+ <value> <int>0</int> </value>
+ </item>
+ <item>
+ <key> <string>src</string> </key>
+ <value> <string encoding="cdata"><![CDATA[
+
+SET @current_path = NULL; <dtml-var sql_delimiter>\n
+SET @current_reference = NULL; <dtml-var sql_delimiter>\n
+\n
+<dtml-let query="portal_catalog.buildSQLQuery(query=portal_catalog.getSecurityQuery(), portal_type=getPortalDocumentTypeList())">\n
+<dtml-let user_language="Localizer.get_selected_language()">\n
+\n
+SELECT path, uid\n
+FROM\n
+(\n
+SELECT DISTINCT\n
+path,\n
+(select uid from catalog where catalog.path=sub.path) as uid\n
+FROM\n
+( SELECT\n
+ @current_path:=IF(@current_reference = reference, @current_path, path) AS path,\n
+ @current_reference:=reference AS reference\n
+ FROM (\n
+ SELECT\n
+ reference,\n
+ path,\n
+ catalog.uid,\n
+ CASE language WHEN <dtml-sqlvar user_language type=string> THEN 1 WHEN \'en\' THEN 0 ELSE -1 END as language_order\n
+ FROM\n
+ catalog, versioning, sphinxse_index\n
+ WHERE\n
+ catalog.uid = versioning.uid\n
+ AND\n
+ catalog.uid = sphinxse_index.uid\n
+ <dtml-if "query[\'where_expression\']">\n
+ AND <dtml-var "query[\'where_expression\']">\n
+ </dtml-if>\n
+ AND\n
+ sphinxse_index.sphinxse_query="<dtml-sqlvar reference type=string>;mode=ext2"\n
+ AND\n
+ <dtml-sqltest reference op=ne type=string>\n
+ ORDER BY reference, language_order DESC, version DESC, revision DESC\n
+ ) AS innersub\n
+)\n
+AS sub\n
+)\n
+AS main\n
+WHERE\n
+<dtml-sqltest "getUid()" column=uid op=ne type=int>\n
+LIMIT 1000\n
+\n
+</dtml-let>\n
+</dtml-let>\n
+
+
+]]></string> </value>
+ </item>
+ <item>
+ <key> <string>title</string> </key>
+ <value> <string></string> </value>
+ </item>
+ </dictionary>
+ </pickle>
+ </record>
+</ZopeData>
Modified: erp5/trunk/bt5/erp5_km_sphinxse_full_text_search/bt/revision
URL: http://svn.erp5.org/erp5/trunk/bt5/erp5_km_sphinxse_full_text_search/bt/revision?rev=44421&r1=44420&r2=44421&view=diff
==============================================================================
--- erp5/trunk/bt5/erp5_km_sphinxse_full_text_search/bt/revision [utf8] (original)
+++ erp5/trunk/bt5/erp5_km_sphinxse_full_text_search/bt/revision [utf8] Fri Mar 18 12:57:35 2011
@@ -1 +1 @@
-14
\ No newline at end of file
+15
\ No newline at end of file
More information about the Erp5-report
mailing list