Avoid repeating variable setup in bash

Question

Bash newbie here! How do I avoid repeating the "PASSGEN=$(</dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12)" each time in this bash script excerpt?

sqlite variables.db "create table passwords (name TEXT PRIMARY KEY, value TEXT);"
PASSGEN=$(</dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12)
sqlite variables.db "insert into passwords (name,value) values ('BOOKSTACK_MYSQL_ROOT', '$PASSGEN');"
PASSGEN=$(</dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12)
sqlite variables.db "insert into passwords (name,value) values ('BOOKSTACK_MYSQL', '$PASSGEN');"
PASSGEN=$(</dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12)
sqlite variables.db "insert into passwords (name,value) values ('BORG_PASSPHRASE', '$PASSGEN');"
PASSGEN=$(</dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12)
sqlite variables.db "insert into passwords (name,value) values ('CODE_SERVER_PASS', '$PASSGEN');"
PASSGEN=$(</dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12)
sqlite variables.db "insert into passwords (name,value) values ('CODE_SERVER_SUDO_PASS', '$PASSGEN');"
PASSGEN=$(</dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12)
sqlite variables.db "insert into passwords (name,value) values ('EXPORTARR_TOKEN', '$PASSGEN');"
PASSGEN=$(</dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12)
sqlite variables.db "insert into passwords (name,value) values ('FLAME_PASS', '$PASSGEN');"
PASSGEN=$(</dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12)
sqlite variables.db "insert into passwords (name,value) values ('FLIGHTAIRMAP_INSTALL_PASS', '$PASSGEN');"

Green 绿色 · Accepted Answer · 2022-05-24 12:25:48Z

2

A simple solution would be to write a function:

function generate_password {
    </dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12
}

Then, your code snippet becomes:

sqlite variables.db "create table passwords (name TEXT PRIMARY KEY, value TEXT);"
sqlite variables.db "insert into passwords (name,value) values ('BOOKSTACK_MYSQL_ROOT', '$(generate_password)');"
sqlite variables.db "insert into passwords (name,value) values ('BOOKSTACK_MYSQL', '$(generate_password)');"
sqlite variables.db "insert into passwords (name,value) values ('BORG_PASSPHRASE', '$(generate_password)');"
# ...

answered May 24, 2022 at 12:25

Green 绿色

3,2033 gold badges33 silver badges66 bronze badges

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

2 Comments

AnimeAi Over a year ago

Perfect! Thanks for the super fast and concise help!

Green 绿色 Over a year ago

No problem. If this solution is what you need, select this answer as "accepted answer".

pjh · Accepted Answer · 2022-05-24 13:42:33Z

1

One way to do it is to use a loop for the table insertions. Try this Shellcheck-clean code:

sqlite variables.db "create table passwords (name TEXT PRIMARY KEY, value TEXT);"

for name in BOOKSTACK_MYSQL_ROOT BOOKSTACK_MYSQL BORG_PASSPHRASE    \
            CODE_SERVER_PASS CODE_SERVER_SUDO_PASS EXPORTARR_TOKEN  \
            FLAME_PASS FLIGHTAIRMAP_INSTALL_PASS
do
    passgen=$(</dev/urandom tr -dc _A-Z-a-z-0-9 | head -c12)
    sqlite variables.db "insert into passwords (name,value) values ('$name', '$passgen');"
done

See Correct Bash and shell script variable capitalization for an explanation of why I replaced PASSGEN with passgen.

answered May 24, 2022 at 13:42

pjh

8,4232 gold badges20 silver badges21 bronze badges

Collectives™ on Stack Overflow

Avoid repeating variable setup in bash

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related