udeeTgSm

1BEGIN {
2        FS="[./]";
3        strnum=0;
4        print "PRAGMA journal_mode = OFF;";
5        print "PRAGMA synchronous = 0;";
6        print "DROP TABLE IF EXISTS test;";
7        print "CREATE TABLE test(ip_int bigint not null, mask_int bigint not null, comment varchar(30));";
8        print "INSERT INTO test (ip_int,mask_int,comment) VALUES";
9}
10END {print ";";}
11{
12        ip_as_int="("$1"<<24)+("$2"<<16)+("$3"<<8)+"$4;
13        mask_as_int="(1<<32)-(1<<"$5")";
14        masked_ip="("ip_as_int")&("mask_as_int")";
15        fullstr="("masked_ip","mask_as_int",'"$0"')";
16        if (strnum){
17                print ","
18                }
19        print fullstr;
20        strnum++;
21}