| | 62 | ##FUNCGEN |
| | 63 | export species_name="$species_name"; var=`echo "ls -l /pub/plants/release-${release}/mysql/" | ncftp ${ftp_site} | perl -ane 'if ( $_ =~ /$Logged in to/ ) { $go=1; next } if ( $go ) { @a=split; $fileName=$a[ scalar( @a ) - 1]; $compareStr=$ENV{ species_name }."_funcgen"; if ( $fileName =~/^$compareStr/) { print $fileName."\n"; } }'`; set -- $var; mysql_efg_name=$1 |
| | 64 | |
| | 65 | # check variable before proceeding |
| | 66 | if [[ $mysql_efg_name =~ 'species_list' || $mysql_efg_name == '' ]] |
| | 67 | then |
| | 68 | echo "Skip!: $species_name not found at $ftp_site. Please fix file: $species_list" |
| | 69 | continue |
| | 70 | fi |
| | 71 | |
| | 72 | echo "** $mysql_efg_name **" |
| | 73 | mkdir ./${mysql_efg_name} |
| | 74 | |
| | 75 | # get raw tables from ftp site |
| | 76 | ncftpget ${ftp_site} ./${mysql_efg_name} /pub/plants/release-${release}/mysql/${mysql_efg_name}/*.txt.gz |
| | 77 | for q in ./${mysql_efg_name}/*.txt.gz |
| | 78 | do |
| | 79 | gunzip $q |
| | 80 | done |
| | 81 | |
| | 82 | ncftpget ${ftp_site} ./ /pub/plants/release-${release}/mysql/${mysql_efg_name}/${mysql_efg_name}.sql.gz |
| | 83 | gunzip ./${mysql_efg_name}.sql.gz |
| | 84 | |
| | 85 | #create local mysql db |
| | 86 | echo "create database if not exists ${mysql_efg_name}" | ${mysql} -u genmapp -pfun4genmapp |
| | 87 | #create schema |
| | 88 | ${mysql} -u genmapp -pfun4genmapp ${mysql_efg_name} < ./${mysql_efg_name}.sql |
| | 89 | # place in own scope, due to "cd" command |
| | 90 | ( |
| | 91 | cd ./${mysql_efg_name}; for table_name in *.txt |
| | 92 | do |
| | 93 | ${mysqlimport} -u genmapp -pfun4genmapp ${mysql_efg_name} `pwd`/${table_name} |
| | 94 | done |
| | 95 | ) |
| | 96 | |
| | 97 | # zip, archive and clean up |
| | 98 | gzip ./${mysql_efg_name}.sql |
| | 99 | tar cvzf ./${mysql_efg_name}.txt.tgz ./${mysql_efg_name}/* |
| | 100 | rm -R ./${mysql_efg_name}/ |
| | 101 | |
