Method extract_table_name

src/optimization/read_only_optimizer.rs:413–437

Extract table name from SELECT query

(&self, query: &str)

    /// Extract table name from SELECT query
    fn extract_table_name(&self, query: &str) -> Option<String> {
        let query_upper = query.to_uppercase();
        
        // Find FROM clause
        if let Some(from_pos) = query_upper.find(" FROM ") {
            let after_from = &query[from_pos + 6..].trim();
            
            // Find end of table name
            let end = after_from.find(' ')
                .or_else(|| after_from.find(';'))
                .or_else(|| after_from.find('\n'))
                .unwrap_or(after_from.len());
            
            let table_name = after_from[..end].trim();
            
            // Remove quotes if present
            let table_name = table_name.trim_matches('"').trim_matches('\'');
            
            if !table_name.is_empty() {
                return Some(table_name.to_string());
            }
        }
        
        None
    }

    /// Classify query complexity for optimization decisions
    fn classify_query_complexity(&self, query: &str) -> QueryComplexity {