There is no way we can tell you what to change, without knowing: what is supposed to happen when you try the code? What happens when you try it, and how is that different? And especially: where is the actual code that tries to do the insert? You have only shown us some Python code to create some strings that look like SQL code. That does not actually cause any SQL queries to run.
But before trying to fix these problems, please read the pinned thread and follow the guide to format the code properly. Otherwise, it’s hard to read, and the forum software will change some details (to make it “look nice”, but this is terrible for code).