pricecharts

commit 1c0a906205e2cffcdd5bb1430cf4a65effba2c3c
parent 53154f9b2850fc28bf7ea50239a16051828551bd
Author: Kyle Milz <kyle@getaddrinfo.net>
Date:   Thu,  6 Nov 2014 22:36:33 -0700

price_scraper: use sql variable name instead of qry

Diffstat:
M
price_scraper.pl
 | 
8
++++----

1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/price_scraper.pl b/price_scraper.pl
@@ -31,12 +31,12 @@ printf $log "%-15s [", $part_num;
 
 vprint("$part_num\n");
 
-my $qry = "insert into prices(date, part_num, vendor, price, duration) " .
+$sql = "insert into prices(date, part_num, vendor, price, duration) " .
 	"values (?, ?, ?, ?, ?)";
-my $prices_sth = $dbh->prepare($qry);
+my $prices_sth = $dbh->prepare($sql);
 
-$qry = "update products set last_seen = ? where part_num = ?";
-my $products_sth = $dbh->prepare($qry);
+$sql = "update products set last_seen = ? where part_num = ?";
+my $products_sth = $dbh->prepare($sql);
 
 my $date = time;
 for (sort keys $cfg->{vendors}) {