python - 在Python中从元组格式化为 float ？

Question

def tong_thoigian (self,kr,uid,ids,context={}):
    obj=self.browse(kr,uid,ids,context=context)[0]
    kr.execute('''select name,giolam from x_giolam where name=%s'''%(obj.ma_luong))
    kq=kr.fetchall()
    tong=0.00000
    for i in kq:
          tong+=kq[1]                      
    self.write(kr,uid,ids,{'tonggiolam':tong},context=context)

错误是:

TypeError: unsupported operand type(s) for +=: 'float' and 'tuple'

我认为你不关心表和数据库......因为意味着在表x_giolam中获取可能行的函数具有属性giolam和sum它......然后我们就有了员工的工资。

Answer 1

由于查询是“select name,giolam ...”，kq 可能类似于:

[ ('Thong', 324.34), ('Tran', 543.34), ('Thang', 765.52) ... ]

所以我认为你想要:

for record in kq:
    tong+=record[1]

而不是tong+=kq[1]。