def setUp(self): """Create test database in memory""" self.connection = Connection.test() self.connection.create_tables() self.mapper = Mapper(self.connection) self.mapper.register(*objects)
def setUp(self): self.connection = Connection.test() self.connection.create_tables() self.m = Mapper(self.connection) self.m.register(Experiment) class GrandParent(Entity): declared_params = { "A1": "string", "A2": "string", "A3": "integer", "A4": "integer" } class Parent(Entity): declared_params = { "A1": "integer" } class Child(Entity): declared_params = { "A1": "string", "A4": "integer", "A5": "float", "A6": "float" } self.gparent = GrandParent(A1="GP", A2="GP", A3=300) self.parent = Parent(A1=100) self.child = Child(A1="C", A4=500, A5=0.5) self.child.parent = self.parent self.parent.parent = self.gparent
def setUp(self): # first we need to ensure that the test database is indeed emtpy self.connection = Connection.test() self.assertEqual(len(self.connection._table_names()), 0, msg="Test database was not emtpy prior testing.") # create a table result = self.connection.session.execute("CREATE TABLE test (dummy char(2));")
def setUp(self): class MyTestEntity(Entity): declared_params = { "some_param": "string" } self.MyTestEntity = MyTestEntity self.connection = Connection.test() self.connection.create_tables() self.m = Mapper(self.connection) self.m.register(self.MyTestEntity)
def setUp(self): self.connection = Connection.test() self.connection.create_tables() self.m = Mapper(self.connection) self.m.register(Experiment) self.good_params = { "datetime": [datetime(2011, 1, 1, 12, 32, 11)], "time": [time(12, 32, 11)], "date": [date(2011, 1, 1)], "integer": [112, 20010213322], "float": [11.2, 200.10213322], "boolean": [True, False], "string": [u"Kleiner Text", u"äöü", u"Юникод"]}
def setUp(self): self.connection = Connection.test() self.connection.create_tables() self.m = Mapper(self.connection)
def setUp(self): self.connection = Connection.test() self.connection.create_tables() self.m = Mapper(self.connection) self.m.register(Observer, Experiment, Trial, Session)
def setUp(self): self.connection = Connection.test() self.connection.create_tables() self.m = Mapper(self.connection) self.m.register(Experiment)
def setUp(self): # first we need to ensure that the test database is indeed emtpy self.connection = Connection.test() self.assertEqual(len(self.connection._table_names()), 0, msg="Test database was not emtpy prior testing.")
def setUp(self): self.connection = Connection.test() self.connection.create_tables() self.mapper = Mapper(self.connection) #register params self.mapper.register(Observer, Experiment, Session, Trial) #_register_parameter('Observer', 'name', 'string') #self.p._register_parameter('Observer', 'age', 'integer') #self.p._register_parameter('Observer', 'handedness', 'string') #self.p._register_parameter('Experiment', 'project', 'string') #self.p._register_parameter('Experiment', 'experimenter', 'string') #self.p._register_parameter('Session', 'date', 'string') #self.p._register_parameter('Trial', 'time', 'string') #self.p._register_parameter('Trial', 'rt', 'integer') #self.p._register_parameter('Trial', 'valid', 'integer') #self.p._register_parameter('Trial', 'response', 'string') #create hierarchy self.e1 = Experiment(project='MyProject', experimenter="John Doe") self.e2 = Experiment(project='YourProject', experimenter="Jeanne Done") self.o3 = Observer(name="Max Mustermann", handedness="right", age=26) self.o4 = Observer(name="Susanne Sorgenfrei", handedness='left', age=38) self.o5 = Observer(name="Susi Sorgen", handedness='left', age=40) self.s6 = Session(date='2009-08-20') self.s7 = Session(date='2009-09-21') self.s8 = Session(date='2009-09-22') self.s9 = Session(date='2009-09-23') self.s10 = Session(date='2009-09-24') self.t11 = Trial(rt=int(randint(100, 3000)), valid=True, response='left') self.t12 = Trial(rt=randint(100, 3000), valid=True, response='right') self.t13 = Trial(rt=randint(100, 3000), valid=True, response='left') self.t14 = Trial(rt=randint(100, 3000), valid=True, response='right') self.t15 = Trial(rt=randint(100, 3000), valid=True, response='left') self.t16 = Trial(rt=randint(100, 3000), valid=True, response='right') self.t17 = Trial(rt=randint(100, 3000), valid=True, response='left') self.t18 = Trial(rt=randint(100, 3000), valid=False, response='right') self.t19 = Trial(rt=randint(100, 3000), valid=False, response='left') self.t20 = Trial(rt=randint(100, 3000), valid=False, response='right') self.t21 = Trial(rt=randint(100, 3000), valid=False, response='left') self.t22 = Trial(rt=randint(100, 3000), valid=False, response='right') self.t23 = Trial(rt=randint(100, 3000), valid=False, response='left') self.t24 = Trial(rt=randint(100, 3000), valid=False, response='right') self.mapper.save(self.e1, self.e2, self.o3, self.o4, self.o5, self.s6, self.s7, self.s8, self.s9, self.s10, self.t11, self.t12, self.t13, self.t14, self.t15, self.t16, self.t17, self.t18, self.t19, self.t20, self.t21, self.t22, self.t23, self.t24) self.e1.children.append(self.o3) self.e1.children.append(self.o4) self.e2.children.append(self.o4) self.o3.children.append(self.s6) self.o3.children.append(self.s7) self.o4.children.append(self.s8)#, self.e1) # TODO: Children can be saved twice #self.o4.children.append(self.s8)#, self.e2) self.o4.children.append(self.s9)#, self.e2) self.o4.children.append(self.s10)#, self.e2) self.s6.children.append(self.t11) self.s6.children.append(self.t12) self.s7.children.append(self.t13) self.s7.children.append(self.t14) #self.s8.children.append(self.t15, self.e1) #self.s8.children.append(self.t16, self.e1) #self.s8.children.append(self.t17, self.e2) self.s9.children.append(self.t18) self.s9.children.append(self.t19) self.s9.children.append(self.t20) self.s10.children.append(self.t21) self.s10.children.append(self.t22) self.s10.children.append(self.t23) self.s10.children.append(self.t24) self.mapper.save(self.e1, self.e2, self.o3, self.o4, self.o5, self.s6, self.s7, self.s8, self.s9, self.s10, self.t11, self.t12, self.t13, self.t14, self.t15, self.t16, self.t17, self.t18, self.t19, self.t20, self.t21, self.t22, self.t23, self.t24)
trial1_2 = Trial() trial1_2.parent = sess1 trial2_1 = Trial() trial2_1.parent = sess2 trial2_2 = Trial() trial2_2.parent = sess2 trial3_1 = Trial() trial3_1.parent = sess3 trial3_2 = Trial() trial3_2.parent = sess3 db = Connection.test() db.create_tables() m = Mapper(db) m.register(Observer, Experiment, Trial) m.save(exp_monorail, exp_neptune) eeee = Experiment() oooo = Observer() eeee.attach("Obs", oooo) exp_monorail.attach("Observer", obs_1) exp_monorail.attach("Observer", obs_2) exp_neptune.attach("Observer", obs_1)
def setUp(self): self.connection = Connection.test() self.connection.create_tables() self.m = Mapper(self.connection) self.m.register(NameEntityAutoId) self.m.register(NameEntity)