Category Archives: python

Using Oracle SYS_GUID() and RAW in SQLAlchemy

Posted on April 12, 2017 by admin

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

Posted on November 20, 2014 by admin

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 | 1 Comment

HOWTO: Create a random alpha-numeric string in Python

Posted on December 27, 2013 by admin

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