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)
