ViewVC Help
View File | Revision Log | Show Annotations | Root Listing
root/cvsroot/UserCode/OSUT3Analysis/DBTools/scripts/osusub
(Generate patch)

Comparing UserCode/OSUT3Analysis/DBTools/scripts/osusub (file contents):
Revision 1.2 by ahart, Thu Jun 14 17:42:30 2012 UTC vs.
Revision 1.3 by ahart, Tue Jul 31 14:17:11 2012 UTC

# Line 11 | Line 11 | sub outputRunList;
11   sub getLocation;
12   sub outputCondor;
13  
14 < our $db;
14 > our $db = Mysql->connect ("cmshead", "ntuple", "osuT3User");
15  
16   my %opt;
17   Getopt::Long::Configure ("bundling");
# Line 112 | Line 112 | getLocation
112    my $queryDataset = $dataset;
113    $queryDataset =~ s/\*/%/g;
114    $queryDataset =~ s/(.*)/%$1%/g;
115 <  $db = Mysql->connect ("cmshead", "ntuple", "osuT3User");
116 <  my $query = "select dataset,user,creationTime,location,nFiles,status from ntuple where dataset like '$queryDataset' order by lastUpdateTime";
115 >  my $query = "select dataset,user,creationTime,location,nFiles,status from ntuple where dataset like '$queryDataset' and status='present' order by lastUpdateTime";
116    $db->selectdb ("ntuple");
117    $results = $db->query ($query);
118    if ($results->numrows () == 1)
# Line 177 | Line 176 | printHelp
176    my $exeName = $0;
177    $exeName =~ s/^.*\/([^\/]*)$/$1/;
178  
179 <  print "Usage: $exeName [OPTIONS] DATASET CONFIG DIRECTORY NJOBS\n";
179 >  print "Usage: $exeName [OPTION]... DATASET CONFIG DIRECTORY NJOBS\n";
180    print "Submits CMSSW jobs to the OSU Tier 3 compute nodes using Condor.\n";
181    print "\n";
182    printf "%-29s%s\n", "  -h, --help", "print this help message";

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines