pyexcel.Book.save_to_database¶
- Book.save_to_database(session, tables, initializers=None, mapdicts=None, auto_commit=True)¶
Save data in sheets to database tables
- Parameters:
session – database session
tables – a list of database tables, that is accepted by
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.initializers – a list of intialization functions for your tables and the sequence should match tables,
mapdicts – custom map dictionary for your data columns and the sequence should match tables
auto_commit – by default, data is committed.