summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDirk Engling <erdgeist@erdgeist.org>2019-03-04 02:06:39 +0100
committerDirk Engling <erdgeist@erdgeist.org>2019-03-04 02:06:39 +0100
commit5ac7e2e4229dab3124ad9d1556ea714a3149fff0 (patch)
tree9e484d06b3c4ef3163f351e87aeb0984d946214c
parent13773527601bebdbe224ec18ccfdc3cb75a0aa90 (diff)
Add quoting
-rwxr-xr-xmakecolumns.sh12
-rw-r--r--src/postprocess/postgres.txt2
2 files changed, 7 insertions, 7 deletions
diff --git a/makecolumns.sh b/makecolumns.sh
index e10165d..4381f13 100755
--- a/makecolumns.sh
+++ b/makecolumns.sh
@@ -68,19 +68,19 @@ do_decompress_version_3() {
68 68
69do_processfile_version_3() { 69do_processfile_version_3() {
70 working_on=`basename ${1}` 70 working_on=`basename ${1}`
71 mkdir $working_on && cd ${working_on} 71 mkdir "${working_on}" && cd "${working_on}"
72 do_decompress_version_3 "${1}" "${2}" 72 do_decompress_version_3 "${1}" "${2}"
73 cd .. 73 cd ..
74 74
75 printf "Combining $2 into single file ... " 75 printf "Combining $2 into single file ... "
76 if [ "${4}" = "convert_zeros" ]; then 76 if [ "${4}" = "convert_zeros" ]; then
77 cat ${working_on}/* | tr '\n\0' '\t\n' > $3 77 cat "${working_on}"/* | tr '\n\0' '\t\n' > $3
78 else 78 else
79 cat ${working_on}/* > $3 79 cat "${working_on}"/* > $3
80 fi 80 fi
81 printf "done.\n" 81 printf "done.\n"
82 82
83 rm -rf ${working_on} 83 rm -rf "${working_on}"
84} 84}
85 85
86size() { 86size() {
@@ -134,10 +134,10 @@ handle_format_version_2() {
134 for database in `find "$1" -iname atb?dd00`; do 134 for database in `find "$1" -iname atb?dd00`; do
135 dir=`dirname ${database}` 135 dir=`dirname ${database}`
136 base=`basename ${database}` 136 base=`basename ${database}`
137 printf " %d/3 in %4s. Decompressing ... " ${cd} "$( basename ${dir} )" 137 printf " %d/3 in %4s. Decompressing ..." ${cd} "$( basename ${dir} )"
138 extract_version_2 "${database}" > ${base}.dump 138 extract_version_2 "${database}" > ${base}.dump
139 139
140 printf ", extracting ... " 140 printf ", extracting ..."
141 indexfile=$( find ${dir} -iname atb?di00 ) 141 indexfile=$( find ${dir} -iname atb?di00 )
142 split_version_2 "${base}.dump" "${indexfile}" 142 split_version_2 "${base}.dump" "${indexfile}"
143 143
diff --git a/src/postprocess/postgres.txt b/src/postprocess/postgres.txt
index 943a88a..e47ca00 100644
--- a/src/postprocess/postgres.txt
+++ b/src/postprocess/postgres.txt
@@ -62,7 +62,7 @@ CREATE INDEX trgm_idx_web ON indexed_view_web USING gin (value gi
62CREATE INDEX trgm_idx_email ON indexed_view_email USING gin (value gin_trgm_ops); 62CREATE INDEX trgm_idx_email ON indexed_view_email USING gin (value gin_trgm_ops);
63 63
64# slow way: 64# slow way:
65SELECT * FROM Telefonbuch WHERE nachname = 'Engling'; 65SELECT * FROM Telefonbuch WHERE nachname = 'CCC';
66 66
67# using the index: 67# using the index:
68SELECT * FROM Telefonbuch 68SELECT * FROM Telefonbuch