TInsertSqlStatement (gudusoft.gsqlparser 2.0.1.0 API)

java.lang.Object
- gudusoft.gsqlparser.nodes.TParseTreeNode
- - gudusoft.gsqlparser.TCustomSqlStatement
  - - gudusoft.gsqlparser.stmt.TInsertSqlStatement

All Implemented Interfaces:

Visitable
```
public class TInsertSqlStatement
extends TCustomSqlStatement
```
SQL insert statement.

TCustomSqlStatement.getTargetTable() returns the table or view that receive the data.
getColumnList() returns the list of columns in target table if specified.
Usually, the data comes from a value clause, you can get those values from getValues().
Always checking getInsertSource() before fetch the data source which may various from value clause to subquery and other forms. Below are some data source types:
- EInsertSource.values -> getValues()
- EInsertSource.subquery -> getSubQuery()
Examples:
```
 INSERT INTO Production.UnitMeasure (Name, UnitMeasureCode,ModifiedDate)
 VALUES (N'Square Yards', N'Y2', GETDATE());
 
```
Table name: Production.UnitMeasure. Fetched from TCustomSqlStatement.getTargetTable() or the first element of TCustomSqlStatement.tables
column list: (Name, UnitMeasureCode,ModifiedDate). Fetch from getColumnList()
value list: (N'Square Yards', N'Y2', GETDATE()). Fetch from getValues()
```
 INSERT INTO dbo.EmployeeSales
 SELECT 'SELECT', sp.BusinessEntityID, c.LastName, sp.SalesYTD
 FROM Sales.SalesPerson AS sp
 INNER JOIN Person.Person AS c
 ON sp.BusinessEntityID = c.BusinessEntityID
 WHERE sp.BusinessEntityID LIKE '2%'
 ORDER BY sp.BusinessEntityID, c.LastName;
 
```
select query in above insert statement can be fetched from getSubQuery()
See Also:

TCustomSqlStatement.cteList, TCustomSqlStatement.targetTable, TCustomSqlStatement.outputClause, TCustomSqlStatement.returningClause

Field Summary
- Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement
  dbvendor, dummytag, isparsed, joins, parser, plsqlparser, rootNode, sourcetokenlist, sqlstatementtype, tables

Constructor Summary

Constructors
Constructor and Description

TInsertSqlStatement(EDbVendor dbvendor)

Constructors
Constructor and Description
`TInsertSqlStatement(EDbVendor dbvendor)`

Method Summary

All Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`void`	`accept(TParseTreeVisitor v)` Accept a visitor
`void`	`acceptChildren(TParseTreeVisitor v)` Accept a visitor to iterate this class and sub-nodes of this class
`int`	`doParseStatement(TCustomSqlStatement psql)`
`TObjectNameList`	`getColumnList()` columns of the target table.
`TObjectName`	`getDirectoryName()` Hive directory name
`TPTNodeList<TInsertIntoValue>`	`getElseIntoValues()` Oracle, values in else clause
`TErrorLoggingClause`	`getErrorLoggingClause()` Oracle error logging clause
`TMssqlExecute`	`getExecuteStmt()` SQL Server, execute statement used in the insert statement.
`TFunctionCall`	`getFunctionCall()` value clause valid when `getInsertSource()` is `EInsertSource.values_function`.
`EHiveInsertType`	`getHiveInsertType()` Hive insert type
`TSourceToken`	`getIgnore()` IGNORE keyword used in the insert statement.
`TPTNodeList<TInsertCondition>`	`getInsertConditions()` Oracle insert condition
`TPTNodeList<TInsertIntoValue>`	`getInsertIntoValues()` Oracle insert into values used after insert all/first clause
`EInsertSource`	`getInsertSource()` Type of the source from where the data is coming for this insert statement.
`TSourceToken`	`getInsertToken()` INSERT keyword
`TResultColumnList`	`getOnDuplicateKeyUpdate()` MySQL on duplicate key update column list.
`TSourceToken`	`getPriority_delayed()` DELAY, LOW_PRIORITY, HIGH_PRIORITY keyword used in insert statement.
`TObjectName`	`getRecordName()` Oracle PLSQL record name in values clause, `getInsertSource()` returns `EInsertSource.values_oracle_record`
`TResultColumnList`	`getSetColumnValues()` set column value clauses in MySQL insert statement.
`TSelectSqlStatement`	`getSubQuery()` value clause valid when `getInsertSource()` is `EInsertSource.subquery`.
`TMultiTargetList`	`getValues()` value clause, valid when `getInsertSource()` is `EInsertSource.values`.
`int`	`getValueType()` Deprecated. As of v1.6.4.9, use `getInsertSource()` instead.
`boolean`	`isInsertAll()` Oracle insert all
`boolean`	`isInsertFirst()` Oracle insert first
`void`	`setColumnList(TObjectNameList columnList)`
`void`	`setDirectoryName(TObjectName directoryName)`
`void`	`setErrorLoggingClause(TErrorLoggingClause errorLoggingClause)`
`void`	`setExecuteStmt(TMssqlExecute executeStmt)`
`void`	`setFunctionCall(TFunctionCall functionCall)`
`void`	`setHiveInsertType(EHiveInsertType hiveInsertType)`
`void`	`setInsertAll(boolean insertAll)`
`void`	`setInsertConditions(TPTNodeList<TInsertCondition> insertConditions)`
`void`	`setInsertFirst(boolean insertFirst)`
`void`	`setInsertIntoValues(TPTNodeList<TInsertIntoValue> insertIntoValues)`
`void`	`setInsertSource(EInsertSource insertSource)`
`void`	`setInsertToken(TSourceToken insertToken)`
`void`	`setOnDuplicateKeyUpdate(TResultColumnList onDuplicateKeyUpdate)`
`void`	`setRecordName(TObjectName recordName)`
`void`	`setSetColumnValues(TResultColumnList setColumnValues)`
`void`	`setSubQuery(TSelectSqlStatement subQuery)`
`void`	`setValues(TMultiTargetList values)`
`void`	`setValueType(int valueType)`

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement
addToTables, addWhereClause, analyzeFromTable, analyzeJoin, analyzeTablename, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, clearError, dochecksyntax, findTable, fireOnMetaDatabaseTableColumn, getAncestorStmt, getCteList, getDaxFunctionStack, getEndlabelName, getErrorCount, getFirstPhysicalTable, getIndexColumns, getJoins, getLabelName, getOrphanColumns, getOutputClause, getParentStmt, getResultColumnList, getReturningClause, getStatements, getSymbolTable, getTables, getTargetTable, getTopClause, getTopStatement, getVariableStack, getWhereClause, isnzplsql, isoracleplsql, ispgplsql, isTableACTE, isverticaplsql, linkColumnReferenceToTable, linkColumnToTable, linkToFirstTable, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parseerrormessagehandle, parsestatement, searchCTEList, searchDaxVariableInStack, setCteList, setEndlabelName, setLabelName, setOutputClause, setParentStmt, setResultColumnList, setReturningClause, setTargetTable, setTopClause, setVariableStack, setWhereClause, VerticaStatementCanBeSeparatedByBeginEndPair

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode
addAllMyTokensToTokenList, appendString, doParse, fastSetString, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, init, init, removeAllMyTokensFromTokenList, setDummyTag, setEndToken, setEndToken, setEndToken, setEndToken, setGsqlparser, setIncludingComment, setNodeType, setStartToken, setStartToken, setStartToken, setStartToken, setString, toScript, toString

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - TInsertSqlStatement
```
public TInsertSqlStatement(EDbVendor dbvendor)
```
- Method Detail
  - setInsertAll
```
public void setInsertAll(boolean insertAll)
```
  - setInsertFirst
```
public void setInsertFirst(boolean insertFirst)
```
  - isInsertAll
