Re: reduce number of multiple values to be inserted

Rob Sargent <robjsargent@xxxxxxxxx> · Tue, 29 May 2018 18:40:23 -0600

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)? ;)