tuffy.db
Class SQLMan

java.lang.Object
  tuffy.db.SQLMan

public class SQLMan
extends java.lang.Object

Container of SQL related utilities.

Field Summary

static java.lang.String	sqlFuncMisc
static java.lang.String	sqlIntArrayFuncReg
static java.lang.String	sqlRandomAgg
static java.lang.String	sqlTypeConversions

Constructor Summary

SQLMan()

Method Summary

static java.lang.String	andSelCond(java.util.ArrayList<java.lang.String> conds)
static java.lang.String	andSelCond(java.lang.String a, java.lang.String b)
static java.lang.String	escapeString(java.lang.String s) blue --> E'blue' John's hat --> E'John\'s hat' key\tdata --> E'key\tdata'
static java.lang.String	funcHead(java.lang.String pname)
static java.lang.String	funcTail()
static java.lang.String	indexName(java.lang.String object, java.lang.String tag)
static java.lang.String	negSelCond(java.lang.String cond)
static java.lang.String	orSelCond(java.util.ArrayList<java.lang.String> conds)
static java.lang.String	orSelCond(java.lang.String a, java.lang.String b)
static java.lang.String	procName(java.lang.String object, java.lang.String tag)
static java.lang.String	procTail()
static java.lang.String	seqCurr(java.lang.String seq)
static java.lang.String	seqName(java.lang.String object)
static java.lang.String	seqNext(java.lang.String seq)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

sqlTypeConversions

public static java.lang.String sqlTypeConversions

sqlFuncMisc

public static java.lang.String sqlFuncMisc

sqlRandomAgg

public static java.lang.String sqlRandomAgg

sqlIntArrayFuncReg

public static java.lang.String sqlIntArrayFuncReg

Constructor Detail

SQLMan

public SQLMan()

Method Detail

escapeString

public static java.lang.String escapeString(java.lang.String s)

blue --> E'blue' John's hat --> E'John\'s hat' key\tdata --> E'key\tdata'

Parameters:

s -

procTail

public static java.lang.String procTail()

seqNext

public static java.lang.String seqNext(java.lang.String seq)

seqCurr

public static java.lang.String seqCurr(java.lang.String seq)

funcHead

public static java.lang.String funcHead(java.lang.String pname)

funcTail

public static java.lang.String funcTail()

indexName

public static java.lang.String indexName(java.lang.String object,
                                         java.lang.String tag)

seqName

public static java.lang.String seqName(java.lang.String object)

procName

public static java.lang.String procName(java.lang.String object,
                                        java.lang.String tag)

negSelCond

public static java.lang.String negSelCond(java.lang.String cond)

andSelCond

public static java.lang.String andSelCond(java.lang.String a,
                                          java.lang.String b)

orSelCond

public static java.lang.String orSelCond(java.lang.String a,
                                         java.lang.String b)

andSelCond

public static java.lang.String andSelCond(java.util.ArrayList<java.lang.String> conds)

orSelCond

public static java.lang.String orSelCond(java.util.ArrayList<java.lang.String> conds)