From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id UAFmJThW6V6jRwAA0tVLHw (envelope-from ) for ; Tue, 16 Jun 2020 23:31:04 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id IDw3IThW6V77cQAAbx9fmQ (envelope-from ) for ; Tue, 16 Jun 2020 23:31:04 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 1818A940415 for ; Tue, 16 Jun 2020 23:31:03 +0000 (UTC) Received: from localhost ([::1]:51842 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jlL2k-0000zi-Ab for larch@yhetil.org; Tue, 16 Jun 2020 19:31:02 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:56862) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jlL28-0000xH-PE for emacs-orgmode@gnu.org; Tue, 16 Jun 2020 19:30:24 -0400 Received: from [183.249.131.157] (port=2410 helo=localhost) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jlL26-0000z1-SK for emacs-orgmode@gnu.org; Tue, 16 Jun 2020 19:30:24 -0400 Received: by localhost (Postfix, from userid 1000) id 7504224160E; Wed, 17 Jun 2020 07:20:08 +0800 (CST) References: User-agent: mu4e 1.4; emacs 28.0.50 From: stardiviner To: Ag Ibragimov Subject: Re: ob-sql src blocks with a totally custom engine In-reply-to: Date: Wed, 17 Jun 2020 07:20:08 +0800 Message-ID: <87pn9ypphz.fsf@gmail.com> MIME-Version: 1.0 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable X-Host-Lookup-Failed: Reverse DNS lookup failed for 183.249.131.157 (deferred) Received-SPF: softfail client-ip=183.249.131.157; envelope-from=numbchild@gmail.com; helo=localhost X-detected-operating-system: by eggs.gnu.org: First seen = 2020/06/16 19:20:09 X-ACL-Warn: Detected OS = Linux 2.2.x-3.x [generic] [fuzzy] X-Spam_score_int: 63 X-Spam_score: 6.3 X-Spam_bar: ++++++ X-Spam_report: (6.3 / 5.0 requ) BAYES_00=-1.9, DKIM_ADSP_CUSTOM_MED=0.001, FORGED_GMAIL_RCVD=1, FREEMAIL_FROM=0.001, FSL_HELO_NON_FQDN_1=0.001, HELO_LOCALHOST=3.828, NML_ADSP_CUSTOM_MED=0.9, RDNS_NONE=0.793, SPF_SOFTFAIL=0.665, SPOOFED_FREEMAIL_NO_RDNS=1, URIBL_BLOCKED=0.001 autolearn=_AUTOLEARN X-Spam_action: reject X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-To: numbchild@gmail.com Cc: emacs-orgmode@gnu.org Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: 1.59 X-TUID: 6OZBt6XjlpML =2D----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Ag Ibragimov writes: > Is it possible to have source code SQL blocks that are processed with a c= ustom command line tool? > e.g. how can I make something like this to work: > > #+begin_src sql :cmdline "osqueryi --json" > select * from processes limit 5; > #+end_src I think it's possible. Should not be hard to implement. You can check out o= b-sql.el source code. > > For those who don't know what osquery is, here's a quote from https://osq= uery.io: "Osquery uses basic SQL commands to leverage a relational data-mod= el to describe a device." This is interesting project. > > I vaguely remember there was a way to basically "pipe" entire code block = to be executed in a given cmd line tool, but I am struggling to find how to= do that. There's a way, right? But even then, I think it requires the code= block to be of sh-mode of shell-mode, but I want it to be SQL because osqu= ery uses SQL. =2D --=20 [ stardiviner ] I try to make every word tell the meaning that I want to express. Blog: https://stardiviner.github.io/ IRC(freenode): stardiviner, Matrix: stardiviner GPG: F09F650D7D674819892591401B5DF1C95AE89AC3 =2D----BEGIN PGP SIGNATURE----- iQFIBAEBCAAyFiEE8J9lDX1nSBmJJZFAG13xyVromsMFAl7pU6gUHG51bWJjaGls ZEBnbWFpbC5jb20ACgkQG13xyVromsOTXQf/Z3CT2/mTjtCeaSGaZSzziO3TQVzO k8eIu/6cX9byVIg96DOpiyWy6+u89C9YTT78w2vqPy353P6+XOskkBBGPLyHlPqa PyePGNvOAGiFevT7CB0b2X6HuzhkL3bTJt7PQhkc/PakrN2Da7/MewC2UBNML5lQ t27KEv3JKjQcY79LtcEr0vT0TxXAY1gluO2Flm/b7jXF4DnNBOTfItqGdmTDOxRE t45jbbM/1SrpwsFvSTLQNI3WBklXDZNF3soiSoc+tw0g0Cn/MQqLKDN1ZE1zbGBf T8exQ+TuXjQn3yMC8zAhwIluaoCTxyN3gJIIVtT6ZCKrEblcvQxL3aonjA=3D=3D =3DyK3s =2D----END PGP SIGNATURE-----