使用包含两个以上术语的查询拉力 pyral sdk 错误。(解析表达式时出错 - 预期")",但看到的是"AND"。



我使用的是Rally python SDK pyral,我用元组格式化查询字符串,但似乎任何时候我有两个以上的项都会失败。这是我的测试代码:

import pyral
rally = pyral.Rally('rally1.rallydev.com', 'user@example.com', 'password')
user = rally.getUserInfo(name='User Name').pop(0)
wksp = rally.getWorkspace()
proj = rally.getProject()
print user.FirstName, user.LastName
print wksp.Name
print proj.Name
queryStrings = (
('State != "Closed"', 'Owner = ' + user.ref),
('State != "Fixed"', 'Owner = ' + user.ref),
('State != "Closed"', 'State != "Fixed"'),
('State != "Closed"', 'State != "Fixed"', 'Owner = ' + user.ref),
('State != Closed', 'State != Fixed', 'State != Submitted'),
('State != Fixed', 'ScheduleState != Tested'),
('State != Fixed', 'Owner = ' + user.ref, 'ScheduleState != Tested'),
)
for query in queryStrings:
    print "++++++++++++++++++++++++++++++++++++++++++"
    print "Query:",query
    defects = rally.get("Defect", True, query=query)
    print "Number of results:",defects.resultCount
    print "Errors:", defects.errors
    print

这是最终的输出

User Name
A Workspace
Web Project
++++++++++++++++++++++++++++++++++++++++++
Query: ('State != "Closed"', u'Owner = user/1234567890')
QUERYJUNK: ((State != "Closed") AND (Owner = user/1234567890))
Number of results: 25
Errors: []
++++++++++++++++++++++++++++++++++++++++++
Query: ('State != "Fixed"', u'Owner = user/1234567890')
QUERYJUNK: ((State != "Fixed") AND (Owner = user/1234567890))
Number of results: 89
Errors: []
++++++++++++++++++++++++++++++++++++++++++
Query: ('State != "Closed"', 'State != "Fixed"')
QUERYJUNK: ((State != "Closed") AND (State != "Fixed"))
Number of results: 149
Errors: []
++++++++++++++++++++++++++++++++++++++++++
Query: ('State != "Closed"', 'State != "Fixed"', u'Owner = user/1234567890')
QUERYJUNK: ((State != "Closed") AND (State != "Fixed") AND (Owner = user/1234567890))
Number of results: 0
Errors: [u'Could not parse: Error parsing expression -- expected ")" but saw "AND"       instead.']
++++++++++++++++++++++++++++++++++++++++++
Query: ('State != Closed', 'State != Fixed', 'State != Submitted')
QUERYJUNK: ((State != Closed) AND (State != Fixed) AND (State != Submitted))
Number of results: 0
Errors: [u'Could not parse: Error parsing expression -- expected ")" but saw "AND" instead.']
++++++++++++++++++++++++++++++++++++++++++
Query: ('State != Fixed', 'ScheduleState != Tested')
QUERYJUNK: ((State != Fixed) AND (ScheduleState != Tested))
Number of results: 247
Errors: []
++++++++++++++++++++++++++++++++++++++++++
Query: ('State != Fixed', u'Owner = user/1234567890', 'ScheduleState != Tested')
QUERYJUNK: ((State != Fixed) AND (Owner = user/1234567890) AND (ScheduleState !=     Tested))
Number of results: 0
Errors: [u'Could not parse: Error parsing expression -- expected ")" but saw "AND" instead.']

QUERYJUNK是Rally SDK自身构建的查询字符串的输出,然后再将其发送到集会服务。

编辑:

根据Kyle的回答,由于这是SDK本身的一个错误,我在脚本中创建了一个变通方案,直到SDK可以修复为止。

def buildQueryString(querySequence):
if type(query) in [types.ListType, types.TupleType]:
    seq = ["(%s)" % (s,) for s in querySequence]
    qs = "%s" % seq.pop(0)
    for qt in seq:
        qs = "(%s AND %s)" % (qs, qt)
    print "QS:",qs
    return qs
return querySequence

然后,我将生成的这个字符串传递到API中,现在一切似乎都工作了。API似乎也支持查询参数的字典,但由于它没有文档,我不需要它,所以我没有为这种情况创建解决方案。

这似乎是pyral生成包含2个以上子句的查询字符串时的一个错误。

当前为:

((State != Closed) AND (State != Fixed) AND (State != Submitted))

应为:

(((State != Closed) AND (State != Fixed)) AND (State != Submitted))

我们将尽快解决这个问题,并在github上开源,这样社区就可以更好地解决这样的问题。

相关内容

最新更新