Mercurial > hgrepos > hgweb.cgi > s4
changeset 795:6164d88fbc0e feature-world
Update replyblog URL with ERE
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Sun, 14 Jun 2020 09:50:30 +0900 |
parents | 8448724f69e3 |
children | 8646ec4bd6fc |
files | s4-migrate.sh |
diffstat | 1 files changed, 3 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-migrate.sh Sun Jun 14 08:47:48 2020 +0900 +++ b/s4-migrate.sh Sun Jun 14 09:50:30 2020 +0900 @@ -128,7 +128,7 @@ FROM main.article s JOIN dst.article d ON s.id=d.id WHERE s.id in (SELECT id FROM article WHERE blogid IN ($blogs)) - ) SELECT printf("/^>/s/\#%s($|[ ,\#])/\#%s\1/g", srcrid, dstrid) + ) SELECT printf("/^>/s/\#%s($|[^0-9])/\#%s\1/g", srcrid, dstrid) FROM arttrans; EOF query <<-EOF > $tmpd/repl.art.rowid @@ -150,7 +150,7 @@ SELECT s.rowid srcrid, d.rowid dstrid FROM main.blog s JOIN dst.blog d ON s.id=d.id WHERE s.id IN ($blogs) - ) SELECT printf('s/\(\?replyblog\)\+%s\([^0-9]*\)/\1+%s\2/g', + ) SELECT printf('s/(\?replyblog)\+%s($|[^0-9])/\1+%s\2/g', srcrid, dstrid) FROM blogtrans; EOF @@ -163,7 +163,7 @@ for arid in `cat $bloglinks`; do newval=`query "SELECT hex(replace(val, '$URL', '$dsturl')) FROM dst.article_s WHERE rowid=$arid;" \ - | unhexize | sed -f "$sedfile2" | hexize` + | unhexize | sed -Ef "$sedfile2" | hexize` echo "UPDATE dst.article_s SET val=X'$newval' WHERE rowid=$arid;" >>$sql done if query ".read $sql"; then