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