U ±[Öe ã@stdZddlmZddlmZmZmZddlmZGdd„de ƒZ Gdd„deƒZ Gd d „d e ƒZ Gd d „d e ƒZ d S)zÝ pyexcel.plugins.sources.pydata ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Representation of array, dict, records and book dict sources :copyright: (c) 2015-2022 by Onni Software Ltd. :license: New BSD License é)Ú constants)ÚPY2Ú OrderedDictÚ zip_longest)Ú SheetReaderc@s(eZdZdZdd„Zdd„Zdd„ZdS) Ú_FakeIOzemulates a stream objectcCs d|_dS©N©Z_FakeIO__value©Úself©r úg/var/www/html/services/stratfitenv/lib/python3.8/site-packages/pyexcel/plugins/sources/pydata/common.pyÚ__init__sz_FakeIO.__init__cCs ||_dS)zduck method setvalueNr )r Úvaluer r r Úsetvaluesz_FakeIO.setvaluecCs|jS)zduck method getvaluer r r r r Úgetvaluesz_FakeIO.getvalueN)Ú__name__Ú __module__Ú __qualname__Ú__doc__rrrr r r r rsrc@s eZdZdZdd„Zdd„ZdS)Ú ArrayReaderz0read data from an array via pyexcel-io interfaceccs|jD] }|VqdSr©Ú _native_sheet)r Úrowr r r Ú row_iterator#s zArrayReader.row_iteratorccs|D] }|VqdSrr )r rÚcellr r r Úcolumn_iterator'szArrayReader.column_iteratorN)rrrrrrr r r r r src@seZdZdZdd„ZdS)Ú RecordsReaderaÊread data from a records via pyexcel-io interface By default, all records are assumed to have the keys and the keys of the first dictionary of the records will be taken as a reference. When the keys of the first dictionary is the full list, The records reader will fill-in the missing key with default n/a, which is ''. Otherwise, please supply a complete list of keys as a parameter to get_records method, or save_as ccs†|j d¡}t|jƒD]j\}}|dkrX|dkrRt|tƒrFt| ¡ƒ}n t| ¡ƒ}|Vg}|D]}|  | |t j ¡¡q`|VqdS)NZcustom_headersr) Ú _keywordsÚgetÚ enumeraterÚ isinstancerÚlistÚkeysÚsortedÚappendrÚ DEFAULT_NA)r ÚheadersÚindexrÚvaluesÚkr r r r=s   zRecordsReader.row_iteratorN©rrrrrr r r r r-src@seZdZdZdd„ZdS)Ú DictReaderz4read data from a dictionary via pyexcel-io interfacec#sžˆj ¡}tst|ƒ}tˆjtƒs*t|ƒ}ˆj dd¡r>|Vtˆj|dtƒr‚‡fdd„|Dƒ}t |dt j iŽD] }|Vqtn‡fdd„|Dƒ}|VdS) NZ with_keysTrc3s|]}ˆj|VqdSrr©Ú.0Úkeyr r r Ú \sz*DictReader.row_iterator..Ú fillvaluecsg|]}ˆj|‘qSr rr-r r r Ú bsz+DictReader.row_iterator..) rr#rr"r!rr$rrrrr&)r r#Z sorted_valuesrr r r rRs"  ÿÿ  zDictReader.row_iteratorNr+r r r r r,Osr,N)rZpyexcelrZpyexcel._compactrrrZpyexcel_io.sheetrÚobjectrrrr,r r r r Ús   "