From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Javier Olaechea Newsgroups: gmane.emacs.bugs Subject: bug#70145: [PATCH] Add sqlite-execute-batch command Date: Tue, 2 Apr 2024 10:03:30 -0500 Message-ID: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="00000000000064652006151e6918" Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="38067"; mail-complaints-to="usenet@ciao.gmane.io" To: 70145@debbugs.gnu.org Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Tue Apr 02 17:05:20 2024 Return-path: Envelope-to: geb-bug-gnu-emacs@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1rrfhO-0009Xc-AU for geb-bug-gnu-emacs@m.gmane-mx.org; Tue, 02 Apr 2024 17:05:18 +0200 Original-Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rrfh6-0004Ig-BQ; Tue, 02 Apr 2024 11:05:00 -0400 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rrfh4-0004IP-DP for bug-gnu-emacs@gnu.org; Tue, 02 Apr 2024 11:04:58 -0400 Original-Received: from debbugs.gnu.org ([2001:470:142:5::43]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1rrfh4-0000lk-56 for bug-gnu-emacs@gnu.org; Tue, 02 Apr 2024 11:04:58 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1rrfh7-0003jm-Ri for bug-gnu-emacs@gnu.org; Tue, 02 Apr 2024 11:05:01 -0400 X-Loop: help-debbugs@gnu.org Resent-From: Javier Olaechea Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Tue, 02 Apr 2024 15:05:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 70145 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: patch X-Debbugs-Original-To: bug-gnu-emacs@gnu.org Original-Received: via spool by submit@debbugs.gnu.org id=B.171207024314018 (code B ref -1); Tue, 02 Apr 2024 15:05:01 +0000 Original-Received: (at submit) by debbugs.gnu.org; 2 Apr 2024 15:04:03 +0000 Original-Received: from localhost ([127.0.0.1]:54959 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rrfg9-0003dk-Cw for submit@debbugs.gnu.org; Tue, 02 Apr 2024 11:04:03 -0400 Original-Received: from lists.gnu.org ([2001:470:142::17]:52058) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1rrfg6-0003ck-UC for submit@debbugs.gnu.org; Tue, 02 Apr 2024 11:04:00 -0400 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rrfft-00035l-QH for bug-gnu-emacs@gnu.org; Tue, 02 Apr 2024 11:03:46 -0400 Original-Received: from mail-yb1-xb31.google.com ([2607:f8b0:4864:20::b31]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1rrffr-0000f7-SR for bug-gnu-emacs@gnu.org; Tue, 02 Apr 2024 11:03:45 -0400 Original-Received: by mail-yb1-xb31.google.com with SMTP id 3f1490d57ef6-dcc80d6006aso4750339276.0 for ; Tue, 02 Apr 2024 08:03:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1712070222; x=1712675022; darn=gnu.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=uB38tA2R1SmCuZNDolcMDAhNol1Um5RO/SCaY7EbrGU=; b=lO1DZE0guX80r4V02O6ArtGUmboQ0WZC1ZAEDu3ambL/J0F/7ETitjo/8w8/fTFsWH ZyaYyOkLX6ViZ4NEtNKM51gMa0TyHznBN6GxG0VIvIWTJstoJGQr5hpfSs2UTHs08lBZ GdqUtTmiz9xjNmaLWUyJwfkbrmFX9MxVbCAgXItE7UkT7CB3rQFzrYFCawQgL415WIw3 OB1BdpIuuOXhFxGGn8C2nvzfWJ9qqYHLYbknxPeaMLpapiq7xERHfCvyNjP//vjMrBoM 2Jig6/Jv69+Rp70FioyUkwRRldmpIh2o63TKxO0a/YKqMxVdXxeSZO+N74F7XQOdbarI Vi6g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1712070222; x=1712675022; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=uB38tA2R1SmCuZNDolcMDAhNol1Um5RO/SCaY7EbrGU=; b=pRiTuGDhGODE5R0vYNC2mQzrSps7Fp1W2Hg99prV0X4wS63u4bKg8RqJ0c6JCgbMkC teN8GG3R7HZmQNRZB8yqZDSvWcfOQRvY2NRamFZqDbRZ1cJgVvjU35mXTU+j7JBFd8gV kvQ0YFyTfF6HggZ1phbYQCD+gOtQooGHkv+YcxqbdVySj96HR2eSkJSqcMK0T6UWgYHK 5URRrnZFHmSjG5U4zyZ8wJ2o2god9kzmYQRC1RI4hkoAs6di7M5KAHFaRe4Xd80zl+2X Pi7sZljBMBr3YtPIZkds8q4lQG1D/caeWVNQaovaGMmAODFn3aVCDcVaRspkU1hKWHPw B46A== X-Gm-Message-State: AOJu0Yyud2hUz+BFGnW95GAxLMW8AZ0IyNwA/BwEwbGwy0k2LVFCZ/gX Mlz60VB3oEhDuEiqN+strB3Tz3+nDzTBuUtLsXcuh0DEKSnVpvMrwWnlZSWnTizkVMofYqi+sVi cJNHMsvm1u/4azc8PlkLzxnAsAaZjsexS3M0= X-Google-Smtp-Source: AGHT+IFN44YLkfEeHlw7rPw/0JJKomR9OopEYHWKPwbAlQLurGPz7cnKCZ62WLkBvtHM9rmq4FJp0IqiDXTgrNS2Pis= X-Received: by 2002:a25:cd84:0:b0:dcb:ff73:2262 with SMTP id d126-20020a25cd84000000b00dcbff732262mr10335741ybf.36.1712070221646; Tue, 02 Apr 2024 08:03:41 -0700 (PDT) Received-SPF: pass client-ip=2607:f8b0:4864:20::b31; envelope-from=pirata@gmail.com; helo=mail-yb1-xb31.google.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: bug-gnu-emacs@gnu.org List-Id: "Bug reports for GNU Emacs, the Swiss army knife of text editors" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Original-Sender: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Xref: news.gmane.io gmane.emacs.bugs:282516 Archived-At: --00000000000064652006151e6918 Content-Type: multipart/alternative; boundary="00000000000064651f06151e6916" --00000000000064651f06151e6916 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, while writing tests for an Emacs package I found myself needing to execute multiple statements against an in-memory database, to initialize the schema. Currently there is no easy way to do so as sqlite-execute only executes the first command and ignores the rest. The reason most likely being that accepting arguments for multiple statements and properly preparing would be a tricky task. So instead I'm adding the functionality as a new function that takes no arguments. In GNU Emacs 29.1 (build 1, x86_64-pc-linux-gnu, X toolkit, cairo version 1.18.0, Xaw3d scroll bars) Windowing system distributor 'The X.Org Foundation', version 11.0.12013000 System Description: Ubuntu 20.04.6 LTS Configured using: 'configure --prefix=3D/nix/store/0g4xxdsn4xp9qhgc4cylbksqpwsn51vc-emacs-29.1 --disable-build-details --with-modules --with-x-toolkit=3Dlucid --with-xft --with-cairo --with-native-compilation --with-tree-sitter --with-xinput2' --=20 "I object to doing things that computers can do." =E2=80=94 Olin Shivers --00000000000064651f06151e6916 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi, while writing tests for an Emacs package I found mysel= f needing to
execute multiple statements against an in-memory database, = to initialize
the schema. Currently there is no easy way to do so as sql= ite-execute
only executes the first command and ignores the rest. The re= ason most
likely being that accepting arguments for multiple statements = and
properly preparing would be a tricky task. So instead I'm adding= the
functionality as a new function that takes no arguments.

