From mboxrd@z Thu Jan 1 00:00:00 1970 Return-path: Received: from mail-ej1-x644.google.com ([2a00:1450:4864:20::644]) by metis.ext.pengutronix.de with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1jw7hB-0004F8-9h for ptxdist@pengutronix.de; Thu, 16 Jul 2020 19:29:21 +0200 Received: by mail-ej1-x644.google.com with SMTP id rk21so7463004ejb.2 for ; Thu, 16 Jul 2020 10:29:21 -0700 (PDT) From: Bruno Thomsen Date: Thu, 16 Jul 2020 19:29:13 +0200 Message-Id: <20200716172913.6053-1-bruno.thomsen@gmail.com> MIME-Version: 1.0 Subject: [ptxdist] [PATCH v2] sqlite: config: enable foreign keys by default List-Id: PTXdist Development Mailing List List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-To: ptxdist@pengutronix.de Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Errors-To: ptxdist-bounces@pengutronix.de Sender: "ptxdist" To: ptxdist@pengutronix.de Cc: Bruno Thomsen , bth@kamstrup.com Support for foreign_keys pragma is already enabled at compile time. This allows turning on the feature by default on new database connections. Signed-off-by: Bruno Thomsen --- Changes since version 1: - Make parameter a config option. rules/sqlite.in | 8 ++++++++ rules/sqlite.make | 1 + 2 files changed, 9 insertions(+) diff --git a/rules/sqlite.in b/rules/sqlite.in index 7b60edf3e..e6e01ba97 100644 --- a/rules/sqlite.in +++ b/rules/sqlite.in @@ -30,6 +30,14 @@ config SQLITE_READLINE help Enable readline support +config SQLITE_FOREIGN_KEYS + bool + prompt "enable foreign keys by default" + help + Enable foreign keys support by default on database + connections. This ensures database schema constrains + are enforced by default e.g. consistency between tables. + comment "install options" config SQLITE_TOOL diff --git a/rules/sqlite.make b/rules/sqlite.make index b23c2d377..67a66a371 100644 --- a/rules/sqlite.make +++ b/rules/sqlite.make @@ -45,6 +45,7 @@ SQLITE_CONF_ENV := \ -DSQLITE_ENABLE_COLUMN_METADATA=1 \ -DSQLITE_ENABLE_FTS3_PARENTHESIS=1 \ -DSQLITE_ENABLE_UNLOCK_NOTIFY=1 \ + -DSQLITE_DEFAULT_FOREIGN_KEYS=$(call ptx/ifdef, PTXCONF_SQLITE_FOREIGN_KEYS,1,0) \ -DSQLITE_SOUNDEX=1 \ " base-commit: 9fe5462616de2ce93663f409f471ea83a6d5fbb5 -- 2.26.2 _______________________________________________ ptxdist mailing list ptxdist@pengutronix.de To unsubscribe, send a mail with subject "unsubscribe" to ptxdist-request@pengutronix.de