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 diff
1.1 --- a/s4-migrate.sh Sun Jun 14 08:47:48 2020 +0900 1.2 +++ b/s4-migrate.sh Sun Jun 14 09:50:30 2020 +0900 1.3 @@ -128,7 +128,7 @@ 1.4 FROM main.article s JOIN dst.article d ON s.id=d.id 1.5 WHERE s.id in (SELECT id 1.6 FROM article WHERE blogid IN ($blogs)) 1.7 - ) SELECT printf("/^>/s/\#%s($|[ ,\#])/\#%s\1/g", srcrid, dstrid) 1.8 + ) SELECT printf("/^>/s/\#%s($|[^0-9])/\#%s\1/g", srcrid, dstrid) 1.9 FROM arttrans; 1.10 EOF 1.11 query <<-EOF > $tmpd/repl.art.rowid 1.12 @@ -150,7 +150,7 @@ 1.13 SELECT s.rowid srcrid, d.rowid dstrid 1.14 FROM main.blog s JOIN dst.blog d ON s.id=d.id 1.15 WHERE s.id IN ($blogs) 1.16 - ) SELECT printf('s/\(\?replyblog\)\+%s\([^0-9]*\)/\1+%s\2/g', 1.17 + ) SELECT printf('s/(\?replyblog)\+%s($|[^0-9])/\1+%s\2/g', 1.18 srcrid, dstrid) 1.19 FROM blogtrans; 1.20 EOF 1.21 @@ -163,7 +163,7 @@ 1.22 for arid in `cat $bloglinks`; do 1.23 newval=`query "SELECT hex(replace(val, '$URL', '$dsturl')) 1.24 FROM dst.article_s WHERE rowid=$arid;" \ 1.25 - | unhexize | sed -f "$sedfile2" | hexize` 1.26 + | unhexize | sed -Ef "$sedfile2" | hexize` 1.27 echo "UPDATE dst.article_s SET val=X'$newval' WHERE rowid=$arid;" >>$sql 1.28 done 1.29 if query ".read $sql"; then