[SOLVED] bash script: generate 1000 lines for SQL

Lexus45 · 03-17-2015, 05:08 AM

Hello.

I need to generate 10000 SQL INSERTs like these:

Code:

INSERT INTO sip_conf_new (name,callerid,defaultuser,context,port) VALUES ('0001','Operator 0001 <0001>','0001','operators','5060');
...
INSERT INTO sip_conf_new (name,callerid,defaultuser,context,port) VALUES ('9999','Operator 9999 <9999>','9999','operators','5060');

and like these:

Code:

INSERT INTO sip_conf_new (name,callerid,defaultuser,context,port) VALUES ('0001d','Operator 0001 <0001>','0001d','operators','5060');
...
INSERT INTO sip_conf_new (name,callerid,defaultuser,context,port) VALUES ('9999d','Operator 9999 <9999>','9999d','operators','5060');

So, the first variant works fine -

Code:

#!/bin/bash

for i in $(seq 5)
do
    echo "INSERT INTO sip_conf_new (name,callerid,defaultuser,context,port) VALUES ('000$i','"Operator 000$i" <000$i>','000$i','operators','5060');"
done

But I face a problem hot to add 'd'. I tried to use '$i' , `$i`, {$i} in script. But no success.

How to screen a variable?
Thank you.

============

UPDATE:

Oh... This works fine :)

Code:

#!/bin/bash

D="d"

for i in $(seq 5)
do
    echo "INSERT INTO sip_conf_new (name,callerid,defaultuser,context,port) VALUES ('000$i$D','"Operator 000$i" <000$i>','000$i$D','operators','5060');"
done

linosaurusroot · 03-19-2015, 07:29 AM

$iD does not work because it looks for a variable called iD.
$i$D is what you did.
${i}D would have been the simplest option.