Skip to content

v0.2.2: Fix SQLite DateTime error - parse GitHub API ISO 8601 date strings

Choose a tag to compare

View all tags
@bigknoxy bigknoxy released this 04 May 03:53
· 62 commits to main since this release
v0.2.2
a14a6e4

Bug Fix

Fixed

  • SQLite DateTime type error when storing repository dates

GitHub API returns dates as ISO 8601 strings (e.g., 2025-10-09T19:21:45Z), but SQLAlchemy DateTime columns require Python datetime objects. This was causing the error:

TypeError: SQLite DateTime type only accepts Python datetime and date objects as input

Solution: Added parse_github_datetime() helper function in db.py that converts ISO 8601 date strings from GitHub API to Python datetime objects. This function handles both the Z suffix and timezone offset formats.

Full Changelog

  • Fix SQLite DateTime parsing for GitHub API date strings
  • Add parse_github_datetime() helper function
  • Add unit tests for datetime parsing
  • Bump version to 0.2.2
Assets 2
Loading