1.1 --- a/s4-migrate.sh	Thu Jun 18 19:30:06 2020 +0900
     1.2 +++ b/s4-migrate.sh	Fri Jun 19 09:52:12 2020 +0900
     1.3 @@ -109,7 +109,7 @@
     1.4         )
     1.5    err d3="$d3"
     1.6    if [ -z "$d1$d2$d3" ]; then
     1.7 -    echo "Copying done, rewriting article links..."
     1.8 +    echo "Copy and verification done, rewriting URL in articles..."
     1.9      echo "Old URL: $URL"
    1.10      echo "New URL: $dsturl"
    1.11      query <<-EOF
    1.12 @@ -166,14 +166,19 @@
    1.13                | unhexize | sed -Ef "$sedfile2" | hexize`
    1.14        echo "UPDATE dst.article_s SET val=X'$newval' WHERE rowid=$arid;" >>$sql
    1.15      done
    1.16 +    echo "URL rewriting done." 
    1.17 +    echo -n "Removing the group in the old world..." 
    1.18      if [ -z "`query \".read $sql\"`" ]; then
    1.19        query <<-EOF
    1.20 +	SAVEPOINT rmgroup;
    1.21  	DELETE FROM main.article WHERE blogid IN ($blogs);
    1.22  	DELETE FROM main.blog WHERE id IN ($blogs);
    1.23  	DELETE FROM main.grp WHERE rowid=$grid;
    1.24 +	RELEASE SAVEPOINT rmgroup;
    1.25  	EOF
    1.26        s=`query "SELECT * FROM main.grp WHERE rowid=$grid;"`
    1.27        if [ -z "$s" ]; then
    1.28 +	echo "Done."
    1.29  	echo "Success!!"
    1.30  	query "END;"
    1.31  	clean-orphaned