proxysql

Commit Graph

Author	SHA1	Message	Date
Rene Cannao	3032dffed4	test: Add NL2SQL internal functionality unit tests Add comprehensive TAP unit tests for NL2SQL internal functions: - Error code conversion (5 tests): Validate nl2sql_error_code_to_string() covers all 13 defined error codes plus UNKNOWN_ERROR - SQL validation patterns (17 tests): Test validate_and_score_sql() * Valid SELECT queries (4 tests) * Non-SELECT queries (4 tests) * Injection pattern detection (4 tests) * Edge cases (4 tests): empty, lone keyword, semicolons, complex queries - Request ID generation (12 tests): Test UUID-like ID generation * Format validation (20 assertions for 10 IDs) * Uniqueness (100 IDs checked for duplicates) * Hexadecimal character validation - Prompt building (8 tests): Test build_prompt() * Basic prompt structure (3 tests) * Schema context inclusion (3 tests) * Section ordering (1 test) * Special character handling (2 tests) Note: Tests are self-contained with standalone implementations matching the logic in NL2SQL_Converter.cpp.	1 month ago

Author

SHA1

Message

Date

Rene Cannao

3032dffed4

test: Add NL2SQL internal functionality unit tests

Add comprehensive TAP unit tests for NL2SQL internal functions:

- Error code conversion (5 tests): Validate nl2sql_error_code_to_string()
  covers all 13 defined error codes plus UNKNOWN_ERROR

- SQL validation patterns (17 tests): Test validate_and_score_sql()
  * Valid SELECT queries (4 tests)
  * Non-SELECT queries (4 tests)
  * Injection pattern detection (4 tests)
  * Edge cases (4 tests): empty, lone keyword, semicolons, complex queries

- Request ID generation (12 tests): Test UUID-like ID generation
  * Format validation (20 assertions for 10 IDs)
  * Uniqueness (100 IDs checked for duplicates)
  * Hexadecimal character validation

- Prompt building (8 tests): Test build_prompt()
  * Basic prompt structure (3 tests)
  * Schema context inclusion (3 tests)
  * Section ordering (1 test)
  * Special character handling (2 tests)

Note: Tests are self-contained with standalone implementations
matching the logic in NL2SQL_Converter.cpp.

1 Commits (v3.0_pgsql_advanced_logging)