Class: abstract SqlRewriter

A SqlVisitor for persistently rewriting SQL trees. This class provides methods for visiting different types of SQL nodes and rewriting them.

Extends

• SqlVisitor<SqlNode>

Constructors

new SqlRewriter()

new SqlRewriter(): SqlRewriter

Returns

SqlRewriter

Inherited from

SqlVisitor.constructor

Methods

beforeVisit()

protected beforeVisit(node: SqlNode): void

Parameters

Parameter	Type
node	SqlNode

Returns

void

Defined in

packages/verse-core/src/db/rewriter.ts:67

---

rewriteList()

rewriteList<T>(list?: List<T>): undefined | List<T>

Type Parameters

Type Parameter
T extends SqlNode

Parameters

Parameter	Type
list?	List<T>

Returns

undefined | List<T>

Defined in

packages/verse-core/src/db/rewriter.ts:323

---

rewriteProjection()

rewriteProjection(projection: SqlNode): SqlNode

Parameters

Parameter	Type
projection	SqlNode

Returns

SqlNode

Defined in

packages/verse-core/src/db/rewriter.ts:319

---

visitAddColumn()

visitAddColumn(addColumn: SqlAddColumn): SqlNode

Parameters

Parameter	Type
addColumn	SqlAddColumn

Returns

SqlNode

Overrides

SqlVisitor.visitAddColumn

Defined in

packages/verse-core/src/db/rewriter.ts:169

---

visitAddForeignKey()

visitAddForeignKey(addConstraint: SqlAddForeignKey): SqlNode

Parameters

Parameter	Type
addConstraint	SqlAddForeignKey

Returns

SqlNode

Overrides

SqlVisitor.visitAddForeignKey

Defined in

packages/verse-core/src/db/rewriter.ts:289

---

visitAddPrimaryKey()

visitAddPrimaryKey(addPrimaryKey: SqlAddPrimaryKey): SqlAddPrimaryKey

Parameters

Parameter	Type
addPrimaryKey	SqlAddPrimaryKey

Returns

SqlAddPrimaryKey

Overrides

SqlVisitor.visitAddPrimaryKey

Defined in

packages/verse-core/src/db/rewriter.ts:179

---

visitAlias()

visitAlias(alias: SqlAlias): SqlNode

Parameters

Parameter	Type
alias	SqlAlias

Returns

SqlNode

Overrides

SqlVisitor.visitAlias

Defined in

packages/verse-core/src/db/rewriter.ts:74

---

visitAlterColumn()

visitAlterColumn(alterColumn: SqlAlterColumn): SqlNode

Parameters

Parameter	Type
alterColumn	SqlAlterColumn

Returns

SqlNode

Overrides

SqlVisitor.visitAlterColumn

Defined in

packages/verse-core/src/db/rewriter.ts:174

---

visitBinary()

visitBinary(binary: SqlBinary): SqlNode

Parameters

Parameter	Type
binary	SqlBinary

Returns

SqlNode

Overrides

SqlVisitor.visitBinary

Defined in

packages/verse-core/src/db/rewriter.ts:84

---

visitBoolean()

visitBoolean(boolean: SqlBoolean): SqlNode

Parameters

Parameter	Type
boolean	SqlBoolean

Returns

SqlNode

Overrides

SqlVisitor.visitBoolean

Defined in

packages/verse-core/src/db/rewriter.ts:254

---

visitCase()

visitCase(cas: SqlCase): SqlNode

Parameters

Parameter	Type
cas	SqlCase

Returns

SqlNode

Overrides

SqlVisitor.visitCase

Defined in

packages/verse-core/src/db/rewriter.ts:314

---

visitColumn()

visitColumn(column: SqlColumn): SqlNode

Parameters

Parameter	Type
column	SqlColumn

Returns

SqlNode

Overrides

SqlVisitor.visitColumn

Defined in

packages/verse-core/src/db/rewriter.ts:194

---

visitComposite()

visitComposite(composite: SqlComposite): SqlNode

Parameters

Parameter	Type
composite	SqlComposite

