split problem if the delimiter is inside the text limiter

Tim Chase python.list at tim.thechases.com
Wed Mar 18 19:30:46 EDT 2009


Bruno Desthuilliers wrote:
> Tim Chase a écrit :
>> (if your columns in your CSV happen to match the order of your INSERT 
>> statement, you can just use
>>
>>   execute(sql, tuple(row))
> 
> Or more simply:
> 
>      cursor.execute(sql, row)

that's always annoyed me with the mxODBC drivers I've 
used....they require(d?) a tuple in this position, so I developed 
  this habit.  I think the OP hinted they were using postgres 
drivers which may be a bit kinder to the user.  (and don't get me 
started on mxODBC's failure to determine the data-type for 
parameters in subqueries, raising exceptions on perfectly valid 
queries</rant>)

-tkc







More information about the Python-list mailing list