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

yatex.org