# store your values of experiment 1
e.store_values(1, values)
# store your values of experiment 2
e.store_values(2, values)
# get only results from experiment 1
result = e.load_values(1)
print "\nresult exp1:\n" + str(result)
# get results from all experiment series
allresults = e.load_values()
print "\nall results:\n" + str(allresults)
print "\nMetadata: "
for metadata in ({"x":"y"}, {"x":"z"}, {"name":"x1", "v1unit":"m/s^2"}):
e.store_metadata(metadata)
print e.load_metadata()
# close the database connection
e.close()
# delete Database if it is a file on the filesystem
if dbdestination != ":memory:":
os.unlink(dbdestination)
import os
import utils
from data_import import CSVImporter
from data_access import ExperimentFile
path = 'examples' + os.sep
#filename = 'Abklingkonstante.csv'
filename = 'Motorkalibrierung.csv'
#filename = 'Eigenfrequenz (Chaos2).csv'
uri = path + filename
data = CSVImporter(uri)
e = ExperimentFile(':memory:', data.rowsize - 1)
#e = ExperimentFile('abklingkonstante.sqlite')
#e = ExperimentFile('motorkalibrierung.sqlite',2)
#e = ExperimentFile('eigenfrequenz_chaos2.sqlite')
e.store_values(1, data.values)
e.store_metadata(data.metadata)
print "imported vals:"
print data.values
print "imported meta:"
print data.metadata
print "stored vals:"
print e.load_values()
print "stored meta:"
print e.load_metadata()
e.close()
