File: FEATURES

package info (click to toggle)
sqsh 2.1-6
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 2,000 kB
  • ctags: 1,113
  • sloc: ansic: 20,040; sh: 3,131; makefile: 514; sql: 94
file content (59 lines) | stat: -rw-r--r-- 1,470 bytes parent folder | download | duplicates (4)
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
/* $Id: FEATURES,v 1.1.1.1 2001/10/23 20:31:06 gray Exp $ */

Features I don't want to forget about:

1. \if, \elif, \endif syntax

   I have some ideas, but I really want to think this through. For
   example with:
   
     \if (expression)
   
   will expression *always* be an external unix command?  Do I need
   to come up with another type of function (something different then
   a sqsh command) that can replace things like 'test', 'access', etc.?
   
   Within:

     \if (expression)
        select count(*) from syspickles
     \endif
   
   Will the select actually happen, or does it need an explicit "go"?
   Such as 

     \if (expression)
        select count(*) from syspickles
        \go
     \endif
   
   Inquiring minds want to know.

2. .netrc style password file

   Before I dive into this I want to explore an \if, \elif, \endif
   construct.  This would provide something far more flexible. For
   example:

     \if (test "$DSQUERY" = "SYB_PICKLES")
        \set password=ickypoo
     \elif (test "$DSQUERY" = "SYB_STINK")
        \set password=yukcy
     \endif

3. A read command

   So you could have interactive scripts like:

      \echo -n "Name: "
      \read $name
      select * from sysobjects where name like "$name"

4. Allow the \abort and \exit commands to take an error code

   Once again, this would be primarily useful with if-then-else logic,
   such as:

      \if (test "$severity" -gt "10")
         \exit 128
      \fi