SQLiteContext

Classes > Nimblesite.Lql.SQLite > SQLiteContext

Context for building SQLite queries with proper table aliases and structure

public sealed class SQLiteContext : SelectContextBase, ISqlContext

Constructors

SQLiteContext

public SQLiteContext()

Initializes a new instance of the SQLiteContext class

Methods

SetBaseTable(string)

public override void SetBaseTable(string tableName)

Sets the base table for the query

Parameters:

Name Type Description
tableName String The base table name

AddJoin(string, string, string?)

public override void AddJoin(string joinType, string tableName, string? condition)

Adds a JOIN to the query

Parameters:

Name Type Description
joinType String The type of join (INNER JOIN, LEFT JOIN, etc.)
tableName String The table to join
condition String The join condition

GenerateSQL()

public override string GenerateSQL()

Generates the final SQL query

Returns: String - The SQL query string

ProcessPipeline(Pipeline)

public string ProcessPipeline(Pipeline pipeline)

Processes a pipeline and returns the generated SQL

Parameters:

Name Type Description
pipeline Pipeline The pipeline to process

Returns: String - The generated SQLite SQL

ToSQLiteSql(SelectStatement)

public static string ToSQLiteSql(SelectStatement statement)

Public helper to generate SQLite SQL from an existing SelectStatement

Parameters:

Name Type Description
statement SelectStatement The statement to generate SQL for

Returns: String - SQLite SQL string