pricecharts

commit 46b2a49676aa0d874fdf78d97f53e5481bf4420a
parent 35fa47ff1b2239b70b90e6baeaaa0452d8c649be
Author: Kyle Milz <kyle@getaddrinfo.net>
Date:   Sun, 12 Oct 2014 22:36:09 -0600

product_scraper: don't create vendor specific tables

Diffstat:
M
product_scraper.pl
 | 
10
----------

1 file changed, 0 insertions(+), 10 deletions(-)
diff --git a/product_scraper.pl b/product_scraper.pl
@@ -39,9 +39,6 @@ my $email;
 # Memory Express
 #
 
-$dbh->do("create table if not exists [Memory Express](" .
-	"date int not null primary key)");
-
 my %product_map = ("televisions" => "Televisions",
 	"laptops" => "LaptopsNotebooks",
 	"hard_drives" => "HardDrives");
@@ -132,13 +129,6 @@ for (keys %product_map) {
 	$email .= sprintf("%7s %5s %3s\n", $scraped, scalar @results,
 			scalar @new);
 	next;
-
-	my $sth = $dbh->prepare("select * from [Memory Express]");
-	my @columns = @{$sth->{NAME}};
-	for my $column (@columns) {
-		next if ($column ne $_);
-	}
-	$dbh->do("alter table [Memory Express] add column $_");
 }
 
 $email .= "\nNew products:\n" if (@new);