我使用的是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上开源,这样社区就可以更好地解决这样的问题。