Add unit tests for database operations in `internal/database/database.go`

[sweep-ai[bot]]

Purpose

Implement unit tests for the GetOriginalFilePath function in the internal/database/database.go file to ensure its functionality and reliability.

Description

The changes in this pull request include:

• Creating a new file internal/database/database_test.go for the unit tests
• Implementing test cases for the GetOriginalFilePath function:
  • Test successful retrieval of file path and base name
  • Test handling of non-existent UUID
  • Test database connection error scenario
  • Test query execution error scenario
• Updating internal/database/database.go to improve testability:
  • Extracting the database connection logic into a separate function
  • Using dependency injection for the database connection to allow for easier mocking in tests

Summary

• Created internal/database/database_test.go file
• Implemented test cases:
  • TestGetOriginalFilePathSuccess
  • TestGetOriginalFilePathNoEntry
  • TestGetOriginalFilePathDatabaseError
  • TestGetOriginalFilePathQueryError
• Updated internal/database/database.go to improve testability
  • Added OpenDatabase function
  • Refactored GetOriginalFilePath to use OpenDatabase

Fixes

2. Continue the conversation here: https://app.sweep.dev/c/9746de6e-6fbb-44a2-bf50-b78229e65c9e.

To have Sweep make further changes, please add a comment to this PR starting with "Sweep:".

:book: For more information on how to use Sweep, please read our documentation.

^{Tracking ID: e722d50f93}

[sweep-ai[bot]]

❌ Error while fixing CI

Traceback (most recent call last):
  File "/app/sweepai/handlers/fix_ci.py", line 286, in fix_ci_failures_once
    logs_list = get_ci_failure_logs(error_runs, pull_request)
  File "/app/sweepai/handlers/fix_ci.py", line 182, in get_ci_failure_logs
    raw_logs = unzip_and_extract_logs(raw_binary_logs)
  File "/app/sweepai/handlers/fix_ci.py", line 137, in unzip_and_extract_logs
    zip_file = zipfile.ZipFile(io.BytesIO(blob))
  File "/usr/local/lib/python3.10/zipfile.py", line 1272, in __init__
    self._RealGetContents()
  File "/usr/local/lib/python3.10/zipfile.py", line 1339, in _RealGetContents
    raise BadZipFile("File is not a zip file")
zipfile.BadZipFile: File is not a zip file

File is not a zip file

Sweep has encountered a runtime error unrelated to your request. Please let us know via this link or at support@sweep.dev directly.

:book: For more information on how to use Sweep, please read our documentation.

^{Tracking ID: e722d50f93-ci-0}