In GNU Emacs 29.1 (build 1, x86_64-pc-linux-gnu, X toolkit, cairo
versi= on 1.18.0, Xaw3d scroll bars)
Windowing system distributor 'The X.Or= g Foundation', version 11.0.12013000
System Description: Ubuntu 20.0= 4.6 LTS

Configured using:
=C2=A0'configure
=C2=A0--prefix= =3D/nix/store/0g4xxdsn4xp9qhgc4cylbksqpwsn51vc-emacs-29.1
=C2=A0--disabl= e-build-details --with-modules --with-x-toolkit=3Dlucid
=C2=A0--with-xft= --with-cairo --with-native-compilation --with-tree-sitter
=C2=A0--with-= xinput2'

--=
"I object to doing things that computers can do." = =E2=80=94 Olin Shivers
--00000000000064651f06151e6916-- --00000000000064652006151e6918 Content-Type: text/x-patch; charset="US-ASCII"; name="0001-Add-sqlite-execute-batch-command.patch" Content-Disposition: attachment; filename="0001-Add-sqlite-execute-batch-command.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_luiidoik0 RnJvbSA0NTRiMjNjYjMxMzMyZmJkNWI1ZDJjNTExNzM5NGM1Nzg1ODFiNzJiIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBKYXZpZXIgT2xhZWNoZWEgPHBpcmF0YUBnbWFpbC5jb20+CkRh dGU6IFN1biwgMzEgTWFyIDIwMjQgMjM6MDc6MTAgLTA1MDAKU3ViamVjdDogW1BBVENIXSBBZGQg c3FsaXRlLWV4ZWN1dGUtYmF0Y2ggY29tbWFuZAoKVGhpcyBjb21tYW5kIGlzIHNpbWlsYXIgdG8g c3FsaXRlLWV4ZWN1dGUgZXhjZXB0IHRoYXQgaXQgZXhlY3V0ZXMKbXVsdGlwbGUgc3RhdGVtZW50 cyBpbiBleGNoYW5nZSBmb3Igbm90IGFjY2VwdGluZyBhbnkgYXJndW1lbnRzLgoKKiBkb2MvbGlz cHJlZi90ZXh0LnRleGkgKERhdGFiYXNlKTogRG9jdW1lbnQgaXQuCiogc3JjL3NxbGl0ZS5jIChG c3FsaXRlX2V4ZWN1dGVfYmF0Y2gpOiBBZGQgc3FsaXRlX2V4ZWN1dGVfYmF0Y2gKY29tbWFuZC4g SXQgaXMgc2ltaWxhciB0byBzcWxpdGUtZXhlY3V0ZSBidXQgaXQgZXhlY3V0ZXMgYWxsIHRoZQpz dGF0ZW1lbnRzIGluIHRoZSBxdWVyeS4gVW5saWtlIHNxbGl0ZS1leGVjdXRlIHRoZSBjb21tYW5k IGRvZXNuJ3QgdGFrZQphbnkgYXJndW1lbnRzIHRvIHBhc3MgZG93biB0byB0aGUgc3RhdGVtZW50 cy4KLS0tCiBkb2MvbGlzcHJlZi90ZXh0LnRleGkgfCAgNiArKysrKysKIHNyYy9zcWxpdGUuYyAg ICAgICAgICB8IDEwICsrKysrKysrKysKIDIgZmlsZXMgY2hhbmdlZCwgMTYgaW5zZXJ0aW9ucygr KQoKZGlmZiAtLWdpdCBhL2RvYy9saXNwcmVmL3RleHQudGV4aSBiL2RvYy9saXNwcmVmL3RleHQu dGV4aQppbmRleCA5MGUyYzZjZTg4Mi4uY2FkNmRmNTJlNTUgMTAwNjQ0Ci0tLSBhL2RvYy9saXNw cmVmL3RleHQudGV4aQorKysgYi9kb2MvbGlzcHJlZi90ZXh0LnRleGkKQEAgLTU0MDQsNiArNTQw NCwxMiBAQCBEYXRhYmFzZQogCiBAZW5kIGRlZnVuCiAKK0BkZWZ1biBzcWxpdGUtZXhlY3V0ZS1i YXRjaCBkYiBzdGF0ZW1lbnRzCitFeGVjdXRlIHRoZSBAYWNyb255bXtTUUx9IEB2YXJ7c3RhdGVt ZW50c30uIFRoaXMgbWlnaHQgYmUgdXNlZnVsIHdoZW4gd2UKK3dhbnQgdG8gZXhlY3V0ZSBtdWx0 aXBsZSBAYWNyb255bXtEREx9IHN0YXRlbWVudHMuCisKK0BlbmQgZGVmdW4KKwogQGRlZnVuIHNx bGl0ZS1zZWxlY3QgZGIgcXVlcnkgJm9wdGlvbmFsIHZhbHVlcyByZXR1cm4tdHlwZQogU2VsZWN0 IHNvbWUgZGF0YSBmcm9tIEB2YXJ7ZGJ9IGFuZCByZXR1cm4gdGhlbS4gIEZvciBpbnN0YW5jZToK IApkaWZmIC0tZ2l0IGEvc3JjL3NxbGl0ZS5jIGIvc3JjL3NxbGl0ZS5jCmluZGV4IDI2MTA4MGRh NjczLi4wNDM4MDE0NTlkMiAxMDA2NDQKLS0tIGEvc3JjL3NxbGl0ZS5jCisrKyBiL3NyYy9zcWxp dGUuYwpAQCAtNjQ2LDYgKzY0NiwxNSBAQCBzcWxpdGVfZXhlYyAoc3FsaXRlMyAqc2RiLCBjb25z dCBjaGFyICpxdWVyeSkKICAgcmV0dXJuIFF0OwogfQogCitERUZVTiAoInNxbGl0ZS1leGVjdXRl LWJhdGNoIiwgRnNxbGl0ZV9leGVjdXRlX2JhdGNoLCBTc3FsaXRlX2V4ZWN1dGVfYmF0Y2gsIDIs IDIsIDAsCisgICAgICAgZG9jOiAvKiBFeGVjdXRlIG11bHRpcGxlIFNRTCBzdGF0ZW1lbnRzLiAg Ki8pCisgIChMaXNwX09iamVjdCBkYiwgTGlzcF9PYmplY3QgcXVlcnkpCit7CisgIGNoZWNrX3Nx bGl0ZSAoZGIsIGZhbHNlKTsKKyAgQ0hFQ0tfU1RSSU5HIChxdWVyeSk7CisgIHJldHVybiBzcWxp dGVfZXhlYyAoWFNRTElURSAoZGIpLT5kYiwgU1NEQVRBIChxdWVyeSkpOworfQorCiBERUZVTiAo InNxbGl0ZS10cmFuc2FjdGlvbiIsIEZzcWxpdGVfdHJhbnNhY3Rpb24sIFNzcWxpdGVfdHJhbnNh Y3Rpb24sIDEsIDEsIDAsCiAgICAgICAgZG9jOiAvKiBTdGFydCBhIHRyYW5zYWN0aW9uIGluIERC LiAgKi8pCiAgIChMaXNwX09iamVjdCBkYikKQEAgLTg2Niw2ICs4NzUsNyBAQCBzeW1zX29mX3Nx bGl0ZSAodm9pZCkKICAgZGVmc3ViciAoJlNzcWxpdGVfY2xvc2UpOwogICBkZWZzdWJyICgmU3Nx bGl0ZV9leGVjdXRlKTsKICAgZGVmc3ViciAoJlNzcWxpdGVfc2VsZWN0KTsKKyAgZGVmc3ViciAo JlNzcWxpdGVfZXhlY3V0ZV9iYXRjaCk7CiAgIGRlZnN1YnIgKCZTc3FsaXRlX3RyYW5zYWN0aW9u KTsKICAgZGVmc3ViciAoJlNzcWxpdGVfY29tbWl0KTsKICAgZGVmc3ViciAoJlNzcWxpdGVfcm9s bGJhY2spOwotLSAKMi4yOS4yLjE1NC5nN2Y3ZWJlMDU0YQoK --00000000000064652006151e6918--