def isave_book_to_database(self,
session=None,
tables=None,
initializers=None,
mapdicts=None,
auto_commit=True,
**keywords):
"""
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`
"""
params = self.get_params(**keywords)
params['dest_session'] = session
params['dest_tables'] = tables
params['dest_initializers'] = initializers
params['dest_mapdicts'] = mapdicts
params['dest_auto_commit'] = auto_commit
pe.isave_book_as(**params)
def isave_book_to_database(self, models=None, initializers=None,
mapdicts=None, batch_size=None,
**keywords):
"""
Save data from a book to a nominated django models
"""
params = self.get_params(**keywords)
params['dest_models'] = models
params['dest_initializers'] = initializers
params['dest_mapdicts'] = mapdicts
params['dest_batch_size'] = batch_size
pe.isave_book_as(**params)
def test_isave_book_as():
content = _produce_ordered_dict()
io = pe.isave_book_as(dest_file_type="xls", bookdict=content)
book2 = pe.get_book(file_content=io.getvalue(), file_type="xls")
assert book2.to_dict() == content
botM=Calibrator(**settings)
botM.read_data()
discrete_fit_data_M=decorator(botM, botM.discrete_fit_data, h=lambda y: y/1000*9.81*np.cos(momentArmTilt)*armLength)
resultMoment=discrete_fit_data_M(customEquation)
MomentData=[
['Parameter', 'Parameter_Std', 'R2', 'Max95%Scatter_Uncertainty', 'Max95%Mean_Uncertainty'],
[resultMoment['param'][0], resultMoment['paramStd'][0], resultMoment['R2'], max(resultMoment['scatterUncert']), max(resultMoment['meanUncert'])],
[resultMoment['param'][1], resultMoment['paramStd'][1], '', '', '']
]
os.chdir(savingDirectory)
calibrationResult=collections.OrderedDict()
calibrationResult.update({'SG': SGData, 'AOA': AOAData, 'Drag': DragData,
'MomentCCW': MomentCCWData, 'MomentCW': MomentCWData,
'MomentTotal': MomentData})
pyexcel.isave_book_as(bookdict=calibrationResult, dest_file_name='results.xlsx')
# velocity=11.25
# velocityUncertanties=0.05
# density=1.184
# densityUncertanties=0.2/100*density
# chord=0.14
# chordUncertanties=0
# span=0.197
# spanUncertanties=0
# airfoilMass=149.8/1000
#
# fSG=resultSG['f']
# fAOA=resultAOA['f']
# fDrag=resultDrag['f']