Changeset 258

Show
Ignore:
Timestamp:
10/07/2006 10:30:24 AM (3 years ago)
Author:
brian
Message:

Added -block=all syntax to check_block.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • PhedexTools/trunk/check_block.py

    • Property svn:executable set to *
    r248 r258  
    5050  curs = orcl.cursor() 
    5151  curs.arraysize=300 
    52   sql = 'select f.logical_name, f.filesize from t_xfer_replica r join t_node n on r.node = n.id join t_dps_file f on f.id = r.fileid where node=(select id from t_node where name=:node) and fileid in (select fileid from t_dps_file where inblock in (select id from t_dps_block where regexp_like( name, :block )))' 
    53   sql2 = 'select logical_name, filesize from t_dps_file where id in (select fileid from t_xfer_replica where node=(select id from t_node where name=:node) and inblock in (select id from t_dps_block where name=:block ) )' 
     52  #sql = 'select f.logical_name, f.filesize from t_xfer_replica r join t_node n on r.node = n.id join t_dps_file f on f.id = r.fileid where node=(select id from t_node where name=:node) and fileid in (select fileid from t_dps_file where inblock in (select id from t_dps_block where regexp_like( name, :block )))' 
     53  if block != 'all': 
     54    sql2 = """ 
     55        select  
     56          logical_name, filesize  
     57        from t_dps_file where  
     58          id in (select  
     59                   fileid  
     60                 from t_xfer_replica where  
     61                   node=(select id from t_node where name=:node) and  
     62                   inblock in (select id from t_dps_block where name=:block ) 
     63                ) 
     64      """ 
     65  else: 
     66    sql2 = """ 
     67        select 
     68          logical_name, filesize 
     69        from t_dps_file where 
     70          id in (select 
     71                   fileid 
     72                 from t_xfer_replica where 
     73                   node=(select id from t_node where name=:node) 
     74                ) 
     75      """ 
    5476  curs.prepare( sql2 ) 
    5577  curs.execute( sql2, {'block':block, 'node':node} )