Mercurial > hgrepos > hgweb.cgi > s4
changeset 790:7ac852e8c216 feature-world
Update URL only itself
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Sat, 13 Jun 2020 17:04:29 +0900 |
parents | ce8942919edf |
children | 567980314463 |
files | s4-migrate.sh |
diffstat | 1 files changed, 4 insertions(+), 6 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-migrate.sh Sat Jun 13 14:33:23 2020 +0900 +++ b/s4-migrate.sh Sat Jun 13 17:04:29 2020 +0900 @@ -114,12 +114,10 @@ echo "New URL: $dsturl" query <<-EOF UPDATE dst.article_s - SET val=replace(val, '$URL', '$dsturl') - WHERE key='text' AND val LIKE '|${URL}|' ESCAPE '|'; - UPDATE dst.blog_s - SET val=replace(val, '$URL', '$dsturl') - WHERE key='heading' AND val LIKE '|${URL}|' ESCAPE '|'; - EOF + SET val=replace(val, + '${URL}?grp+$grid', + '${dsturl}?grp+$destrowid') + WHERE key='text' AND val LIKE '%${URL}%'; # Create blog-rowid conversion table sedfile=$tmpd/arttrans.sed # sedfile=tmp/arttrans.sed