blob: b743c6c6133639ce96b4133f16b8d49ad4724006 (
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
|
#! /bin/gawk -f
##
## This AWK-script generates some example queries, when applied on "testcases",
## as command line argument. When you need to add new test cases, edit the
## file "testcases". Each line in this file should be of the form:
##
## filename @ query @ -- comment @ -- comment
##
## For example the line:
##
## mm.ql @ select 2- -1 from ImgCharA as a @ -- caution: -- introduces comments.
##
## should generate a test file named mm.ql with the folowing content:
##
## -- caution: -- introduces comments.
##
## select 2- -1 from ImgCharA as a
##
## The char @ is somewhat unusual for SQL and I chose it as field separator.
BEGIN {FS = "@"} ;
{
for (i = 3; i < NF; i++) {
printf "%s\n", $i > $1
}
printf "\n" >> $1
printf "%s\n", $2 >> $1
}
|
