1. 05 Apr, 2017 1 commit
  2. 25 Nov, 2015 1 commit
  3. 07 Oct, 2015 4 commits
  4. 04 Oct, 2015 1 commit
    • Kazuhiko Shiozaki's avatar
      Add auto_extend_select_list argument in buildSQLQuery() and use alias in... · bdcdaca8
      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.
      bdcdaca8
  5. 24 Sep, 2015 1 commit
  6. 22 Sep, 2015 1 commit
  7. 18 Nov, 2014 1 commit
  8. 08 Nov, 2014 1 commit
    • Kazuhiko Shiozaki's avatar
      use fulltext search in title and description. · d47df833
      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.
      d47df833
  9. 16 Oct, 2014 1 commit
  10. 04 Sep, 2014 1 commit
  11. 30 Jan, 2014 1 commit
  12. 08 Nov, 2012 1 commit
  13. 23 Jul, 2012 1 commit
  14. 15 Jun, 2012 1 commit
  15. 07 Jun, 2012 1 commit
  16. 19 May, 2012 1 commit
  17. 18 May, 2012 1 commit
  18. 08 Nov, 2011 1 commit
  19. 15 Apr, 2011 1 commit
  20. 08 Mar, 2011 1 commit
  21. 03 Jan, 2011 1 commit
  22. 18 Nov, 2010 3 commits
  23. 14 Sep, 2010 2 commits
  24. 24 Aug, 2010 1 commit
  25. 28 Jul, 2010 1 commit
  26. 15 Jul, 2010 1 commit
    • Sebastien Robin's avatar
      sync with trunk@37114 · c1ae57b0
      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
      c1ae57b0
  27. 08 Jul, 2010 1 commit
  28. 26 May, 2010 1 commit
  29. 22 Apr, 2010 1 commit
  30. 20 Apr, 2010 1 commit
    • Vincent Pelletier's avatar
      Provide backward compatilibity with older ZSQLCatalog. · 6a1899e9
      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
      6a1899e9
  31. 16 Apr, 2010 2 commits
  32. 11 Mar, 2010 2 commits