def set_geolocation(cls, offer_id, lat, lon):
transaction.begin()
DBSession.query(cls) \
.filter(cls.id == offer_id) \
.update({'latitude': lat,
'longitude': lon,
'geolocation_is_valid': True})
transaction.commit()