def register_sim(pid: int, force=False) -> Pk_sim:
try:
new_sim = Pk_sim(pid=pid,
sim_date=func.current_date(),
sim_time=func.current_time())
session.add(new_sim)
session.commit()
except:
if force:
session.rollback()
del_pksimid = session.query(
Pk_sim.pksimid).filter(Pk_sim.pid == pid)
to_del = session.query(Pk).filter(Pk.pksimid == del_pksimid)
to_del.delete(synchronize_session=False)
to_del = session.query(Pk_sim).filter(Pk_sim.pid == pid)
to_del.delete(synchronize_session=False)
session.commit()
new_sim = Pk_sim(pid=pid,
sim_date=func.current_date(),
sim_time=func.current_time())
session.add(new_sim)
session.commit()
else:
logging.error("The protein has already been calculated")
exit()
return new_sim
def test_function(self):
self.assert_compile(func.foo(1, 2), 'foo(:foo_1, :foo_2)')
self.assert_compile(func.current_time(), 'CURRENT_TIME')
self.assert_compile(func.foo(), 'foo()')
m = MetaData()
t = Table(
'sometable', m, Column('col1', Integer), Column('col2', Integer))
self.assert_compile(select([func.max(t.c.col1)]),
'SELECT max(sometable.col1) AS max_1 FROM '
'sometable')
def test_function(self):
self.assert_compile(func.foo(1, 2), 'foo(:foo_1, :foo_2)')
self.assert_compile(func.current_time(), 'CURRENT_TIME')
self.assert_compile(func.foo(), 'foo()')
m = MetaData()
t = Table(
'sometable', m, Column('col1', Integer), Column('col2', Integer))
self.assert_compile(select([func.max(t.c.col1)]),
'SELECT max(sometable.col1) AS max_1 FROM '
'sometable')
def test_function(self):
self.assert_compile(func.foo(1, 2), "foo(:foo_1, :foo_2)")
self.assert_compile(func.current_time(), "CURRENT_TIME")
self.assert_compile(func.foo(), "foo()")
m = MetaData()
t = Table("sometable", m, Column("col1", Integer),
Column("col2", Integer))
self.assert_compile(
select([func.max(t.c.col1)]),
"SELECT max(sometable.col1) AS max_1 FROM "
"sometable",
)
def test_function(self):
self.assert_compile(func.foo(1, 2), "foo(:foo_1, :foo_2)")
self.assert_compile(func.current_time(), "CURRENT_TIME")
self.assert_compile(func.foo(), "foo()")
m = MetaData()
t = Table(
"sometable", m, Column("col1", Integer), Column("col2", Integer)
)
self.assert_compile(
select([func.max(t.c.col1)]),
"SELECT max(sometable.col1) AS max_1 FROM " "sometable",
)
