So frequently, I need to run small data migrations or transformations. Especially on the way to Doctrine, there’s a lot to clean-up in a database which has been used and evolved over five years or so.
The other day, I wanted to run some transformations on the data located a history column in a pretty simple table — here’s what it looks like:
Building a class to interface the table is simple:
Now it should be easy to iterate across it, find data and save — wrong!