summaryrefslogtreecommitdiff
path: root/system/csv2sql/csv2sql.SlackBuild
blob: 3fd9a532e042710e69df1ed02eb0b30a372ce958 (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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
#!/bin/bash

# Slackware build script for csv2sql

# Written by B. Watson (urchlay@slackware.uk)

# Licensed under the WTFPL. See http://www.wtfpl.net/txt/copying/ for details.

cd $(dirname $0) ; CWD=$(pwd)

PRGNAM=csv2sql
VERSION=${VERSION:-0.1}
BUILD=${BUILD:-1}
TAG=${TAG:-_SBo}
PKGTYPE=${PKGTYPE:-tgz}
ARCH=noarch

if [ ! -z "${PRINT_PACKAGE_NAME}" ]; then
  echo "$PRGNAM-$VERSION-$ARCH-$BUILD$TAG.$PKGTYPE"
  exit 0
fi

TMP=${TMP:-/tmp/SBo}
PKG=$TMP/package-$PRGNAM
OUTPUT=${OUTPUT:-/tmp}

set -e

rm -rf $PKG
mkdir -p $TMP $PKG $OUTPUT
cd $TMP
rm -rf $PRGNAM-$VERSION
tar xvf $CWD/$PRGNAM-$VERSION.tar.gz
cd $PRGNAM-$VERSION
chown -R root:root .
chmod 644 *

# As shipped, csv2sql refuses to read stdin if it's a redirect from a file.
# This works:
#   cat file.csv | csv2sql
# This doesn't work:
#   csv2sql < file.csv
# ...which violates the principle of least surprise. The patch makes
# it read from stdin unconditionally, if no filename given (so the 2nd
# example will work). This is how standard UNIX utilities like cat,
# grep, sed have worked for decades.
# For those of you who don't like me patching the code, don't bother
# complaining via email/etc. I consider this a bugfix that enhances
# usability. Feel free to comment out the next line, if it bothers you:
patch -p1 < $CWD/stdin.diff

mkdir -p $PKG/usr/bin
install -oroot -groot -m0755 $PRGNAM $PKG/usr/bin/$PRGNAM

# man page by SlackBuild author.
mkdir -p $PKG/usr/man/man1
gzip -9c < $CWD/$PRGNAM.1 > $PKG/usr/man/man1/$PRGNAM.1.gz

PKGDOC=$PKG/usr/doc/$PRGNAM-$VERSION
mkdir -p $PKGDOC
cp -a README* $PKGDOC
cat $CWD/$PRGNAM.SlackBuild > $PKGDOC/$PRGNAM.SlackBuild

mkdir -p $PKG/install
cat $CWD/slack-desc > $PKG/install/slack-desc

cd $PKG
/sbin/makepkg -l y -c n $OUTPUT/$PRGNAM-$VERSION-$ARCH-$BUILD$TAG.$PKGTYPE