ViewVC Help

View File | Revision Log | Show Annotations | Root Listing

root/cvsroot/UserCode/OSUT3Analysis/DBTools/scripts/osucrab

Comparing UserCode/OSUT3Analysis/DBTools/scripts/osucrab (file contents):
Revision 1.1 by ahart, Wed Jun 6 12:14:37 2012 UTC vs.
Revision 1.2 by ahart, Tue Jul 31 14:04:18 2012 UTC

#	Line 10 | Line 10 | sub dbInsert;
10		sub addSlashes;
11		sub getOption;
12
13	<	our $db;
13	>	our $db = Mysql->connect ("cmshead.mps.ohio-state.edu", "ntuple", "osuT3User") or die "Failed to connect to Tier 3, stopped";
14
15		my $arg = join (" ", @ARGV);
16		if ($arg =~ m/-create/)
#	Line 166 | Line 166 | dbInsert
166		$comment = addSlashes ($comment);
167
168		my $results;
169	–	$db = Mysql->connect ("cmshead.mps.ohio-state.edu", "ntuple", "osuT3User");
169		my $query = "select max(id) from ntuple";
170		$db->selectdb ("ntuple");
171		$results = $db->query ($query);
#	Line 202 | Line 201 | dbUpdate
201		$status = addSlashes ($status);
202
203		my $results;
205	–	$db = Mysql->connect ("cmshead.mps.ohio-state.edu", "ntuple", "osuT3User");
204		my $query = "update ntuple set lastUpdateTime=now(), status='$status', submissionLog='$submissionLog' where id=$id";
205		$db->selectdb ("ntuple");
206		$results = $db->query ($query);
#	Line 226 | Line 224 | dbReport
224		$status = addSlashes ($status);
225
226		my $results;
229	–	$db = Mysql->connect ("cmshead.mps.ohio-state.edu", "ntuple", "osuT3User");
227		my $query = "update ntuple set lastUpdateTime=now(), status='$status', lumiSummary='$lumiSummary' where id=$id";
228		$db->selectdb ("ntuple");
229		$results = $db->query ($query);

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines