| 46 |
|
my $dataset = shift; |
| 47 |
|
|
| 48 |
|
my $results; |
| 49 |
+ |
my $queryDataset = $dataset; |
| 50 |
+ |
$queryDataset =~ s/\*/%/g; |
| 51 |
+ |
$queryDataset =~ s/(.*)/%$1%/g; |
| 52 |
|
$db = Mysql->connect ("cmshead.mps.ohio-state.edu", "ntuple", "osuT3User"); |
| 53 |
< |
my $query = "select id,user,creationTime from ntuple where dataset='$dataset' order by lastUpdateTime"; |
| 53 |
> |
my $query = "select id,dataset,user,creationTime from ntuple where dataset like '$queryDataset' order by lastUpdateTime"; |
| 54 |
|
$db->selectdb ("ntuple"); |
| 55 |
|
$results = $db->query ($query); |
| 56 |
|
if ($results->numrows () == 1) |
| 70 |
|
my %map; |
| 71 |
|
print "Found multiple database entries matching\n"; |
| 72 |
|
print "\"$dataset\":\n"; |
| 73 |
< |
print "(0) new\n"; |
| 73 |
> |
print "( 0) new\n"; |
| 74 |
|
for (my $i = 1; $i <= $results->numrows (); $i++) |
| 75 |
|
{ |
| 76 |
|
my @row = $results->fetchrow (); |
| 77 |
|
$map{"$i"} = $row[0]; |
| 78 |
< |
print "($i) created by $row[1] on $row[2]\n"; |
| 78 |
> |
printf "(%2d) $row[1]\n", $i; |
| 79 |
> |
print " created by $row[2] on $row[3]\n"; |
| 80 |
|
} |
| 81 |
|
print "\nWhich entry would you like to update? (Select 0 to create a new entry): "; |
| 82 |
|
my $response = <STDIN>; |
