PRAGMA options

Question

PRAGMA options

trevornagy opened this issue 7 months ago · 6 comments

I'm just wondering how to use the foreign_keys option, I see it in code but not sure how to enable it. In sqlite it would look like:
PRAGMA foreign_keys=ON;

Additionally, would it be possible to get the recursive_triggers option? In sqlite: PRAGMA recursive_triggers=ON;

Thanks!

Answer 1 · 2024-05-29T12:19:04.000Z

foreign_keys is enabled by storage after every SQLite connection is opened if make_table contains at least 1 foreign key;
recursive_triggers will be added soon.

Answer 2 · 2024-05-29T12:43:32.000Z

PR with recursive_triggers #1302

Answer 3 · 2024-05-29T17:39:08.000Z

Awesome, thank you!

I appreciate the clarification on foreign_keys

Answer 4 · 2024-05-29T19:00:15.000Z

@trevornagy merged. Please check dev branch

Answer 5 · 2024-05-29T19:34:07.000Z

This should be possible to allow change in data or structure We go back to a touchy subject but I think we should enable this in a safe manner and being very careful to explain the dangers of it’s unscrupulous useMaybe allow it in sync_schema and disable it afterwardsRegards Juan DentSent from my iPhoneOn 29 May 2024, at 8:44 AM, Yevgeniy Zakharov ***@***.***> wrote: PR with recursive_triggers #1302 —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

Answer 6 · 2024-05-30T00:25:10.000Z

Works as expected, thanks!