Re: Dictionary

Em Qui, 2010-04-22 às 10:59 -0700, Tim Roberts escreveu:
> Antonio Prado wrote:
> > Correct! That's right I'm trying to do.
> >
> > But I'm having problem bellow.
> >
> > What is wrong?
> >
> > [...]
> > cur = db.cur(cursor_factory=psycopg_extras.DictCursor)
> > cur.execute("SELECT * FROM users")
> > result = cur.fetchall()
> >
> >   
> >>>> print result
> >>>>         
> > [[2, 'JOSE ALBERTO', 'MOTA'], [3, 'MARY ANN', 'MARY']]
> >
> >   
> >>>> print resultado[0]['nome']
> >>>>         
> > JOSE ALBERTO
> >
> >   
> >>>> resultado[0]['nome'] = 'teste'
> >>>>         
> > TypeError: list indices must be integers, not str
> >   
> 
> Each row behaves like a read-only dictionary, although it is not a
> dictionary.
> 
> > result = dict(result)
> >   
> >>> ValueError: dictionary update sequence element #0 has length 3; 2 is
> >>>       
> > required
> >   
> 
> You are trying to convert the whole result set here, not just one row. 
> You need to convert the rows one by one.  For example
>     result = [dict(x) for x in result]


It worked, but in some cases this error that occurs:

>>> expected string or Unicode object, NoneType found


What is causing the error?

Thank you!


Antonio Prado.






_______________________________________________
Psycopg mailing list
[email protected]
http://lists.initd.org/mailman/listinfo/psycopg