Commits · 344f929a1dc222f8ef23f702cc8fb226a21886b9 · Noah Brackenbury / erp5

An error occurred fetching the project authors.

27 Feb, 2009 3 commits

Woops, unbalanced parentheses. · 344f929a

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

344f929a

Distinguish the case where a related key has the same name as a column from... · d99e867c

Vincent Pelletier authored 16 years ago

Distinguish the case where a related key has the same name as a column from the case where a related key is declared more than once.


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

d99e867c

It is not obvious that there is the same name column is in table somewhere. · 877ef41f

Yusei Tahara authored 16 years ago

because column_set is extended.


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

877ef41f

25 Feb, 2009 4 commits

Restore support for scriptable keys. · ee908835

Vincent Pelletier authored 16 years ago

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

ee908835

Be more robust against malformed related key definitions. · 02198cc9
Vincent Pelletier authored 16 years ago
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@25714 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
02198cc9

ExactMatch was renamed into RawKey in the commit. ExactMatch is still... · 583e1f40

Vincent Pelletier authored 16 years ago

ExactMatch was renamed into RawKey in the commit. ExactMatch is still explicitely asked for in existing code, so add a compatibility alias.


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

583e1f40

Major SQLCatalog rework on query-generation (not on indexation): · 51cad3f4

Vincent Pelletier authored 16 years ago

- further extend SearchKey concept
- define, implement and validate Interfaces
- add a column mapper (mapping is decided on a completely-formed query tree instead of being done individualy on each used column)
- state what is present for backward compatibility, warn about deprecated/dangerous uses


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

51cad3f4

18 Feb, 2009 1 commit

Remove catalog method custom wrapping, as it prevents indexation method from... · c0b016a7

Vincent Pelletier authored 16 years ago

Remove catalog method custom wrapping, as it prevents indexation method from accessing each other (useful when one is a python script wishing to access ZSQLMethods to do actual indexation).


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

c0b016a7

05 Feb, 2009 1 commit

Do not systematicaly copy cached values. It's not good in all cases (mutable... · 1c956639

Vincent Pelletier authored 16 years ago

Do not systematicaly copy cached values. It's not good in all cases (mutable subtypes, ...) so it's not a good idea and would set a bad precedent.


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

1c956639

08 Jan, 2009 1 commit

When query_table is given a false value, do not expand related keys. · 2786c72b

Vincent Pelletier authored 16 years ago

  Also, since columns are not mapped to any table when query_table is set to a false value, this means that catalog passes column names through. The purppose of using catalog over rendering "by hand" the where-expression is that it will use search keys (keyword key, fulltext key, ...) to guess desired operator.


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

2786c72b

19 Dec, 2008 1 commit

When query_table was explicitely given a None value, prevent joins from happening. · 7c0aee92

Vincent Pelletier authored 16 years ago

  Other uses in that function are None-safe:
   - first use checks that query_table exavuates to True before using
   - (this fix applied to the second use)
   - third use is to provide related keys with a query_tabe parameter. So when using a related key it is either meaningless (if related key ignores that parameter, it means that it hadcodes its "source" table) or fixable (by making related key handle a None query_table nicely, if not already the case).


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

7c0aee92

18 Dec, 2008 1 commit
- Another type mistake: this returns a dict, so use .copy(). · 59a07ca1
  Vincent Pelletier authored 16 years ago
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24936 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
  59a07ca1
17 Dec, 2008 2 commits

Woops, this method returns a list, not a dict. · ceab69ca
Vincent Pelletier authored 16 years ago
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@24920 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
ceab69ca

As we return cached version of those values, copy them upon return. This... · 6d8deafd

Vincent Pelletier authored 16 years ago

As we return cached version of those values, copy them upon return. This prevents third-party code from "poisoning" the cache.


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

6d8deafd

30 Oct, 2008 1 commit

Add a getter for security uid cache. · 3887bb9b

Vincent Pelletier authored 16 years ago

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

3887bb9b

14 Oct, 2008 1 commit

Minor coding style cleanup. · c5f6355f

Vincent Pelletier authored 16 years ago

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

c5f6355f

03 Oct, 2008 1 commit

support query passed as dict in the REQUEST, in this case it is not a dict, but · d6b9f70d

Jérome Perrin authored 16 years ago

a ZPublisher.HTTPRequest.record instance (which behaves like a dict)


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

d6b9f70d

24 Sep, 2008 1 commit
- use sort(key=) instead of sort(cmp=) for better performance. · 0ad0819d
  Kazuhiko Shiozaki authored 16 years ago
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@23781 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
  0ad0819d
13 Aug, 2008 2 commits

