csvkit is a suite of utilities for converting to and working with CSV,

the king of tabular file formats.

6 files changed, 230 insertions, 0 deletions

diff --git a/textproc/csvkit/DESCR b/textproc/csvkit/DESCR
new file mode 100644
index 00000000000..dacd28d5096
--- /dev/null
+++ b/textproc/csvkit/DESCR
@@ -0,0 +1,16 @@
+csvkit is a suite of utilities for converting to and working with CSV,
+the king of tabular file formats.
+
+csvkit is to tabular data what the standard Unix text processing suite
+(grep, sed, cut, sort) is to text. As such, csvkit adheres to the Unix
+philosophy.
+
+    Small is beautiful.
+    Make each program do one thing well.
+    Build a prototype as soon as possible.
+    Choose portability over efficiency.
+    Store data in flat text files.
+    Use software leverage to your advantage.
+    Use shell scripts to increase leverage and portability.
+    Avoid captive user interfaces.
+    Make every program a filter.
diff --git a/textproc/csvkit/Makefile b/textproc/csvkit/Makefile
new file mode 100644
index 00000000000..de139b2062a
--- /dev/null
+++ b/textproc/csvkit/Makefile
@@ -0,0 +1,37 @@
+# $NetBSD: Makefile,v 1.1.1.1 2015/01/11 13:35:16 cheusov Exp $
+
+DISTNAME=	0.9.0
+PKGNAME=	csvkit-${DISTNAME}
+CATEGORIES=	textproc
+MASTER_SITES=	https://github.com/onyxfish/csvkit/archive/
+
+MAINTAINER=	cheusov@NetBSD.org
+HOMEPAGE=	https://github.com/onyxfish/csvkit/archive/
+COMMENT=	Suite of utilities for converting to and working with CSV
+LICENSE=	mit
+
+DEPENDS+=	${PYPKGPREFIX}-nose>=1.1.2:../../devel/py-nose \
+		${PYPKGPREFIX}-xlrd>=0.9.2:../../textproc/py-xlrd \
+		${PYPKGPREFIX}-dateutil>=2.2:../../time/py-dateutil \
+		${PYPKGPREFIX}-sqlalchemy>=0.9.3:../../databases/py-sqlalchemy \
+		${PYPKGPREFIX}-sphinx>=1.0.7:../../textproc/py-sphinx \
+		${PYPKGPREFIX}-coverage>=1.0.7:../../devel/py-coverage \
+		${PYPKGPREFIX}-openpyxl>=2.0.3:../../textproc/py-openpyxl \
+		${PYPKGPREFIX}-jdcal>=0.9.3:../../time/py-jdcal \
+		${PYPKGPREFIX}-simplejson>=3.6.3:../../converters/py-simplejson \
+		${PYPKGPREFIX}-six>=1.6.1:../../lang/py-six
+#		${PYPKGPREFIX}-tox>=1.3:../../*/py-tox
+
+PYTHON_VERSIONS_INCOMPATIBLE=	26
+
+# csvkit publishes files like "0.9.0.tar.gz"
+DIST_SUBDIR=	${PKGNAME_NOREV}
+WRKSRC=		${WRKDIR}/${PKGNAME_NOREV}
+
+USE_LANGUAGES=	# none
+
+EGG_NAME=	${PKGNAME}
+
+.include "../../lang/python/application.mk"
+.include "../../lang/python/egg.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/textproc/csvkit/PLIST b/textproc/csvkit/PLIST
new file mode 100644
index 00000000000..a740777cfa1
--- /dev/null
+++ b/textproc/csvkit/PLIST
@@ -0,0 +1,132 @@
+@comment $NetBSD: PLIST,v 1.1.1.1 2015/01/11 13:35:16 cheusov Exp $
+bin/csvclean
+bin/csvcut
+bin/csvformat
+bin/csvgrep
+bin/csvjoin
+bin/csvjson
+bin/csvlook
+bin/csvpy
+bin/csvsort
+bin/csvsql
+bin/csvstack
+bin/csvstat
+bin/in2csv
+bin/sql2csv
+${PYSITELIB}/${EGG_INFODIR}/PKG-INFO
+${PYSITELIB}/${EGG_INFODIR}/SOURCES.txt
+${PYSITELIB}/${EGG_INFODIR}/dependency_links.txt
+${PYSITELIB}/${EGG_INFODIR}/entry_points.txt
+${PYSITELIB}/${EGG_INFODIR}/requires.txt
+${PYSITELIB}/${EGG_INFODIR}/top_level.txt
+${PYSITELIB}/csvkit/__init__.py
+${PYSITELIB}/csvkit/__init__.pyc
+${PYSITELIB}/csvkit/__init__.pyo
+${PYSITELIB}/csvkit/cleanup.py
+${PYSITELIB}/csvkit/cleanup.pyc
+${PYSITELIB}/csvkit/cleanup.pyo
+${PYSITELIB}/csvkit/cli.py
+${PYSITELIB}/csvkit/cli.pyc
+${PYSITELIB}/csvkit/cli.pyo
+${PYSITELIB}/csvkit/convert/__init__.py
+${PYSITELIB}/csvkit/convert/__init__.pyc
+${PYSITELIB}/csvkit/convert/__init__.pyo
+${PYSITELIB}/csvkit/convert/csvitself.py
+${PYSITELIB}/csvkit/convert/csvitself.pyc
+${PYSITELIB}/csvkit/convert/csvitself.pyo
+${PYSITELIB}/csvkit/convert/dbase.py
+${PYSITELIB}/csvkit/convert/dbase.pyc
+${PYSITELIB}/csvkit/convert/dbase.pyo
+${PYSITELIB}/csvkit/convert/fixed.py
+${PYSITELIB}/csvkit/convert/fixed.pyc
+${PYSITELIB}/csvkit/convert/fixed.pyo
+${PYSITELIB}/csvkit/convert/geojs.py
+${PYSITELIB}/csvkit/convert/geojs.pyc
+${PYSITELIB}/csvkit/convert/geojs.pyo
+${PYSITELIB}/csvkit/convert/js.py
+${PYSITELIB}/csvkit/convert/js.pyc
+${PYSITELIB}/csvkit/convert/js.pyo
+${PYSITELIB}/csvkit/convert/xls.py
+${PYSITELIB}/csvkit/convert/xls.pyc
+${PYSITELIB}/csvkit/convert/xls.pyo
+${PYSITELIB}/csvkit/convert/xlsx.py
+${PYSITELIB}/csvkit/convert/xlsx.pyc
+${PYSITELIB}/csvkit/convert/xlsx.pyo
+${PYSITELIB}/csvkit/exceptions.py
+${PYSITELIB}/csvkit/exceptions.pyc
+${PYSITELIB}/csvkit/exceptions.pyo
+${PYSITELIB}/csvkit/grep.py
+${PYSITELIB}/csvkit/grep.pyc
+${PYSITELIB}/csvkit/grep.pyo
+${PYSITELIB}/csvkit/headers.py
+${PYSITELIB}/csvkit/headers.pyc
+${PYSITELIB}/csvkit/headers.pyo
+${PYSITELIB}/csvkit/join.py
+${PYSITELIB}/csvkit/join.pyc
+${PYSITELIB}/csvkit/join.pyo
+${PYSITELIB}/csvkit/py2.py
+${PYSITELIB}/csvkit/py2.pyc
+${PYSITELIB}/csvkit/py2.pyo
+${PYSITELIB}/csvkit/py3.py
+${PYSITELIB}/csvkit/py3.pyc
+${PYSITELIB}/csvkit/py3.pyo
+${PYSITELIB}/csvkit/sniffer.py
+${PYSITELIB}/csvkit/sniffer.pyc
+${PYSITELIB}/csvkit/sniffer.pyo
+${PYSITELIB}/csvkit/sql.py
+${PYSITELIB}/csvkit/sql.pyc
+${PYSITELIB}/csvkit/sql.pyo
+${PYSITELIB}/csvkit/table.py
+${PYSITELIB}/csvkit/table.pyc
+${PYSITELIB}/csvkit/table.pyo
+${PYSITELIB}/csvkit/typeinference.py
+${PYSITELIB}/csvkit/typeinference.pyc
+${PYSITELIB}/csvkit/typeinference.pyo
+${PYSITELIB}/csvkit/unicsv.py
+${PYSITELIB}/csvkit/unicsv.pyc
+${PYSITELIB}/csvkit/unicsv.pyo
+${PYSITELIB}/csvkit/utilities/__init__.py
+${PYSITELIB}/csvkit/utilities/__init__.pyc
+${PYSITELIB}/csvkit/utilities/__init__.pyo
+${PYSITELIB}/csvkit/utilities/csvclean.py
+${PYSITELIB}/csvkit/utilities/csvclean.pyc
+${PYSITELIB}/csvkit/utilities/csvclean.pyo
+${PYSITELIB}/csvkit/utilities/csvcut.py
+${PYSITELIB}/csvkit/utilities/csvcut.pyc
+${PYSITELIB}/csvkit/utilities/csvcut.pyo
+${PYSITELIB}/csvkit/utilities/csvformat.py
+${PYSITELIB}/csvkit/utilities/csvformat.pyc
+${PYSITELIB}/csvkit/utilities/csvformat.pyo
+${PYSITELIB}/csvkit/utilities/csvgrep.py
+${PYSITELIB}/csvkit/utilities/csvgrep.pyc
+${PYSITELIB}/csvkit/utilities/csvgrep.pyo
+${PYSITELIB}/csvkit/utilities/csvjoin.py
+${PYSITELIB}/csvkit/utilities/csvjoin.pyc
+${PYSITELIB}/csvkit/utilities/csvjoin.pyo
+${PYSITELIB}/csvkit/utilities/csvjson.py
+${PYSITELIB}/csvkit/utilities/csvjson.pyc
+${PYSITELIB}/csvkit/utilities/csvjson.pyo
+${PYSITELIB}/csvkit/utilities/csvlook.py
+${PYSITELIB}/csvkit/utilities/csvlook.pyc
+${PYSITELIB}/csvkit/utilities/csvlook.pyo
+${PYSITELIB}/csvkit/utilities/csvpy.py
+${PYSITELIB}/csvkit/utilities/csvpy.pyc
+${PYSITELIB}/csvkit/utilities/csvpy.pyo
+${PYSITELIB}/csvkit/utilities/csvsort.py
+${PYSITELIB}/csvkit/utilities/csvsort.pyc
+${PYSITELIB}/csvkit/utilities/csvsort.pyo
+${PYSITELIB}/csvkit/utilities/csvsql.py
+${PYSITELIB}/csvkit/utilities/csvsql.pyc
+${PYSITELIB}/csvkit/utilities/csvsql.pyo
+${PYSITELIB}/csvkit/utilities/csvstack.py
+${PYSITELIB}/csvkit/utilities/csvstack.pyc
+${PYSITELIB}/csvkit/utilities/csvstack.pyo
+${PYSITELIB}/csvkit/utilities/csvstat.py
+${PYSITELIB}/csvkit/utilities/csvstat.pyc
+${PYSITELIB}/csvkit/utilities/csvstat.pyo
+${PYSITELIB}/csvkit/utilities/in2csv.py
+${PYSITELIB}/csvkit/utilities/in2csv.pyc
+${PYSITELIB}/csvkit/utilities/in2csv.pyo
+${PYSITELIB}/csvkit/utilities/sql2csv.py
+${PYSITELIB}/csvkit/utilities/sql2csv.pyc
+${PYSITELIB}/csvkit/utilities/sql2csv.pyo
diff --git a/textproc/csvkit/distinfo b/textproc/csvkit/distinfo
new file mode 100644
index 00000000000..b3235a062b5
--- /dev/null
+++ b/textproc/csvkit/distinfo
@@ -0,0 +1,7 @@
+$NetBSD: distinfo,v 1.1.1.1 2015/01/11 13:35:16 cheusov Exp $
+
+SHA1 (csvkit-0.9.0/0.9.0.tar.gz) = 9afc884d9af7b5c8c5277d6816384dd15a4968cf
+RMD160 (csvkit-0.9.0/0.9.0.tar.gz) = 2836ec7769e87ee0fe13829187069ebcbfcac26b
+Size (csvkit-0.9.0/0.9.0.tar.gz) = 3928467 bytes
+SHA1 (patch-csvkit_convert_____init____.py) = b2da7ef399cac88c9f4de737aa0b43ee61341ce0
+SHA1 (patch-setup.py) = d0f4f3b6bbe9b4adbdabbeb90d60d02a3e92cb61
diff --git a/textproc/csvkit/patches/patch-csvkit_convert_____init____.py b/textproc/csvkit/patches/patch-csvkit_convert_____init____.py
new file mode 100644
index 00000000000..0b0e7ba3ede
--- /dev/null
+++ b/textproc/csvkit/patches/patch-csvkit_convert_____init____.py
@@ -0,0 +1,21 @@
+$NetBSD: patch-csvkit_convert_____init____.py,v 1.1.1.1 2015/01/11 13:35:16 cheusov Exp $
+
+# Fix too strict requirements
+--- csvkit/convert/__init__.py.orig	2014-09-09 00:22:49.000000000 +0000
++++ csvkit/convert/__init__.py
+@@ -12,10 +12,11 @@ from csvkit.convert.xlsx import xlsx2csv
+ SUPPORTED_FORMATS = ['fixed', 'xls', 'xlsx', 'csv', 'json', 'geojson']
+ 
+ # DBF is supported for Python 2 only
+-if six.PY2:
+-    from csvkit.convert.dbase import dbf2csv
+-
+-    SUPPORTED_FORMATS.append('dbf')
++# I do not like "==" style of requirements, newer version is available
++#if six.PY2:
++#    from csvkit.convert.dbase import dbf2csv
++#
++#    SUPPORTED_FORMATS.append('dbf')
+ 
+ def convert(f, format, schema=None, key=None, **kwargs):
+     """
diff --git a/textproc/csvkit/patches/patch-setup.py b/textproc/csvkit/patches/patch-setup.py
new file mode 100644
index 00000000000..a39a2f85129
--- /dev/null
+++ b/textproc/csvkit/patches/patch-setup.py
@@ -0,0 +1,17 @@
+$NetBSD: patch-setup.py,v 1.1.1.1 2015/01/11 13:35:16 cheusov Exp $
+
+# Fix too strict requirements
+--- setup.py.orig	2014-09-09 00:22:49.000000000 +0000
++++ setup.py
+@@ -16,8 +16,9 @@ if sys.version_info < (2, 7):
+     install_requires.append('ordereddict>=1.1')
+     install_requires.append('simplejson>=3.6.3')
+ 
+-if sys.version_info[0] == 2:
+-    install_requires.append('dbf==0.94.003')
++# I don't like "==" style of requirements, newer version is available
++#if sys.version_info[0] == 2:
++#    install_requires.append('dbf==0.94.003')
+ 
+ setup(
+     name='csvkit',