sql_cli/
text_navigation.rs

1use crate::recursive_parser::{Lexer, Token};
2
3/// Manages text navigation and token-based movement
4/// Extracted from the monolithic enhanced_tui.rs
5pub struct TextNavigator;
6
7impl TextNavigator {
8    /// Get the cursor's position in terms of tokens (current_token, total_tokens)
9    pub fn get_cursor_token_position(query: &str, cursor_pos: usize) -> (usize, usize) {
10        if query.is_empty() {
11            return (0, 0);
12        }
13
14        // Use lexer to tokenize the query
15        let mut lexer = Lexer::new(query);
16        let tokens = lexer.tokenize_all_with_positions();
17
18        if tokens.is_empty() {
19            return (0, 0);
20        }
21
22        // Special case: cursor at position 0 is always before the first token
23        if cursor_pos == 0 {
24            return (0, tokens.len());
25        }
26
27        // Find which token the cursor is in
28        let mut current_token = 0;
29        for (i, (start, end, _)) in tokens.iter().enumerate() {
30            if cursor_pos >= *start && cursor_pos <= *end {
31                current_token = i + 1;
32                break;
33            } else if cursor_pos < *start {
34                // Cursor is between tokens
35                current_token = i;
36                break;
37            }
38        }
39
40        // If cursor is after all tokens
41        if current_token == 0 && cursor_pos > 0 {
42            current_token = tokens.len();
43        }
44
45        (current_token, tokens.len())
46    }
47
48    /// Get the token at the cursor position
49    pub fn get_token_at_cursor(query: &str, cursor_pos: usize) -> Option<String> {
50        if query.is_empty() {
51            return None;
52        }
53
54        // Use lexer to tokenize the query
55        let mut lexer = Lexer::new(query);
56        let tokens = lexer.tokenize_all_with_positions();
57
58        // Find the token at cursor position
59        for (start, end, token) in &tokens {
60            if cursor_pos >= *start && cursor_pos <= *end {
61                // Format token nicely
62                let token_str = Self::format_token(token);
63                return Some(token_str.to_string());
64            }
65        }
66
67        None
68    }
69
70    /// Calculate the target position for jumping to the previous token
71    pub fn calculate_prev_token_position(query: &str, cursor_pos: usize) -> Option<usize> {
72        if cursor_pos == 0 {
73            return None;
74        }
75
76        let mut lexer = Lexer::new(query);
77        let tokens = lexer.tokenize_all_with_positions();
78
79        // Find current token position
80        let mut in_token = false;
81        let mut current_token_start = 0;
82        for (start, end, _) in &tokens {
83            if cursor_pos > *start && cursor_pos <= *end {
84                in_token = true;
85                current_token_start = *start;
86                break;
87            }
88        }
89
90        // Find the previous token start
91        let target_pos = if in_token && cursor_pos > current_token_start {
92            // If we're in the middle of a token, go to its start
93            current_token_start
94        } else {
95            // Otherwise, find the previous token
96            let mut prev_start = 0;
97            for (start, _, _) in tokens.iter().rev() {
98                if *start < cursor_pos {
99                    prev_start = *start;
100                    break;
101                }
102            }
103            prev_start
104        };
105
106        if target_pos < cursor_pos {
107            Some(target_pos)
108        } else {
109            None
110        }
111    }
112
113    /// Calculate the target position for jumping to the next token
114    pub fn calculate_next_token_position(query: &str, cursor_pos: usize) -> Option<usize> {
115        let query_len = query.len();
116        if cursor_pos >= query_len {
117            return None;
118        }
119
120        let mut lexer = Lexer::new(query);
121        let tokens = lexer.tokenize_all_with_positions();
122
123        // Find current token position
124        let mut in_token = false;
125        let mut current_token_end = query_len;
126        for (start, end, _) in &tokens {
127            if cursor_pos >= *start && cursor_pos < *end {
128                in_token = true;
129                current_token_end = *end;
130                break;
131            }
132        }
133
134        // Find the next token start
135        let target_pos = if in_token && cursor_pos < current_token_end {
136            // If we're in a token, go to the start of the next token
137            let mut next_start = query_len;
138            for (start, _, _) in &tokens {
139                if *start > current_token_end {
140                    next_start = *start;
141                    break;
142                }
143            }
144            next_start
145        } else {
146            // Otherwise, find the next token from current position
147            let mut next_start = query_len;
148            for (start, _, _) in &tokens {
149                if *start > cursor_pos {
150                    next_start = *start;
151                    break;
152                }
153            }
154            next_start
155        };
156
157        if target_pos > cursor_pos && target_pos <= query_len {
158            Some(target_pos)
159        } else {
160            None
161        }
162    }
163
164    /// Format a token for display
165    fn format_token(token: &Token) -> &str {
166        match token {
167            Token::Select => "SELECT",
168            Token::From => "FROM",
169            Token::Where => "WHERE",
170            Token::GroupBy => "GROUP BY",
171            Token::OrderBy => "ORDER BY",
172            Token::Having => "HAVING",
173            Token::As => "AS",
174            Token::Asc => "ASC",
175            Token::Desc => "DESC",
176            Token::And => "AND",
177            Token::Or => "OR",
178            Token::In => "IN",
179            Token::DateTime => "DateTime",
180            Token::Case => "CASE",
181            Token::When => "WHEN",
182            Token::Then => "THEN",
183            Token::Else => "ELSE",
184            Token::End => "END",
185            Token::Identifier(s) => s,
186            Token::QuotedIdentifier(s) => s,
187            Token::StringLiteral(s) => s,
188            Token::NumberLiteral(s) => s,
189            Token::Star => "*",
190            Token::Comma => ",",
191            Token::Dot => ".",
192            Token::LeftParen => "(",
193            Token::RightParen => ")",
194            Token::Equal => "=",
195            Token::NotEqual => "!=",
196            Token::LessThan => "<",
197            Token::LessThanOrEqual => "<=",
198            Token::GreaterThan => ">",
199            Token::GreaterThanOrEqual => ">=",
200            Token::Like => "LIKE",
201            Token::Not => "NOT",
202            Token::Is => "IS",
203            Token::Null => "NULL",
204            Token::Between => "BETWEEN",
205            Token::Limit => "LIMIT",
206            Token::Offset => "OFFSET",
207            Token::Plus => "+",
208            Token::Minus => "-",
209            Token::Divide => "/",
210            Token::Eof => "EOF",
211        }
212    }
213}
214
215/// Text editing utilities
216pub struct TextEditor;
217
218impl TextEditor {
219    /// Kill text from beginning of line to cursor position
220    /// Returns (killed_text, remaining_text)
221    pub fn kill_line_backward(text: &str, cursor_pos: usize) -> Option<(String, String)> {
222        if cursor_pos == 0 {
223            return None;
224        }
225
226        let killed_text = text.chars().take(cursor_pos).collect::<String>();
227        let remaining_text = text.chars().skip(cursor_pos).collect::<String>();
228
229        Some((killed_text, remaining_text))
230    }
231
232    /// Kill text from cursor position to end of line
233    /// Returns (killed_text, remaining_text)
234    pub fn kill_line_forward(text: &str, cursor_pos: usize) -> Option<(String, String)> {
235        if cursor_pos >= text.len() {
236            return None;
237        }
238
239        let remaining_text = text.chars().take(cursor_pos).collect::<String>();
240        let killed_text = text.chars().skip(cursor_pos).collect::<String>();
241
242        Some((killed_text, remaining_text))
243    }
244
245    /// Delete word backward from cursor position
246    /// Returns (deleted_text, remaining_text, new_cursor_pos)
247    pub fn delete_word_backward(text: &str, cursor_pos: usize) -> Option<(String, String, usize)> {
248        if cursor_pos == 0 {
249            return None;
250        }
251
252        let before_cursor = &text[..cursor_pos];
253        let after_cursor = &text[cursor_pos..];
254
255        // Find word boundary, including leading whitespace before the word
256        let mut word_start = before_cursor.len();
257        let mut chars = before_cursor.chars().rev().peekable();
258
259        // Step 1: Skip trailing whitespace (if any)
260        while let Some(&ch) = chars.peek() {
261            if ch.is_whitespace() {
262                word_start -= ch.len_utf8();
263                chars.next();
264            } else {
265                break;
266            }
267        }
268
269        // Step 2: Skip the word itself
270        while let Some(&ch) = chars.peek() {
271            if !ch.is_alphanumeric() && ch != '_' {
272                break;
273            }
274            word_start -= ch.len_utf8();
275            chars.next();
276        }
277
278        // Step 3: Include any whitespace before the word (so deleting at a word boundary includes the space)
279        while let Some(&ch) = chars.peek() {
280            if ch.is_whitespace() {
281                word_start -= ch.len_utf8();
282                chars.next();
283            } else {
284                break;
285            }
286        }
287
288        let deleted_text = text[word_start..cursor_pos].to_string();
289        let remaining_text = format!("{}{}", &text[..word_start], after_cursor);
290
291        Some((deleted_text, remaining_text, word_start))
292    }
293
294    /// Delete word forward from cursor position
295    /// Returns (deleted_text, remaining_text)
296    pub fn delete_word_forward(text: &str, cursor_pos: usize) -> Option<(String, String)> {
297        if cursor_pos >= text.len() {
298            return None;
299        }
300
301        let before_cursor = &text[..cursor_pos];
302        let after_cursor = &text[cursor_pos..];
303
304        // Find word boundary
305        let mut chars = after_cursor.chars();
306        let mut word_end = 0;
307
308        // Skip any non-alphanumeric chars at the beginning
309        while let Some(ch) = chars.next() {
310            word_end += ch.len_utf8();
311            if ch.is_alphanumeric() || ch == '_' {
312                // Found start of word, now skip the rest of it
313                while let Some(ch) = chars.next() {
314                    if !ch.is_alphanumeric() && ch != '_' {
315                        break;
316                    }
317                    word_end += ch.len_utf8();
318                }
319                break;
320            }
321        }
322
323        let deleted_text = text[cursor_pos..cursor_pos + word_end].to_string();
324        let remaining_text = format!("{}{}", before_cursor, &after_cursor[word_end..]);
325
326        Some((deleted_text, remaining_text))
327    }
328}
329
330#[cfg(test)]
331mod tests {
332    use super::*;
333
334    #[test]
335    fn test_cursor_token_position() {
336        let query = "SELECT * FROM users WHERE id = 1";
337
338        // Cursor at beginning
339        assert_eq!(TextNavigator::get_cursor_token_position(query, 0), (0, 8));
340
341        // Cursor in SELECT
342        assert_eq!(TextNavigator::get_cursor_token_position(query, 3), (1, 8));
343
344        // Cursor after SELECT
345        assert_eq!(TextNavigator::get_cursor_token_position(query, 7), (2, 8));
346    }
347
348    #[test]
349    fn test_kill_line_backward() {
350        let text = "SELECT * FROM users";
351
352        // Kill from middle
353        let result = TextEditor::kill_line_backward(text, 8);
354        assert_eq!(
355            result,
356            Some(("SELECT *".to_string(), " FROM users".to_string()))
357        );
358
359        // Kill from beginning (no-op)
360        let result = TextEditor::kill_line_backward(text, 0);
361        assert_eq!(result, None);
362    }
363
364    #[test]
365    fn test_delete_word_backward() {
366        let text = "SELECT * FROM users";
367
368        // Delete "FROM"
369        let result = TextEditor::delete_word_backward(text, 13);
370        assert_eq!(
371            result,
372            Some((" FROM".to_string(), "SELECT * users".to_string(), 8))
373        );
374    }
375}