o h}D@s2dZddlZdZidddddd d d d d d ddeddddddddddddddddddddddddd d!ZGd"d#d#eZGd$d%d%eZd=d'd(Zea d>d)d*Z d+d,Z  d?d-d.Z d>d/d0Z d>d1d2Z d>d3d4Z d>d5d6Z d>d7d8Z d>d9d:Z d>d;d<ZdS)@z pyexcel_webio ~~~~~~~~~~~~~~~~~~~ A generic request and response interface for pyexcel web extensions :copyright: (c) 2015-2017 by Onni Software Ltd. :license: New BSD License NzAapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheetcsvztext/csvtsvztext/tab-separated-valuescsvzzapplication/ziptsvzodsz.application/vnd.oasis.opendocument.spreadsheetxlszapplication/vnd.ms-excelxlsxxlsmz.application/vnd.ms-excel.sheet.macroenabled.12jsonzapplication/jsonplainz text/plainsimplegridpipeorgtblrst mediawikilatexzapplication/x-latexzapplication/svg+xmlztext/html; charset=UTF-8z image/png)latex_booktabssvghtmlzhandsontable.htmlpngc@seZdZdZd ddZddZddZd d Zd d Zd dZ ddZ   d!ddZ   d!ddZ ddZ ddZ   d!ddZ   d!ddZddZdS)" ExcelInputznA generic interface for an excel file input The source could be from anywhere, memory or file system NcKtd)a}Abstract method :param sheet_name: For an excel book, there could be multiple sheets. If it is left unspecified, the sheet at index 0 is loaded. For 'csv', 'tsv' file, *sheet_name* should be None anyway. :param keywords: additional key words :returns: A sheet object Please implement this functionNotImplementedError)self sheet_namekeywordsrH/var/www/html/env/lib/python3.10/site-packages/pyexcel_webio/__init__.py get_params/s zExcelInput.get_paramscK |jdi|}tjdi|S)a Get a :class:`Sheet` instance from the file :param sheet_name: For an excel book, there could be multiple sheets. If it is left unspecified, the sheet at index 0 is loaded. For 'csv', 'tsv' file, *sheet_name* should be None anyway. :param keywords: additional key words :returns: A sheet object Nr)r!pe get_sheetrrparamsrrr r$; zExcelInput.get_sheetcKr")a Get a list of lists from the file :param sheet_name: For an excel book, there could be multiple sheets. If it is left unspecified, the sheet at index 0 is loaded. For 'csv', 'tsv' file, *sheet_name* should be None anyway. :param keywords: additional key words :returns: A list of lists Nr)r!r# get_arrayr%rrr r(Ir'zExcelInput.get_arraycKr")a Get a generator for a list of lists from the file :param sheet_name: For an excel book, there could be multiple sheets. If it is left unspecified, the sheet at index 0 is loaded. For 'csv', 'tsv' file, *sheet_name* should be None anyway. :param keywords: additional key words :returns: A generator for a list of lists Nr)r!r# iget_arrayr%rrr r)Wr'zExcelInput.iget_arraycK0|jdi|}d|vrd|d<tjdi|S)aGet a dictionary from the file :param sheet_name: For an excel book, there could be multiple sheets. If it is left unspecified, the sheet at index 0 is loaded. For 'csv', 'tsv' file, *sheet_name* should be None anyway. :param keywords: additional key words :returns: A dictionary name_columns_by_rowrNr)r!r#get_dictr%rrr r,e zExcelInput.get_dictcKr*)aGet a list of records from the file :param sheet_name: For an excel book, there could be multiple sheets. If it is left unspecified, the sheet at index 0 is loaded. For 'csv', 'tsv' file, *sheet_name* should be None anyway. :param keywords: additional key words :returns: A list of records r+rNr)r!r# get_recordsr%rrr r.tr-zExcelInput.get_recordscKr")aGet a generator of a list of records from the file :param sheet_name: For an excel book, there could be multiple sheets. If it is left unspecified, the sheet at index 0 is loaded. For 'csv', 'tsv' file, *sheet_name* should be None anyway. :param keywords: additional key words :returns: A generator of alist of records Nr)r!r# iget_recordsr%rrr r/s zExcelInput.iget_recordsTcKsl|jd i|}d|vrd|d<d|vrd|d<||d<||d<||d<||d<||d <tjd i|d S) a Save data from a sheet to database :param session: a SQLAlchemy session :param table: a database table :param initializer: a custom table initialization function if you have one :param mapdict: the explicit table column names if your excel data do not have the exact column names :param keywords: additional keywords to :meth:`pyexcel.Sheet.save_to_database` r+rname_rows_by_column dest_session dest_tabledest_initializer dest_mapdictdest_auto_commitNr)r!r#save_asrsessiontable initializermapdict auto_commitrr&rrr save_to_databaseszExcelInput.save_to_databasecKL|jdi|}||d<||d<||d<||d<||d<tjdi|dS)a Save large data from a sheet to database :param session: a SQLAlchemy session :param table: a database table :param initializer: a custom table initialization function if you have one :param mapdict: the explicit table column names if your excel data do not have the exact column names :param keywords: additional keywords to :meth:`pyexcel.Sheet.save_to_database` r2r3r4r5r6Nr)r!r#isave_asr8rrr isave_to_databaseszExcelInput.isave_to_databasecKr")zGet a instance of :class:`Book` from the file :param keywords: additional key words :returns: A instance of :class:`Book` Nr)r!r#get_bookr%rrr rBzExcelInput.get_bookcKr")zGet a dictionary of two dimensional array from the file :param keywords: additional key words :returns: A dictionary of two dimensional arrays Nr)r!r# get_book_dictr%rrr rDrCzExcelInput.get_book_dictcKr?)a  Save a book into database :param session: a SQLAlchemy session :param tables: a list of database tables :param initializers: a list of model initialization functions. :param mapdicts: a list of explicit table column names if your excel data sheets do not have the exact column names :param keywords: additional keywords to :meth:`pyexcel.Book.save_to_database` r2 dest_tablesdest_initializers dest_mapdictsr6Nr)r!r# save_book_asrr9tables initializersmapdictsr=rr&rrr save_book_to_databasez ExcelInput.save_book_to_databasecKr?)a Save a large book into database :param session: a SQLAlchemy session :param tables: a list of database tables :param initializers: a list of model initialization functions. :param mapdicts: a list of explicit table column names if your excel data sheets do not have the exact column names :param keywords: additional keywords to :meth:`pyexcel.Book.save_to_database` r2rErFrGr6Nr)r!r# isave_book_asrIrrr isave_book_to_databaserNz!ExcelInput.isave_book_to_databasecCs tdS)zq After you have used iget_array and iget_records, it's recommended to call this function N)r#free_resources)rrrr rQs zExcelInput.free_resourcesN)NNNNT)__name__ __module__ __qualname____doc__r!r$r(r)r,r.r/r>rArBrDrMrPrQrrrr r*s8         rc@s"eZdZdZddZdddZdS)ExcelInputInMultiDictzT A generic interface for an upload excel file appearing in a dictionary cCr)z Abstract method to get the file tuple It is expected to return file type and a file handle to the uploaded file rr)r field_namerrr get_file_tuplesz$ExcelInputInMultiDict.get_file_tupleNcKs\||\}}|dur*|dur*|d|}|r&||d}|||Stdtd)z= Load the single sheet from named form field Nr) file_type file_contentzNo content was uploadedzInvalid parameters)rYseekreadupdateIOError Exception)rrXrrZ file_handlecontentr&rrr r!s  z ExcelInputInMultiDict.get_paramsrR)rSrTrUrVrYr!rrrr rWs rWcCsdSrRr)rb content_typestatus file_namerrr dummy_func3srgcCs@t|dr |}|r||sd||f}t|t|||dS)Nr]z%s.%s)rdrerf)hasattrr]endswith__excel_response_func__FILE_TYPE_MIME_TABLE)rbrZrerfrrr _make_response:s   rlcCs|adSrR)rj)response_functionrrr init_webioGsrncKs:t|dr |dur ||_|j|dfi|}t||||S)a1 Make a http response from a pyexcel instance of :class:`~pyexcel.Sheet` or :class:`~pyexcel.Book` :param pyexcel_instance: pyexcel.Sheet or pyexcel.Book :param file_type: one of the following strings: * 'csv' * 'tsv' * 'csvz' * 'tsvz' * 'xls' * 'xlsx' * 'xlsm' * 'ods' :param status: unless a different status is to be returned. :returns: http response nameN)rhrosave_to_memoryrl)pyexcel_instancerZrerfrrr[rrr make_responseLsrrcK$tjd||d|}t||||S)z Make a http response from an array :param array: a list of lists :param file_type: same as :meth:`~pyexcel_webio.make_response` :param status: same as :meth:`~pyexcel_webio.make_response` :returns: http response )arraydest_file_typeNrr#r7rl)rtrZrerfr file_streamrrr make_response_from_arrayh rxcKrs)z Make a http response from a dictionary of lists :param dict: a dictinary of lists :param file_type: same as :meth:`~pyexcel_webio.make_response` :param status: same as :meth:`~pyexcel_webio.make_response` :returns: http response )adictruNrrvrzrZrerfrrwrrr make_response_from_dictvryr|cKrs)a Make a http response from a list of dictionaries :param records: a list of dictionaries :param file_type: same as :meth:`~pyexcel_webio.make_response` :param status: same as :meth:`~pyexcel_webio.make_response` :returns: http response )recordsruNrrv)r}rZrerfrrwrrr make_response_from_recordss  r~cKrs)a+ Make a http response from a dictionary of two dimensional arrays :param book_dict: a dictionary of two dimensional arrays :param file_type: same as :meth:`~pyexcel_webio.make_response` :param status: same as :meth:`~pyexcel_webio.make_response` :returns: http response )bookdictruNrr#rHrlr{rrr make_response_from_book_dicts  rcK&tjd|||d|}t||||S)a Make a http response from a dictionary of two dimensional arrays :param query_sets: a query set :param column_names: a nominated column names. It could not be N one, otherwise no data is returned. :param file_type: same as :meth:`~pyexcel_webio.make_response` :param status: same as :meth:`~pyexcel_webio.make_response` :returns: a http response ) query_sets column_namesruNrrv)rrrZrerfrrwrrr make_response_from_query_setss rcKr)a" Make a http response from sqlalchmey table :param session: SQLAlchemy session :param table: a SQLAlchemy table :param file_type: same as :meth:`~pyexcel_webio.make_response` :param status: same as :meth:`~pyexcel_webio.make_response` :returns: a http response )r9r:ruNrrv)r9r:rZrerfrrwrrr make_response_from_a_table rcKr)a" Make a http response from sqlalchmy tables :param session: SQLAlchemy session :param tables: SQLAlchemy tables :param file_type: same as :meth:`~pyexcel_webio.make_response` :param status: same as :meth:`~pyexcel_webio.make_response` :returns: a http response )r9rJruNrr)r9rJrZrerfrrwrrr make_response_from_tablesrr)NrcN)rcN)rcNN)rVpyexcelr# _XLSX_MIMErkobjectrrWrgrjrlrnrrrxr|r~rrrrrrrr s      g #