Mercurial > hgrepos > hgweb.cgi > s4
changeset 784:f9702e2c6591 feature-world
Ensure to roder by rowid
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Sat, 13 Jun 2020 07:49:52 +0900 |
parents | 5adf7e5a5fcc |
children | 1f310d682c07 |
files | s4-migrate.sh |
diffstat | 1 files changed, 5 insertions(+), 5 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-migrate.sh Fri Jun 12 21:27:53 2020 +0900 +++ b/s4-migrate.sh Sat Jun 13 07:49:52 2020 +0900 @@ -53,14 +53,13 @@ WHERE id IN ($blogs); EOF done - for blogid in $blogs; do - for tbl in article article_s article_m; do - query <<-EOF + for tbl in article article_s article_m; do + query <<-EOF REPLACE INTO dst.$tbl SELECT * FROM main.$tbl - WHERE id IN (SELECT id FROM main.article WHERE blogid IN ($blogs)); + WHERE id IN (SELECT id FROM main.article WHERE blogid IN ($blogs)) + ORDER BY rowid; EOF - done done ## Check the equality of two DBs echo "grid=$grid grp=$grp qgrp=$qgrp" | htmlescape @@ -121,6 +120,7 @@ EOF # Create blog-rowid conversion table sedfile=$tmpd/arttrans.sed + sedfile=tmp/arttrans.sed query <<-EOF > $sedfile WITH arttrans AS ( SELECT s.rowid srcrid, d.rowid dstrid