Feature: Google Sheets Status Operations
  As a data engineer
  I want to update and query dataset status in Google Sheets
  So that I can track processing progress

  Background:
    Given an authenticated sheets tracker
    And a sheet with the following datasets
      | Dataset Name | Status      | Error |
      | wordnet      | NOT STARTED |       |
      | yago         | IN PROGRESS |       |
      | dbpedia      | DONE        |       |

  Scenario: Get status of dataset that exists
    When I get the status of "wordnet"
    Then the status should be "NOT STARTED"
    And the error should be empty

  Scenario: Get status of dataset not in sheet
    When I get the status of "nonexistent"
    Then the status should be None
    And the row should be None

  Scenario: Update status to IN PROGRESS
    When I mark "wordnet" as in progress
    Then the update should succeed
    And the status of "wordnet" should be "IN PROGRESS"

  Scenario: Update status to DONE
    When I mark "wordnet" as completed
    Then the update should succeed
    And the status of "wordnet" should be "DONE"

  Scenario: Reset status to NOT STARTED with error
    When I reset "yago" to not started with error "Download failed"
    Then the update should succeed
    And the status of "yago" should be "NOT STARTED"
    And the error for "yago" should contain "Download failed"

  Scenario: Clear error message on successful completion
    Given "yago" has error "Previous error"
    When I mark "yago" as completed
    Then the status of "yago" should be "DONE"
    And the error for "yago" should be empty

  Scenario: Update status for dataset with special characters
    Given a dataset named "fb15k-237"
    When I mark "fb15k-237" as in progress
    Then the update should succeed