11 lines
1.2 KiB
Bash
11 lines
1.2 KiB
Bash
|
#!/bin/sh
|
||
|
|
|
||
|
|
# insert into FWDUSER (email,fwdaddr,domain) VALUES ('dbagnoli@consiag.it','dbagnoli@domino01.estraspa.it','consiag.it');
|
||
|
|
# insert into MAILUSER (email,fwdaddr,domain) VALUES ('dbagnoli@consiag.it','dbagnoli@domino01.estraspa.it','consiag.it');
|
||
|
|
|
||
|
|
TEMPFILE=`mktemp -q /tmp/temp.XXXXXX`
|
||
|
|
#/usr/local/bin/sqlite3 $1 'select login, pwd, gid, email, home, shell, domain from MAILUSER;' | awk -F '|' '{printf "insert into MAILUSER ( login, pwd, gid, email, home, shell, domain ) VALUES ( \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\" )\n", $1,$2,$3,$4,$5,$6,$7 }' > ${TEMPFILE}
|
||
|
|
# cat ${TEMPFILE} | /usr/local/bin/sqlite3 /home/web/default/petar.company/db/petar.db3
|
||
|
|
/usr/local/bin/sqlite3 $1 'select login, pwd, gid, email, home, shell, domain from MAILUSER;' | awk -F '|' '{printf "insert into MAILUSER ( login, pwd, gid, email, home, shell, domain ) VALUES ( \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\" );\n", $1,$2,$3,$4,$5,$6,$7 }'
|
||
|
|
# /usr/local/bin/sqlite3 $1 'select login, pwd, gid, email, home, shell, domain from MAILUSER;' | awk -F '|' '{printf "insert into MAILUSER VALUES ( \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\", \"%s\" )\n", $1,$2,$3,$4,$5,$6,$7 }'
|