Function extract_sql_queries_from_file

src/parser/sql_parser.rs:30–65

Extract SQL queries from raw SQL file content Supports multiple queries separated by semicolons and annotations

(content: &str, file_path: &Path)

/// Extract SQL queries from raw SQL file content
/// Supports multiple queries separated by semicolons and annotations
fn extract_sql_queries_from_file(content: &str, file_path: &Path) -> Result<Vec<SQL>> {
  let mut queries = Vec::new();

  // Split content by semicolons to handle multiple queries
  let query_blocks = split_sql_queries(content);

  for (index, block) in query_blocks.iter().enumerate() {
    let trimmed_block = block.trim();

    // Skip empty blocks or comment-only blocks
    if trimmed_block.is_empty() || is_comment_only(trimmed_block) {
      continue;
    }

    // Extract annotations and clean query
    let (query_name, _db_connection, cleaned_query) = extract_annotations_from_sql(trimmed_block);

    // Skip if no actual SQL content after cleaning
    if cleaned_query.trim().is_empty() {
      continue;
    }

    // Generate default name if not provided via annotation
    let var_decl_name = query_name.or_else(|| generate_default_query_name(file_path, index));

    let sql = SQL {
      query: cleaned_query,
      var_decl_name,
      span: DUMMY_SP.into(),
    };

    queries.push(sql);
  }

  Ok(queries)
}

/// Split SQL content into individual queries
/// Handles semicolons inside strings and comments properly