lightning icon indicating copy to clipboard operation
lightning copied to clipboard
verified publisher icon ElementsProject

Turn on strict tables for SQLITE3 when running integration tests

Open niftynei opened this issue 3 years ago • 5 comments

image

It'd be great to turn on strict tables etc for our integration test suite.

Suggested-By: @answrguy

https://www.sqlite.org/stricttables.html

niftynei avatar Jul 08 '22 22:07 niftynei

Open CLN bounty on this: https://community.corelightning.org/c/cln-bounties/5390-turn-on-strict-tables-for-sqlite3-when-running-integration-tests

BitcoinJiuJitsu avatar Jun 25 '24 01:06 BitcoinJiuJitsu

Would it be reasonable to assume that lightningd is running the integration tests if network is on regtest and the --developer option is set?

s373nZ avatar Sep 21 '24 14:09 s373nZ

Would it be reasonable to assume that lightningd is running the integration tests if network is on regtest and the --developer option is set?

All tests run in --developer mode. However, the network can be configured using the TEST_NETWORK environment variable, which accepts [regtest/liquid-regtest] as valid values. The default network is set to regtest.

ShahanaFarooqui avatar Jul 29 '25 23:07 ShahanaFarooqui

Hi, Did I understand correctly that you want to add STRICT Mode to the wallet/db.c tables?

Crypto4udit avatar Aug 11 '25 16:08 Crypto4udit

Working on implementing STRICT tables and security PRAGMAs for the integration test suite. Will have a PR ready soon.

wqxoxo avatar Sep 20 '25 12:09 wqxoxo