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", )