lR\2$@sdZdddZdddZdZdgZdd lmZdd lmZdd lm Z Gd dde Z d dZ ddZ edkrddlZeejdkrejdpdZe ee endS)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@sNeZdZdZd-ZejZej Z e Z dddd d Z e d d Ze d d Ze dd Ze dd Ze dd ZddZe dd eddZddZddZddZddZddZd d!Zd"d#Zd$d%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|trR||_|r3t|d|_qpt|dt||_nt|dd|_||_|r|j|_n|jj |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+br+brbr FN)rzrb) isinstancestrr openr boolgetattr HeaderClassr fromStream ignoreErrorsr r )selffZreadOnlynewrrO/var/www/dbchiro/venv/lib/python3.4/site-packages/tablib/packages/dbfpy3/dbf.py__init__^s   z Dbf.__init__cCs |jjS)N)r closed)rrrrsz Dbf.cCs |jjS)N)r recordCount)rrrrr scCsdd|jjDS)NcSsg|]}|jqSr)r ).0Z_fldrrr s z Dbf...)rfields)rrrrr scCs |jjS)N)rr$)rrrrr scCs|jp|jjS)N)r rchanged)rrrrr scCst||j_|_dS)z8Update `ignoreErrors` flag on the header object and selfN)rrrr )rvaluerrrrszDbf.ignoreErrorscCs|jS)N)r )rrrrr sdoczError processing mode for DBF field value conversion if set, failing field value conversion will return ``INVALID_VALUE`` instead of raising conversion error. cCsft|tstdn|dkrA|t|d7}n|t|krbtdn|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 IndexError)rindexrrr _fixIndexs z Dbf._fixIndexcCs|j|jjdS)N)flushr close)rrrrr0s z Dbf.closecCsF|jrB|jj|jj|j|jjd|_ndS)z$Flush data to the associated stream.FN)r%rZsetCurrentDatewriter r/r )rrrrr/s    z Dbf.flushcCs,dd|jjD}|j|jS)zIndex of field named ``name``.cSsg|]}|jqSr)r )r"rrrrr#s z(Dbf.indexOfFieldName..)rr$r-upper)rr namesrrrindexOfFieldNameszDbf.indexOfFieldNamecCs |j|S)z.Return new record, which belong to this table.) RecordClass)rrrr newRecordsz Dbf.newRecordcCsA|jj|_|j|jjd7_d|_d|_dS)z"Append ``record`` to the database.rTFN)rr!r-_writer r )rrrrrappends   z Dbf.appendcGs,|jr|jj|n tddS)z_Add field definitions. For more information see `header.DbfHeader.addField`. z9At least one record was added, structure can't be changedN)r raddFieldr*)rZdefsrrrr9s z Dbf.addFieldcCsd|jt|jS)NzDbf stream '%s' )r reprr)rrrr__repr__sz Dbf.__repr__cCs|jS)zReturn number of records.)r!)rrrr__len__sz Dbf.__len__cCs|jj||j|S)zReturn `DbfRecord` instance.)r5rr.)rr-rrr __getitem__szDbf.__getitem__cCs2|j||_|jd|_d|_dS)z)Write `DbfRecord` instance to the stream.TFN)r.r-r7r r )rr-rrrr __setitem__s  zDbf.__setitem__N)znamezheaderzstreamz_changedz_newz_ignore_errors)__name__ __module__ __qualname____doc__ __slots__rZ DbfHeaderrrZ DbfRecordr5rrpropertyrr!Z fieldNamesZ fieldDefsr%rr.r0r/r4r6r8r9r;r<r=r>rrrrrFs:   1             cCsEt|d}x%|D]}ttt|qW|jdS)NT)rprintr:r0)filename_dbf_recrrr demo_reads  rIc Cst|dd}|jd#d$d%d&xXd/D]P\}}}}|j}||d<||d<||d<||d <|jq/Wtt||jdS)0NrTNAMECSURNAMEINITIALS BIRTHDATEDJohnMillerYCrrAndyLarkinALBillClinthrBobbMcNailr)zNAMErKrL)rMrKrN)rOrKrP)rQrRrVrrrSrTrUrfrZr[r\rWrXrYrhr_r`rar]r^rrjrdrrerbrcrrl)rgrirkrm)rr9r6storerEr:r0)rFrGZ_nZ_sZ_iZ_brHrrr demo_create s&     ro__main__r(Nz county.dbfrq)rB __version____date__ __author____all__rrrutilsrobjectrrIror?sysr+argv_namerrrr's     (