added undeal updates that seem to work for sqlalchemy