Package liquibase.sqlgenerator.core

Class InsertOrUpdateGeneratorSQLite

java.lang.Object

liquibase.sqlgenerator.core.AbstractSqlGenerator<InsertOrUpdateStatement>

liquibase.sqlgenerator.core.InsertOrUpdateGenerator

liquibase.sqlgenerator.core.InsertOrUpdateGeneratorSQLite

All Implemented Interfaces:

PrioritizedService, SqlGenerator<InsertOrUpdateStatement>

public class InsertOrUpdateGeneratorSQLite
extends InsertOrUpdateGenerator

Adds an ON CONFLICT REPLACE clause to an INSERT INTO ... statement for SQLite.

Field Summary

Fields inherited from interface liquibase.servicelocator.PrioritizedService

COMPARATOR

Fields inherited from interface liquibase.sqlgenerator.SqlGenerator

EMPTY_SQL, PRIORITY_DATABASE, PRIORITY_DEFAULT

Constructor Summary

Constructors

Constructor	Description
InsertOrUpdateGeneratorSQLite()

Method Summary

Modifier and Type	Method	Description
protected String	getElse(Database database)
protected String	getInsertStatement(InsertOrUpdateStatement insertOrUpdateStatement, Database database, SqlGeneratorChain sqlGeneratorChain)
protected String	getRecordCheck(InsertOrUpdateStatement insertOrUpdateStatement, Database database, String whereClause)
protected String	getUpdateStatement(InsertOrUpdateStatement insertOrUpdateStatement, Database database, String whereClause, SqlGeneratorChain sqlGeneratorChain)	Generates an SQL UPDATE statement for the specified insert or update statement, database, and SQL generator chain.
boolean	supports(InsertOrUpdateStatement statement, Database database)	Does this generator support the given statement/database combination?

Methods inherited from class liquibase.sqlgenerator.core.InsertOrUpdateGenerator

generateSql, getAffectedTable, getPostUpdateStatements, getPriority, getWhereClause, validate

Methods inherited from class liquibase.sqlgenerator.core.AbstractSqlGenerator

generateRollbackStatementsIsVolatile, generateStatementsIsVolatile, looksLikeFunctionCall, warn

Methods inherited from class java.lang.Object

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

Constructor Details

InsertOrUpdateGeneratorSQLite

public InsertOrUpdateGeneratorSQLite()

Method Details

supports

public boolean supports(InsertOrUpdateStatement statement,
 Database database)

Description copied from interface: SqlGenerator

Does this generator support the given statement/database combination? Do not validate the statement with this method, only return if it can support it.

Specified by:

supports in interface SqlGenerator<InsertOrUpdateStatement>

Overrides:

supports in class AbstractSqlGenerator<InsertOrUpdateStatement>

getInsertStatement

protected String getInsertStatement(InsertOrUpdateStatement insertOrUpdateStatement,
 Database database,
 SqlGeneratorChain sqlGeneratorChain)

Overrides:

getInsertStatement in class InsertOrUpdateGenerator

getUpdateStatement

protected String getUpdateStatement(InsertOrUpdateStatement insertOrUpdateStatement,
 Database database,
 String whereClause,
 SqlGeneratorChain sqlGeneratorChain)

Description copied from class: InsertOrUpdateGenerator

Generates an SQL UPDATE statement for the specified insert or update statement, database, and SQL generator chain.

Overrides:

getUpdateStatement in class InsertOrUpdateGenerator

Parameters:

insertOrUpdateStatement - the insert or update statement to generate the update statement from

database - the database to generate the update statement for

whereClause - the WHERE clause to use in the update statement

sqlGeneratorChain - the SQL generator chain to use in the update statement

Returns:

the generated update statement, or null if there is nothing to update

getRecordCheck

protected String getRecordCheck(InsertOrUpdateStatement insertOrUpdateStatement,
 Database database,
 String whereClause)

Specified by:

getRecordCheck in class InsertOrUpdateGenerator

getElse

protected String getElse(Database database)

Specified by:

getElse in class InsertOrUpdateGenerator