tags:

views:

35

answers:

1
+1  Q: 

Python/Sqlite3 - is there a way to programmatically set .nullvalue?

Currently, Python is storing the string "None" for nulls returned by sqlite3. I read that you can change the default value for nulls in sqlite3 at the command line, but can you set this within the Python code?

I'd like all of my blank results to look the same without having to loop through and check each value. So I want any nulls returned from sqlite3 to be an empty string ("") instead of "None".

A: 

In docs there is an explanation with examples of how to make use of converters and adapters.

SilentGhost  2010-07-30 17:18:03
Yes, I read that section, but unless I'm missing something, it does not help in this situation. I don't have one specific column that I'm selecting that has nulls, nor a specific data type that is coming back null, almost any column can come back with nulls using a left join.
javovo  2010-07-30 18:34:18

related questions

Programmatically talking to a Serial Port in OS X or Linux
Best ways to teach a beginner to program?
Calling a Function From a String With the Function's Name in Python
An executable Python app
Text Editor For Linux (Besides Vi)?
What Hosting Service is best for Django applications?
File size differences after copying a file to a server vía FTP
Python: what is the difference between (1,2,3) and [1,2,3], and when should I use each?
Python: What OS am I running on?
How do I make a menu in python that does not require the user to press (enter) to make a selection?
How do you express binary literals in Python?
What is the most efficient graph data structure in Python?
Adding a Method to an Existing Object
How to learn Python: Good Example Code?
How do I use Python's itertools.groupby()?
Python and MySQL
Class views in Django
Is there an IDE that provides code completion for Python
Using 'in' to match an attribute of Python objects in an array
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
Continuous Integration System for a Python Codebase
Get a preview jpeg of a pdf on windows?
How can I find the full path to a font from its display name on a Mac?
XML Processing in Python