1. class
  2. local_middag
  3. \
  4. framework
  5. \
  6. infrastructure
  7. \
  8. search_engine
  9. \
  10. sql_generator

sql_generator

class sql_generator

internal  
 

SQL generator for query conditions.

Translates abstract Query Conditions (field + operator + value) into Moodle-compatible SQL fragments. Table-agnostic and reusable across repositories.

Methods

array
compile_condition(string $column, operator $op, mixed $value, mixed $value2, string $param_prefix)

Compile a single SQL condition based on Operator Enum.

Details

at line 47
array compile_condition(string $column, operator $op, mixed $value, mixed $value2, string $param_prefix)

Compile a single SQL condition based on Operator Enum.

Parameters

string $column

SQL column reference
operator $op

Enum Operator
mixed $value

Primary value
mixed $value2

Secondary value (for BETWEEN)
string $param_prefix

Unique prefix for parameter names

Return Value

array

Exceptions

coding_exception