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 diff
1.1 --- a/s4-migrate.sh Fri Jun 12 21:27:53 2020 +0900 1.2 +++ b/s4-migrate.sh Sat Jun 13 07:49:52 2020 +0900 1.3 @@ -53,14 +53,13 @@ 1.4 WHERE id IN ($blogs); 1.5 EOF 1.6 done 1.7 - for blogid in $blogs; do 1.8 - for tbl in article article_s article_m; do 1.9 - query <<-EOF 1.10 + for tbl in article article_s article_m; do 1.11 + query <<-EOF 1.12 REPLACE INTO dst.$tbl 1.13 SELECT * FROM main.$tbl 1.14 - WHERE id IN (SELECT id FROM main.article WHERE blogid IN ($blogs)); 1.15 + WHERE id IN (SELECT id FROM main.article WHERE blogid IN ($blogs)) 1.16 + ORDER BY rowid; 1.17 EOF 1.18 - done 1.19 done 1.20 ## Check the equality of two DBs 1.21 echo "grid=$grid grp=$grp qgrp=$qgrp" | htmlescape 1.22 @@ -121,6 +120,7 @@ 1.23 EOF 1.24 # Create blog-rowid conversion table 1.25 sedfile=$tmpd/arttrans.sed 1.26 + sedfile=tmp/arttrans.sed 1.27 query <<-EOF > $sedfile 1.28 WITH arttrans AS ( 1.29 SELECT s.rowid srcrid, d.rowid dstrid