Returns

SqlNode

Overrides

SqlVisitor.visitComposite

Defined in

packages/verse-core/src/db/rewriter.ts:119

---

visitCreateDatabase()

visitCreateDatabase(createDatabase: SqlCreateDatabase): SqlNode

Parameters

Parameter	Type
createDatabase	SqlCreateDatabase

Returns

SqlNode

Overrides

SqlVisitor.visitCreateDatabase

Defined in

packages/verse-core/src/db/rewriter.ts:124

---

visitCreateIndex()

visitCreateIndex(createIndex: SqlCreateIndex): SqlNode

Parameters

Parameter	Type
createIndex	SqlCreateIndex

Returns

SqlNode

Overrides

SqlVisitor.visitCreateIndex

Defined in

packages/verse-core/src/db/rewriter.ts:159

---

visitCreateSequence()

visitCreateSequence(createSequence: SqlCreateSequence): SqlNode

Parameters

Parameter	Type
createSequence	SqlCreateSequence

Returns

SqlNode

Overrides

SqlVisitor.visitCreateSequence

Defined in

packages/verse-core/src/db/rewriter.ts:149

---

visitCreateTable()

visitCreateTable(createTable: SqlCreateTable): SqlCreateTable

Parameters

Parameter	Type
createTable	SqlCreateTable

Returns

SqlCreateTable

Overrides

SqlVisitor.visitCreateTable

Defined in

packages/verse-core/src/db/rewriter.ts:134

---

visitDelete()

visitDelete(_delete: SqlDelete): SqlNode

Parameters

Parameter	Type
_delete	SqlDelete

Returns

SqlNode

Overrides

SqlVisitor.visitDelete

Defined in

packages/verse-core/src/db/rewriter.ts:224

---

visitDropColumn()

visitDropColumn(dropColumn: SqlDropColumn): SqlNode

Parameters

Parameter	Type
dropColumn	SqlDropColumn

Returns

SqlNode

Overrides

SqlVisitor.visitDropColumn

Defined in

packages/verse-core/src/db/rewriter.ts:184

---

visitDropDatabase()

visitDropDatabase(dropDatabase: SqlDropDatabase): SqlNode

Parameters

Parameter	Type
dropDatabase	SqlDropDatabase

Returns

SqlNode

Overrides

SqlVisitor.visitDropDatabase

Defined in

packages/verse-core/src/db/rewriter.ts:129

---

visitDropIndex()

visitDropIndex(dropIndex: SqlDropIndex): SqlNode

Parameters

Parameter	Type
dropIndex	SqlDropIndex

Returns

SqlNode

Overrides

SqlVisitor.visitDropIndex

Defined in

packages/verse-core/src/db/rewriter.ts:164

---

visitDropSequence()

visitDropSequence(dropSequence: SqlDropSequence): SqlNode

Parameters

Parameter	Type
dropSequence	SqlDropSequence

Returns

SqlNode

Overrides

SqlVisitor.visitDropSequence

Defined in

packages/verse-core/src/db/rewriter.ts:154

---

visitDropTable()

visitDropTable(dropTable: SqlDropTable): SqlNode

Parameters

Parameter	Type
dropTable	SqlDropTable

Returns

SqlNode

Overrides

SqlVisitor.visitDropTable

Defined in

packages/verse-core/src/db/rewriter.ts:139

---

visitExists()

visitExists(exists: SqlExists): SqlNode

Parameters

Parameter	Type
exists	SqlExists

Returns

SqlNode

Overrides

SqlVisitor.visitExists

Defined in

packages/verse-core/src/db/rewriter.ts:89

---

visitForeignKey()

visitForeignKey(foreignKey: SqlForeignKey): SqlNode

Parameters

Parameter	Type
foreignKey	SqlForeignKey

Returns

SqlNode

Overrides

SqlVisitor.visitForeignKey

Defined in

packages/verse-core/src/db/rewriter.ts:294

---

visitFunction()

visitFunction(func: SqlFunction): SqlNode

Parameters

Parameter	Type
func	SqlFunction

Returns