Comment was not quite right: actualy, giving a kw simply means we are passing... · 6f30ef42

Vincent Pelletier authored 16 years ago

Comment was not quite right: actualy, giving a kw simply means we are passing Query contructor parameters directly, wich not only involves column names.
Simplify code to make this obvious.

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

6f30ef42

Add a warning about ambiguous code (loop must only be executed once for code to work). · 1ecfc061
Vincent Pelletier authored 16 years ago
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@22984 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
1ecfc061

17 Jul, 2008 2 commits

Always allow MySQL to use primary key. · a96416a5

Vincent Pelletier authored 16 years ago

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

a96416a5

Do not reinvent string.join . Use it. · b4d8826f

Vincent Pelletier authored 16 years ago

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

b4d8826f

01 Jul, 2008 3 commits

Commit again r22153 with fixes: · 3bf252f4

Vincent Pelletier authored 16 years ago

Do not generate a from_expression if no from_expression was passed by parameter.
Fix a swap between table and alias in new code.

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

3bf252f4

Revert commit 22153: it broke SQLCatalog. · fa981d8b

Vincent Pelletier authored 16 years ago

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

fa981d8b

Provide a way to replace table alias ("AS" inclued) by an arbitrary string.... · d966bf52

Vincent Pelletier authored 16 years ago

Provide a way to replace table alias ("AS" inclued) by an arbitrary string. Given value must be a dictionary, with impacted table as a key and the arbitrary string as a value.
This allows, for example, to generate queries with LEFT JOINs.

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

d966bf52

03 Jun, 2008 1 commit
- add logs when buildSQLQuery is not working as expected · af363af5
  Sebastien Robin authored 16 years ago
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@21285 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
  af363af5
14 May, 2008 1 commit

this variable is no longer used · f37cf98c

Jérome Perrin authored 16 years ago

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

f37cf98c

18 Apr, 2008 1 commit

use a threading.local for SEARCH_KEY_INSTANCE_POOL · c46302e0

Jérome Perrin authored 16 years ago


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

c46302e0

08 Apr, 2008 2 commits

As discussed with seb, it should not be required to add portal_type here,... · d6d7433e

Yoshinori Okuji authored 16 years ago

As discussed with seb, it should not be required to add portal_type here, because here.getPortalType() must work. Add some comment on the purpose of having some hardcoded items. 

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

d6d7433e

allow to do filter expression on portal type · 0de325f9

Sebastien Robin authored 16 years ago

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

0de325f9

19 Feb, 2008 1 commit

Add sql_catalog_role_keys and sql_catalog_local_role_keys to catalog, in order · 49df4003

Romain Courteaud authored 17 years ago

to configure explicitely which column should be mapped when generation security
query.

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

49df4003

08 Feb, 2008 1 commit

Refactoring of ZSQLCatalog. · 3aeb0ab9

Ivan Tyagov authored 17 years ago

Introduce search key which now are reposnsible for Query generation.
Improve parsing of search strings (you must install "ply":http://www.dabeaz.com/ply/).

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

3aeb0ab9

03 Feb, 2008 3 commits
- No return value is expected from this method. Avoid confusing reader. · f921c8d4
  Vincent Pelletier authored 17 years ago
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19011 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
  f921c8d4
- Factorize self.filter_dict[method_name] lookups. · 863e9811
  Vincent Pelletier authored 17 years ago
```
Use an ImmutableSet instead of a dict where value = key.


git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19010 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
  863e9811
- Iterate just once in method_id_list. This limits the number of values to keep in memory. · 094862d8
  Vincent Pelletier authored 17 years ago
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@19009 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
  094862d8
09 Jan, 2008 1 commit

initialize variable · d7efb54e

Aurel authored 17 years ago

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

d7efb54e

07 Jan, 2008 1 commit
- Modified so that names in the fast input are displayed according to the result order · 9df321a0
  Mame Coumba Sall authored 17 years ago
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18608 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
  9df321a0
24 Dec, 2007 1 commit
- Do not use integers as dictionary value placeholder as python instanciates as many objects. · 8c012345
  Vincent Pelletier authored 17 years ago
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18510 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
  8c012345
07 Dec, 2007 1 commit

Do not explicitly convert to ISO. It's too early. · 30efe2ed

Ivan Tyagov authored 17 years ago

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

30efe2ed

06 Dec, 2007 1 commit
- Add rendering of DateTime keys in SQL generation code for queries. · ff0e0bb7
  Ivan Tyagov authored 17 years ago
```
git-svn-id: https://svn.erp5.org/repos/public/erp5/trunk@18058 20353a03-c40f-0410-a6d1-a30d3c3de9de
```
  ff0e0bb7