Django Advanced Queries

This post will show some more advanced parts of the Django ORM and the queries you can do with it. There are multiple ways to achieve the same query result in Django, but this post will focus on the ways done through the ORM and the python functions. Raw SQL For completeness, I quickly mention the way to execute raw SQL statements. In my opinion, this way should be used as a last resort, if no other way works because you loose a lot of benefits like type conversion and bound checks if you completly skip the ORM and access the database directly....

July 28, 2023

Trigger a z/OS JCL-Job from Python through FTP

While working with mainframe systems in todays world, it can make a lot of sense to try and integrate it with other languages or control it from the “outside”. This enabled me to simplify tasks such as automated testing, continous integration and deployment, and a few smaller tasks that would have taken way longer if they were done manually. In this post, I’ll show how I used Python to orchestrate jobs on a z/OS-system through FTP....

February 18, 2023