Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 27133)
+++ trunk/ippTools/share/Makefile.am	(revision 27149)
@@ -256,4 +256,8 @@
      regtool_revertprocessedimfile.sql \
      regtool_updateprocessedimfile.sql \
+     regtool_pendingcompressimfile.sql \
+     regtool_finishcompressexp.sql \
+     regtool_updatebyquery.sql \
+     regtool_updatebyqueryimfile.sql \
      stacktool_definebyquery_insert.sql \
      stacktool_definebyquery_insert_random_part1.sql \
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 27133)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 27149)
@@ -117,4 +117,5 @@
     filelevel VARCHAR(64),
     workdir VARCHAR(255),
+    state VARCHAR(64),
     reduction VARCHAR(64),
     dvodb VARCHAR(255),
@@ -189,4 +190,5 @@
     class_id VARCHAR(64),
     uri VARCHAR(255),
+    data_state VARCHAR(64),
     exp_type VARCHAR(64),
     filelevel VARCHAR(64),
Index: trunk/ippTools/share/regtool_finishcompressexp.sql
===================================================================
--- trunk/ippTools/share/regtool_finishcompressexp.sql	(revision 27149)
+++ trunk/ippTools/share/regtool_finishcompressexp.sql	(revision 27149)
@@ -0,0 +1,89 @@
+select DISTINCT
+    exp_id,
+    exp_name,
+    camera,   
+    telescope,
+    dateobs,
+    exp_tag,
+    exp_type,
+    filelevel,
+    workdir,
+    state,
+    reduction,    
+    dvodb,
+    tess_id,
+    end_stage,
+    filter,
+    comment,
+    obs_mode,
+    obs_group,
+    airmass,
+    ra,
+    decl,
+    exp_time,
+    sat_pixel_frac,
+    bg,
+    bg_stdev,
+    bg_mean_stdev,
+    alt,
+    az,
+    ccd_temp,
+    posang,
+    m1_x,
+    m1_y,
+    m1_z,
+    m1_tip,
+    m1_tilt,
+    m2_x,
+    m2_y,
+    m2_z,
+    m2_tip,
+    m2_tilt,
+    env_temperature,
+    env_humidity,
+    env_wind_speed,
+    env_wind_dir,
+    teltemp_m1,
+    teltemp_m1cell,
+    teltemp_m2,
+    teltemp_spider,
+    teltemp_truss,
+    teltemp_extra,
+    pon_time,
+    user_1,
+    user_2,
+    user_3,
+    user_4,
+    user_5,
+    object,
+    sun_angle,
+    sun_alt,
+    moon_angle,
+    moon_alt,
+    moon_phase,
+    hostname,
+    fault,
+    epoch,
+    magicked
+FROM
+    (SELECT
+	rawExp.*,
+	count(rawImfile.class_id) AS complete,
+	count(newImfile.tmp_class_id) AS total
+	FROM rawExp
+	JOIN newImfile
+	     ON rawExp.exp_id = newImfile.exp_id
+	LEFT JOIN rawImfile
+	     ON rawExp.exp_id = rawImfile.exp_id
+	     AND rawImfile.tmp_class_id = newImfile.tmp_class_id
+	WHERE
+	     ((rawExp.state = 'goto_compressed' 
+	       AND rawImfile.data_state = 'compressed')OR
+	      (rawExp.state = 'goto_lossy'
+	       AND rawImfile.data_state = 'lossy'))
+	GROUP BY
+	      rawExp.exp_id
+      ) as foo
+      WHERE (foo.complete = foo.total)
+	
+	
Index: trunk/ippTools/share/regtool_pendingcompressimfile.sql
===================================================================
--- trunk/ippTools/share/regtool_pendingcompressimfile.sql	(revision 27149)
+++ trunk/ippTools/share/regtool_pendingcompressimfile.sql	(revision 27149)
@@ -0,0 +1,4 @@
+SELECT * from rawImfile
+       WHERE (data_state = 'goto_compressed' OR data_state = 'goto_lossy')
+-- where hook %s
+-- limit hook %s       
Index: trunk/ippTools/share/regtool_updatebyquery.sql
===================================================================
--- trunk/ippTools/share/regtool_updatebyquery.sql	(revision 27149)
+++ trunk/ippTools/share/regtool_updatebyquery.sql	(revision 27149)
@@ -0,0 +1,5 @@
+UPDATE rawExp
+       SET state = '%s'
+WHERE 1
+-- where hook %s
+-- limit hook %s
Index: trunk/ippTools/share/regtool_updatebyqueryimfile.sql
===================================================================
--- trunk/ippTools/share/regtool_updatebyqueryimfile.sql	(revision 27149)
+++ trunk/ippTools/share/regtool_updatebyqueryimfile.sql	(revision 27149)
@@ -0,0 +1,5 @@
+UPDATE rawImfile JOIN rawExp USING(exp_id)
+       SET data_state = '%s'
+WHERE 1
+-- where hook %s
+-- limit hook %s
Index: trunk/ippTools/share/regtool_updateprocessedimfile.sql
===================================================================
--- trunk/ippTools/share/regtool_updateprocessedimfile.sql	(revision 27133)
+++ trunk/ippTools/share/regtool_updateprocessedimfile.sql	(revision 27149)
@@ -1,4 +1,4 @@
 UPDATE rawImfile
-  SET burntool_state = %d
+    SET %s
   WHERE
     rawImfile.exp_id = %lld