Skip to content

Content Tagged "batch"

Page 1 of 1

Execute a Command in Every Directory with Bash

July 13, 2018Categories: Software, Tutorial
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…

Delete Dependent Entries of a Table in Oracle PL/SQL

March 13, 2017Categories: Software, Tutorial
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…

Replace a colour in an image with imagemagick

June 8, 2016Categories: IT, Tutorial
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…

Use XPath in PL/PGSQL for Batch Processing

March 5, 2016Categories: Software, Tutorial
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…

All tags