servicenow.community.sql
Class SqlGenerator

java.lang.Object
  extended by servicenow.community.sql.SqlGenerator

public class SqlGenerator
extends java.lang.Object

Generates SQL statements using templates from the sqltemplates.xml file.

Author:
LewisGF

Constructor Summary
SqlGenerator(java.util.Properties props)
           
 
Method Summary
 java.util.List<java.lang.String> getInitializations()
           
 java.lang.String getTemplate(java.lang.String templateName, java.lang.String tableName)
           
 java.lang.String getTemplate(java.lang.String templateName, java.lang.String tableName, java.util.Map<java.lang.String,java.lang.String> vars)
           
 java.lang.String getUser()
           
 java.lang.String glideName(java.lang.String name)
           
 void setDialect(java.lang.String dialect)
           
 void setNameCase(java.lang.String namecase)
           
 void setNameQuotes(java.lang.String namequotes)
           
 void setUser(java.lang.String name)
           
 void setUserCase(java.lang.String usercase)
           
 java.lang.String sqlCase(java.lang.String name)
           
 java.lang.String sqlName(java.lang.String name)
           
 java.lang.String sqlQuote(java.lang.String name)
           
 java.lang.String sqlType(java.lang.String glidetype, int size)
          Return the SQL Type corresponding to a Glide Type
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

SqlGenerator

public SqlGenerator(java.util.Properties props)
             throws java.io.IOException,
                    org.jdom2.JDOMException,
                    PumperException
Throws:
java.io.IOException
org.jdom2.JDOMException
PumperException
Method Detail

setDialect

public void setDialect(java.lang.String dialect)
                throws PumperException
Throws:
PumperException

getInitializations

public java.util.List<java.lang.String> getInitializations()

setNameCase

public void setNameCase(java.lang.String namecase)
                 throws PumperException
Throws:
PumperException

setNameQuotes

public void setNameQuotes(java.lang.String namequotes)
                   throws PumperException
Throws:
PumperException

setUserCase

public void setUserCase(java.lang.String usercase)
                 throws PumperException
Throws:
PumperException

setUser

public void setUser(java.lang.String name)

getUser

public java.lang.String getUser()

sqlCase

public java.lang.String sqlCase(java.lang.String name)

sqlQuote

public java.lang.String sqlQuote(java.lang.String name)

sqlName

public java.lang.String sqlName(java.lang.String name)

glideName

public java.lang.String glideName(java.lang.String name)

sqlType

public java.lang.String sqlType(java.lang.String glidetype,
                                int size)
Return the SQL Type corresponding to a Glide Type


getTemplate

public java.lang.String getTemplate(java.lang.String templateName,
                                    java.lang.String tableName)

getTemplate

public java.lang.String getTemplate(java.lang.String templateName,
                                    java.lang.String tableName,
                                    java.util.Map<java.lang.String,java.lang.String> vars)