Skip to main content

Python: Oh How Long I've Known Thee

I have a buddy who was doing some Python programming with Oracle today. He has asked me a question, and after I thought about it, I said, "Hey, that sounds familiar. I think I have some code for that." I knew it was in my open source project, Aquarium, but I also knew it wasn't in newer releases. I eventually found the code and gave it to him.

Here's the punchline: It was from 2001! Yes, I've been coding Python that long.

In case you're wondering what it was, the Oracle driver doesn't have code to fetch rows as dicts, so that's what I was giving him. Here's what it looks like:
    def fetchonedict(self, cursor, force=1): 
"""Fetch one row as a dict.

If force is 1 and there are no more rows, I'll throw
an EXPECTED_RECORD_NOT_FOUND exception. Otherwise (if
force is 0 and there are no more rows), I'll simply return
None. Note, database modules don't *have* to use this
function, I'm just providing it for convenience.

row = cursor.fetchone()
if not row:
if force: raise self.EXPECTED_RECORD_NOT_FOUND
else: return None
fieldCount = len(cursor.description)
retDict = {}
for i in range(0, fieldCount):
# Note that the 0'th element of each tuple in
# cursor.description is the col name.
retDict[cursor.description[i][0]] = row[i]
return retDict
Aside from the camelCased variable names, that ain't bad for a piece of seven year old code!


Noah Gift said…
Two comments:

1. Isn't it great, when you go, wow, I wrote that, and it isn't crap :)

2. This is why I am soooooo happy you are one of the reviewers for my book :)

Btw, if you want on the most insanely complete technical reviewers on Planet Earth, go to JJ, but not for the next few months.
Anonymous said…
or do something like (untested):

ret_dict = dict( zip (map(lambda x:x[0],cursor.descriptions), row ) )


Popular posts from this blog

Ubuntu 20.04 on a 2015 15" MacBook Pro

I decided to give Ubuntu 20.04 a try on my 2015 15" MacBook Pro. I didn't actually install it; I just live booted from a USB thumb drive which was enough to try out everything I wanted. In summary, it's not perfect, and issues with my camera would prevent me from switching, but given the right hardware, I think it's a really viable option. The first thing I wanted to try was what would happen if I plugged in a non-HiDPI screen given that my laptop has a HiDPI screen. Without sub-pixel scaling, whatever scale rate I picked for one screen would apply to the other. However, once I turned on sub-pixel scaling, I was able to pick different scale rates for the internal and external displays. That looked ok. I tried plugging in and unplugging multiple times, and it didn't crash. I doubt it'd work with my Thunderbolt display at work, but it worked fine for my HDMI displays at home. I even plugged it into my TV, and it stuck to the 100% scaling I picked for the othe

Drawing Sierpinski's Triangle in Minecraft Using Python

In his keynote at PyCon, Eben Upton, the Executive Director of the Rasberry Pi Foundation, mentioned that not only has Minecraft been ported to the Rasberry Pi, but you can even control it with Python . Since four of my kids are avid Minecraft fans, I figured this might be a good time to teach them to program using Python. So I started yesterday with the goal of programming something cool for Minecraft and then showing it off at the San Francisco Python Meetup in the evening. The first problem that I faced was that I didn't have a Rasberry Pi. You can't hack Minecraft by just installing the Minecraft client. Speaking of which, I didn't have the Minecraft client installed either ;) My kids always play it on their Nexus 7s. I found an open source Minecraft server called Bukkit that "provides the means to extend the popular Minecraft multiplayer server." Then I found a plugin called RaspberryJuice that implements a subset of the Minecraft Pi modding API for B

Creating Windows 10 Boot Media for a Lenovo Thinkpad T410 Using Only a Mac and a Linux Machine

TL;DR: Giovanni and I struggled trying to get Windows 10 installed on the Lenovo Thinkpad T410. We struggled a lot trying to create the installation media because we only had a Mac and a Linux machine to work with. Everytime we tried to boot the USB thumb drive, it just showed us a blinking cursor. At the end, we finally realized that Windows 10 wasn't supported on this laptop :-/ I've heard that it took Thomas Edison 100 tries to figure out the right material to use as a lightbulb filament. Well, I'm no Thomas Edison, but I thought it might be noteworthy to document our attempts at getting it to boot off a USB thumb drive: Download the ISO. Attempt 1: Use Etcher. Etcher says it doesn't work for Windows. Attempt 2: Use Boot Camp Assistant. It doesn't have that feature anymore. Attempt 3: Use Disk Utility on a Mac. Erase a USB thumb drive: Format: ExFAT Scheme: GUID Partition Map Mount the ISO. Copy everything from