Importing and Exporting Data

DLATK is packged with tools to import and export data from MySQL. There are two options: a standalone Python script (similar to dlatkInterface.py) or you can use Python.

Standalone Script

CSV to MySQL

If your MySQL table does not exist, then use the following to upload your CSV:

./dlatk/tools/importmethods.py -d database -t table --csv_to_mysql --csv_file /path/to/file.csv --column_description "some mysql column description" [--ignore_lines N]

If your table already exists then you can append the CSV file with

./dlatk/tools/importmethods.py -d database -t table --append_csv_to_mysql --csv_file /path/to/file.csv [--ignore_lines N]

MySQL to CSV

./dlatkInterface.py -d dla_tutorial -t msgs -c user_id --mysql_to_csv --csv_file /path/to/file.csv

Using Python

You can also use Python to import/export your data.

CSV to MySQL

import dlatk
dlatk.csvToMySQL(csvFile, database, table, columnDescription, ignoreLines=0)

MySQL to CSV

import dlatk
dlatk.mySQLToCSV(database, table, csvFile)