```
public boolean isInsertAll()
```
    Oracle insert all
    
    Returns:
    
    Oracle insert all
  - isInsertFirst
```
public boolean isInsertFirst()
```
    Oracle insert first
    
    Returns:
    
    Oracle insert first
  - getErrorLoggingClause
```
public TErrorLoggingClause getErrorLoggingClause()
```
    Oracle error logging clause
    
    Returns:
    
    Oracle error logging clause
  - getHiveInsertType
```
public EHiveInsertType getHiveInsertType()
```
    Hive insert type
    
    Returns:
    
    Hive insert type
  - getDirectoryName
```
public TObjectName getDirectoryName()
```
    Hive directory name
    
    Returns:
    
    directory name
  - getInsertConditions
```
public TPTNodeList<TInsertCondition> getInsertConditions()
```
    Oracle insert condition
    
    Returns:
    
    Oracle insert condition
  - getInsertIntoValues
```
public TPTNodeList<TInsertIntoValue> getInsertIntoValues()
```
    Oracle insert into values used after insert all/first clause
    
    Returns:
    
    Oracle insert into values used after insert all/first clause
  - setInsertToken
```
public void setInsertToken(TSourceToken insertToken)
```
  - getInsertToken
```
public TSourceToken getInsertToken()
```
    INSERT keyword
    
    Returns:
    
    INSERT keyword
  - getSubQuery
```
public TSelectSqlStatement getSubQuery()
```
    value clause valid when getInsertSource() is EInsertSource.subquery.
    
    Returns:
    
    sub-query
  - getFunctionCall
```
public TFunctionCall getFunctionCall()
```
    value clause valid when getInsertSource() is EInsertSource.values_function.
    
    Returns:
    
    row value was constructed by a function.
  - getRecordName
```
public TObjectName getRecordName()
```
    Oracle PLSQL record name in values clause, getInsertSource() returns EInsertSource.values_oracle_record
    
    Returns:
    
    record name in plsql.
  - getInsertSource
```
public EInsertSource getInsertSource()
```
    Type of the source from where the data is coming for this insert statement.
    
    Returns:
    
    Type of the data source
  - getValueType
```
public int getValueType()
```
    Deprecated. As of v1.6.4.9, use getInsertSource() instead.
    
    Returns:
    
    how rows was insert into table. value can be one of
    vt_values, getValues()
    vt_values_empty, syntax like: value ()
    vt_query, getSubQuery()
    vt_default_values,
    vt_execute,
    vt_values_function, getFunctionCall()
  - getValues
```
public TMultiTargetList getValues()
```
    value clause, valid when getInsertSource() is EInsertSource.values. represents in format like this: ((1,2,3),(4,5),(6,7,8)), if even value clause is (1,2,3), it will be saved in TMultiTargetList like ((1,2,3))
    
    Returns:
    
    a single row value, or multi row values returned by query or value constructor.
  - getOnDuplicateKeyUpdate
```
public TResultColumnList getOnDuplicateKeyUpdate()
```
    MySQL on duplicate key update column list.
    
    Returns:
    
    MySQL on duplicate key update column list
  - getIgnore
```
public TSourceToken getIgnore()
```
    IGNORE keyword used in the insert statement.
    
    Returns:
    
    IGNORE keyword if used, otherwise, returns null.
  - getPriority_delayed
```
public TSourceToken getPriority_delayed()
```
    DELAY, LOW_PRIORITY, HIGH_PRIORITY keyword used in insert statement.
    
    Returns:
    
    null if none of those keywords is used: DELAY, LOW_PRIORITY, HIGH_PRIORITY
  - getSetColumnValues
```
public TResultColumnList getSetColumnValues()
```
    set column value clauses in MySQL insert statement.
    
    Returns:
    
    MySQL specific column value list.
  - getColumnList
```
public TObjectNameList getColumnList()
```
    columns of the target table.
    
    Returns:
    
    column name list in insert into clause.
  - setValues
