summaryrefslogtreecommitdiff
path: root/tablib/formats/_csv.py
blob: b71755bf9f530be25fbf1c0777d79f8ce4c4ee6a (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
# -*- coding: utf-8 -*-

""" Tablib - CSV Support.
"""

import cStringIO
import csv
import os

import tablib


title = 'csv'
extentions = ('csv',)



def export_set(dataset):
    """Returns CSV representation of Dataset."""
    stream = cStringIO.StringIO()
    _csv = csv.writer(stream)

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

    return stream.getvalue()


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

    dset.wipe()

    rows = csv.reader(in_stream.splitlines())
    for i, row in enumerate(rows):

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


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