[PR #582] [MERGED] fix(checkpoint-sqlite): list method bug fixes #869

Closed
opened 2026-02-15 19:16:13 -05:00 by yindo · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/langchain-ai/langgraphjs/pull/582
Author: @benjamincburns
Created: 10/11/2024
Status: Merged
Merged: 10/19/2024
Merged by: @jacoblee93

Base: mainHead: checkpoint-sqlite-list-method-fixes


📝 Commits (4)

  • 91bd8bf fix(checkpoint-sqlite): fix invalid SQL syntax on list
  • 98e6c06 fix(checkpoint-sqlite): add missing list filter on checkpoint_ns
  • 75833f3 fix(checkpoint-sqlite): sanitize limit field in list method
  • 45c5df2 fix(checkpoint-sqlite): add missing filter support to list method

📊 Changes

2 files changed (+103 additions, -15 deletions)

View changed files

📝 libs/checkpoint-sqlite/src/index.ts (+84 -8)
📝 libs/checkpoint-sqlite/src/tests/checkpoints.test.ts (+19 -7)

📄 Description

This PR fixes a few issues in the list method of SqliteSaver that were found while working on #541.

  • Fixes a SQL syntax error resulting from an empty WHERE clause when none of the filtering options are specified
  • Adds missing support for filtering on config.configurable.checkpoint_ns
  • Sanitizes limit field prior to concatenating
  • Adds support for the filter field in the options argument by parsing the stored metadata in a CTE the WHERE clause

Submitting these together because they're all somewhat intertwined.


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/langchain-ai/langgraphjs/pull/582 **Author:** [@benjamincburns](https://github.com/benjamincburns) **Created:** 10/11/2024 **Status:** ✅ Merged **Merged:** 10/19/2024 **Merged by:** [@jacoblee93](https://github.com/jacoblee93) **Base:** `main` ← **Head:** `checkpoint-sqlite-list-method-fixes` --- ### 📝 Commits (4) - [`91bd8bf`](https://github.com/langchain-ai/langgraphjs/commit/91bd8bf0bd81b9ea1b8e968a7ee46d2f14cc34f7) fix(checkpoint-sqlite): fix invalid SQL syntax on list - [`98e6c06`](https://github.com/langchain-ai/langgraphjs/commit/98e6c064a051230a4e8f941909fe258d6de6c37f) fix(checkpoint-sqlite): add missing list filter on checkpoint_ns - [`75833f3`](https://github.com/langchain-ai/langgraphjs/commit/75833f3b1f583a84b58771c8fc0282d23eb843ff) fix(checkpoint-sqlite): sanitize limit field in list method - [`45c5df2`](https://github.com/langchain-ai/langgraphjs/commit/45c5df22ccee6e73f1daaef16067381f3863de1a) fix(checkpoint-sqlite): add missing filter support to list method ### 📊 Changes **2 files changed** (+103 additions, -15 deletions) <details> <summary>View changed files</summary> 📝 `libs/checkpoint-sqlite/src/index.ts` (+84 -8) 📝 `libs/checkpoint-sqlite/src/tests/checkpoints.test.ts` (+19 -7) </details> ### 📄 Description This PR fixes a few issues in the `list` method of `SqliteSaver` that were found while working on #541. - Fixes a SQL syntax error resulting from an empty `WHERE` clause when none of the filtering options are specified - Adds missing support for filtering on `config.configurable.checkpoint_ns` - Sanitizes `limit` field prior to concatenating - Adds support for the `filter` field in the `options` argument by parsing the stored metadata in ~~a CTE~~ the `WHERE` clause Submitting these together because they're all somewhat intertwined. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
yindo added the pull-request label 2026-02-15 19:16:13 -05:00
yindo closed this issue 2026-02-15 19:16:13 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: langchain-ai/langgraphjs#869