生成兑换码随机数

#!/usr/bin/env sh

sql_name=$(tr -dc 'a-z' </dev/urandom | head -c 4; echo)

for ((i=1;i<=3100;i++));
do
    four_str=$(tr -dc 'A-Z0-9' </dev/urandom | head -c 4; echo)
    cdkey_str=$(echo "UDHW${four_str}")
    sql_str="insert into promote_code_info(code_name, code_type, code_sdate, code_edate, code_status, product_id, channel_name) values('${cdkey_str}', 0, '2020-11-01', '2020-12-01', 0, 4, '华为应用商城');"
    echo "${sql_str}" >> huawei_app_3100_single_cdkey_${sql_name}.sql
done


for ((i=1;i<=300;i++));
do
    four_str=$(tr -dc 'A-Z0-9' </dev/urandom | head -c 4; echo)
    cdkey_str=$(echo "UDFG${four_str}")
    sql_str="insert into promote_code_info(code_name, code_type, code_sdate, code_edate, code_status, product_id, channel_name) values('${cdkey_str}', 1, '2020-11-09', '2020-11-15', 1, 3, '双十一营销活动');"
    echo "${sql_str}" >> double_eleven_300_general_cdkey_${sql_name}.sql
done


for ((i=1;i<=300;i++));
do
    four_str=$(tr -dc 'A-Z0-9' </dev/urandom | head -c 4; echo)
    cdkey_str=$(echo "UDFZ${four_str}")
    sql_str="insert into promote_code_info(code_name, code_type, code_sdate, code_edate, code_status, product_id, channel_name) values('${cdkey_str}', 0, '2020-11-09', '2020-11-15', 0, 5, '双十一营销活动');"
    echo "${sql_str}" >> double_eleven_300_single_cdkey_${sql_name}.sql
done