AbstractSqlCmds (General SQL Parser Java Library Core 4.1.0.5 API)

Object
- gudusoft.gsqlparser.sqlcmds.AbstractSqlCmds

All Implemented Interfaces:

ISqlCmds

Direct Known Subclasses:

TSqlCmdsAthena, TSqlCmdsBigquery, TSqlCmdsClickhouse, TSqlCmdsCouchbase, TSqlCmdsDatabricks, TSqlCmdsDb2, TSqlCmdsDoris, TSqlCmdsFlink, TSqlCmdsGaussdb, TSqlCmdsGreenplum, TSqlCmdsHana, TSqlCmdsHive, TSqlCmdsInformix, TSqlCmdsMdx, TSqlCmdsMssql, TSqlCmdsMysql, TSqlCmdsNetezza, TSqlCmdsOdbc, TSqlCmdsOpenedge, TSqlCmdsOracle, TSqlCmdsPostgresql, TSqlCmdsPresto, TSqlCmdsRedshift, TSqlCmdsSnowflake, TSqlCmdsSoql, TSqlCmdsSparksql, TSqlCmdsSqlite, TSqlCmdsStarrocks, TSqlCmdsSybase, TSqlCmdsTeradata, TSqlCmdsTrino, TSqlCmdsVertica
```
public abstract class AbstractSqlCmds
extends Object
implements ISqlCmds
```
Abstract base class for vendor-specific SQL command resolvers. Provides common functionality and the TSqlCmd/TSqlCmdList infrastructure that all vendor implementations share.

Since:

3.1.0.9

Field Summary

Fields
Modifier and Type	Field and Description
`protected ESqlStatementType`	`gnewsqlstatementtype` Temporary field for tracking statement type during issql() processing.
`protected boolean`	`initialized`
`protected Object`	`initLock`
`protected TSqlCmdList`	`sqlCmdList`
`protected EDbVendor`	`vendor`

Constructor Summary

Constructors
Modifier Constructor and Description

protected AbstractSqlCmds(EDbVendor vendor)
Constructor for vendor-specific implementation.

Constructors
Modifier	Constructor and Description
`protected`	`AbstractSqlCmds(EDbVendor vendor)` Constructor for vendor-specific implementation.

Method Summary

All Methods Instance Methods Abstract Methods Concrete Methods
Modifier and Type	Method and Description
`protected void`	`addCmd(int token1, ESqlStatementType stmtType)` Overloaded helper for simpler commands.
`protected void`	`addCmd(int token1, String token2, ESqlStatementType stmtType)`
`protected void`	`addCmd(int token1, String token2, String token3, ESqlStatementType stmtType)`
`protected void`	`addCmd(int token1, String token2, String token3, String token4, ESqlStatementType stmtType)`
`protected void`	`addCmd(int token1, String token2, String token3, String token4, String token5, ESqlStatementType stmtType)`
`protected void`	`addCmd(int token1, String token2, String token3, String token4, String token5, String token6, ESqlStatementType stmtType)`
`protected void`	`addCmd(int token1, String token2, String token3, String token4, String token5, String token6, String token7, ESqlStatementType stmtType)`
`protected void`	`addCmd(int token1, String token2, String token3, String token4, String token5, String token6, String token7, String token8, ESqlStatementType stmtType)` Helper method to add a command to the list.
`protected void`	`ensureInitialized()` Ensures command list is initialized using double-checked locking.
`protected TCustomSqlStatement`	`findcte(TSourceToken ptoken)` Detect Common Table Expression (CTE) for all database vendors.
`protected TSqlCmd`	`finddbcmd(TSourceToken pcst, TSqlCmdList cmdList)` Find command in the list starting from a specific token.
`TSqlCmdList`	`getSqlCmdList()` Gets the command list for this vendor (for compatibility and debugging).
`ESqlStatementType`	`getStatementTypeForToken(TSourceToken token)` Finds SQL command type for yacc parser integration.
`protected String`	`getToken1Str(int token1)` Get the string representation for vendor-specific token codes.
`EDbVendor`	`getVendor()` Gets the vendor this command resolver handles.
`protected abstract void`	`initializeCommands()` Initialize vendor-specific commands.

Methods inherited from class Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface gudusoft.gsqlparser.sqlcmds.ISqlCmds
issql

Field Detail

vendor
```
protected EDbVendor vendor
```

sqlCmdList

protected volatile TSqlCmdList sqlCmdList

initLock
```
protected final Object initLock
```

initialized
```
protected volatile boolean initialized
```

gnewsqlstatementtype
```
protected ESqlStatementType gnewsqlstatementtype
```
Temporary field for tracking statement type during issql() processing. Used by both findcte() and issql() methods.

