o w¨Êhöã@s¤dZddlmZGdd„deƒZGdd„deƒZGdd„deƒZGd d „d eƒZGd d „d eƒZGd d„deƒZ Gdd„deƒZ Gdd„deƒZ Gdd„deƒZ dS)zô pyexcel_io.database.common ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Common classes shared among database importers and exporters :copyright: (c) 2014-2017 by Onni Software Ltd. :license: New BSD License, see LICENSE for more details é)Ú BookReaderc@s0eZdZdZdd„Zdd„Zdd„Zdd „Zd S) Ú DbExporterz5 Transcode the book reader interface to db interface cKó|j||fi|¤ŽdS©N©Ú export_tables)ÚselfÚ file_nameÚkeywords©r úL/var/www/html/env/lib/python3.10/site-packages/pyexcel_io/database/common.pyÚopenózDbExporter.opencKrrr)rÚ file_streamr r r r Ú open_streamrzDbExporter.open_streamcKs|j|fi|¤ŽdSrr)rÚ file_contentr r r r Ú open_contentszDbExporter.open_contentcKstdƒ‚)z read database tables zPlease implement this method)ÚNotImplementedError)rÚexporterr r r r rszDbExporter.export_tablesN)Ú__name__Ú __module__Ú __qualname__Ú__doc__r rrrr r r r r s  rc@s.eZdZdZd dd„Zedd„ƒZdd„ZdS) ÚDjangoModelExportAdapterz django export parameter holder NcCs||_||_dSr)ÚmodelÚexport_columns©rrrr r r Ú__init__!ó z!DjangoModelExportAdapter.__init__cCs| ¡S©z get database table name )Úget_name©rr r r Úname%ózDjangoModelExportAdapter.namecCs |jjjSr)rÚ_metaÚ model_namer!r r r r *s z!DjangoModelExportAdapter.get_namer)rrrrrÚpropertyr"r r r r r rs    rc@s~eZdZdZGdd„deƒZdd„Zedd„ƒZedd „ƒZ ed d „ƒZ ej d d„ƒZe j d d „ƒZ e j dd „ƒZ dd„Z dS)ÚDjangoModelImportAdapterz) parameter holder for django data import c@óeZdZdZdd„ZdS)z'DjangoModelImportAdapter.InOutParameterz' local class to manipulate variable io cCsd|_d|_dSr)ÚoutputÚinputr!r r r r5rz0DjangoModelImportAdapter.InOutParameter.__init__N©rrrrrr r r r ÚInOutParameter2ó r,cCs6t ||¡| ¡|_| ¡|_| ¡|_| ¡dSr)rrr,Ú'_DjangoModelImportAdapter__column_namesÚ3_DjangoModelImportAdapter__column_name_mapping_dictÚ*_DjangoModelImportAdapter__row_initializerÚ_process_parameters©rrr r r r9s     z!DjangoModelImportAdapter.__init__cCó|jjS)z' contructor for a database table entry )r0r)r!r r r Úrow_initializer@r#z(DjangoModelImportAdapter.row_initializercCr3)z& the desginated database column names )r.r)r!r r r Ú column_namesEr#z%DjangoModelImportAdapter.column_namescCr3)z3 if not the same, a mapping dictionary is looked up)r/r)r!r r r Úcolumn_name_mapping_dictJr#z1DjangoModelImportAdapter.column_name_mapping_dictcCó||j_| ¡dS)z set the contructor N)r0r*r1)rÚ a_functionr r r r4Oó cCr7)z set the column names N)r.r*r1)rr5r r r r5Ur9cCr7)z set the mapping dict N)r/r*r1)rÚ mapping_dictr r r r6[r9csžˆjjdur dˆj_nˆjjˆj_tˆjjtƒr#ˆjjˆj_dˆj_ntˆjjtƒr?ˆjjr?‡fdd„ˆjjDƒˆj_dˆj_ˆjjdurMˆjjˆj_dSdS)Ncsg|]}ˆjj|‘qSr )r/r*)Ú.0r"r!r r Ú ks ÿÿz@DjangoModelImportAdapter._process_parameters..)r0r*r)Ú isinstancer/Úlistr.Údictr!r r!r r1as       þ ÿz,DjangoModelImportAdapter._process_parametersN) rrrrÚobjectr,rr&r4r5r6Úsetterr1r r r r r'/s"       r'c@ó eZdZdZdd„Zdd„ZdS)ÚDjangoModelExporterz* public interface for django model export cCs g|_dSr)Úadaptersr!r r r rwó zDjangoModelExporter.__init__cCs|j |¡dS©z/ store model parameter for more than one model N)rDÚappend©rÚimport_adapterr r r rGzszDjangoModelExporter.appendN)rrrrrrGr r r r rCts rCc@s(eZdZdZdd„Zdd„Zdd„ZdS) ÚDjangoModelImporterz* public interface for django model import cCs i|_dSr)Ú_DjangoModelImporter__adaptersr!r r r r‚rEzDjangoModelImporter.__init__cCs||j| ¡<dSrF)rKr rHr r r rG…szDjangoModelImporter.appendcCs|j |d¡S)z get a parameter out N)rKÚget)rr"r r r rL‰szDjangoModelImporter.getN)rrrrrrGrLr r r r rJs  rJc@s"eZdZdZddd„Zdd„ZdS)ÚSQLTableExportAdapterz, parameter holder for sql table data export NcCst |||¡||_dSr)rrÚtablerr r r r‘s zSQLTableExportAdapter.__init__cCót|jddƒS©NÚ __tablename__©ÚgetattrrNr!r r r r •ózSQLTableExportAdapter.get_namer©rrrrrr r r r r rMŽs  rMc@rB)ÚSQLTableImportAdapterz. parameter holder for sqlalchemy table import cCst ||¡||_dSr)r'rrNr2r r r rœs  zSQLTableImportAdapter.__init__cCrOrPrRr!r r r r  rTzSQLTableImportAdapter.get_nameNrUr r r r rV™s rVc@r()ÚSQLTableExporterz' public interface for sql table export cCót |¡||_dSr)rCrÚsession©rrYr r r r§ó  zSQLTableExporter.__init__Nr+r r r r rW¤r-rWc@r()ÚSQLTableImporterz3 public interface to do data import via sqlalchemy cCrXr)rJrrYrZr r r r¯r[zSQLTableImporter.__init__Nr+r r r r r\¬r-r\N) rÚpyexcel_io.bookrrr@rr'rCrJrMrVrWr\r r r r Ús E