hi.
r3506 is still ok, while r3507 gives this:
result: [] expected: [35]
SAMPLE: 2006-09-11 00:00:00 2006-09-12 00:00:00 2006-09-14 00:00:00
[35]
'trans exact, valids between _2' FROM test_range TimedRangeTestCase
----------------------------------------------------------------------
Traceback (most recent call last):
...
File "test_timed_dbcook.py", line 142, in _get_range_val
q = me.val.get_obj_history_in_range( me.val.OBJ_ID, timeFrom,
timeTo).all()
File "/home/az/src/hor-trunk/sqlalchemy/orm/query.py", line 571, in
all
return list(self)
File "/home/az/src/hor-trunk/sqlalchemy/orm/query.py", line 619, in
__iter__
return self._execute_and_instances(statement)
File "/home/az/src/hor-trunk/sqlalchemy/orm/query.py", line 624, in
_execute_and_instances
return iter(self.instances(result))
File "/home/az/src/hor-trunk/sqlalchemy/orm/query.py", line 680, in
instances
self.select_mapper._instance(context, row, result)
File "/home/az/src/dbcook/sqlalchemy/orm/mapper.py", line 1436, in
_instance
self.populate_instance(context, instance, row, **flags)
File "/home/az/src/dbcook/sqlalchemy/orm/mapper.py", line 1496, in
populate_instance
(newpop, existingpop, post_proc) =
prop.create_row_processor(selectcontext, self, row)
ValueError: need more than 2 values to unpack
the result query is somewhat awwful, but it works before that:
---------- TEST trans exact, valids between _2* SA: INFO
SELECT "PolymBase".disabled AS "PolymBase_disabled", "PolymBase".val
AS "PolymBase_val", "PolymBase".time_valid
AS "PolymBase_time_valid", "PolymBase".time_trans
AS "PolymBase_time_trans", "PolymBase".obj_id
AS "PolymBase_obj_id", "PolymBase".atype
AS "PolymBase_atype", "PolymBase".db_id
AS "PolymBase_db_id", "PolymLeaf".db_id AS "PolymLeaf_db_id"
FROM (
SELECT max("PolymBase".db_id) AS db_id, "PolymBase".time_trans AS
time_trans, "PolymBase".time_valid AS time_valid
FROM "PolymBase" JOIN (
SELECT max("PolymBase".time_trans) AS
time_trans, "PolymBase".time_valid AS time_valid
FROM "PolymBase"
WHERE "PolymBase".time_trans <= ? AND "PolymBase".time_valid
>= ? AND "PolymBase".time_valid <= ? AND "PolymBase".obj_id = ?
AND "PolymBase".atype = ?
GROUP BY "PolymBase".time_valid
) AS t1 ON "PolymBase".time_valid = t1.time_valid
AND "PolymBase".time_trans = t1.time_trans
WHERE "PolymBase".obj_id = ? AND "PolymBase".atype = ?
GROUP BY "PolymBase".time_valid, "PolymBase".time_trans
) AS timedr, "PolymBase" JOIN "PolymLeaf" ON "PolymLeaf".db_id
= "PolymBase".db_id
WHERE "PolymBase".db_id = timedr.db_id AND NOT "PolymBase".disabled
ORDER BY "PolymBase".time_valid
* SA: INFO [11, 12, 14, 1, 'PolymLeaf', 1, 'PolymLeaf']
any idea? i mau try prepare some stripped testcase but it'll take
time...
if u wanna try, svn co then run make in
https://dbcook.svn.sourceforge.net/svnroot/dbcook/trunk/dbcook/misc/timed2/test/
or do
PYTHONPATH=..:../../../..:../../..:$(PYTHONPATH) python
test_timed_dbcook.py
svil
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
