An error occurred fetching the project authors.
- 07 Oct, 2015 4 commits
-
-
Kazuhiko Shiozaki authored
-
Kazuhiko Shiozaki authored
-
Kazuhiko Shiozaki authored
It is useful when use select_expression in inner query and use group_by_expression or order_by_expression in outer query.
-
Kazuhiko Shiozaki authored
Revert "Add auto_extend_select_list argument in buildSQLQuery() and use alias in group_by_expression and order_by_expression." Revert "Support group_by_list and order_by_list in WebSection_getDocumentValueList." Revert "Support order_by_list in Resource_zGetMovementHistoryList." No need to extend SQLCatalog parameter to support group_by_list and order_by_list in sub-queries.
-
- 04 Oct, 2015 1 commit
-
-
Kazuhiko Shiozaki authored
Add auto_extend_select_list argument in buildSQLQuery() and use alias in group_by_expression and order_by_expression. If True, select_list is automatically extended to have columns used in group_by_list and order_by_list. It is useful when use select_expression in inner query and use group_by_expression or order_by_expression in outer query.
-
- 24 Sep, 2015 1 commit
-
-
Vincent Pelletier authored
Also, extract unwanted kw entries by just declaring them as separate parameters.
-
- 22 Sep, 2015 1 commit
-
-
Vincent Pelletier authored
-
- 18 Nov, 2014 1 commit
-
-
Kazuhiko Shiozaki authored
sort_on=(('title',),) => sort by title sort_on=(('title__score__',),) => sort by full text search score for title
-
- 08 Nov, 2014 1 commit
-
-
Kazuhiko Shiozaki authored
* 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.
-
- 16 Oct, 2014 1 commit
-
-
Julien Muchembled authored
-
- 04 Sep, 2014 1 commit
-
-
Gabriel Monnerat authored
-
- 08 Nov, 2012 1 commit
-
-
Vincent Pelletier authored
-
- 23 Jul, 2012 1 commit
-
-
Yusei Tahara authored
-
- 15 Jun, 2012 1 commit
-
-
Vincent Pelletier authored
-
- 07 Jun, 2012 1 commit
-
-
Vincent Pelletier authored
-
- 19 May, 2012 1 commit
-
-
Arnaud Fontaine authored
This fixes 43c8d0b5.
-
- 18 May, 2012 1 commit
-
-
Yusei Tahara authored
-
- 08 Nov, 2011 1 commit
-
-
Leonardo Rochael Almeida authored
-
- 15 Apr, 2011 1 commit
-
-
Romain Courteaud authored
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@45521 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 08 Mar, 2011 1 commit
-
-
Vincent Pelletier authored
DateTimeKey is capable of completing dates given with less than 3 parts (year, month and day). This means less than 2 separators, not 3. Also, be resilient to string which, when split by separators, generate an empty list. Add test cases. git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@44048 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 03 Jan, 2011 1 commit
-
-
Leonardo Rochael Almeida authored
git-svn-id: https://svn.erp5.org/repos/public/erp5/sandbox/catalog_join@41964 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 18 Nov, 2010 3 commits
-
-
Vincent Pelletier authored
Word prefix used to be detected as an actual operator. Add a test. git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@40393 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
Vincent Pelletier authored
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@40391 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
Vincent Pelletier authored
It is not practical, as it is not easily possible to nest parsers. This fix stops unquoting strings in lexer, and postpone it to syntax tree walking code. Add tests showing search key nesting works with different unquoting rules. git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@40389 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 14 Sep, 2010 2 commits
-
-
Vincent Pelletier authored
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@38362 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
Vincent Pelletier authored
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@38360 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 24 Aug, 2010 1 commit
-
-
Kazuhiko Shiozaki authored
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@37964 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 28 Jul, 2010 1 commit
-
-
Vincent Pelletier authored
This changes SQLExpression API, but this should not be a problem, since this API is internal to ZSQLCatalog. git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@37338 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 15 Jul, 2010 1 commit
-
-
Sebastien Robin authored
Conflicts: bt5/erp5_base/bt/revision bt5/erp5_simulation/DocumentTemplateItem/InvoiceSimulationRule.py bt5/erp5_simulation/bt/revision bt5/erp5_trade/SkinTemplateItem/portal_skins/erp5_trade/Base_viewTradeFieldLibrary.xml bt5/erp5_trade/bt/change_log bt5/erp5_trade/bt/revision products/ERP5/Document/BusinessPath.py products/ERP5/Document/SimulationMovement.py products/ERP5/Document/TradeCondition.py products/ERP5/Document/TradeModelLine.py products/ERP5/bootstrap/erp5_mysql_innodb_catalog/bt/revision products/ERP5Type/ERP5Type.py git-svn-id: https://svn.erp5.org/repos/public/erp5/sandbox/amount_generator@37129 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 08 Jul, 2010 1 commit
-
-
Vincent Pelletier authored
This requires them to be both accepted as columns (see change in isValidColumn) and usable in an abstract syntax tree (see changes in buildQueryFromAbstractSyntaxTreeNode), requiring a ScriptableKey-to- SearchKey wrapper (see SearchKeyWrapperForScriptableKey). Add a test. git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@36990 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 22 Apr, 2010 1 commit
-
-
Leonardo Rochael Almeida authored
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@34727 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 20 Apr, 2010 1 commit
-
-
Vincent Pelletier authored
In older ZSQLCatalog versions (pre-r25706), values fetched via select_expression='catalog.simulation_state' were accessible on brain as "brain.simulation_state". In current catalog, this became "getattr(brain, 'catalog.simulation_state')" and hence broke compatibility somewhat. This patch fixes this problem by stripping table name from the generated alias. Note: the table name is only stripped from implicit aliases, never from explicit ones. git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@34685 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 16 Apr, 2010 1 commit
-
-
Leonardo Rochael Almeida authored
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@34629 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 11 Mar, 2010 3 commits
-
-
Grégory Wisniewski authored
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@33669 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
Vincent Pelletier authored
Fulltext operator (MatchComparisonOperator) is special because it generates ORDER BY expression, which is to be used only if caller tells catalog to sort on the fulltext column. This code tests just that. git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@33661 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
Vincent Pelletier authored
As the generated order-by expressions now (rightly) differ based on data, the exception generated when detecting the difference must be postponed to when expression is actualy used, as it might not be used. Also, test that postponing effectively works, and demonstrate another way to express the same condition, but which allows sorting. git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@33660 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 21 Jan, 2010 1 commit
-
-
Sebastien Robin authored
either on the brain or on the real object * update unit test for getProperty * add new method hasColumn in catalog API * add test for hasColumn git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@31884 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 23 Nov, 2009 1 commit
-
-
Yoshinori Okuji authored
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@30830 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 20 Nov, 2009 1 commit
-
-
Yusuke Muraoka authored
That was category relation related. Lazy generation of category relation is replaced by using IN with sub query. git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@30783 20353a03-c40f-0410-a6d1-a30d3c3de9de
-
- 27 Oct, 2009 1 commit
-
-
Vincent Pelletier authored
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@30043 20353a03-c40f-0410-a6d1-a30d3c3de9de
-