SqlNode

Overrides

SqlVisitor.visitFunction

Defined in

packages/verse-core/src/db/rewriter.ts:209

---

visitIdentifier()

visitIdentifier(identifier: SqlIdentifier): SqlNode

Parameters

Parameter	Type
identifier	SqlIdentifier

Returns

SqlNode

Overrides

SqlVisitor.visitIdentifier

Defined in

packages/verse-core/src/db/rewriter.ts:199

---

visitIn()

visitIn(_in: SqlIn): SqlNode

Parameters

Parameter	Type
_in	SqlIn

Returns

SqlNode

Overrides

SqlVisitor.visitIn

Defined in

packages/verse-core/src/db/rewriter.ts:94

---

visitInsert()

visitInsert(insert: SqlInsert): SqlNode

Parameters

Parameter	Type
insert	SqlInsert

Returns

SqlNode

Overrides

SqlVisitor.visitInsert

Defined in

packages/verse-core/src/db/rewriter.ts:214

---

visitIsNotNull()

visitIsNotNull(isNotNull: SqlIsNotNull): SqlNode

Parameters

Parameter	Type
isNotNull	SqlIsNotNull

Returns

SqlNode

Overrides

SqlVisitor.visitIsNotNull

Defined in

packages/verse-core/src/db/rewriter.ts:284

---

visitIsNull()

visitIsNull(isNull: SqlIsNull): SqlNode

Parameters

Parameter	Type
isNull	SqlIsNull

Returns

SqlNode

Overrides

SqlVisitor.visitIsNull

Defined in

packages/verse-core/src/db/rewriter.ts:279

---

visitJoin()

visitJoin(join: SqlJoin): SqlNode

Parameters

Parameter	Type
join	SqlJoin

Returns

SqlNode

Overrides

SqlVisitor.visitJoin

Defined in

packages/verse-core/src/db/rewriter.ts:229

---

visitLike()

visitLike(like: SqlLike): SqlNode

Parameters

Parameter	Type
like	SqlLike

Returns

SqlNode

Overrides

SqlVisitor.visitLike

Defined in

packages/verse-core/src/db/rewriter.ts:99

---

visitMember()

visitMember(member: SqlMember): SqlNode

Parameters

Parameter	Type
member	SqlMember

Returns

SqlNode

Overrides

SqlVisitor.visitMember

Defined in

packages/verse-core/src/db/rewriter.ts:244

---

visitNegation()

visitNegation(negation: SqlNegation): SqlNode

Parameters

Parameter	Type
negation	SqlNegation

Returns

SqlNode

Overrides

SqlVisitor.visitNegation

Defined in

packages/verse-core/src/db/rewriter.ts:109

---

visitNextValue()

visitNextValue(nextValue: SqlNextValue): SqlNode

Parameters

Parameter	Type
nextValue	SqlNextValue

Returns

SqlNode

Overrides

SqlVisitor.visitNextValue

Defined in

packages/verse-core/src/db/rewriter.ts:204

---

visitNode()

visitNode(node: SqlNode): SqlNode

Parameters

Parameter	Type
node	SqlNode

Returns

SqlNode

Overrides

SqlVisitor.visitNode

Defined in

packages/verse-core/src/db/rewriter.ts:62

---

visitNot()

visitNot(not: SqlNot): SqlNode

Parameters

Parameter	Type
not	SqlNot

Returns

SqlNode

Overrides

SqlVisitor.visitNot

Defined in

packages/verse-core/src/db/rewriter.ts:114

---

visitNotLike()

visitNotLike(notLike: SqlNotLike): SqlNode

Parameters

Parameter	Type
notLike	SqlNotLike

Returns

SqlNode

Overrides

SqlVisitor.visitNotLike

Defined in

packages/verse-core/src/db/rewriter.ts:104

---

visitNull()

visitNull(nul: SqlNull): SqlNode

Parameters

Parameter	Type
nul	SqlNull

Returns

SqlNode

Overrides

SqlVisitor.visitNull

Defined in

packages/verse-core/src/db/rewriter.ts:274

