comparison s4-migrate.sh @ 822:fc6855839333

Remove trailing spaces
author HIROSE Yuuji <yuuji@gentei.org>
date Fri, 19 Jun 2020 09:52:46 +0900
parents 2465fff63ad9
children fcf485cbabc6
comparison
equal deleted inserted replaced
821:2465fff63ad9 822:fc6855839333
164 newval=`query "SELECT hex(replace(val, '$URL', '$dsturl')) 164 newval=`query "SELECT hex(replace(val, '$URL', '$dsturl'))
165 FROM dst.article_s WHERE rowid=$arid;" \ 165 FROM dst.article_s WHERE rowid=$arid;" \
166 | unhexize | sed -Ef "$sedfile2" | hexize` 166 | unhexize | sed -Ef "$sedfile2" | hexize`
167 echo "UPDATE dst.article_s SET val=X'$newval' WHERE rowid=$arid;" >>$sql 167 echo "UPDATE dst.article_s SET val=X'$newval' WHERE rowid=$arid;" >>$sql
168 done 168 done
169 echo "URL rewriting done." 169 echo "URL rewriting done."
170 echo -n "Removing the group in the old world..." 170 echo -n "Removing the group in the old world..."
171 if [ -z "`query \".read $sql\"`" ]; then 171 if [ -z "`query \".read $sql\"`" ]; then
172 query <<-EOF 172 query <<-EOF
173 SAVEPOINT rmgroup; 173 SAVEPOINT rmgroup;
174 DELETE FROM main.article WHERE blogid IN ($blogs); 174 DELETE FROM main.article WHERE blogid IN ($blogs);
175 DELETE FROM main.blog WHERE id IN ($blogs); 175 DELETE FROM main.blog WHERE id IN ($blogs);

yatex.org