```
public void setValues(TMultiTargetList values)
```
  - setColumnList
```
public void setColumnList(TObjectNameList columnList)
```
  - setSubQuery
```
public void setSubQuery(TSelectSqlStatement subQuery)
```
  - getExecuteStmt
```
public TMssqlExecute getExecuteStmt()
```
    SQL Server, execute statement used in the insert statement. getInsertSource() returns EInsertSource.execute
    
    Returns:
    
    SQL Server, execute statement
  - getElseIntoValues
```
public TPTNodeList<TInsertIntoValue> getElseIntoValues()
```
    Oracle, values in else clause
    
    Returns:
    
    values in else clause
  - doParseStatement
```
public int doParseStatement(TCustomSqlStatement psql)
```
    Overrides:
    
    doParseStatement in class TCustomSqlStatement
  - accept
```
public void accept(TParseTreeVisitor v)
```
    Description copied from class: TParseTreeNode
    
    Accept a visitor
    
    Specified by:
    
    accept in interface Visitable
    
    Overrides:
    
    accept in class TParseTreeNode
    
    Parameters:
    
    v - visitor is a descendant class of TParseTreeVisitor
  - acceptChildren
```
public void acceptChildren(TParseTreeVisitor v)
```
    Description copied from class: TParseTreeNode
    
    Accept a visitor to iterate this class and sub-nodes of this class
    
    Specified by:
    
    acceptChildren in interface Visitable
    
    Overrides:
    
    acceptChildren in class TParseTreeNode
    
    Parameters:
    
    v - visitor is a descendant class of TParseTreeVisitor
  - setErrorLoggingClause
```
public void setErrorLoggingClause(TErrorLoggingClause errorLoggingClause)
```
  - setHiveInsertType
```
public void setHiveInsertType(EHiveInsertType hiveInsertType)
```
  - setDirectoryName
```
public void setDirectoryName(TObjectName directoryName)
```
  - setInsertConditions
```
public void setInsertConditions(TPTNodeList<TInsertCondition> insertConditions)
```
  - setInsertIntoValues
```
public void setInsertIntoValues(TPTNodeList<TInsertIntoValue> insertIntoValues)
```
  - setFunctionCall
```
public void setFunctionCall(TFunctionCall functionCall)
```
  - setExecuteStmt
```
public void setExecuteStmt(TMssqlExecute executeStmt)
```
  - setRecordName
```
public void setRecordName(TObjectName recordName)
```
  - setInsertSource
```
public void setInsertSource(EInsertSource insertSource)
```
  - setValueType
```
public void setValueType(int valueType)
```
  - setSetColumnValues
```
public void setSetColumnValues(TResultColumnList setColumnValues)
```
  - setOnDuplicateKeyUpdate
```
public void setOnDuplicateKeyUpdate(TResultColumnList onDuplicateKeyUpdate)
```

Class TInsertSqlStatement

Field Summary

Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement

Constructor Summary

Method Summary

Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement

Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode

Methods inherited from class java.lang.Object

Constructor Detail

TInsertSqlStatement

Method Detail

setInsertAll

setInsertFirst

isInsertAll

isInsertFirst

getErrorLoggingClause

getHiveInsertType

getDirectoryName

getInsertConditions

getInsertIntoValues

setInsertToken

getInsertToken

getSubQuery

getFunctionCall

getRecordName

getInsertSource

getValueType

getValues

getOnDuplicateKeyUpdate

getIgnore

getPriority_delayed

getSetColumnValues

getColumnList

setValues

setColumnList

setSubQuery

getExecuteStmt

getElseIntoValues

doParseStatement

accept

acceptChildren

setErrorLoggingClause

setHiveInsertType

setDirectoryName

setInsertConditions

setInsertIntoValues

setFunctionCall

setExecuteStmt

setRecordName

setInsertSource

setValueType

setSetColumnValues

setOnDuplicateKeyUpdate