[SQL-CVS] [ sqlobject-Bugs-3111474 ] _defaultOrder Documentation outdated

[SourceForge.net <no...@so...>]

Bugs item #3111474, was opened at 2010-11-18 12:14
Message generated for change (Tracker Item Submitted) made by nobody
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=3111474&group_id=74338

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: SQLObject release (specify)
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: _defaultOrder Documentation outdated

Initial Comment:
Documentation autodated, _defaultOrder does not work like described in:
http://sqlobject.org/SQLObject.html#exported-symbols


from sqlobject import SQLObject, UnicodeCol, connectionForURI, sqlhub

connection = connectionForURI('sqlite:/:memory:?debug=1')
sqlhub.processConnection = connection

class DefOrder(SQLObject):
    _defaultOrder = "name"
    name = UnicodeCol(default="")

DefOrder.createTable()
def test_defaultorder():
    b = DefOrder(name="b")
    a = DefOrder(name="a")
    s = DefOrder.select()
    assert s[0] == a

def test_defaultorder_sqlmeta():
    for d in DefOrder.select():
        d.destroySelf()
    DefOrder.sqlmeta.defaultOrder = DefOrder.q.name
    b = DefOrder(name="b")
    a = DefOrder(name="a")
    s = DefOrder.select()
    assert s[0] == a

gregor@valun:/tmp$ nosetests --pdb defaultorder.py 
/usr/lib/pymodules/python2.6/tw/core/view.py:223: DeprecationWarning: object.__new__() takes no parameters
  obj = object.__new__(cls, *args, **kw)
F.
======================================================================
FAIL: defaultorder.test_defaultorder
----------------------------------------------------------------------
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.6/nose/case.py", line 183, in runTest
    self.test(*self.arg)
  File "/tmp/defaultorder.py", line 15, in test_defaultorder
    assert s[0] == a
AssertionError: 
-------------------- >> begin captured stdout << ---------------------
 2/QueryIns:  INSERT INTO def_order (name) VALUES ('b')
 2/QueryR  :  INSERT INTO def_order (name) VALUES ('b')
 3/QueryOne:  SELECT name FROM def_order WHERE ((def_order.id) = (1))
 3/QueryR  :  SELECT name FROM def_order WHERE ((def_order.id) = (1))
 4/QueryIns:  INSERT INTO def_order (name) VALUES ('a')
 4/QueryR  :  INSERT INTO def_order (name) VALUES ('a')
 5/QueryOne:  SELECT name FROM def_order WHERE ((def_order.id) = (2))
 5/QueryR  :  SELECT name FROM def_order WHERE ((def_order.id) = (2))
 6/Select  :  SELECT def_order.id, def_order.name FROM def_order WHERE 1 = 1 LIMIT 1
 6/QueryR  :  SELECT def_order.id, def_order.name FROM def_order WHERE 1 = 1 LIMIT 1

--------------------- >> end captured stdout << ----------------------

----------------------------------------------------------------------
Ran 2 tests in 0.003s

FAILED (failures=1)

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=3111474&group_id=74338