| 1 | #!/usr/bin/env bash
|
| 2 | #
|
| 3 | # Usage:
|
| 4 | # ./csv2html-test.sh <function name>
|
| 5 |
|
| 6 | set -o nounset
|
| 7 | set -o pipefail
|
| 8 | set -o errexit
|
| 9 |
|
| 10 | readonly REPO_ROOT=$(readlink -f $(dirname $0))/../..
|
| 11 |
|
| 12 | source $REPO_ROOT/test/common.sh
|
| 13 | source $REPO_ROOT/web/table/html.sh
|
| 14 |
|
| 15 |
|
| 16 | readonly BASE_DIR=_tmp/www
|
| 17 |
|
| 18 | link-static() {
|
| 19 | mkdir -p $BASE_DIR
|
| 20 |
|
| 21 | ln -s -f -v \
|
| 22 | $PWD/../ajax.js \
|
| 23 | $PWD/table-sort.js \
|
| 24 | $PWD/table-sort.css \
|
| 25 | $BASE_DIR
|
| 26 | }
|
| 27 |
|
| 28 | html-head() {
|
| 29 | PYTHONPATH=$REPO_ROOT $REPO_ROOT/doctools/html_head.py "$@"
|
| 30 | }
|
| 31 |
|
| 32 | header() {
|
| 33 | html-head --title 'csv2html-test' \
|
| 34 | ajax.js table-sort.js table-sort.css
|
| 35 |
|
| 36 | table-sort-begin
|
| 37 | }
|
| 38 |
|
| 39 | write-html() {
|
| 40 | local name=$1
|
| 41 | shift
|
| 42 |
|
| 43 | local out=$BASE_DIR/$name.html
|
| 44 |
|
| 45 | { header
|
| 46 | ./csv2html.py "$@" _tmp/$name.csv
|
| 47 | table-sort-end $name
|
| 48 | } > $out
|
| 49 | echo "Wrote $out"
|
| 50 | }
|
| 51 |
|
| 52 | test-no-schema() {
|
| 53 | cat >_tmp/foo.csv <<EOF
|
| 54 | a_number,b
|
| 55 | 1,2
|
| 56 | 3,4
|
| 57 | NA,4
|
| 58 | EOF
|
| 59 |
|
| 60 | write-html foo
|
| 61 | }
|
| 62 |
|
| 63 | test-schema() {
|
| 64 | cat >_tmp/bar.csv <<EOF
|
| 65 | name,name_HREF,num
|
| 66 | spam,#spam,11
|
| 67 | eggs,#eggs,22
|
| 68 | ham,#ham,99
|
| 69 | xxx,#xxx,123456
|
| 70 | zzz,#zzz,NA
|
| 71 | EOF
|
| 72 |
|
| 73 | # NOTE: Columns are out of order, which is OK.
|
| 74 |
|
| 75 | # type: could be html-anchor:shell-id, html-href:shell-id
|
| 76 |
|
| 77 | cat >_tmp/bar.schema.csv <<EOF
|
| 78 | column_name,type
|
| 79 | num,integer
|
| 80 | name,string
|
| 81 | name_HREF,string
|
| 82 | EOF
|
| 83 |
|
| 84 | write-html bar
|
| 85 |
|
| 86 | cp _tmp/bar.csv _tmp/bar2.csv
|
| 87 | cp _tmp/bar.schema.csv _tmp/bar2.schema.csv
|
| 88 | write-html bar2 --thead-offset 1
|
| 89 | }
|
| 90 |
|
| 91 | test-precision() {
|
| 92 | cat >_tmp/prec.csv <<EOF
|
| 93 | name,age
|
| 94 | andy,1.2345
|
| 95 | bob,2.3456789
|
| 96 | EOF
|
| 97 |
|
| 98 | # NOTE: Columns are out of order, which is OK.
|
| 99 |
|
| 100 | # type: could be html-anchor:shell-id, html-href:shell-id
|
| 101 |
|
| 102 | cat >_tmp/prec.schema.csv <<EOF
|
| 103 | column_name,type,precision
|
| 104 | name,string,1
|
| 105 | age,double,2
|
| 106 | EOF
|
| 107 |
|
| 108 | write-html prec
|
| 109 | }
|
| 110 |
|
| 111 | # NOTE: This combination doesn't work, but the default precision of 1 is OK?
|
| 112 | test-precision-href() {
|
| 113 | cat >_tmp/prec-href.csv <<EOF
|
| 114 | name,age,age_HREF
|
| 115 | andy,1.2345,http://example.com/foo
|
| 116 | bob,2.3456789,http://example.com/bar
|
| 117 | EOF
|
| 118 |
|
| 119 | # NOTE: Columns are out of order, which is OK.
|
| 120 |
|
| 121 | # type: could be html-anchor:shell-id, html-href:shell-id
|
| 122 |
|
| 123 | cat >_tmp/prec.schema.csv <<EOF
|
| 124 | column_name,type,precision
|
| 125 | name,string,1
|
| 126 | age,double,2
|
| 127 | age_HREF,string,0
|
| 128 | EOF
|
| 129 |
|
| 130 | write-html prec-href
|
| 131 | }
|
| 132 |
|
| 133 | test-timestamp() {
|
| 134 | cat >_tmp/timestamp.csv <<EOF
|
| 135 | name,start_time,end_time
|
| 136 | python3,0.1,1000000000.2
|
| 137 | bash,1100000000.3,1200000000.4
|
| 138 | EOF
|
| 139 |
|
| 140 | # NOTE: Columns are out of order, which is OK.
|
| 141 |
|
| 142 | # type: could be html-anchor:shell-id, html-href:shell-id
|
| 143 |
|
| 144 | cat >_tmp/timestamp.schema.csv <<EOF
|
| 145 | column_name,type,strftime
|
| 146 | name,string,-
|
| 147 | start_time,float,iso
|
| 148 | end_time,float,iso
|
| 149 | EOF
|
| 150 |
|
| 151 | write-html timestamp
|
| 152 |
|
| 153 | cp _tmp/timestamp.csv _tmp/timestamp2.csv
|
| 154 |
|
| 155 | cat >_tmp/timestamp2.schema.csv <<EOF
|
| 156 | column_name,type,strftime
|
| 157 | name,string,-
|
| 158 | start_time,float,iso
|
| 159 | end_time,float,%H:%M:%S
|
| 160 | EOF
|
| 161 |
|
| 162 | write-html timestamp2
|
| 163 | }
|
| 164 |
|
| 165 | test-row-css-class() {
|
| 166 | cat >_tmp/css.csv <<EOF
|
| 167 | name,age
|
| 168 | andy,1.2345
|
| 169 | bob,2.3456789
|
| 170 | EOF
|
| 171 |
|
| 172 | # NOTE: Columns are out of order, which is OK.
|
| 173 |
|
| 174 | # type: could be html-anchor:shell-id, html-href:shell-id
|
| 175 |
|
| 176 | cat >_tmp/css.schema.csv <<EOF
|
| 177 | column_name,type,precision
|
| 178 | name,string,1
|
| 179 | age,double,3
|
| 180 | EOF
|
| 181 |
|
| 182 | write-html css --css-class-pattern 'myclass ^a'
|
| 183 |
|
| 184 | cat >_tmp/css2.csv <<EOF
|
| 185 | ROW_CSS_CLASS,name,age
|
| 186 | pass,andy,1.2345
|
| 187 | fail,bob,2.3456789
|
| 188 | EOF
|
| 189 |
|
| 190 | # NOTE: Columns are out of order, which is OK.
|
| 191 |
|
| 192 | # type: could be html-anchor:shell-id, html-href:shell-id
|
| 193 |
|
| 194 | cat >_tmp/css2.schema.csv <<EOF
|
| 195 | column_name,type,precision
|
| 196 | ROW_CSS_CLASS,string,0
|
| 197 | name,string,1
|
| 198 | age,double,3
|
| 199 | EOF
|
| 200 |
|
| 201 | write-html css2
|
| 202 | }
|
| 203 |
|
| 204 | test-schema2sqlite() {
|
| 205 | sed 's/,/\t/g' >_tmp/foo.schema.tsv <<EOF
|
| 206 | column_name,type,precision
|
| 207 | ROW_CSS_CLASS,string,0
|
| 208 | name,string,1
|
| 209 | age,double,3
|
| 210 | EOF
|
| 211 |
|
| 212 | ./schema2sqlite.py _tmp/foo.schema.tsv
|
| 213 | }
|
| 214 |
|
| 215 | all() {
|
| 216 | link-static
|
| 217 | echo
|
| 218 | run-test-funcs
|
| 219 | }
|
| 220 |
|
| 221 | "$@"
|
| 222 |
|