René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"support copyfrom","articleBody":"To insert mutliple values at once there is the sqlc [copyfrom](https://docs.sqlc.dev/en/stable/howto/insert.html#using-copyfrom), but it it is unsupported in sqlc-gen-python\r\n\r\n\r\nBut it should be quite easy to implement using an `executemany` statement:\r\nhttps://stackoverflow.com/questions/13020908/sql-multiple-inserts-with-python\r\n\r\n```python\r\nrows = []\r\n\r\nfor row in range(sheet.nrows):\r\n    \"\"\"name is in the 0th col. email is the 4th col.\"\"\"\r\n    name = sheet.cell(row, 0).value  \r\n    email =  sheet.cell(row, 4).value\r\n    rows.append((name, email))\r\n\r\ndb = MySQLdb.connect(host=host, user=user, db=dbname, passwd=pwd)\r\ncursor = db.cursor()\r\ncursor.executemany(\"\"\"INSERT INTO mailing_list (name,email) VALUES (%s,%s)\"\"\", rows)\r\n```","author":{"url":"https://github.com/borissmidt","@type":"Person","name":"borissmidt"},"datePublished":"2024-11-21T11:58:41.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/63/sqlc-gen-python/issues/63"}