proxysql

Commit Graph

Author	SHA1	Message	Date
Rene Cannao	a36834f968	test: add 6 unit test files with 676 assertions (Round 4) New test files (test/tap/tests/unit/): Core: - c_tokenizer_unit-t (59 tests): tokenizer/tokenize/free_tokenizer, c_split_2, mysql_query_digest_and_first_comment (literal replacement, comment stripping, NULL handling, grouping_limit, IN-clause), mysql_query_digest_first_stage, strip_comments - config_write_unit-t (111 tests): all 7 Write_*_to_configfile() functions with in-memory SQLite — MySQL users/servers/query rules, scheduler, restapi, global variables, proxysql_servers; tests field formatting, NULL handling, double-quote escaping, prefix grouping - listen_validator_unit-t (112 tests): trim_copy, split_listener_list, is_ipv4/ipv6_wildcard, parse_listener (IPv4/IPv6/Unix socket/ invalid/edge cases), sets_intersect, listeners_conflict, validate_module_listener_conflicts - ezoption_parser_unit-t (110 tests): standalone ezOptionParser — flags, string/int/float options, defaults, required/unknown, aliases, multi-value, usage layout, export/import, validators, vector getters - pgsql_txn_state_unit-t (+58 tests, 112 total): EXTENDED with PgSQL_ExplicitTxnStateMgr state machine tests — BEGIN/COMMIT/ ROLLBACK lifecycle, ROLLBACK AND CHAIN, savepoint add/release/ rollback_to, reset_state, fill_internal_session JSON, case- insensitive savepoints, END/ABORT synonyms. Uses minimal PgSQL_Session mock with variable snapshots. GenAI/MCP (PROXYSQLGENAI=1): - genai_discovery_schema_unit-t (172 tests): Discovery_Schema with in-memory SQLite — run/agent_run management, schema/object/column/ index/FK insertion, profile/LLM summary/domain/metrics/notes, list_objects pagination+ordering, get_object with columns/indexes, get_relationships FK mappings, FTS rebuild+search, fingerprint_mcp_args, compute_mcp_digest determinism, MCP_Query_Digest_Stats timing, MCP_Query_Processor_Output, MCP_Query_Rule defaults Running totals: 27 test files, 1944+ assertions, all passing.	3 months ago
Rene Cannao	accc68c9dc	test: add 11 new unit test files with 520 assertions for lib/ coverage Add targeted unit tests for pure functions and isolated components across lib/, increasing test coverage for both core utilities and GenAI/MCP components. New test files (test/tap/tests/unit/): Core utilities: - pgsql_variables_validator_unit-t (75 tests): bool, float, string, memory size, search_path, and client_encoding validators - gen_utils_unit-t (28 tests): mywildcmp wildcard matching, escape_string_single_quotes, Proxy_file_regular - mysql_encode_unit-t (23 tests): mysql_encode_length, CPY3/CPY8, proxy_my_crypt XOR, write_encoded_length - proxysql_utils_unit-t (23 tests): hex/unhex, sql_escape, split_str, replace_str, generate_multi_rows_query, checksums - proxy_protocol_unit-t (22 tests): PROXY v1 header parsing, subnet validation, IPv4/IPv6 network matching - pgsql_error_helper_unit-t (139 tests): SQLSTATE code mapping, all 38 error class branches, severity classification, fill/reset - pgsql_txn_state_unit-t (54 tests): TxnCmdParser for BEGIN, COMMIT, ROLLBACK, SAVEPOINT, RELEASE, AND CHAIN variants - sqlite3db_unit-t (21 tests): execute, return_one_int, check_table_structure, build_table, row ops, locking GenAI/MCP (PROXYSQLGENAI=1): - genai_stats_parsing_unit-t (79 tests): parse_server_filter, parse_digest_filter, parse_ll_or_zero, get_interval_config, calculate_percentile - genai_fts_string_unit-t (32 tests): MySQL_FTS sanitize_name, escape_identifier, escape_sql, table name construction - genai_anomaly_unit-t (24 tests): normalize_query SQL normalization, check_sql_injection pattern detection Minimal production changes for GenAI testability: - include/Anomaly_Detector.h: add friend class for test access - include/Stats_Tool_Handler.h: declare 4 parsing helpers, move 2 pure computation methods (get_interval_config, calculate_percentile) to public - lib/Stats_Tool_Handler.cpp: remove static from 4 free helper functions (no behavioral change, only linkage visibility)	3 months ago

Author

SHA1

Message

Date

Rene Cannao

a36834f968

test: add 6 unit test files with 676 assertions (Round 4)

