Changeset 20358

Timestamp:

Jul 2, 2006, 2:58:57 PM (18 years ago)

Author:

markus

Message:

Speed up for non-DBF drivers

File:

• grass/trunk/scripts/v.rast.stats/v.rast.stats (modified) (4 diffs)

grass/trunk/scripts/v.rast.stats/v.rast.stats

@@ -71 +71 @@
 fi
 TMPNAME=`basename $TMP`
+SQLTMP=$TMPNAME.sql
 
 cleanup()
@@ -83 +84 @@
    g.rename ${TMPNAME}_origmask,MASK > /dev/null
  fi
- rm -f $TMPNAME $TMP.cats
+ rm -f $TMPNAME $TMP.cats $SQLTMP
 }
 
@@ -165 +166 @@
   DBFDRIVER=0
 fi
+# we need this for non-DBF driver:
+DB_SQLDRIVER=`v.db.connect -g $VECTOR | cut -d' ' -f5`
+DB_DATABASE="`v.db.connect -g $VECTOR | cut -d' ' -f4`"
 
 for i in n min max range mean stddev variance cf_var sum ; do
@@ -210 +214 @@
   v.db.update map=$VECTOR col="`echo ${COLPREFIX}_sum| cut -b1-10`"      value=$sum      where="cat=$i"
  else
-  v.db.update map=$VECTOR col=${COLPREFIX}_n         value=$n         where="cat=$i"
-  v.db.update map=$VECTOR col=${COLPREFIX}_min       value=$min       where="cat=$i"
-  v.db.update map=$VECTOR col=${COLPREFIX}_max       value=$max       where="cat=$i"
-  v.db.update map=$VECTOR col=${COLPREFIX}_range     value=$range     where="cat=$i"
-  v.db.update map=$VECTOR col=${COLPREFIX}_mean      value=$mean      where="cat=$i"
-  v.db.update map=$VECTOR col=${COLPREFIX}_stddev    value=$stddev    where="cat=$i"
-  v.db.update map=$VECTOR col=${COLPREFIX}_variance  value=$variance  where="cat=$i"
-  v.db.update map=$VECTOR col=${COLPREFIX}_cf_var    value=$coeff_var where="cat=$i"
-  v.db.update map=$VECTOR col=${COLPREFIX}_sum       value=$sum       where="cat=$i"
+  echo "UPDATE $VECTOR SET ${COLPREFIX}_n=$n     WHERE cat=$i;" > $SQLTMP
+  echo "UPDATE $VECTOR SET ${COLPREFIX}_min=$min WHERE cat=$i;" >> $SQLTMP
+  echo "UPDATE $VECTOR SET ${COLPREFIX}_max=$max WHERE cat=$i;" >> $SQLTMP
+  echo "UPDATE $VECTOR SET ${COLPREFIX}_range=$range WHERE cat=$i;" >> $SQLTMP
+  echo "UPDATE $VECTOR SET ${COLPREFIX}_mean=$mean   WHERE cat=$i;" >> $SQLTMP
+  echo "UPDATE $VECTOR SET ${COLPREFIX}_stddev=$stddev     WHERE cat=$i;" >> $SQLTMP
+  echo "UPDATE $VECTOR SET ${COLPREFIX}_variance=$variance WHERE cat=$i;" >> $SQLTMP
+  echo "UPDATE $VECTOR SET ${COLPREFIX}_cf_var=$coeff_var  WHERE cat=$i;" >> $SQLTMP
+  echo "UPDATE $VECTOR SET ${COLPREFIX}_sum=$sum     WHERE cat=$i;" >> $SQLTMP
+
+  # this should be fast:
+  cat $SQLTMP | db.execute database=$DB_DATABASE driver=$DB_SQLDRIVER
  fi