[Tutor] School Boy Error

[Liam Clarke]

Hi John,

Listy will be a list of lists, and the DBAPI specifies tuples. So
either change this -

listy.append(line)

to

listy.append(tuple(line))

or stick a list comprehension at the end if you need to mung anything
in listy before passing it in:

listy = [ tuple(item) for item in listy]

Regards,

Liam Clarke

On 4/16/06, John CORRY <john.corry at ntlworld.com> wrote:
>
>
>
> Thanks Brian for the help on the last one.  I couldn't see the wood for the
> trees.  I have a tougher one for you.
>
>
>
> I am reading in a CSV file.  Each line represents a line that I want to
> upload into my database.  I am trying to upload the first line in the file
> to get myself started.  The code is below:-
>
>
>
> import string, re
>
> path = "c:/test/import.csv"
>
> listy = []
>
> input = file(path, "r")
>
> for line in input.readlines():
>
>     line = line.split(",")
>
>     listy.append(line)
>
>
>
> print listy[-1]
>
>
>
> stat = """Insert into cost_grid values
> (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
>
> ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
>
> ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
>
> ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,)"""
>
> t = 5000
>
> d = "PF2"
>
> b = 91.4
>
> a = 95.00
>
>
>
> import mx.ODBC
>
> import mx.ODBC.Windows
>
> db = mx.ODBC.Windows.DriverConnect('DSN=vfp')
>
> c = db.cursor()
>
> c.execute(stat, listy[-1])
>
>
>
> db.commit()
>
> c.close()
>
>
>
> I get the following error:
>
>
>
> TypeError: parameters must be a list of tuples
>
>
>
> Any suggestions would be greatly appreciated.
>
>
>
> Thanks,
>
>
>
> John.
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
>
>
>