Roundup Tracker - Issues

Issue 802405

classification
sqlite backend does not resolve links to other classes
Type: Severity: normal
Components: Database Versions:
process
Status: closed fixed
:
: richard : richard, schlatterbeck
Priority: normal :

Created on 2003-09-08 11:34 by schlatterbeck, last changed 2003-11-11 00:26 by richard.

Messages
msg957 Author: [hidden] (schlatterbeck) Date: 2003-09-08 11:34
following example using roundup-admin modifies the
"category" field in the issues specified to contain the
literal string "container" instead of the number of the
actual item of the "category" roundup class. The
problem does not occur with the *dbm backends.
roundup-admin -u schlatterbeck -i
/tttech/org/software/roundup/tttech set
issue5544,issue5543,issue5546,issue5538,issue5537,issue5536,issue4203
category=container

If specifying the number of the "container" item in the
roundup class category (56 in our db) the roundup-admin
command works as expected.

Maybe the same cause:
in the programming interface using a query 
status = ['open','feedback','analyzed','testing']
filterspec = {'status' : status}
for issue_id in db.issue.filter (None, filterspec,
sort=('-','priority')) :
[...]
will not yield any results (nothing is matched by the
filter).
If I use 
status = \
    [db.status.lookup (i) for i in
['open','feedback','analyzed','testing']]
the expected issues are returned by the query. Again
this works ok with the *dbm backends but does not with
the sqlite backend.
msg958 Author: [hidden] (richard) Date: 2003-11-11 00:26
Logged In: YES 
user_id=6405

This is a generic problem with the roundup-admin interface and has been 
addressed in CVS. It's not likely to be back-ported though, as it's a 
major code change. 
 
History
Date User Action Args
2003-09-08 11:34:57schlatterbeckcreate