0

Getting Error

"OperationalError: near "in": syntax error" in line 7: conn.execute('INSERT INTO Good_Raw_Data VALUES ({values})'.format(values=(list_)))

conn.execute('INSERT INTO Good_Raw_Data VALUES ({values})'.format(values=(list_)))

OperationalError: near "in": syntax error

with open("adult.csv", "r") as f:
    next(f)
    reader = csv.reader(f, delimiter="\n")
    for line in enumerate(reader):
        for list_ in (line[1]):
            try:
                conn.execute('INSERT INTO Good_Raw_Data VALUES ({values})'.format(values=(list_)))
                                
                conn.commit()
            except Exception as e:
                raise(e)

What to do?

Ch3steR
  • 19,076
  • 4
  • 25
  • 52
Suraj Goswami
  • 11
  • 3
  • Why do you use an underscore suffix for `list_` ? That's a weird variable name! – Marcello Romani Sep 30 '21 at 19:01
  • Could you post a sample line from `adult.csv` ? I suspect you need to format `{values}` in SQL-compatible way – Marcello Romani Sep 30 '21 at 19:02
  • https://www.kaggle.com/wenruliu/adult-income-dataset – Suraj Goswami Sep 30 '21 at 19:07
  • First of all, I hope that data is anonymised :-D Also, there you go: that string gets passed unaltered into the SQL query (very dangerous practice!) without any quoting around strings. I suggest you split `conn.execute('INSERT ...'.format(...))` in two steps: 1) build the string (and then print it out) 2) execute the string – Marcello Romani Sep 30 '21 at 19:09
  • See https://stackoverflow.com/a/589416/5320906 (the parameter substitution character is `%s` for most database connectors, `?` for sqlite; check the connector's `paramstyle` attribute). Using parameter substitution will protect you from quoting errors and SQL injection. Using string formatting will not. – snakecharmerb Sep 30 '21 at 19:35

0 Answers0