Constructor Detail
- AbstractSqlCmds
```
protected AbstractSqlCmds(EDbVendor vendor)
```
  Constructor for vendor-specific implementation.
  
  Parameters:
  
  vendor - Database vendor this resolver handles

Method Detail

getVendor
```
public EDbVendor getVendor()
```
Description copied from interface: ISqlCmds

Gets the vendor this command resolver handles.

Specified by:

getVendor in interface ISqlCmds

Returns:

Database vendor

getSqlCmdList
```
public TSqlCmdList getSqlCmdList()
```
Description copied from interface: ISqlCmds

Gets the command list for this vendor (for compatibility and debugging).

Specified by:

getSqlCmdList in interface ISqlCmds

Returns:

Command list containing all recognized commands

ensureInitialized
```
protected void ensureInitialized()
```
Ensures command list is initialized using double-checked locking. This provides thread-safe lazy initialization.

initializeCommands
```
protected abstract void initializeCommands()
```
Initialize vendor-specific commands. Subclasses must implement this to populate sqlCmdList.

addCmd

protected void addCmd(int token1,
                      String token2,
                      String token3,
                      String token4,
                      String token5,
                      String token6,
                      String token7,
                      String token8,
                      ESqlStatementType stmtType)

Helper method to add a command to the list. Simplifies command initialization in subclasses.

Parameters:: token1 - First token (keyword); token2 - Second token pattern; token3 - Third token pattern; token4 - Fourth token pattern; token5 - Fifth token pattern; token6 - Sixth token pattern; token7 - Seventh token pattern; token8 - Eighth token pattern; stmtType - Statement type

getToken1Str
```
protected String getToken1Str(int token1)
```
Get the string representation for vendor-specific token codes. Subclasses should override this method to provide mappings for vendor-specific reserved words (tokens > TBaseType.rrw_abort).

Parameters:

token1 - Token code

Returns:

String representation of the token, or null if not applicable

addCmd

protected void addCmd(int token1,
                      ESqlStatementType stmtType)

Overloaded helper for simpler commands.

addCmd

protected void addCmd(int token1,
                      String token2,
                      ESqlStatementType stmtType)

addCmd

protected void addCmd(int token1,
                      String token2,
                      String token3,
                      ESqlStatementType stmtType)

addCmd

protected void addCmd(int token1,
                      String token2,
                      String token3,
                      String token4,
                      ESqlStatementType stmtType)

addCmd

protected void addCmd(int token1,
                      String token2,
                      String token3,
                      String token4,
                      String token5,
                      ESqlStatementType stmtType)

addCmd

protected void addCmd(int token1,
                      String token2,
                      String token3,
                      String token4,
                      String token5,
                      String token6,
                      ESqlStatementType stmtType)

addCmd

protected void addCmd(int token1,
                      String token2,
                      String token3,
                      String token4,
                      String token5,
                      String token6,
                      String token7,
                      ESqlStatementType stmtType)

finddbcmd
```
protected TSqlCmd finddbcmd(TSourceToken pcst,
                            TSqlCmdList cmdList)
```
Find command in the list starting from a specific token. This is the core search algorithm used by all vendors.

Parameters:

pcst - Starting token

cmdList - Command list to search

Returns:

Found command or null

getStatementTypeForToken
```
public ESqlStatementType getStatementTypeForToken(TSourceToken token)
```
Description copied from interface: ISqlCmds

Finds SQL command type for yacc parser integration. Used by vendor-specific yacc parsers to identify statement types.

Specified by:

getStatementTypeForToken in interface ISqlCmds

Parameters:

token - Token to analyze

Returns:

SQL statement type, or sstunknown if not recognized

findcte
```
protected TCustomSqlStatement findcte(TSourceToken ptoken)
```
Detect Common Table Expression (CTE) for all database vendors. Handles WITH clauses before DELETE, INSERT, SELECT, UPDATE, MERGE. This is a shared method used by all vendor implementations since CTE syntax is similar across vendors (standardized by SQL:1999).

Parameters:

ptoken - The WITH token

Returns:

Statement object for the CTE query, or null if not a valid CTE

Class AbstractSqlCmds

Field Summary

Constructor Summary

Method Summary

Methods inherited from class Object

Methods inherited from interface gudusoft.gsqlparser.sqlcmds.ISqlCmds

Field Detail

vendor

sqlCmdList

initLock

initialized

gnewsqlstatementtype

Constructor Detail

AbstractSqlCmds

Method Detail

getVendor

getSqlCmdList

ensureInitialized

initializeCommands

addCmd

getToken1Str

addCmd

addCmd

addCmd

addCmd

addCmd

addCmd

addCmd

finddbcmd

getStatementTypeForToken

findcte