U yag$@sddlmZmZddlmZdddZdddZdZd gZGd d d Z d d Z d dZ e dkrddl Z ee jdkre jdpdZe ee edS))headerrecord) INVALID_VALUEz$Revision: 1.7 $ z$Date: 2007/02/11 09:23:13 $z1Jeff Kunce Dbfc@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|tr8||_|r"t|d|_qLt|dt||_nt|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 )selffZreadOnlynewrrM/var/www/html/myvenv/lib/python3.8/site-packages/tablib/packages/dbfpy/dbf.py__init__]s   z Dbf.__init__cCs|jjSN)r closedrrrrz Dbf.cCs|jjSr)r recordCountr rrrr!r"cCsdd|jjDS)NcSsg|] }|jqSrr ).0Z_fldrrr sz Dbf...rfieldsr rrrr!r"cCs|jjSrr'r rrrr!r"cCs|jp |jjSr)r rchangedr rrrr!r"cCst||j_|_dS)z8Update `ignoreErrors` flag on the header object and selfN)rrrr )rvaluerrrrszDbf.ignoreErrorscCs|jSr)r r rrrr!r"zError processing mode for DBF field value conversion if set, failing field value conversion will return ``INVALID_VALUE`` instead of raising conversion error. )doccCsBt|tstd|dkr*|t|d7}|t|kr>td|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 rrrr5sz Dbf.closecCs2|jr.|j|j|j|jd|_dS)z$Flush data to the associated stream.FN)r)rZsetCurrentDatewriter r4r r rrrr4s   z Dbf.flushcCs dd|jjD}||S)zIndex of field named ``name``.cSsg|] }|jqSrr$)r%rrrrr&sz(Dbf.indexOfFieldName..)rr(r2upper)rr namesrrrindexOfFieldNameszDbf.indexOfFieldNamecCs ||S)z.Return new record, which belong to this table.) RecordClassr rrr newRecordsz Dbf.newRecordcCs2|jj|_||jjd7_d|_d|_dS)z"Append ``record`` to the database.rTFN)rr#r2_writer r )rrrrrappends  z Dbf.appendcGs |jr|jj|ntddS)z_Add field definitions. For more information see `header.DbfHeader.addField`. z9At least one record was added, structure can't be changedN)r raddFieldr.)rZdefsrrrr>sz Dbf.addFieldcCsd|jt|jS)NzDbf stream '%s' )r reprrr rrr__repr__sz Dbf.__repr__cCs|jS)zReturn number of records.)r#r rrr__len__sz Dbf.__len__cCs|j|||S)zReturn `DbfRecord` instance.)r:rr3r1rrr __getitem__szDbf.__getitem__cCs$|||_|d|_d|_dS)z)Write `DbfRecord` instance to the stream.TFN)r3r2r<r r )rr2rrrr __setitem__s zDbf.__setitem__N)FFF)__name__ __module__ __qualname____doc__ __slots__rZ DbfHeaderrrZ DbfRecordr:rrpropertyrr#Z fieldNamesZ fieldDefsr)rr3r5r4r9r;r=r>r@rArBrCrrrrrEs< 1     cCs2t|d}|D]}ttt|q|dS)NT)rprintr?r5)filename_dbf_recrrr demo_reads  rNcCsvt|dd}|dddddD]<\}}}}|}||d<||d <||d <||d <|q tt||dS) NT)r)NAMEC)SURNAMErP)INITIALSrP ) BIRTHDATED))ZJohnZMillerZYC)ir)ZAndyZLarkinAL)i)ZBillZClinthr)i)ZBobbZMcNailr)irrOrRrTrV)rr>r;storerJr?r5)rKrLZ_nZ_sZ_i_brMrrr demo_create s    ra__main__r,Nz county.dbf)rrrutilsr __version____date__ __author____all__rrNrarDsysr/argv_namerrrrs   <>