def save_to_django_models(self, models, initializers=None, mapdicts=None, **keywords): """ Save to database table through django model :param models: a list of database models, that is accepted by :meth:`Sheet.save_to_django_model`. The sequence of tables matters when there is dependencies in between the tables. For example, **Car** is made by **Car Maker**. **Car Maker** table should be specified before **Car** table. :param initializers: a list of intialization functions for your tables and the sequence should match tables, :param mapdicts: custom map dictionary for your data columns and the sequence should match tables optional parameters: :param batch_size: django bulk_create batch size :param bulk_save: whether to use bulk_create or to use single save per record """ save_book(self, models=models, initializers=initializers, mapdicts=mapdicts, **keywords)
def save_to_database( self, session, tables, initializers=None, mapdicts=None, auto_commit=True, ): """ Save data in sheets to database tables :param session: database session :param tables: a list of database tables, that is accepted by :meth:`Sheet.save_to_database`. The sequence of tables matters when there is dependencies in between the tables. For example, **Car** is made by **Car Maker**. **Car Maker** table should be specified before **Car** table. :param initializers: a list of intialization functions for your tables and the sequence should match tables, :param mapdicts: custom map dictionary for your data columns and the sequence should match tables :param auto_commit: by default, data is committed. """ save_book( self, session=session, tables=tables, initializers=initializers, mapdicts=mapdicts, auto_commit=auto_commit, )
def save_to_database(self, session, tables, initializers=None, mapdicts=None, auto_commit=True): """ Save data in sheets to database tables :param session: database session :param tables: a list of database tables, that is accepted by :meth:`Sheet.save_to_database`. The sequence of tables matters when there is dependencies in between the tables. For example, **Car** is made by **Car Maker**. **Car Maker** table should be specified before **Car** table. :param initializers: a list of intialization functions for your tables and the sequence should match tables, :param mapdicts: custom map dictionary for your data columns and the sequence should match tables :param auto_commit: by default, data is committed. """ save_book(self, session=session, tables=tables, initializers=initializers, mapdicts=mapdicts, auto_commit=auto_commit)
def save_as(self, filename, **keywords): """ Save the content to a new file :param filename: a file path """ return save_book(self, file_name=filename, **keywords)
def save_book_as(**keywords): """ Save a book from a data source to another one """ dest_keywords, source_keywords = _split_keywords(**keywords) book = sources.get_book_stream(**source_keywords) book = to_book(book) return sources.save_book(book, **dest_keywords)
def isave_book_as(**keywords): """Save a book from a data source to another one It is simliar to :meth:`pyexcel.save_book_as` but it read when it writes. This function provide some speedup but the output data is made uniform. """ dest_keywords, source_keywords = _split_keywords(**keywords) book = sources.get_book_stream(**source_keywords) return sources.save_book(book, **dest_keywords)
def isave_book_as(**keywords): """ Save a book from a data source to another one It is simliar to :meth:`pyexcel.save_book_as` but it read when it writes. This function provide some speedup but the output data is not made uniform. """ dest_keywords, source_keywords = _split_keywords(**keywords) book = sources.get_book_stream(on_demand=True, **source_keywords) return sources.save_book(book, **dest_keywords)
def save_to_memory(self, file_type, stream=None, **keywords): """ Save the content to a memory stream :param file_type: what format the stream is in :param stream: a memory stream. Note in Python 3, for csv and tsv format, please pass an instance of StringIO. For xls, xlsx, and ods, an instance of BytesIO. """ stream = save_book(self, file_type=file_type, file_stream=stream, **keywords) return stream
def save_to_django_models(self, models, initializers=None, mapdicts=None, batch_size=None): """ Save to database table through django model :param models: a list of database models, that is accepted by :meth:`Sheet.save_to_django_model`. The sequence of tables matters when there is dependencies in between the tables. For example, **Car** is made by **Car Maker**. **Car Maker** table should be specified before **Car** table. :param initializers: a list of intialization functions for your tables and the sequence should match tables, :param mapdicts: custom map dictionary for your data columns and the sequence should match tables """ save_book(self, models=models, initializers=initializers, mapdicts=mapdicts, batch_size=batch_size)
def save_as(self, filename, **keywords): """ Save the content to a new file """ return save_book(self, file_name=filename, **keywords)
def save_book_as(**keywords): """Save a book from a data source to another one :param file_name: a file with supported file extension :param file_content: the file content :param file_stream: the file stream :param file_type: the file type in *content* :param session: database session :param tables: a list of database table :param models: a list of django models :param bookdict: a dictionary of two dimensional arrays :param url: a download http url for your excel file :param dest_file_name: another file name. **out_file** is deprecated though is still accepted. :param dest_file_type: this is needed if you want to save to memory :param dest_session: the target database session :param dest_tables: the list of target destination tables :param dest_models: the list of target destination django models :param dest_mapdicts: a list of mapping dictionaries :param dest_initializers: table initialization functions :param dest_mapdicts: to nominate a model or table fields. Optional :param dest_batch_size: batch creation size. Optional :param keywords: additional keywords can be found at :meth:`pyexcel.get_book` :returns: IO stream if saving to memory. None otherwise see also :ref:`a-list-of-data-structures` Here is a table of parameters: ========================== =============================== source parameters ========================== =============================== loading from file file_name, keywords loading from string file_content, file_type, keywords loading from stream file_stream, file_type, keywords loading from sql session, tables loading from django models models loading from dictionary bookdict loading from an url url ========================== =============================== Where the dictionary should have text as keys and two dimensional array as values. ================ ============================================ Saving to source parameters ================ ============================================ file dest_file_name, dest_sheet_name, keywords with prefix 'dest' memory dest_file_type, dest_content, dest_sheet_name, keywords with prefix 'dest' sql dest_session, dest_tables, dest_table_init_func, dest_mapdict django model dest_models, dest_initializers, dest_mapdict, dest_batch_size ================ ============================================ """ dest_keywords, source_keywords = _split_keywords(**keywords) book = sources.get_book_stream(**source_keywords) book = to_book(book) return sources.save_book(book, **dest_keywords)