def create(): config = get_test_config() initdb(config['DB']['engine']) fixtures.load() conn = get_handle() xaction = Xaction() conn.add(xaction) conn.commit() typ1, typC = SampleType(name='patient'), SampleType(name='control') s1, s2 = Sample(sample_type=typ1), Sample(sample_type=typC) plate96_t = conn.query(ContainerType).filter(ContainerType.name=='Plate-96_well').one() plate = ContainerInst( name='my_plate', type=plate96_t ) conn.add(plate) conn.commit() well1 = conn.query(Container).filter(Container.type == plate96_t).filter(Container.name == 'A01').one() well2 = conn.query(Container).filter(Container.type == plate96_t).filter(Container.name == 'A02').one() p1 = Plating( plate=plate, well=well1, sample=s1, xaction=xaction ) p2 = Plating( plate=plate, well=well2, sample=s2, xaction=xaction ) conn.add( p1 ) conn.add( p2 ) conn.commit() return plate
def test_cont(self): fixtures.load() conn = get_handle() for typ in conn.query(ContainerTyp): for cont in typ.units: print('@@ %s :: %s' % (typ, cont))
def main(): print('@@ helper main') config = get_config() destroydb(config['DB']['engine']) initdb(config['DB']['engine']) DB << fixtures.load() DB << populate_plate()