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