| … | |
… | |
| 4 | |
4 | |
| 5 | my $dinfo = new dinfo "DBI:mysql:dinfo"; |
5 | my $dinfo = new dinfo "DBI:mysql:dinfo"; |
| 6 | |
6 | |
| 7 | while (<>) { |
7 | while (<>) { |
| 8 | |
8 | |
| 9 | #my $r = $dinfo->search (nummer => prefix => "000", vorwahl => exact => "0721"); |
|
|
| 10 | my $r = $dinfo->search (nummer => prefix => "000000"); |
|
|
| 11 | |
|
|
| 12 | #print "results: " . $r->rows . "\n"; |
9 | #print "results: " . $r->rows . "\n"; |
| 13 | #chomp; |
10 | #chomp; |
| 14 | while (my $row = $r->fetch) { |
11 | #while (my $row = $r->fetch) { |
| 15 | #$row = $dinfo->identify_number($_); |
12 | $row = $dinfo->identify_number($_); |
| 16 | while (my ($k, $v) = each %$row) { |
13 | while (my ($k, $v) = each %$row) { |
| 17 | print "$k:$v "; |
14 | print "$k:$v "; |
| 18 | } |
15 | } |
| 19 | print "\n"; |
16 | print "\n"; |
| 20 | last if 1000..20000; |
17 | last if 1000..20000; |
| 21 | } |
18 | #} |
| 22 | |
19 | |
| 23 | #my $r = $dinfo->search (ort => exact => "Karlsruhe"); |
20 | #my $r = $dinfo->search (ort => exact => "Karlsruhe"); |
| 24 | } |
21 | } |