New test files (test/tap/tests/unit/):

  Core:
  - c_tokenizer_unit-t (59 tests): tokenizer/tokenize/free_tokenizer,
    c_split_2, mysql_query_digest_and_first_comment (literal
    replacement, comment stripping, NULL handling, grouping_limit,
    IN-clause), mysql_query_digest_first_stage, strip_comments
  - config_write_unit-t (111 tests): all 7 Write_*_to_configfile()
    functions with in-memory SQLite — MySQL users/servers/query rules,
    scheduler, restapi, global variables, proxysql_servers; tests
    field formatting, NULL handling, double-quote escaping, prefix
    grouping
  - listen_validator_unit-t (112 tests): trim_copy, split_listener_list,
    is_ipv4/ipv6_wildcard, parse_listener (IPv4/IPv6/Unix socket/
    invalid/edge cases), sets_intersect, listeners_conflict,
    validate_module_listener_conflicts
  - ezoption_parser_unit-t (110 tests): standalone ezOptionParser —
    flags, string/int/float options, defaults, required/unknown,
    aliases, multi-value, usage layout, export/import, validators,
    vector getters
  - pgsql_txn_state_unit-t (+58 tests, 112 total): EXTENDED with
    PgSQL_ExplicitTxnStateMgr state machine tests — BEGIN/COMMIT/
    ROLLBACK lifecycle, ROLLBACK AND CHAIN, savepoint add/release/
    rollback_to, reset_state, fill_internal_session JSON, case-
    insensitive savepoints, END/ABORT synonyms. Uses minimal
    PgSQL_Session mock with variable snapshots.

  GenAI/MCP (PROXYSQLGENAI=1):
  - genai_discovery_schema_unit-t (172 tests): Discovery_Schema with
    in-memory SQLite — run/agent_run management, schema/object/column/
    index/FK insertion, profile/LLM summary/domain/metrics/notes,
    list_objects pagination+ordering, get_object with columns/indexes,
    get_relationships FK mappings, FTS rebuild+search,
    fingerprint_mcp_args, compute_mcp_digest determinism,
    MCP_Query_Digest_Stats timing, MCP_Query_Processor_Output,
    MCP_Query_Rule defaults

Running totals: 27 test files, 1944+ assertions, all passing.

Rene Cannao

accc68c9dc

test: add 11 new unit test files with 520 assertions for lib/ coverage

Add targeted unit tests for pure functions and isolated components
across lib/, increasing test coverage for both core utilities and
GenAI/MCP components.

New test files (test/tap/tests/unit/):

  Core utilities:
  - pgsql_variables_validator_unit-t (75 tests): bool, float, string,
    memory size, search_path, and client_encoding validators
  - gen_utils_unit-t (28 tests): mywildcmp wildcard matching,
    escape_string_single_quotes, Proxy_file_regular
  - mysql_encode_unit-t (23 tests): mysql_encode_length, CPY3/CPY8,
    proxy_my_crypt XOR, write_encoded_length
  - proxysql_utils_unit-t (23 tests): hex/unhex, sql_escape,
    split_str, replace_str, generate_multi_rows_query, checksums
  - proxy_protocol_unit-t (22 tests): PROXY v1 header parsing,
    subnet validation, IPv4/IPv6 network matching
  - pgsql_error_helper_unit-t (139 tests): SQLSTATE code mapping,
    all 38 error class branches, severity classification, fill/reset
  - pgsql_txn_state_unit-t (54 tests): TxnCmdParser for BEGIN,
    COMMIT, ROLLBACK, SAVEPOINT, RELEASE, AND CHAIN variants
  - sqlite3db_unit-t (21 tests): execute, return_one_int,
    check_table_structure, build_table, row ops, locking

  GenAI/MCP (PROXYSQLGENAI=1):
  - genai_stats_parsing_unit-t (79 tests): parse_server_filter,
    parse_digest_filter, parse_ll_or_zero, get_interval_config,
    calculate_percentile
  - genai_fts_string_unit-t (32 tests): MySQL_FTS sanitize_name,
    escape_identifier, escape_sql, table name construction
  - genai_anomaly_unit-t (24 tests): normalize_query SQL
    normalization, check_sql_injection pattern detection

Minimal production changes for GenAI testability:
- include/Anomaly_Detector.h: add friend class for test access
- include/Stats_Tool_Handler.h: declare 4 parsing helpers, move
  2 pure computation methods (get_interval_config,
  calculate_percentile) to public
- lib/Stats_Tool_Handler.cpp: remove static from 4 free helper
  functions (no behavioral change, only linkage visibility)

2 Commits (feature/pgsql-native-backend-protocol)