Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #Carga el fichero en un dataframe para manejarlo internamente
- df_words = pd.read_csv(file, sep=';', header=None)
- #Crea una tabla temporal
- df_words.to_sql('temp_table', db_con, if_exists='append', index=False)
- cursor.execute("INSERT INTO "+name+" (WORD) SELECT * FROM temp_table")
- cursor.execute("DROP TABLE temp_table")
- db_con.commit()
- cursor.execute("INSERT INTO "+name+" (WORD) SELECT * FROM temp_table")
- cursor.execute("INSERT INTO "+name+" (WORD) SELECT * FROM temp_table")
- cursor.execute("INSERT INTO ? (WORD) SELECT * FROM temp_table", (name,))
- try: # Intentamos hacer esto.
- cursor.execute("INSERT INTO ? (WORD) SELECT * FROM temp_table", (name,))
- except: # Si da error, informamos de ello.
- print("La palabra {0} ha dado error".format(name))
- else: # Si no ha dado error...
- # haces lo que quieras con esos datos.
- finally:
- # Finalmente desconectamos la base de datos o lo que quieras.
- cursor.execute("DROP TABLE temp_table")
- db_con.commit()
Add Comment
Please, Sign In to add comment