Re: reduce number of multiple values to be inserted

On Wed, May 30, 2018 at 8:40 AM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:

>
>
>
> On 05/29/2018 06:36 PM, Adrian Klaver wrote:
>
>> On 05/29/2018 05:10 PM, tango ward wrote:
>>
>>>
>>> Hi,
>>>
>> Not sure where you are pulling the data from and how it is ordered, but
>> an outline:
>>
>> data_input (Assuming sorted by village and then age)
>>
>> for village in data_input:
>> for age in village:
>> curr_pgsql.execute('''
>> INSERT INTO student (created, modified, name,
>> address, age, level)
>> VALUES(current_timezone, current_timezone,
>> %s, %s, %s, 2)''', (name, village, age))
>>
>>
>>>
>>> Thanks,
>>> J
>>>
>>>
>>
>> You might need random(name)? ;)

Noted. Thank you Sirs. I love you both.