def get_engine():
if DEBUG:
engine = sqlalchemy.create_engine('sqlite://')
else:
#engine = get_sqlite_engine(delete=False)
engine = get_psql_engine()
return engine
def get_engine():
if DEBUG:
engine = sqlalchemy.create_engine('sqlite://')
else:
#engine = get_sqlite_engine(delete=False)
engine = get_psql_engine()
return engine
def test(engine):
cases = [
dict(mz=100,rt=90),
dict(mz=102,rt=90),
dict(mz=102,rt=200),
dict(mz=103,rt=100),
dict(mz=105,rt=80,ioc=10),
dict(mz=107,rt=200,attrs=['media']),
dict(mz=108,rt=100,attrs=['media']),
dict(mz=109,rt=500,attrs=['media','time']),
dict(mz=111,rt=500,attrs=['media','time']),
dict(mz=113,rt=100,attrs=['media'],ioc=10),
dict(mz=113,rt=200,attrs=['media'],ioc=10),
dict(mz=114,rt=100,attrs=['media'],ioc=10),
dict(mz=116,rt=100,attrs=['media','time'],ioc=10)
]
for case in cases:
print case
r = search(engine,
case.get('mz'),
case.get('rt'),
ioc=case.get('ioc'),
attrs=case.get('attrs',[]))
for line in results_as_csv(r):
print line
if __name__=='__main__':
engine = get_psql_engine()
test(engine)
def test(engine):
cases = [
dict(mz=100, rt=90),
dict(mz=102, rt=90),
dict(mz=102, rt=200),
dict(mz=103, rt=100),
dict(mz=105, rt=80, ioc=10),
dict(mz=107, rt=200, attrs=['media']),
dict(mz=108, rt=100, attrs=['media']),
dict(mz=109, rt=500, attrs=['media', 'time']),
dict(mz=111, rt=500, attrs=['media', 'time']),
dict(mz=113, rt=100, attrs=['media'], ioc=10),
dict(mz=113, rt=200, attrs=['media'], ioc=10),
dict(mz=114, rt=100, attrs=['media'], ioc=10),
dict(mz=116, rt=100, attrs=['media', 'time'], ioc=10)
]
for case in cases:
print case
r = search(engine,
case.get('mz'),
case.get('rt'),
ioc=case.get('ioc'),
attrs=case.get('attrs', []))
for line in results_as_csv(r):
print line
if __name__ == '__main__':
engine = get_psql_engine()
test(engine)
