IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 36788


Ignore:
Timestamp:
May 28, 2014, 10:20:59 AM (12 years ago)
Author:
eugene
Message:

limit unrestricted queries to current date or no selection

Location:
trunk/ippMonitor/def
Files:
17 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippMonitor/def/camIQstats.d

    r27892 r36788  
    1010WHERE camProcessedExp.cam_id  = camRun.cam_id
    1111WHERE camProcessedExp.fault = 0
     12
     13RESTRICT_COUNT AND dateobs >= CURDATE()
     14UNRESTRICTED AND dateobs >= CURDATE()
    1215
    1316ARGS  ARG1  rawImfile.exp_id=$rawExp.exp_id

  • trunk/ippMonitor/def/camProcessedExp.d

    r27892 r36788  
    1010WHERE camProcessedExp.cam_id  = camRun.cam_id
    1111WHERE camProcessedExp.fault = 0
     12
     13RESTRICT_COUNT AND dateobs >= CURDATE()
     14UNRESTRICTED AND dateobs >= CURDATE()
    1215
    1316# define the arguments supplied to the links below (if any)

  • trunk/ippMonitor/def/camProcessedExp_Images.d

    r34011 r36788  
    33FILE  camProcessedExp_Images.php
    44MENU  ipp.science.dat
    5 
    6 UNRESTRICTED AND 0>1
    75
    86# the following WHERE clauses are added to all queries joined by AND
    … …  
    1210WHERE camProcessedExp.cam_id  = camRun.cam_id
    1311WHERE camProcessedExp.fault = 0
     12
     13RESTRICT_COUNT AND dateobs >= CURDATE()
     14UNRESTRICTED AND dateobs >= CURDATE()
     15
    1416# define image names to be used below
    1517# IMAGE VAR basename filerule camera class_id

  • trunk/ippMonitor/def/camProcessedExp_NoImages.d

    r27892 r36788  
    1010WHERE camProcessedExp.cam_id  = camRun.cam_id
    1111WHERE camProcessedExp.fault = 0
     12
     13RESTRICT_COUNT AND dateobs >= CURDATE()
     14UNRESTRICTED AND dateobs >= CURDATE()
    1215
    1316# define the arguments supplied to the links below (if any)

  • trunk/ippMonitor/def/camProcessedImfile.d

    r27892 r36788  
    1010WHERE camProcessedExp.cam_id = camRun.cam_id
    1111WHERE chipProcessedImfile.chip_id = camRun.chip_id
     12
     13RESTRICT_COUNT AND dateobs >= CURDATE()
     14UNRESTRICTED AND dateobs >= CURDATE()
    1215
    1316ARGS  ARG1  rawImfile.exp_id=$rawExp.exp_id

  • trunk/ippMonitor/def/camStageExp.d

    r27892 r36788  
    66WHERE camRun.chip_id = chipRun.chip_id
    77WHERE chipRun.exp_id = rawExp.exp_id
     8
     9RESTRICT_COUNT AND dateobs >= CURDATE()
     10UNRESTRICTED AND dateobs >= CURDATE()
    811
    912ARGS  ARG1  rawImfile.exp_id=$rawExp.exp_id

  • trunk/ippMonitor/def/chipIQstats.d

    r27892 r36788  
    88WHERE chipRun.exp_id = rawExp.exp_id
    99WHERE chipRun.chip_id = chipProcessedImfile.chip_id
     10
     11RESTRICT_COUNT AND dateobs >= CURDATE()
     12UNRESTRICTED AND dateobs >= CURDATE()
    1013
    1114ARGS  ARG1  rawImfile.exp_id=$rawExp.exp_id

  • trunk/ippMonitor/def/chipProcessedExp.d

    r27892 r36788  
    77WHERE chipRun.state != 'new'
    88WHERE chipRun.exp_id = rawExp.exp_id
     9
     10RESTRICT_COUNT AND dateobs >= CURDATE()
     11UNRESTRICTED AND dateobs >= CURDATE()
    912
    1013ARGS  ARG1  rawImfile.exp_id=$rawExp.exp_id

  • trunk/ippMonitor/def/chipProcessedImfile.d

    r32539 r36788  
    99WHERE chipProcessedImfile.chip_id = chipRun.chip_id
    1010WHERE chipProcessedImfile.fault = 0
     11
     12RESTRICT_COUNT AND dateobs >= CURDATE()
     13UNRESTRICTED AND dateobs >= CURDATE()
    1114
    1215#UNRESTRICTED WHERE 0=1

  • trunk/ippMonitor/def/chipStageExp.d

    r27892 r36788  
    55
    66WHERE chipRun.exp_id = rawExp.exp_id
     7
     8RESTRICT_COUNT AND dateobs >= CURDATE()
     9UNRESTRICTED AND dateobs >= CURDATE()
    710
    811ARGS  ARG1  rawImfile.exp_id=$rawExp.exp_id

  • trunk/ippMonitor/def/diffInputSkyfile.d

    r27892 r36788  
    55
    66WHERE diffInputSkyfile.diff_id = diffRun.diff_id
     7
     8RESTRICT_COUNT AND 0 = 1
     9UNRESTRICTED AND 0 = 1
    710
    811#        field                            size format  name           show     link to         extras

  • trunk/ippMonitor/def/diffProcessedSkyfile.d

    r27892 r36788  
    77# WHERE diffRun.state = 'full'
    88# WHERE diffSkyfile.fault = 0
     9
     10RESTRICT_COUNT AND 0 = 1
     11UNRESTRICTED AND 0 = 1
    912
    1013ARGS  ARG7 diffSkyfile.diff_id=$diffSkyfile.diff_id

  • trunk/ippMonitor/def/diffProcessedSkyfile_Images.d

    r35660 r36788  
    33FILE  diffProcessedSkyfile_Images.php
    44MENU  ipp.stack.dat
     5
     6#RESTRICT_COUNT AND dateobs >= CURDATE()
     7#UNRESTRICTED AND dateobs >= CURDATE()
    58
    69UNRESTRICTED AND 0>1

  • trunk/ippMonitor/def/diffRun.d

    r27892 r36788  
    33FILE  diffRun.php
    44MENU  ipp.stack.dat
     5
     6#RESTRICT_COUNT WHERE dateobs >= CURDATE()
     7#UNRESTRICTED WHERE dateobs >= CURDATE()
    58
    69#        field        size  format  name           show     link to         extras

  • trunk/ippMonitor/def/rawBurntoolState.d

    r34014 r36788  
    55
    66# if no query restrictions are supplied, we want to limit the query or it is extremely long running:
    7 RESTRICT_COUNT WHERE 0>1
    8 UNRESTRICTED WHERE exp_id = 0
     7RESTRICT_COUNT WHERE dateobs >= CURDATE()
     8# UNRESTRICTED WHERE exp_id = 0
     9UNRESTRICTED WHERE dateobs >= CURDATE()
    910
    1011#        field        size format  name           show          link to   extras

  • trunk/ippMonitor/def/warpProcessedSkyfiles.d

    r32368 r36788  
    44MENU  ipp.science.dat
    55
    6 UNRESTRICTED WHERE 0=1
     6RESTRICT_COUNT WHERE dateobs >= CURDATE()
     7UNRESTRICTED WHERE dateobs >= CURDATE()
    78
    89ARGS  ARG1  rawImfile.exp_id=$rawExp.exp_id

  • trunk/ippMonitor/def/warpProcessedSkyfiles_Images.d

    r33847 r36788  
    44MENU  ipp.science.dat
    55
    6 UNRESTRICTED WHERE 0=1
     6RESTRICT_COUNT WHERE dateobs >= CURDATE()
     7UNRESTRICTED WHERE dateobs >= CURDATE()
     8
     9# UNRESTRICTED WHERE 0=1
    710
    811# WHERE warpSkyfile.warp_id = warpRun.warp_id
Note: See TracChangeset for help on using the changeset viewer.