aboutsummaryrefslogtreecommitdiffstats
path: root/tools
diff options
context:
space:
mode:
authorNeels Hofmeyr <neels@hofmeyr.de>2017-09-04 03:35:30 +0200
committerNeels Hofmeyr <neels@hofmeyr.de>2017-09-06 16:47:47 +0200
commit1e52928ad9e87f2db0a9abe0ba37d2c9c2629463 (patch)
tree21581a95387fb508d5ac12bfb62fb572be4aaffc /tools
parent075cac02b0e346e1fdb1176f7434a900999ec6f5 (diff)
drop files unrelated to osmo-sgsn
These either remain from openbsc.git or slipped in while applying recent patches from openbsc.git and do not belong in osmo-sgsn. Change-Id: Ie9dc7514c3850010d0e9b3ab716b4f4e8d83594f
Diffstat (limited to 'tools')
-rwxr-xr-xtools/hlrstat.pl73
1 files changed, 0 insertions, 73 deletions
diff --git a/tools/hlrstat.pl b/tools/hlrstat.pl
deleted file mode 100755
index 668fc9a4a..000000000
--- a/tools/hlrstat.pl
+++ /dev/null
@@ -1,73 +0,0 @@
-#!/usr/bin/perl
-
-use strict;
-use DBI;
-my $dbh = DBI->connect("dbi:SQLite:dbname=hlr.sqlite3","","");
-
-
-my %mcc_names;
-my %mcc_mnc_names;
-
-sub get_mcc_mnc_name($)
-{
- my $mcc_mnc = shift;
- my $ret = $mcc_mnc;
-
- if ($mcc_mnc_names{$mcc_mnc} ne '') {
- $ret = $mcc_mnc_names{$mcc_mnc};
- }
-
- return $ret;
-}
-
-sub read_networks($)
-{
- my $filename = shift;
- my $cur_name;
-
- open(INFILE, $filename);
- while (my $l = <INFILE>) {
- chomp($l);
- if ($l =~ /^#/) {
- next;
- }
- if ($l =~ /^\t/) {
- my ($mcc, $mnc, $brand, $r) = split(' ', $l, 4);
- #printf("%s|%s|%s\n", $mcc, $mnc, $brand);
- $mcc_mnc_names{"$mcc-$mnc"} = $brand;
- $mcc_names{$mcc} = $cur_name;
- } elsif ($l =~ /^(\w\w)\t(.*)/) {
- #printf("%s|%s\n", $1, $2);
- $cur_name = $2;
- }
- }
- close(INFILE);
-}
-
-read_networks("networks.tab");
-
-my %oper_count;
-my %country_count;
-
-#my $sth = $dbh->prepare("SELECT imsi FROM subscriber where authorized=1");
-my $sth = $dbh->prepare("SELECT imsi FROM subscriber");
-
-$sth->execute();
-
-while (my $href = $sth->fetchrow_hashref) {
- my ($mcc, $mnc) = $$href{imsi} =~ /(\d{3})(\d{2}).*/;
- #printf("%s %s-%s \n", $$href{imsi}, $mcc, $mnc);
- $oper_count{"$mcc-$mnc"}++;
- $country_count{$mcc}++;
-}
-
-
-foreach my $c (sort{$country_count{$b} <=> $country_count{$a}} keys %country_count) {
- printf("%s: %d\n", $mcc_names{$c}, $country_count{$c});
-
- foreach my $k (sort{$oper_count{$b} <=> $oper_count{$a}} keys %oper_count) {
- if ($k =~ /^$c-/) {
- printf("\t%s: %d\n", get_mcc_mnc_name($k), $oper_count{$k});
- }
- }
-}