sed等 を使って confファイルの編集を自動化したい

Question

こういうconfファイルがあったとして、

cat << 'EOF' > tmp.txt
aaa
bbb
ccc
DB = [ BACKEND = "sqlite" ]
ddd
EOF

tmp変数にこういう文字列をいれて、

tmp=$(cat << 'EOF'
#DB = [ BACKEND = "sqlite" ]
DB = [ backend = "mysql",
 server = "localhost",
 port = 0,
 user = "userrr",
 passwd = "passwddd",
 db_name = "dbbb" ]
EOF
)

^DBのところに tmp変数のような 複数行文字列を追記したいです。
(これはsedのsが終わらないみたいで、うまくいきません)

cat tmp.txt | sed -r "s/^DB =.*/${tmp}/"
#DB = [ BACKEND = "sqlite" ]
DB = [ backend = "mysql",
 server = "localhost",
 port = 0,
 user = "userrr",
 passwd = "passwddd",
 db_name = "dbbb" ]

・一度変数に入れずに追記したいですし、
・ワンライナー?でこんな風にできたらいいと思うのですが、
何かいい方法ないでしょうか。

cat << 'EOF' | sed i.bak -r "s/^DB =.*/$(cat)/" tmp.txt
aaa
bbb
ccc
#DB = [ BACKEND = "sqlite" ]
DB = [ backend = "mysql",
 server = "localhost",
 port = 0,
 user = "userrr",
 passwd = "passwddd",
 db_name = "dbbb" ]
ddd
EOF

Answer 1

perlだと難しくないですね。sedはよく分かりません。

tmp.txt

aaa
bbb
ccc
DB = [ BACKEND = "sqlite" ]
ddd

newdata.txt

DB = [ backend = "mysql",
 server = "localhost",
 port = 0,
 user = "userrr",
 passwd = "passwddd",
 db_name = "dbbb" ]

perl -i.bak -pe 'BEGIN{$new=join("",<STDIN>)} s/DB = [^]]*/$new/' tmp.txt < newdata.txt

Comments

[teityura]

こちらの方法を使わせていただきます！ありがとうございました。

Answer 2

I dont know the reason why you use sed to replace strings with LF. I think you can use another way that meet your demand, which is easier to understand and to maintain as following:

$ cat << "EOF" > db.conf.in
aaa
bbb
ccc
ddd
EOF

$ cat << "EOF" > sqlite.conf.in
DB = [ backend = "sqlite" ]
EOF

$ cat << "EOF" > mysql.conf.in
DB = [ 
 backend = "mysql",
 server = "localhost",
 port = 0,
 user = "userrr",
 passwd = "passwddd",
 db_name = "dbbb"
]
EOF

and to get db.conf for sqlite:

$ cat db.conf.in sqlite.conf.in > db.conf

or for mysql:

$ cat db.conf.in mysql.conf.in > db.conf

Free from sed and LF!

Answer 3

^DBのところに tmp変数のような 複数行文字列を追記したいです。

^DBの行の前に、複数行を挿入したければ、こうです。

sed '/^DB/i\
aaa\
bbb\
ccc
' tmp.txt