Syntax Error Exec-ing Python Code From Database

I'm loading some python code from a database (it's doing dynamic mapping of values that I can change at runtime without a code redeploy). In my code, I'm doing this to execute the

Solution 1:

Do you BLOB or other binary type column to store code? Otherwise database might change line endings and exec will break with SyntaxError:

>>>s='''\...print 'ok'...'''>>>s
"print 'ok'\n"
>>>exec s
ok
>>>exec s.replace('\n', '\r\n')
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "<string>", line 1
    print 'ok'
              ^
SyntaxError: invalid syntax

Update: Writing to file on Windows in text mode will change line endings to platform native ones. Another way to normalize them is:

lMapping = os.linesep.join(lMapping.splitlines())