automation - Simon Facciol

Simon Facciol

automation

A collection of 3 posts

Python: Rename files using a csv map

Python: Rename files using a csv map

This script is written in Python and makes use of a 2 column .csv file to find and rename files by mapping their existing name and rename it to the new one.

Python: Check the resolution of images in a directory

Python: Check the resolution of images in a directory

Check the resolution of images in a directory and output the filename of the incorrect images. I had to check over 200 images and there was no better way than using Ruby or Python on OSX to go through all those image files and check their proper dimensions, and I

MySQL Trigger to generate a slug on before insert a new row

This week I needed to write a trigger for MySQL to generate automatically the slug from a string column whenever a new game is added. What this trigger does is to get the game name column and replace some characters to generate a proper slug. Watch out for the escaped