Error with a bash loop for sqlite insert

Question

I'm trying to insert stuff in db whith a while loop, but after 2 inserts my loop break ... here the code:

x=0
while [[ "$x" < 10 ]];do
    ((x++))
    sqlite my_db.db "insert into (col) values ('$x...')
done

So I tried to do that but unsuccess too.

y=0
x=0
while [[ "$y" < 5 ]];do
    while [[ "$x" < 10 ]];do
        ((x++))
        sqlite my_db.db "insert into (col) values ('$x...')"
    done
    ((y++))
done

But once again its only insert 2 times ... So why did i have this error and how to fixe that ? thx.

Tip: ShellCheck detects common problems, including this one. — that other guy
– that other guy, Commented Jul 7, 2017 at 20:16

hedgar2017 · Accepted Answer · 2017-07-07 19:50:12Z

1

< and > are string comparison operators.
For integers you must use -lt (less than) and -gt (greater than) respectively.
Also close the query string.

x=0
while [[ "$x" -lt 10 ]];do
    ((x++))
    sqlite my_db.db "insert into (col) values ('$x...')"
done

answered Jul 7, 2017 at 19:50

hedgar2017

1,6974 gold badges23 silver badges43 bronze badges

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

1 Comment

user7427983 Over a year ago

Thx you ... shame on me for don't trying this ..And the unclosed query is a typo (i'm on mobile).

Jeff Holt · Accepted Answer · 2017-07-07 20:08:00Z

1

Because your code never resets x to 0 (or anything less than 10). Additionally, you're using the wrong operator (which is why the first snippet isn't working).

x=0
y=0
while [[ $y -lt 5 ]];do
   x=0
   while [[ $x -lt 10 ]];do
      ((x++))
      sqlite my_db.db "insert into (col) values ('$x...')
   done
   ((y++))
done

edited Jul 7, 2017 at 20:08

answered Jul 7, 2017 at 19:45

Jeff Holt

3,2623 gold badges27 silver badges34 bronze badges

Collectives™ on Stack Overflow

Error with a bash loop for sqlite insert

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related