summaryrefslogtreecommitdiff
path: root/tablib/formats/_tsv.py
blob: 8603c4524d4b4a6502445f452cb9eeada7d9d204 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
# -*- coding: utf-8 -*-

""" Tablib - TSV (Tab Separated Values) Support.
"""

import cStringIO
import csv
import os

import tablib


title = 'tsv'
extentions = ('tsv',)



def export_set(dataset):
	"""Returns a TSV representation of Dataset."""
	stream = cStringIO.StringIO()
	_tsv = csv.writer(stream, delimiter="\t")

	for row in dataset._package(dicts=False):
		_tsv.writerow(row)

	return stream.getvalue()


def import_set(dset, in_stream, headers=True):
	"""Returns dataset from TSV stream."""

	dset.wipe()

	rows = csv.reader(in_stream.split("\r\n"), delimiter="\t")
	for i, row in enumerate(rows):

		# Skip empty rows
		if not row:
			continue

		if (i == 0) and (headers):
			dset.headers = row
		else:
			dset.append(row)


def detect(stream):
	"""Returns True if given stream is valid TSV."""
	try:
		rows = dialect = csv.Sniffer().sniff(stream, delimiters="\t")
		return True
	except csv.Error:
		return False