def testMerge(self):
self.session = Settings.Session(bind=self.connection)
strparam = StringParameter('strname', 'string100')
session.add(strparam)
session.commit()
session.close()
strparam2 = StringParameter('strname', 'string100')
strparam2.id = 1
strparam2 = self.session.merge(strparam2, load=True)
strparam2.value = 'test'
self.session.commit()
def testUpdate(self):
strparam1 = StringParameter('strname1', 'string1')
strparam2 = StringParameter('strname2', 'string2')
self.session.add(strparam1)
self.session.add(strparam2)
self.session.commit()
#commenting the following line in results in a ObjectDeletedError unless one also resets the value
#somehow sqlalchemy's order of selects and update is confounded
#self.assertEqual([strparam1, strparam2], self.session.query(Parameter).all())
#strparam2.value = strparam2.value
strparam2.name = 'strname22'
self.session.commit()
self.assertEqual([strparam1, strparam2], self.session.query(Parameter).all())
