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

Question

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".

Donal Fellows · Accepted Answer · 2011-12-07 12:51:25Z

1

Uses the SQL-Function COALESCE for each column of your left join.

SELECT 
  a.id, a.value, 
  COALESCE(b.id, ''), COALESCE(b.value, '')
FROM 
  a 
  LEFT OUTER JOIN b ON b.a_id = a.id

edited Dec 7, 2011 at 12:51

Donal Fellows

139k19 gold badges161 silver badges222 bronze badges

answered Dec 7, 2011 at 12:22

Heinz Z.

1,5943 gold badges15 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

javovo Over a year ago

Thank you! This solution works perfectly for what I was doing at the time where I only had one or columns to worry about. I would still like to find a way to do it programmatically so I wouldn't have to build the coalesce function into every sql statement that might produce these results.

SilentGhost · Accepted Answer · 2010-07-30 17:18:03Z

0

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

answered Jul 30, 2010 at 17:18

SilentGhost

322k67 gold badges312 silver badges294 bronze badges

1 Comment

javovo Over a year ago

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.

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related