Ozzie.eu

Love to code, although it bugs me.

Print tab separated values as table using MySQL

Ozzie 11:29 AM , , No comments
Using mysql command line utility to get recordsets, the data rows alignment and line breaks are often  a mess. You can use the command line tool on a mysql database server to get a set of rows into an output TSV file like so:
shell>  mysql -u your_user -p < your_statement.sql > data.csv
I came up with the following python script to grab the output file and pretty print:
import csv
from tabulate import tabulate
if __name__ == '__main__':
report_headers = []
data = []
with open('data.csv','r') as f:
reader=csv.reader(f,delimiter='\t')
for dataRow in reader:
data.append(dataRow)
report_headers = data[0]
del data[0]
print tabulate(data,report_headers)
view raw print-tsv-to-table.py hosted with ❤ by GitHub
You can put your own filename instead of 'data.csv'. And of course, this script also works for other TSV files that don't come from mysql. To run the script you should install the python tabulate package:
https://pypi.python.org/pypi/tabulate

No comments :

Post a Comment

Subscribe to: Post Comments ( Atom )