I need a shell script that downloads from the following page:
[login to view URL]
The following files:
[login to view URL]
[login to view URL]
And then loads the files into a database using the following commands:
For [login to view URL] :
mariadb dispos_db -e "load data local infile '$file ' replace into table filings fields terminated by '\t' lines terminated by '\n' ignore 1 lines (rundate, cdi, cas, fda, ins, cad, crt, cst, dst, bam, curr_off, curr_off_lit, curr_l_d, nda, cnc, rea, def_nam, def_spn, def_rac, def_sex, def_dob, def_stnum, def_stnam, def_cty, def_st, def_zip, aty_nam, aty_spn, aty_coc, aty_coc_lit, def_birthplace, def_uscitizen);"
For [login to view URL]
mariadb dispos_db -e "load data local infile '$file' ignore into table dispos fields terminated by '\t' lines terminated by '\n' ignore 1 lines (rundate, cdi, cas, fda, ins, cad, crt, cst, dst, bam, curr_off, curr_off_lit, curr_l_d, nda, cnc, rea, def_nam, def_spn, def_rac, def_sex, def_dob, def_stnum, def_stnam, def_cty, def_st, def_zip, aty_nam, aty_spn, aty_coc, aty_coc_lit , dispdt, disposition, sentence, comp_nam, comp_agency, off_rpt_num);"