From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 3371 invoked by alias); 22 Feb 2017 15:44:52 -0000 Mailing-List: contact zsh-workers-help@zsh.org; run by ezmlm Precedence: bulk X-No-Archive: yes List-Id: Zsh Workers List List-Post: List-Help: X-Seq: 40616 Received: (qmail 5389 invoked from network); 22 Feb 2017 15:44:52 -0000 X-Qmail-Scanner-Diagnostics: from park01.gkg.net by f.primenet.com.au (envelope-from , uid 7791) with qmail-scanner-2.11 (clamdscan: 0.99.2/21882. spamassassin: 3.4.1. Clear:RC:0(205.235.26.22):SA:0(0.5/5.0):. Processed in 2.722293 secs); 22 Feb 2017 15:44:52 -0000 X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on f.primenet.com.au X-Spam-Level: X-Spam-Status: No, score=0.5 required=5.0 tests=HEADER_FROM_DIFFERENT_DOMAINS, RCVD_IN_SORBS_SPAM,RP_MATCHES_RCVD,T_DKIM_INVALID autolearn=no autolearn_force=no version=3.4.1 X-Envelope-From: SRS0=Kcsy=2D=brasslantern.com=schaefer@bounces.park01.gkg.net X-Qmail-Scanner-Mime-Attachments: | X-Qmail-Scanner-Zip-Files: | Received-SPF: none (ns1.primenet.com.au: domain at bounces.park01.gkg.net does not designate permitted sender hosts) X-Virus-Scanned: by amavisd-new at gkg.net Authentication-Results: amavisd4.gkg.net (amavisd-new); dkim=pass (2048-bit key) header.d=brasslantern-com.20150623.gappssmtp.com X-Greylist: from auto-whitelisted by SQLgrey-1.8.0 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=brasslantern-com.20150623.gappssmtp.com; s=20150623; h=from:message-id:date:in-reply-to:comments:references:to:subject :mime-version; bh=EaViK6ktepWDOpardMzW44j3exAYOMWT75zPw8uy7m0=; b=vjHlcL+EqJawvjOxeyRQ0/9zn8qNuBDDkXDdq7ixddOfzhVJvvuYDdDfpmdJl5IkJa 8kROvkjG4aJ9vdbSPk/S+jcPaeYGC76HOn+LBi9E+hw6mXEg7cw4h6PNiRayyDgF4jl4 4X4Up512BVclW5I6K6iRg15szJvbWNY3qxd44pSNZD2dojtTQxmklgulIKhtoKEaTQ0h EJjTiqlUjd3R3c/Rh+ssSZPbcDEKwje4RxjgEWTEgS+x5skH3F3cdqJGfxqjk+fiKF/Z TqpptYg7q/HpgQPx5tUWcf9t3AQ5thXMoCvQgzgWUJGaXWiTYmyGaxM8ybYK6yclOhhG x6Yw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:message-id:date:in-reply-to:comments :references:to:subject:mime-version; bh=EaViK6ktepWDOpardMzW44j3exAYOMWT75zPw8uy7m0=; b=QlMasUXetH0yFmpqpovp7xWD48cQm0cj/tmqsY4ZX2G6ihHH3xb8kz/9wI2ZwU5gYm PgICTclvlS3ZjA+YRTK2Eh5FIKx7qaq5goaMym7Gz4ezMIejW7EQE6ywSUsG71wOEOgx PjuivLx+vleJfsYHQGycccLNl6Q36g1h4/3RUWZaJCMMcP/wvTLsnSGDfYyad4wglrWZ sdNufv+P4evDt+cQs7Y5YfUJMmuWuKnbe3KYQyKGc443ClPdI1wDU9w8pp5zqy2iZIBy FhPh6/SnNvkpiFiBcfl9k7CNn4nq6Xuh1JGjnGN6cVuB9y6VBBY3+LKguvRy5fo8ZIhf mxPQ== X-Gm-Message-State: AMke39nQdAQ6nxH8QncFdntAu6fhwvGGjhNZDiXy9HIotOPQYzGNadr7E6spUUFiUkBSbQ== X-Received: by 10.176.74.209 with SMTP id t17mr4683095uae.176.1487778258390; Wed, 22 Feb 2017 07:44:18 -0800 (PST) From: Bart Schaefer Message-Id: <170222074415.ZM18336@torch.brasslantern.com> Date: Wed, 22 Feb 2017 07:44:15 -0800 In-Reply-To: <1487754648.2910142.888918792.4BD9197F@webmail.messagingengine.com> Comments: In reply to Sebastian Gniazdowski "Re: Gdbm module" (Feb 22, 1:10am) References: <170221092506.ZM14329@torch.brasslantern.com> <1487706736.1879125.888350120.03C172EE@webmail.messagingengine.com> <170221204132.ZM15938@torch.brasslantern.com> <1487754648.2910142.888918792.4BD9197F@webmail.messagingengine.com> X-Mailer: OpenZMail Classic (0.9.2 24April2005) To: zsh-workers@zsh.org Subject: Re: Gdbm module MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii On Feb 22, 1:10am, Sebastian Gniazdowski wrote: } } On Tue, Feb 21, 2017, at 08:41 PM, Bart Schaefer wrote: } > ztie -d db/sqlite -Q "SELECT ..." ... queryresult } > } > and define queryresult in a manner similar to the way Perl DBI does } > with fetchall_hashref. } } Interesting, it assumes single row to be selected in Zsh conditions, as } far I understand. Either that, or the keys would be the unique key for each row and the values would be either a single column, or encoded somehow so that they could be split into fields. We are somewhat limited by lacking a mechanism for nested hashrefs, but consider the way "typeset -T" can specify the format of array <-> scalar joining.