diff options
Diffstat (limited to 'internal/store/sqlite.go')
| -rw-r--r-- | internal/store/sqlite.go | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/internal/store/sqlite.go b/internal/store/sqlite.go index 79f5cc8..259bd0f 100644 --- a/internal/store/sqlite.go +++ b/internal/store/sqlite.go @@ -418,6 +418,7 @@ func (s *Store) InvalidateCache(key string) error { // Boards operations // SaveBoards saves multiple boards to the database +// This clears existing data and replaces it with the new data func (s *Store) SaveBoards(boards []models.Board) error { tx, err := s.db.Begin() if err != nil { @@ -425,6 +426,14 @@ func (s *Store) SaveBoards(boards []models.Board) error { } defer tx.Rollback() + // Clear existing data first (cards must be deleted before boards due to foreign key) + if _, err := tx.Exec(`DELETE FROM cards`); err != nil { + return err + } + if _, err := tx.Exec(`DELETE FROM boards`); err != nil { + return err + } + // Save boards boardStmt, err := tx.Prepare(` INSERT OR REPLACE INTO boards (id, name, updated_at) |