Refactoring tens of thousands of records

Having to refactor an old legacy systems database and hate the dangers of working as root within MySQL, really easy to mess up. So we created a local Docker container in Wappler with two DB Connections, one to the remote DB and one to the local container. Nearly twenty thousand account records (for initial test) for users registration where the old DBA used words like ‘active’, ‘suspended’, etc. We wanted to replace with Boolean values (for performance). Simply connected to the remote DB and carried out a repeat query where the value was equal to the term used by the old DBA, and replace with the new Boolean value, and write to the new DB locally. Took minutes and the job was done.

Damn Wappler you make my life easy!