test: Add word-boundary and leading-whitespace tests for PRAGMA detection

ocean · ocean · commit c22a78d2eac8 · 2026-02-23T10:34:04.000+11:00
Mirror the existing test_not_select_if_part_of_word / test_not_cte_if_part_of_word
and test_explain_with_whitespace patterns for the PRAGMA branch of should_use_query:

- test_not_pragma_if_part_of_word: asserts that "PRAGMATIC" and similar strings
  do NOT match, confirming the word-boundary guard is enforced.
- test_pragma_with_whitespace: asserts that leading spaces, tabs, and newlines
  before PRAGMA are correctly skipped by skip_whitespace_and_comments.
diff --git a/native/ecto_libsql/src/tests/utils_tests.rs b/native/ecto_libsql/src/tests/utils_tests.rs
@@ -270,6 +270,21 @@ mod should_use_query_tests {
         assert!(should_use_query("PRAGMA foreign_keys"));
     }
 
+    #[test]
+    fn test_not_pragma_if_part_of_word() {
+        // "PRAGMATIC" and similar should not match PRAGMA.
+        assert!(!should_use_query("PRAGMATIC table_name"));
+        assert!(!should_use_query("PRAGMATICS"));
+    }
+
+    #[test]
+    fn test_pragma_with_whitespace() {
+        // Leading whitespace before PRAGMA must be skipped correctly.
+        assert!(should_use_query("  PRAGMA foreign_keys"));
+        assert!(should_use_query("\tPRAGMA journal_mode"));
+        assert!(should_use_query("\n  PRAGMA wal_checkpoint(FULL)"));
+    }
+
     // ===== Edge Cases =====
 
     #[test]
