ive grepped all the code and cannot find a create_row_processor
method that is returning a 2-tuple (which is what it used to be);
theyre all returning 3-tuples..and of course all those methods have
test coverage too. have you tried deleting all the .pyc files to
ensure all python modules have recompiled ?
On Sep 24, 2007, at 1:39 AM, [EMAIL PROTECTED] wrote:
>
> 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 sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
