Mercurial > hgrepos > hgweb.cgi > s4
changeset 123:718abe22a5d1
Call large query with SQL script in par2table()
| author | HIROSE Yuuji <yuuji@gentei.org> |
|---|---|
| date | Wed, 05 Aug 2015 23:49:14 +0900 |
| parents | 0681534f9451 |
| children | 9742dbee5cba |
| files | s4-funcs.sh |
| diffstat | 1 files changed, 11 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-funcs.sh Wed Aug 05 23:34:40 2015 +0900 +++ b/s4-funcs.sh Wed Aug 05 23:49:14 2015 +0900 @@ -1241,8 +1241,8 @@ query "END;" return fi + par2table $formdir/grp.def query "END TRANSACTION;" - par2table $formdir/grp.def # Remove orphant : <<EOF select a.id,b.val from (select * from blog where id in @@ -2276,8 +2276,16 @@ esac err p2t: "replace into $tb2 values($pval, \"$col\", $type, $val, bin...);" #query "replace into $tb2 values($pval, \"$col\", $type, $val, $bin);" - echo "replace into $tb2 values($pval, \"$col\", $type, $val, $bin);" \ - | sq $db + sql="replace into $tb2 values($pval, \"$col\", $type, $val, $bin);" + if [ x"$bin" = x"NULL" ]; then + err Normal-query: `echo $sql` + query "$sql" + else + sqlfile="$tmpd/query.$$" + echo "$sql" > $sqlfile + # err sqlfile=$sqlfile # `ls -lF $sqlfile` + query ".read $sqlfile" + fi err p2t done done done
