o sY@s|dZ dddZdddZdgZddlTddlTddlTddlTGd d d eZ Gd ddeZ e d kre Z e d dde dddde ddde dededddZeeeeeZded <ded<ded<eeeZded <ded<d ed<eed!eeeeeeD]ZeeZejD] Zed"eeefqeqed#Sd#S)$a!.DBF creation helpers. Note: this is a legacy interface. New code should use Dbf class for table creation (see examples in dbf.py) TODO: - handle Memo fields. - check length of the fields accoring to the `http://www.clicketyclick.dk/databases/xbase/format/data_types.html` z$Revision: 1.4 $ z$Date: 2006/07/04 08:18:18 $dbf_new)*c@sReZdZdZdZedfedfedfedfe dfdZ dd d Z d d Z d dZ dS)_FieldDefinitionajField definition. This is a simple structure, which contains ``name``, ``type``, ``len``, ``dec`` and ``cls`` fields. Objects also implement get/setitem magic functions, so fields could be accessed via sequence iterface, where 'name' has index 0, 'type' index 1, 'len' index 2, 'dec' index 3 and 'cls' could be located at index 4. )nametypelendecclsNr)CNLDTcCsL|j|\}}|dur|durtd|}||_||_||_||_||_dS)NzField length must be defined) FLD_TYPES ValueErrorrr r r r )selfrr r r _cls_lenrO/var/www/html/env/lib/python3.10/site-packages/tablib/packages/dbfpy3/dbfnew.py__init__?s z_FieldDefinition.__init__cCs||j|j|jS)z:Return `DbfFieldDef` instance from the current definition.)r rr r rrrr getDbfFieldKsz_FieldDefinition.getDbfFieldcCs|}||dS)zCreate a `DbfFieldDef` instance and append it to the dbf header. Arguments: dbfh: `DbfHeader` instance. N)raddField)rdbfh_dbffrrrappendToHeaderOsz_FieldDefinition.appendToHeader)Nr)__name__ __module__ __qualname____doc__ __slots__DbfCharacterFieldDefDbfNumericFieldDefDbfLogicalFieldDefDbfDateFieldDefDbfDateTimeFieldDefrrrr"rrrrr!s   rc@s2eZdZdZdZeZddZd ddZdd Z d S) ra3New .DBF creation helper. Example Usage: dbfn = dbf_new() dbfn.add_field("name",'C',80) dbfn.add_field("price",'N',10,2) dbfn.add_field("date",'D',8) dbfn.write("tst.dbf") Note: This module cannot handle Memo-fields, they are special. fieldscCs g|_dS)Nr-rrrrros zdbf_new.__init__rcCs|j|||||dS)a Add field definition. Arguments: name: field name (str object). field name must not contain ASCII NULs and it's length shouldn't exceed 10 characters. typ: type of the field. this must be a single character from the "CNLMDT" set meaning character, numeric, logical, memo, date and date/time respectively. len: length of the field. this argument is used only for the character and numeric fields. all other fields have fixed length. FIXME: use None as a default for this argument? dec: decimal precision. used only for the numric fields. N)r.appendFieldDefinitionClass)rrtypr r rrr add_fieldrszdbf_new.add_fieldcCsDt}||jD]}||q t|d}|||dS)z/Create empty .DBF file using current structure.wbN) DbfHeadersetCurrentDater.r"openwriteclose)rfilename_dbfh_fldDef _dbfStreamrrrr7s     z dbf_new.writeN)r) r#r$r%r&r'rr0rr2r7rrrrrZs  __main__rrPpricer daterr ztst.dbfz*** created tst.dbf: ***r)readOnly somethingg%@)ir z foo and bari/)irz(*** inserted 2 records into tst.dbf: ***z%s: %sN)r& __version____date____all__dbfr.headerrecordobjectrrr#dbfnr2r7printDbfdbftrepr DbfRecordrecstoreranger i1 fieldNamesfldNamer8rrrrsN 9;