Guest User

Untitled

a guest
Feb 18th, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. #Carga el fichero en un dataframe para manejarlo internamente
  2. df_words = pd.read_csv(file, sep=';', header=None)
  3.  
  4. #Crea una tabla temporal
  5. df_words.to_sql('temp_table', db_con, if_exists='append', index=False)
  6.  
  7. cursor.execute("INSERT INTO "+name+" (WORD) SELECT * FROM temp_table")
  8.  
  9. cursor.execute("DROP TABLE temp_table")
  10.  
  11. db_con.commit()
  12.  
  13. cursor.execute("INSERT INTO "+name+" (WORD) SELECT * FROM temp_table")
  14.  
  15. cursor.execute("INSERT INTO "+name+" (WORD) SELECT * FROM temp_table")
  16.  
  17. cursor.execute("INSERT INTO ? (WORD) SELECT * FROM temp_table", (name,))
  18.  
  19. try: # Intentamos hacer esto.
  20. cursor.execute("INSERT INTO ? (WORD) SELECT * FROM temp_table", (name,))
  21. except: # Si da error, informamos de ello.
  22. print("La palabra {0} ha dado error".format(name))
  23. else: # Si no ha dado error...
  24. # haces lo que quieras con esos datos.
  25. finally:
  26. # Finalmente desconectamos la base de datos o lo que quieras.
  27. cursor.execute("DROP TABLE temp_table")
  28. db_con.commit()
Add Comment
Please, Sign In to add comment