INSERT or UPDATE Example

What we actually do in SQLite is somehing they call UPSERT

    #Strings should be added as parameters to avoid sanatisation risks unless you know they are safe.
    #Other values can be added as parameters too or inline in the INSERT text.    
    db1cursor.execute("""INSERT INTO my_table (
                        some_string_column,
                        some_value_column
                    ) VALUES (
                        ?,
                        ?
                    )
                      ON CONFLICT(some_string_column) DO UPDATE SET some_value_column=?;
                    """,
                    (my_string1, my_value1, my_value1));
    db1.commit()
    #if db1cursor.rowcount < 0:
    #    print("FAILED");