|
561
|
1 #!/bin/sh
|
|
|
2
|
|
|
3 while getopts r i; do
|
|
|
4 case $i in
|
|
|
5 r) mode=restore ;;
|
|
|
6 esac
|
|
|
7 done
|
|
|
8 shift $((OPTIND - 1))
|
|
|
9
|
|
|
10 if [ -z "$2" ]; then
|
|
|
11 cat<<-EOF >&2
|
|
|
12 Usage:
|
|
|
13 $0 DB out.csv user(s) - dump users to out.csv
|
|
|
14 $0 -r DB out.csv - import nonexistent user from out.csv
|
|
|
15 EOF
|
|
|
16 exit 1
|
|
|
17 fi
|
|
|
18
|
|
|
19 target=$(cd `dirname "$1"`; pwd)/`basename $1`
|
|
|
20
|
|
|
21 db=$1
|
|
|
22 shift
|
|
|
23 out=$1
|
|
|
24 shift
|
|
|
25
|
|
|
26 if [ x"$mode" = x"restore" ]; then
|
|
|
27 echo "begin;"
|
|
|
28 echo ".read $out"
|
|
|
29 echo "end;"
|
|
|
30 else
|
|
|
31 echo ".output $out"
|
|
|
32 for u; do
|
|
|
33 echo ".mode insert user"
|
|
|
34 echo "SELECT * FROM user WHERE name LIKE '$u';"
|
|
|
35 echo ".mode insert user_s"
|
|
|
36 echo "SELECT * FROM user_s WHERE name LIKE '$u';"
|
|
|
37 echo ".mode insert user_m"
|
|
|
38 echo "SELECT * FROM user_m WHERE name LIKE '$u';"
|
|
|
39 done
|
|
|
40 fi | sqlite3 $db
|
