astatonn

Ola, Gostaria de ler um arquivo csv e cada valor estar dentro de aspas simples. Segue meu código: def InsertData (check_enter, Table): with open (check_enter, encoding="utf8") as csv_file: csv_reader = csv.reader(csv_file, delimiter=',') next(csv_reader) for row in csv_reader: row = (', '.join(row)) sql = "INSERT INTO {} VALUES ({})".format(Table,row) # cursor.execute(sql) # db.commit() print (sql) saída: INSERT INTO shapes VALUES (2731-1, -30.209293, -51.177531, 44) INSERT INTO shapes VALUES (2731-1, -30.209224, -51.177674, 45) INSERT INTO shapes VALUES (2731-1, -30.209062, -51.178096, 46) INSERT INTO shapes VALUES (2731-1, -30.208796, -51.17887, 47) INSERT INTO shapes VALUES (2731-1, -30.208766, -51.178904, 48) INSERT INTO shapes VALUES (2731-1, -30.208691, -51.178892, 49) INSERT INTO shapes VALUES (2731-1, -30.207825, -51.178549, 50) Como deveria ser: INSERT INTO shapes VALUES ('2731-1', '-30.209293', '-51.177531, 44') INSERT INTO shapes VALUES ('2731-1',' -30.209224', '-51.177674', '45') INSERT INTO shapes VALUES ('2731-1', '-30.209062',' -51.178096', '46') . . . INSERT INTO shapes VALUES ('2731-1', '-30.207825',' -51.178549', '50')