MySQL

Mahtaisko tällä onnistua? GitHub - manticorp/CSVDump: A fast, effective and reliable tool for dumping CSV files into a MySQL database.

 

Tällä python skriptillä pitäisi onnistua kunhan ensin muokkaat tuon connectionin sopimaan sille mysqlille.

Koodi:

import pandas as pd
import sqlite3
import os

TXT_FILES = r"C:\Username\dir"
database = r"C:\Username\database.db"

def getFileNames(dataLocation):
    if not os.path.exists(dataLocation):
        print("[-] Error no folder", dataLocation)
        exit()
    return os.listdir(dataLocation)

connection = sqlite3.connect(database)
filenames = getFileNames(TXT_FILES)

for file in filenames:
    df = pd.read_csv(os.path.join(TXT_FILES, file))
    tablename = file[:-4]
    df.to_sql(tablename, connection, if_exists='replace')