using sqlite3 in for loop in shell script gives error

Question

Need to query a certain value from each file in a directory and put it in a file. I use the code:

#!/bin/bash 

ls -lrt | grep -w  "458752" | awk '{print $9}' | sort -V > list

for linename in cat list 
do 

/d/home/alima0152/Desktop/sqlite3 $linename "select trace_count from volume"; >> trc_count 

done 

rm list

But I get this error:

file is encrypted or is not a database

I am also using the latest version of sqlite3

Abhishake Yadav
– Abhishake Yadav

2016-10-16 01:46:56 +00:00
Commented Oct 16, 2016 at 1:46 — Abhishake Yadav
– Abhishake Yadav, Commented Oct 16, 2016 at 1:46

CL. · Accepted Answer · 2016-10-16 06:13:26Z

1

This code is trying to open the files cat and list.

To execute something and insert its output, use `...` or $(...):

for linename in $(cat list)

answered Oct 16, 2016 at 6:13

CL.

182k18 gold badges241 silver badges282 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

using sqlite3 in for loop in shell script gives error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related