Content Tagged "batch"

TL;DR : Use a find-based loop The other day I was wondering how to execute a command in each sub-directory of a project. In python , you have os.walk . In C , I would've probably written myself something just for fun etc. In shell , I know you have find which is capable of finding all…

The other day I had a task to clean up a database which was populated with a list of records. Unfortunately, my main table is linked to a host of other tables via foreign key dependencies and, to make things worse, no CASCADE constraints are specified. The process I want to is as follows: Scan…

I had to change the colour of some monochrome icons for a personal project, from black to something else (i.e. not black). I've tried in python with PIL. Unfortunately, my attempts to use ImageOps failed miserably, because I'm working with RGBA images, not RGB :(. Of course, one could separate…

A while ago I had to process XML loaded in a PostgreSQL database. The task was to extract references from a publication structure. Fortunately, PostgreSQL allows you to use XPath in plpgsql , but there are some things you need to be aware. First, you need to note all namespaces: Then, you can use…