genlog.awk

一本介绍oracle的书籍

END {
    srand();

    CHARGE_FEE="charge_fee.ctl";
    printf("load data\ninfile *\nappend\ninto table charge_fee\nfields terminated by '|'\n(\n\tfee_id\t\tinteger external,\n\tcreate_ts\tdate(14) 'YYYYMMDDHH24MISS',\n\tupdate_ts\tdate(14) 'YYYYMMDDHH24MISS',\n\tstatus\t\tchar(1),\n\tfee_month\t\tchar(6),\n\tuser_nm\t\tchar(20),\n\tcharge_dt\tchar(8)\n)\nbegindata\n") > CHARGE_FEE;

    CHARGE_FEE_DTL="charge_fee_dtl.ctl";
    printf("load data\ninfile *\nappend\ninto table charge_fee_dtl\nfields terminated by '|'\n(\n\tfee_id\t\tinteger external,\n\tfee_type\tchar(2),\n\tfee_at\t\tinteger external\n)\nbegindata\n") > CHARGE_FEE_DTL;

    for(fee_sq=1; fee_sq<=1000000; fee_sq++)
    {
        printf("%07d|20010101000000|20010101000000|1|200201|test%04d|19700101\n", fee_sq, int(rand()*10000)) >> CHARGE_FEE;
        for(i=0; i<5; i++)  a_fee_type[i]=0;
        i=0;
        while(i<5)
        {
            value=int(rand()*10)+1;
            repeat=0;
            for(j=0; j<i; j++)
            {
                if(a_fee_type[j]==value)
                {
                    repeat=1;
                    break;
                }
            }
            if(!repeat)
            {
                a_fee_type[i++]=value;
            }
        }
        for(i=0; i<5; i++)
        {
            printf("%07d|%02d|%012.0lf\n", fee_sq, a_fee_type[i], rand()*1000000) >> CHARGE_FEE_DTL;
        }
    }

    CHARGE_FEE_CFG="charge_fee_cfg.ctl";
    printf("load data\ninfile *\nappend\ninto table charge_fee_cfg\nfields terminated by '|'\n(\n\tfee_type\tchar(2),\n\tfee_nm\t\tchar(10)\n)\nbegindata\n") > CHARGE_FEE_CFG;
    printf("01|市话\n02|长话\n03|国际\n04|异地漫游\n05|来电显示\n06|来电转移\n07|WAP服务\n08|语音信箱\n09|语音增强\n10|多方通话\n") >> CHARGE_FEE_CFG;
}