servicenow.community.sql
Class SqlGenerator
java.lang.Object
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 |
SqlGenerator
public SqlGenerator(java.util.Properties props)
throws java.io.IOException,
org.jdom2.JDOMException,
PumperException
- Throws:
java.io.IOException
org.jdom2.JDOMException
PumperException
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)