langgenius/dify

[Refactor/Chore] use Testcontainers to do sql test

Open

#32454 opened on Feb 21, 2026

View on GitHub
 (33 comments) (1 reaction) (3 assignees)TypeScript (141,412 stars) (22,210 forks)batch import
good first issue🙏 help wanted

Description

Self Checks

  • I have read the Contributing Guide and Language Policy.
  • This is only for refactors or chores; if you would like to ask a question, please head to Discussions.
  • I have searched for existing issues search for existing issues, including closed ones.
  • I confirm that I am using English to submit this report, otherwise it will be closed.
  • 【中文用户 & Non English User】请使用英语提交，否则会被关闭 ：）
  • Please do not modify this template :) and fill in all the required fields.

Description

now it's hard to do SQL improvement since all the query is patch.

Testcontainers will be much easier.

Motivation

Improve DX

Additional Context

Chat with llm https://g.co/gemini/share/abe5288b661a (chat is in Chinese).

Contributor guide

Tech stack
typescriptnodejssqldocker
Domain
backenddatabasetesting
Issue type
chore
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
mostly clear
Prerequisites
Basic understanding of DockerFamiliarity with Testcontainers libraryKnowledge of the project's testing frameworkSQL basics
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
45
Research direction
Review the existing test infrastructure in the repository, particularly SQL related tests. Check the LLM chat link provided in the issue for additional context on how Testcontainers can be integrated. Look at any ongoing discussions in the comments for implementation details. Identify which SQL queries are currently patched and plan to replace them with Testcontainers based integration tests.