Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- if os.path.isfile('\offline.csv'):
- try:
- csv = csv.reader(open('\offline.csv', encoding='utf-8'))
- for row in csv:
- conn = connect()
- cursor = conn.cursor()
- query = "INSERT INTO maquina(processador, mb_fabricante, mb_modelo, mb_num_serie, sis_hostname, sis_versao_sistema, sis_data_instalacao, rede_ipv4, rede_macaddress, rede_srv_dns, memoria_ram, total_hd, nome_tecnico)VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s);"
- cursor.execute(query, row)
- conn.commit()
- print('sucesso csv')
- cursor.close()
- conn.close()
- except Exception as erro:
- print('erro csv', erro)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement