Category Archives: python

Using Oracle SYS_GUID() and RAW in SQLAlchemy

How to use RAW data types from cx_Oracle dialect in SQLAlchemy to create unique row IDs that are generated by SYS_GUID(). Use Oracle’s SYS_GUID() function to create unique IDs for rows without Sequences. Continue reading

Posted in cx_Oracle, Oracle, Programming, python, SQLAlchemy | Leave a comment

HOW TO Lower Case All Dictionary Keys in a Complex Python Dictionary

This tutorial shows you how to write and use a function that will iterate over complex, nested dictionary or list or combination of the two. For any dictionaries it finds, it will rename the keys to lower-case. This is useful … Continue reading

Posted in How Tos, Programming, python, Software | Leave a comment

HOWTO: Create a random alpha-numeric string in Python

Creating an alpha-numeric string in python is easy, but having a quick function you can call or import as a module is better! This is very useful for things like password generators. To see how to do this in Perl, … Continue reading

Posted in How Tos, Programming, python | Leave a comment