Subject: Re: iterating over DictRow
To: David Raymond <David.Raymond@tomtom.com>,
 "psycopg@lists.postgresql.org" <psycopg@lists.postgresql.org>
References: <20200923215444.GA25406@hermes.hilbert.loc>
 <AM0PR07MB4036EA8B58205084F30DA2AC87390@AM0PR07MB4036.eurprd07.prod.outlook.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <7b2272a8-de4d-bc95-1efc-84d69ea7c4c1@aklaver.com>
Date: Thu, 24 Sep 2020 08:51:52 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.12.0
MIME-Version: 1.0
In-Reply-To: 
 <AM0PR07MB4036EA8B58205084F30DA2AC87390@AM0PR07MB4036.eurprd07.prod.outlook.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

On 9/24/20 7:53 AM, David Raymond wrote:
> Since DictRow's can be indexed by either the field name or the field index (either record["ID"] or record[0]) then I think what it "should" be is a little ambiguous. But you can always either cast it to a dict, or iterate over .keys() if you want the field names.
> 
> for field in dict(the_dict):
>      ...
> or
> for field in the_dict.keys():
>     ...
> 

Except I think the_dict is actually the_list. I was just about to post a 
reply to my post saying that my use of the_dict was incorrect as I was 
actually iterating over a list.

-- 
Adrian Klaver
adrian.klaver@aklaver.com