我已经从数据库中获取了数据并得到了这个元组。我正在使用下面的代码将元组转换为列表。但输出是按索引进行的。喜欢
${Rows} [('3/6/2018', '16', '8', '50.00', '3024', '1349', '44.61'), ('3/5/2018', '16', '9', '56.25', '3024', '2114', '69.91'), ('3/4/2018', '16', '9', '56.25', '3024', '2224', '73.54')]
${RowWise} create list
: FOR ${j} IN RANGE 0 7
\ ${row}= Evaluate [x[${j}] for x in ${Rows}]
\ append To list ${RowWise} ${row}
Log List ${RowWise}
上面的代码返回这个
[('3/6/2018','3/6/2018','3/6/2018','3/6/2018','3/6/2018','3/6/2018'), ('16','16','16','16','16',)....]
我想要这样的东西
[['3/6/2018', '16', '8', '50.00', '3024', '1349', '44.61'], ['3/5/2018', '16', '9', '56.25', '3024', '2114', '69.91'], ['3/4/2018', '16', '9', '56.25', '3024', '2224', '73.54']]
你能帮帮我吗?
注意:使用 python iam 可以获得解决方案。但试图在机器人框架中实现。
请您参考如下方法:
这是一个可以使用列表理解的好例子。
我们可以将元组转换为列表
x = list((1,2))
以你为例
x = [('3/6/2018', '16', '8', '50.00', '3024', '1349', '44.61'), ('3/5/2018', '16', '9', '56.25', '3024', '2114', '69.91'), ('3/4/2018', '16', '9', '56.25', '3024', '2224', '73.54')]
x = [list(i) for i in x]
print(x)
[['3/6/2018', '16', '8', '50.00', '3024', '1349', '44.61'],
['3/5/2018', '16', '9', '56.25', '3024', '2114', '69.91'],
['3/4/2018', '16', '9', '56.25', '3024', '2224', '73.54']]
使用提供的答案 How to convert a tuple in robot framework into list
我们可以把它改成
${Row 1} Evaluate [list(x) for x in $id]
