o["otherObj"] = type("otherObj", (Entity,), {'declared_params': {'myParam': 'string'}})
print [s.__name__ for s in Entity.__subclasses__()]
oo = o["otherObj"](myParam="Hey")
m.save(oo)
#m.session.session.commit()
# m.session.delete(e1)
#m.session.session.commit()
xml = m.toXML()
print ""
print xml
with m.auto_session as session:
session.add_all(m.fromXML(xml))
from xdapy.operators import *
print m.find_all(Observer, filter={"name": "%Sor%"})
print m.find_all(Observer, filter={"name": ["%Sor%"]})
print m.find_all(Observer, filter={"age": range(30, 50), "name": ["%Sor%"]})
print m.find_all(Observer, filter={"age": between(30, 50)})
print m.find_all(Observer, filter={"age": 40})
print m.find_all(Observer, filter={"age": gt(10)})
print m.find_all(Session, filter={"date": ge(datetime.date.today())})
print m.get_data_matrix([Observer(name="Max Mustermann")], {Experiment:['project'], Observer:['age','name']})
trial1_5 = Trial(number_of_runs=3)
trial1_5.parent = experiment1
trial2_1 = Trial(number_of_runs=8)
trial2_1.parent = experiment2
trial2_2 = Trial(number_of_runs=5)
trial2_2.parent = experiment2
trial2_3 = Trial(number_of_runs=4)
trial2_3.parent = experiment2
trial2_4 = Trial(number_of_runs=2)
trial2_4.parent = experiment2
trial2_5 = Trial(number_of_runs=1)
trial2_5.parent = experiment2
trial1_1.attach("Observer", observer1)
trial1_2.attach("Observer", observer1)
trial2_1.attach("Observer", observer1)
trial2_2.attach("Observer", observer2)
m.save(trial1_1, trial1_2, trial1_3, trial1_4, trial1_5, trial2_1, trial2_2, trial2_3, trial2_4, trial2_5)
print m.find_all(Trial)
# find all trials with observer.age between 20 and 30
print m.find_related(Trial, (Observer, {"age": between(20, 30)}))
print m.get_data_matrix([Trial], {Observer: ["age"], Experiment: ['project']})
