Code:
#!/usr/bin/python
db = dbf.Dbf("MEST2.DBF")
#LINE TO UPDATE:
rec = db[0]
#PROEST IS A field of my dbf. I'm assigning 1 to this field line 0
rec["PROEST"] = 1
rec.store()
del rec
db.close()
DBF 表的图像:https://i.stack.imgur.com/1UHE1.jpg
我的问题是我无法按行更改记录,导致产品(PROCOD)的位置可能会有所不同。
对于获取 PROCOD 并更改 PROEST 的值有什么建议吗?
UPDATED:
#!/usr/bin/python
import dbf
db = dbf.Table('MEST2.DBF')
with db:
procod_idx = db.create_index(lambda rec: (rec.codigo, rec.procod))
match = procod_idx.search(match='000001')
# should only be one product with that code
record = match[0]
with record:
record.proest = 23
但现在的问题是,我如何根据 CODIGO 字段(股票代码)编辑值。我有多个股票 ID:(1,2,5,11)。代码仅更新第一个结果,我需要更新基于 CODIGO 字段的特定记录。
在 SQL 中将是:“UPDATE PROEST SET 32 where CODIGO=11”...或 CODIGO=2
SOLVED通过伊森·弗曼
#!/usr/bin/python
import dbf
db = dbf.Table('MEST2.DBF')
with db:
procod_idx = db.create_index(lambda rec: (rec.codigo, rec.procod))
match = procod_idx.search(match=(11, '000001'))
record = match[0]
with record:
record.proest = 25
record.dt_atualiz = '14/07/15 16:52'