'InsertQuery' object has no attribute 'columns' about django-pyodbc HOT 4 OPEN

Hi, i have the same problem.

Could you resolve this issue?
How??

Best Regards,
Julio Sánchez.

from django-pyodbc.

I did finally resolve it, but after a year or so I'm having trouble remembering. Over the last few years I've actually made a few little patches to pyodbc that made it work better with django. Looking through git logs I think I made a simple patch to the pyodbc/compiler.py file.

In the file there's a function "as_sql", and in there I swapped out:

    if self.return_id and self.connection.features.can_return_id_from_insert:
        params = params[0]
        output = 'OUTPUT inserted.%s' % qn(opts.pk.column)
        result.append(output)
        result.append("VALUES (%s)" % ", ".join(placeholders[0]))
        return [(" ".join(result), tuple(params))]

with:

    if self.return_id and self.connection.features.can_return_id_from_insert:
        params = params[0]
        #TODO: ryan commented out old output method and replace with scope_identity
        # output = 'OUTPUT inserted.%s' % qn(opts.pk.column)
        # result.append(output)
        result.append("VALUES (%s)" % ", ".join(placeholders[0]))
        result.append("SELECT SCOPE_IDENTITY()")
        return [(" ".join(result), tuple(params))]

... let me know if that doesn't work and i'll dig into it a bit more

from django-pyodbc.

Thanks eviltandem for your support!!

mmmm but this code is just under where i get the error code..

result.append('INSERT INTO %s' % qn(opts.db_table))
result.append('(%s)' % ', '.join([qn(c) for c in self.query.columns])) # <=== here is the error

if self.return_id and self.connection.features.can_return_id_from_insert:
params = params[0]
#TODO: ryan commented out old output method and replace with scope_identity
# output = 'OUTPUT inserted.%s' % qn(opts.pk.column)
# result.append(output)
result.append("VALUES (%s)" % ", ".join(placeholders[0]))
result.append("SELECT SCOPE_IDENTITY()")
return [(" ".join(result), tuple(params))]

Can you give me the columns part? Or maybe all the compile.py

BR,
Julio Sánchez.

from django-pyodbc.

Done!, I was replace all the as_sql code to the as_code from Github lastest version.

It Works!!

Thanks a lot eviltandem!!

Best Regards,
Julio Sánchez.

from django-pyodbc.