SqlExecutor

Full name JSql.Engine.SqlExecutor Assembly JSql Members 11

executes parsed sql statements against the file based storage layer

01 Syntax

JSql.Engine.SqlExecutor

02 Methods

Name	Overloads	Summary
NarrowByIndex	1	use the column search index to narrow the candidate rows before the full WHERE expression is evaluated; returns the full row list when no usable index exists.
RewriteAliases	1	mysql resolves a bare identifier in HAVING against the output column aliases first, so the alias is rewritten into its projection expression here.
ExecuteCheckpoint	1	CHECKPOINT [TABLE t]: merge the pending write ahead log of the table(s) back into the jsonl data file.
ExecuteSelect	1
ExecuteInsert	1
ExecuteUpdate	1
ExecuteDelete	1
ExecuteCreate	1
ExecuteDrop	1
ExecuteUse	1
ExecuteShow	1

03 Members

method NarrowByIndex #

NarrowByIndex(String, String, StoredTable, Expression, Boolean)

use the column search index to narrow the candidate rows before the full WHERE expression is evaluated; returns the full row list when no usable index exists.

method RewriteAliases #

RewriteAliases(Expression, List(Of SelectItem), HashSet(Of String))

mysql resolves a bare identifier in HAVING against the output column aliases first, so the alias is rewritten into its projection expression here.

method ExecuteCheckpoint #

ExecuteCheckpoint(CheckpointStatement)

CHECKPOINT [TABLE t]: merge the pending write ahead log of the table(s) back into the jsonl data file.

method ExecuteSelect #

ExecuteSelect(SelectStatement)

method ExecuteInsert #

ExecuteInsert(InsertStatement)

method ExecuteUpdate #

ExecuteUpdate(UpdateStatement)