integration-test

Integration tests use testserver, a fully functional CockroachDB server with all components in-memory and in the same process. They're SLOW to spin up (can add seconds per test case), so use them only when necessary.

Prefer sqlutils.MakeSQLRunner over raw database connections in most cases. It provides automatic error handling (fails the test on error), cleaner syntax, and helper methods for common operations.

Use sqlDB.DB when you need direct error handling rather than automatic test failure:

使用 CockroachDB 測試伺服器編寫整合測試的指南，包括何時使用它們以及如何使用 sqlutils。 來源：cockroachdb/cockroach。