aboutsummaryrefslogtreecommitdiffstats
path: root/tools/make-switches.pl
diff options
context:
space:
mode:
Diffstat (limited to 'tools/make-switches.pl')
-rwxr-xr-xtools/make-switches.pl36
1 files changed, 0 insertions, 36 deletions
diff --git a/tools/make-switches.pl b/tools/make-switches.pl
deleted file mode 100755
index c0c842a..0000000
--- a/tools/make-switches.pl
+++ /dev/null
@@ -1,36 +0,0 @@
-#! /usr/bin/perl
-
-use strict;
-use warnings;
-
-my $switchtype = "ex2200";
-
-print "begin;\n";
-print "delete from temppoll;\n";
-print "delete from dhcp;\n";
-print "delete from switches where switchtype = '$switchtype';\n";
-#print "SELECT pg_catalog.setval('switches_switch_seq', 1, false);\n";
-print "SELECT pg_catalog.setval('polls_poll_seq', 1, false);\n";
-
-my %ip;
-my $i = 1;
-while (<STDIN>) {
- chomp;
- my @info = split(/ /);
-
- if (scalar @info < 5) {
- die "Unknown line: $_";
- }
-
- my $name = $info[0];
- my $range = $info[1];
- my $ip = $info[3];
- $ip =~ s/\/.*$//;
-
-
- print "insert into switches (ip, sysname, switchtype) values ('$ip', '$name', '$switchtype');\n";
- print "insert into dhcp select switch, '$range' from switches where sysname = '$name';\n";
-}
-close HOSTS;
-
-print "end;\n";