Batch insert ais messages

batch_inser.py

def insertPositionData(cur, data_list, batch_size, received_by):
    sql = '''
        INSERT INTO ais_position 
            (timestamp, mmsi, geom, mgrs_name, accuracy, 
            course, speed, status, status_text, type, heading, 
            shiptype, shiptype_text, received_by, other)
        VALUES %s
        ON CONFLICT (mmsi, timestamp) 
        DO NOTHING
    '''

    template = '''
        (%(timestamp)s, %(mmsi)s, ST_GeomFromEWKT(%(geom)s), 
        (ARRAY(SELECT name from mgrs where ST_Within(ST_GeomFromEWKT(%(geom)s), mgrs.geom))),
        %(accuracy)s, %(course)s, %(speed)s, %(status)s, 
        %(status_text)s, %(type)s, %(heading)s, %(shiptype)s, 
        %(shiptype_text)s, %(received_by)s, %(other)s)
    '''

    execute_values(cur, sql, data_list, template, page_size = batch_size)