o sY2$@sdZ dddZdddZdZdgZdd lmZdd lmZdd lm Z Gd dde Z d dZ ddZ edkrVddlZeejdkrJejdpKdZe ee edSdS)aDBF accessing helpers. FIXME: more documentation needed Examples: Create new table, setup structure, add records: dbf = Dbf(filename, new=True) dbf.addField( ("NAME", "C", 15), ("SURNAME", "C", 25), ("INITIALS", "C", 10), ("BIRTHDATE", "D"), ) for (n, s, i, b) in ( ("John", "Miller", "YC", (1980, 10, 11)), ("Andy", "Larkin", "", (1980, 4, 11)), ): rec = dbf.newRecord() rec["NAME"] = n rec["SURNAME"] = s rec["INITIALS"] = i rec["BIRTHDATE"] = b rec.store() dbf.close() Open existed dbf, read some data: dbf = Dbf(filename, True) for rec in dbf: for fldName in dbf.fieldNames: print '%s: %s (%s)' % (fldName, rec[fldName], type(rec[fldName])) print dbf.close() z$Revision: 1.7 $ z$Date: 2007/02/11 09:23:13 $z1Jeff Kunce Dbf)header)record) INVALID_VALUEc@seZdZdZdZejZej Z e Z d(ddZ e ddZe ddZe d dZe d dZe d dZd d Ze ddeddZddZddZddZddZddZddZddZdd Zd!d"Zd#d$Zd%d&Zd'S))raDBF accessor. FIXME: docs and examples needed (dont' forget to tell about problems adding new fields on the fly) Implementation notes: ``_new`` field is used to indicate whether this is a new data table. `addField` could be used only for the new tables! If at least one record was appended to the table it's structure couldn't be changed. )namerstream_changed_new_ignore_errorsFcCst|tr||_|rt|d|_nt|dt||_n t|dd|_||_|r.||_n|j |j|_||_ t||_ d|_ dS)afInitialize instance. Arguments: f: Filename or file-like object. new: True if new data table must be created. Assume data table exists if this argument is False. readOnly: if ``f`` argument is a string file will be opend in read-only mode; in other cases this argument is ignored. This argument is ignored even if ``new`` argument is True. headerObj: `header.DbfHeader` instance or None. If this argument is None, new empty header will be used with the all fields set by default. ignoreErrors: if set, failing field value conversion will return ``INVALID_VALUE`` instead of raising conversion error. zw+b)zr+brbr FN) isinstancestrr openr boolgetattr HeaderClassr fromStream ignoreErrorsr r )selffreadOnlynewrrL/var/www/html/env/lib/python3.10/site-packages/tablib/packages/dbfpy3/dbf.py__init__^s    z Dbf.__init__cC|jjSN)r closedrrrrz Dbf.cCrr )r recordCountr"rrrr#r$cCsdd|jjDS)NcSg|]}|jqSrr ).0_fldrrr z Dbf...rfieldsr"rrrr#r+cCrr r,r"rrrr#r$cCs|jp|jjSr )r rchangedr"rrrr#scCst||j_|_dS)z8Update `ignoreErrors` flag on the header object and selfN)rrrr )rvaluerrrrszDbf.ignoreErrorscC|jSr )r r"rrrr#szError processing mode for DBF field value conversion if set, failing field value conversion will return ``INVALID_VALUE`` instead of raising conversion error. )doccCsBt|ts td|dkr|t|d7}|t|krtd|S)aReturn fixed index. This method fails if index isn't a numeric object (long or int). Or index isn't in a valid range (less or equal to the number of records in the db). If ``index`` is a negative number, it will be treated as a negative indexes for list objects. Return: Return value is numeric object maning valid index. zIndex must be a numeric objectrzRecord index out of range)rint TypeErrorlen IndexErrorrindexrrr _fixIndexs  z Dbf._fixIndexcCs||jdSr )flushr closer"rrrr;sz Dbf.closecCs6|jr|j|j|j|jd|_dSdS)z$Flush data to the associated stream.FN)r.rsetCurrentDatewriter r:r r"rrrr:s    z Dbf.flushcCs dd|jjD}||S)zIndex of field named ``name``.cSr&rr')r(rrrrr*r+z(Dbf.indexOfFieldName..)rr-r8upper)rr namesrrrindexOfFieldNameszDbf.indexOfFieldNamecCs ||S)z.Return new record, which belong to this table.) RecordClassr"rrr newRecords z Dbf.newRecordcCs2|jj|_||jjd7_d|_d|_dS)z"Append ``record`` to the database.rTFN)rr%r8_writer r )rrrrrappends  z Dbf.appendcGs|jr |jj|dStd)z_Add field definitions. For more information see `header.DbfHeader.addField`. z9At least one record was added, structure can't be changedN)r raddFieldr4)rdefsrrrrEsz Dbf.addFieldcCsd|jt|jS)NzDbf stream '%s' )r reprrr"rrr__repr__sz Dbf.__repr__cCr0)zReturn number of records.)r%r"rrr__len__sz Dbf.__len__cCs|j|||S)zReturn `DbfRecord` instance.)rArr9r7rrr __getitem__szDbf.__getitem__cCs$|||_|d|_d|_dS)z)Write `DbfRecord` instance to the stream.TFN)r9r8rCr r )rr8rrrr __setitem__s  zDbf.__setitem__N)FFF)__name__ __module__ __qualname____doc__ __slots__r DbfHeaderrr DbfRecordrArrpropertyr!r% fieldNames fieldDefsr.rr9r;r:r@rBrDrErHrIrJrKrrrrrFs>  1     cCs2t|d}|D] }ttt|q|dS)NT)rprintrGr;)filename_dbf_recrrr demo_reads  rZcCsvt|dd}|dddddD]\}}}}|}||d<||d <||d <||d <|qtt||dS) NT)r)NAMEC)SURNAMEr\)INITIALSr\ ) BIRTHDATED))JohnMillerYC)ir)AndyLarkinAL)i)BillClinthr)i)BobbMcNailr)irr[r^r`rb)rrErBstorerVrGr;)rWrX_n_s_i_brYrrr demo_create s    ry__main__r2Nz county.dbf)rO __version____date__ __author____all__rrrutilsrobjectrrZryrLsysr5argv_namerrrrs&&     >