diff options
| -rwxr-xr-x | ormtest.py | 33 |
1 files changed, 33 insertions, 0 deletions
diff --git a/ormtest.py b/ormtest.py new file mode 100755 index 0000000..91b8277 --- /dev/null +++ b/ormtest.py @@ -0,0 +1,33 @@ +#!/usr/bin/python +from ebus.web import model +from sqlalchemy import create_engine + +#engine = create_engine('sqlite:///:memory:', echo=True) +engine = create_engine("postgresql:///ebus_test", echo=False) + +model.ModelBase.metadata.create_all(engine) + +from sqlalchemy.orm import sessionmaker +Session = sessionmaker() +Session.configure(bind=engine) + +session = Session() + +t1_sensor = model.Sensor("foosensor", "blatest") +session.add(t1_sensor) + +#annahme 100 mal 3 values /min +for i in xrange(360*24*60*100): + session.add( model.ValueInt(t1_sensor, 1) ) + + session.add( model.ValueFloat(t1_sensor, 1.2) ) + + session.add( model.ValueString(t1_sensor, "foobar") ) + + if i%1000 == 0: + print i + session.commit() + +session.commit() +session.close() + |