lp://staging/~jkakar/storm/any-strips-order-by

Branch merges

Propose for merging

No branches dependent on this one.

Merged into lp://staging/storm at revision 365

Muharem Hrnjadovic (community): Approve on 2010-08-03

Thomas Herve (community): Approve on 2010-07-23

Diff: 319 lines (+107/-61)

4 files modified

storm/sqlobject.py (+3/-3)
storm/store.py (+39/-14)
tests/store/base.py (+64/-43)
tests/tutorial.txt (+1/-1)

api

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Bug #608825: Check usage of ORDER BY in ResultSet methods

Low

Fix Released

Link a bug report

Related blueprints

365. By Jamu Kakar on 2010-08-02

- Fix the implementation of ResultSet.first to not use
  ResultSet.any, which doesn't work as a standin anymore because it
  strips ORDER BY clauses.
- Fixed the behaviour of ResultSet.__getitem__ to use a new custom
  version of any() that doesn't alter the ORDER BY clause. This is
  needed to maintain compatibility with prejoin-related logic.
- Improved docstrings.

364. By Jamu Kakar on 2010-07-22

- Refactored tests to use a tracer.

363. By Jamu Kakar on 2010-07-22

- ResultSet.any strips the ORDER BY clause when its present.

362. By Jamu Kakar on 2010-07-22

Merged is-empty-strips-order-by [r=bigkevmcd,lifeless] [f=246200]

ResultSet.is_empty strips the ORDER BY clause, if one is present,
before issuing a query. The result is the same but will perform
better in cases where the query would match a large number of rows.

361. By Thomas Herve on 2010-07-22

Merge mutable-alive-check-553334 [r=jkakar,salgado] [f=553334]

Add a checkpoint call when an object is updated from the cache with values from
a recent query, to detect changes from mutables correctly, and not issue useless
(or even harmful) updates from other objects.

360. By Marien Zwart on 2010-07-01

Add SQLite specific reserved words.
[f=593633] [r=jkakar,jamesh]

359. By James Henstridge on 2010-07-01

Detect when per-thread stores are used in the wrong thread

ZStorm manages per-thread stores that get joined to the current thread's
transaction when used. If those stores get passed between threads, they
can be joined to the wrong transaction. This can lead to bugs that are
difficult to reproduce and debug. With this change, such use results in
an error.
[f=348815] [r=therve,jkakar]

358. By Jamu Kakar on 2010-06-04

Merged reference-set-order-by [r=niemeyer,sidnei] [f=580037]

The order_by property defined for a ReferenceSet can now be
specified as string, in order to avoid circular dependency issues.
The property column is resolved after import time.

357. By James Henstridge on 2010-04-16

Add a NEWS item for the last commit.

356. By James Henstridge on 2010-04-16

Add an API for blocking access to connections and stores.

This is intended to let applications detect and handle unexpected
database access.
[r=therve,jkakar]