vfp python_Visual Fox Pro和Python

如果你以前听过这个，请停止我：“我有一个DBF阅读模块（pydbfrw），我一直想发布“有一天”

添加您想要的功能比破解dbf模块的源代码要容易得多：>>> import pydbfrw

>>> d = pydbfrw.DBFreader('/devel/dbf/all_files/del.dbf')

>>> list(d)

[['fred', 1], ['harriet', 4]]

>>> d.get_field_names()

['NAME', 'AMT']

>>> d = pydbfrw.DBFreader('/devel/dbf/all_files/del.dbf', include_deleted=True)

>>> list(d)

[[False, 'fred', 1], [True, 'tom', 2], [True, 'dick', 3], [False, 'harriet', 4]]

>>> d.get_field_names()

['deleted__', 'NAME', 'AMT']

>>> for rowdict in d.get_dicts():

... print rowdict

...

{'deleted__': False, 'name': 'fred', 'amt': 1}

{'deleted__': True, 'name': 'tom', 'amt': 2}

{'deleted__': True, 'name': 'dick', 'amt': 3}

{'deleted__': False, 'name': 'harriet', 'amt': 4}

>>> for rowtup in d.get_namedtuples():

... print rowtup

...

Row(deleted__=False, name='fred', amt=1)

Row(deleted__=True, name='tom', amt=2)

Row(deleted__=True, name='dick', amt=3)

Row(deleted__=False, name='harriet', amt=4)

>>>