neosqlite.collection.expr_evaluator.sql_converters package

Submodules

• neosqlite.collection.expr_evaluator.sql_converters.arithmetic module
  • ArithmeticMixin
    • ArithmeticMixin._convert_arithmetic_operator()
• neosqlite.collection.expr_evaluator.sql_converters.array module
  • ArrayMixin
    • ArrayMixin._convert_array_operator()
    • ArrayMixin._convert_array_transform_operator()
    • ArrayMixin._convert_extreme_n()
• neosqlite.collection.expr_evaluator.sql_converters.base module
  • BaseSqlMixin
    • BaseSqlMixin.data_column
    • BaseSqlMixin.jsonb
    • BaseSqlMixin._current_context
    • BaseSqlMixin.json_each_function
    • BaseSqlMixin.json_group_array_function
    • BaseSqlMixin.json_function_prefix
    • BaseSqlMixin._convert_operand_to_sql()
    • BaseSqlMixin._convert_expr_to_sql()
    • BaseSqlMixin._convert_logical_operator()
    • BaseSqlMixin._convert_comparison_operator()
    • BaseSqlMixin._convert_cmp_operator()
    • BaseSqlMixin._convert_arithmetic_operator()
    • BaseSqlMixin._convert_cond_operator()
    • BaseSqlMixin._convert_ifNull_operator()
    • BaseSqlMixin._convert_switch_operator()
    • BaseSqlMixin._convert_array_transform_operator()
    • BaseSqlMixin._convert_array_operator()
    • BaseSqlMixin._convert_set_operator()
    • BaseSqlMixin._convert_string_operator()
    • BaseSqlMixin._convert_math_operator()
    • BaseSqlMixin._convert_trig_operator()
    • BaseSqlMixin._convert_angle_operator()
    • BaseSqlMixin._convert_date_operator()
    • BaseSqlMixin._convert_date_arithmetic_operator()
    • BaseSqlMixin._convert_date_diff_operator()
    • BaseSqlMixin._convert_date_to_string_operator()
    • BaseSqlMixin._convert_date_trunc_operator()
    • BaseSqlMixin._convert_date_from_parts_operator()
    • BaseSqlMixin._convert_date_to_parts_operator()
    • BaseSqlMixin._convert_date_from_string_operator()
    • BaseSqlMixin._convert_object_operator()
    • BaseSqlMixin._convert_let_operator()
    • BaseSqlMixin._convert_data_size_operator()
    • BaseSqlMixin._convert_type_operator()
    • BaseSqlMixin._get_operator_return_type()
    • BaseSqlMixin._get_literal_bson_type()
    • BaseSqlMixin._map_comparison_operator()
    • BaseSqlMixin._map_arithmetic_operator()
    • BaseSqlMixin._build_pattern_with_options()
    • BaseSqlMixin._handle_aggregation_variable()
• neosqlite.collection.expr_evaluator.sql_converters.comparison module
  • ComparisonMixin
    • ComparisonMixin._convert_comparison_operator()
    • ComparisonMixin._convert_cmp_operator()
• neosqlite.collection.expr_evaluator.sql_converters.conditional module
  • ConditionalMixin
    • ConditionalMixin._convert_cond_operator()
    • ConditionalMixin._convert_ifNull_operator()
    • ConditionalMixin._convert_switch_operator()
• neosqlite.collection.expr_evaluator.sql_converters.core module
  • CoreMixin
    • CoreMixin._convert_expr_to_sql()
    • CoreMixin._convert_operand_to_sql()
    • CoreMixin._map_comparison_operator()
    • CoreMixin._map_arithmetic_operator()
• neosqlite.collection.expr_evaluator.sql_converters.data_size module
  • DataSizeMixin
    • DataSizeMixin._convert_data_size_operator()
• neosqlite.collection.expr_evaluator.sql_converters.date module
  • _validate_strftime_format()
  • DateMixin
    • DateMixin._convert_date_operator()
    • DateMixin._convert_date_arithmetic_operator()
    • DateMixin._convert_date_diff_operator()
    • DateMixin._convert_date_to_string_operator()
    • DateMixin._convert_date_trunc_operator()
    • DateMixin._convert_date_from_parts_operator()
    • DateMixin._convert_date_to_parts_operator()
    • DateMixin._convert_date_from_string_operator()
• neosqlite.collection.expr_evaluator.sql_converters.logical module
  • LogicalMixin
    • LogicalMixin._convert_logical_operator()
• neosqlite.collection.expr_evaluator.sql_converters.math_trig module
  • MathTrigMixin
    • MathTrigMixin._log2_warned
    • MathTrigMixin._convert_math_operator()
    • MathTrigMixin._convert_trig_operator()
    • MathTrigMixin._convert_angle_operator()
• neosqlite.collection.expr_evaluator.sql_converters.object module
  • ObjectMixin
    • ObjectMixin._convert_object_operator()
    • ObjectMixin._convert_let_operator()
• neosqlite.collection.expr_evaluator.sql_converters.set module
  • SetMixin
    • SetMixin._convert_set_operator()
• neosqlite.collection.expr_evaluator.sql_converters.string module
  • StringMixin
    • StringMixin._build_pattern_with_options()
    • StringMixin._convert_string_operator()
• neosqlite.collection.expr_evaluator.sql_converters.type_converters module
  • TypeConvertersMixin
    • TypeConvertersMixin._get_operator_return_type()
    • TypeConvertersMixin._get_literal_bson_type()
    • TypeConvertersMixin._convert_type_operator()

Module contents

SQL converters for expression evaluation.

Composes domain-specific mixins into SqlConvertersMixin, which provides all _convert_* methods for translating MongoDB $expr operators to SQL.

This package was split from the monolithic sql_converters.py (1990 lines) into 13 focused modules mirroring the python_evaluators/ structure.

class neosqlite.collection.expr_evaluator.sql_converters.SqlConvertersMixin

Bases: CoreMixin, LogicalMixin, ComparisonMixin, ArithmeticMixin, ConditionalMixin, ArrayMixin, SetMixin, StringMixin, MathTrigMixin, DateMixin, ObjectMixin, TypeConvertersMixin, DataSizeMixin

Mixin class providing SQL conversion methods for expression evaluation.

This class is designed to be composed into ExprEvaluator and provides all the _convert_* methods for converting MongoDB operators to SQL.

Required attributes from parent class:

• data_column: Name of the JSON data column

• json_function_prefix: ‘json’ or ‘jsonb’ based on support

• json_each_function: ‘json_each’ or ‘jsonb_each’

• json_group_array_function: ‘json_group_array’ or ‘jsonb_group_array’

• jsonb: JSONBContext with JSONB capability flags

• _log2_warned: Boolean tracking if $log2 warning was issued

• _current_context: Optional AggregationContext for variable scoping

data_column: str

jsonb: JSONBContext

_log2_warned: bool

_current_context: AggregationContext | None