def insert_similarity(connection, id, vectors_info):
    """Inserts a row of similarity vectors for a given lowlevel.id into
    the similarity table.

        Args: lowlevel.id to be submitted
              vectors_info, list of tuples of the form:
              (metric_name, vector)
    """
    params = {}
    params["id"] = id
    for name, vector in vectors_info:
        print(name)
        print(vector)
        params[name] = tuple(vector)

    query = text("""
        INSERT INTO similarity (
                    id,
                    mfccs,
                    mfccsw,
                    gfccs,
                    gfccsw,
                    key,
                    bpm,
                    onsetrate,
                    moods,
                    instruments,
                    dortmund,
                    rosamerica,
                    tzanetakis)
             VALUES (
                    :id,
                    :mfccs,
                    :mfccsw,
                    :gfccs,
                    :gfccsw,
                    :key,
                    :bpm,
                    :onsetrate,
                    :moods,
                    :instruments,
                    :dortmund,
                    :rosamerica,
                    :tzanetakis)
        ON CONFLICT (id)
         DO NOTHING
    """)
    connection.execute(query, params)