I want to update files values used for database connection in this file:
./software/config/database.yml
file content:
base: &base
adapter: mysql2
username: root
password:
How I can set username and password using bash?
Asked
Active
Viewed 4,292 times
-3
Peter Penzov
- 1,126
- 134
- 430
- 808
-
1What about `vim`, `nano`, `emacs`, etc? That question seems off-topic – illright Nov 21 '16 at 12:51
-
I want to do this using script because I have this file in many locations. – Peter Penzov Nov 21 '16 at 12:52
-
so then you should clearly specify your intentions. As of now, your problem is solvable with a single text editor – illright Nov 21 '16 at 12:53
-
Can you show me a solution with bash script? – Peter Penzov Nov 21 '16 at 12:58
1 Answers
2
awk -F: -v OFS=: '/username/{$2=" NEWUSER"} /password:/{$2=" NEWPASS"}1' inputfile
base: &base
adapter: mysql2
username: NEWUSER
password: NEWPASS
If new username and password are stored in a variable :
awk -F: -v OFS=: -v newPass=" NEWPASS" -v newUser=" NEWUSER" '/username/{$2=newUser} /password:/{$2=newPass}1' input
For editing file:
awk -F: -v OFS=: -v newPass=" NEWPASS" -v newUser=" NEWUSER" '/username/{$2=newUser} /password:/{$2=newPass}1' inputfile > user.tmp && mv user.tmp inputfile
P....
- 17,421
- 2
- 32
- 52
-
One question how I can define the variables at the beginning of the bash script? – Peter Penzov Nov 21 '16 at 13:08
-
you can use `-v newPass="$variable"` in second awk command.where $variable store value of password. you can define it anywhere before execution of this awk command. – P.... Nov 21 '16 at 13:11
-
-
if your `awk` supports `-i` option then you can do inplace replacement. Other wise you can do check update. – P.... Nov 21 '16 at 13:16
-
Look [here](http://stackoverflow.com/questions/16529716/awk-save-modifications-inplace) for info on Gnu awk's `inplace`.edit. – James Brown Nov 21 '16 at 18:00