Re: [sqlite] [OT] suggestion for shell script and variable interpolation

On 11/9/16, Luca Ferrari wrote: > Hi all, > this could be trivial, but assuming I need some shell script to query > SQLite3 databases with variable-interpolated queries, what can I do? I typically using "tclsh" for this. https://www.tcl-lang.org/ SQLite is really a TCL

Re: [sqlite] [OT] suggestion for shell script and variable interpolation

On 11/09/2016 02:39 PM, Luca Ferrari wrote: Hi all, this could be trivial, but assuming I need some shell script to query SQLite3 databases with variable-interpolated queries, what can I do? Of course the following does not work because ticks prevent variable interpolation: COUNT=`sqlite3 $db

Re: [sqlite] [OT] suggestion for shell script and variable interpolation

COUNT=$(sqlite3 "$db" "SELECT COUNT(*) FROM foo WHERE baz='$BAZ'") should totally work (I quoted $BAZ as a string, don't do that if it is a number, and you should escape any ' in $BAZ). On Wed, Nov 9, 2016 at 11:40 AM Clemens Ladisch wrote: > Luca Ferrari wrote: > > this

Re: [sqlite] [OT] suggestion for shell script and variable interpolation

Luca Ferrari wrote: > this could be trivial, but assuming I need some shell script to query > SQLite3 databases with variable-interpolated queries, what can I do? > Of course the following does not work because ticks prevent variable > interpolation: > > COUNT=`sqlite3 $db 'SELECT COUNT(*) FROM

[sqlite] [OT] suggestion for shell script and variable interpolation

Hi all, this could be trivial, but assuming I need some shell script to query SQLite3 databases with variable-interpolated queries, what can I do? Of course the following does not work because ticks prevent variable interpolation: COUNT=`sqlite3 $db 'SELECT COUNT(*) FROM foo WHERE baz=$BAZ'` and