---

visitNumber()

visitNumber(n: SqlNumber): SqlNode

Parameters

Parameter	Type
n	SqlNumber

Returns

SqlNode

Overrides

SqlVisitor.visitNumber

Defined in

packages/verse-core/src/db/rewriter.ts:249

---

visitOrderBy()

visitOrderBy(orderBy: SqlOrderBy): SqlNode

Parameters

Parameter	Type
orderBy	SqlOrderBy

Returns

SqlNode

Overrides

SqlVisitor.visitOrderBy

Defined in

packages/verse-core/src/db/rewriter.ts:234

---

visitOrdering()

visitOrdering(ordering: SqlOrdering): SqlNode

Parameters

Parameter	Type
ordering	SqlOrdering

Returns

SqlNode

Overrides

SqlVisitor.visitOrdering

Defined in

packages/verse-core/src/db/rewriter.ts:239

---

visitParameter()

visitParameter(parameter: SqlParameter): SqlNode

Parameters

Parameter	Type
parameter	SqlParameter

Returns

SqlNode

Overrides

SqlVisitor.visitParameter

Defined in

packages/verse-core/src/db/rewriter.ts:259

---

visitRaw()

visitRaw(raw: SqlRaw): SqlNode

Parameters

Parameter	Type
raw	SqlRaw

Returns

SqlNode

Overrides

SqlVisitor.visitRaw

Defined in

packages/verse-core/src/db/rewriter.ts:309

---

visitRenameColumn()

visitRenameColumn(renameColumn: SqlRenameColumn): SqlNode

Parameters

Parameter	Type
renameColumn	SqlRenameColumn

Returns

SqlNode

Overrides

SqlVisitor.visitRenameColumn

Defined in

packages/verse-core/src/db/rewriter.ts:189

---

visitRenameTable()

visitRenameTable(renameTable: SqlRenameTable): SqlNode

Parameters

Parameter	Type
renameTable	SqlRenameTable

Returns

SqlNode

Overrides

SqlVisitor.visitRenameTable

Defined in

packages/verse-core/src/db/rewriter.ts:144

---

visitSelect()

visitSelect(select: SqlSelect): SqlNode

Parameters

Parameter	Type
select	SqlSelect

Returns

SqlNode

Overrides

SqlVisitor.visitSelect

Defined in

packages/verse-core/src/db/rewriter.ts:264

---

visitSet()

visitSet(set: SqlSet): SqlNode

Parameters

Parameter	Type
set	SqlSet

Returns

SqlNode

Overrides

SqlVisitor.visitSet

Defined in

packages/verse-core/src/db/rewriter.ts:69

---

visitStar()

visitStar(star: SqlStar): SqlNode

Parameters

Parameter	Type
star	SqlStar

Returns

SqlNode

Overrides

SqlVisitor.visitStar

Defined in

packages/verse-core/src/db/rewriter.ts:269

---

visitString()

visitString(str: SqlString): SqlNode

Parameters

Parameter	Type
str	SqlString

Returns

SqlNode

Overrides

SqlVisitor.visitString

Defined in

packages/verse-core/src/db/rewriter.ts:299

---

visitTimestamp()

visitTimestamp(timestamp: SqlTimestamp): SqlNode

Parameters

Parameter	Type
timestamp	SqlTimestamp

Returns

SqlNode

Overrides

SqlVisitor.visitTimestamp

Defined in

packages/verse-core/src/db/rewriter.ts:304

---

visitTypeAlias()

visitTypeAlias(typeAlias: SqlTypeAlias): SqlNode

Parameters

Parameter	Type
typeAlias	SqlTypeAlias

Returns

SqlNode

Overrides

SqlVisitor.visitTypeAlias

Defined in

packages/verse-core/src/db/rewriter.ts:79

---

visitUpdate()

visitUpdate(update: SqlUpdate): SqlNode

Parameters

Parameter	Type
update	SqlUpdate

Returns

SqlNode

Overrides

SqlVisitor.visitUpdate

Defined in

packages/verse-core/src/db/rewriter.ts:219