#!/bin/bash

ftpserver=idxprof.metrolist.com
userid='Condodomain'
password="Kb5*w2z("
ftp -n $ftpserver <<END_OF_FTP
user $userid $password
lcd /var/www/denverftp
bin

cd /IDX_Version_6/

get `eval date +%Y%m%d`_listings_res_A.txt
get `eval date +%Y%m%d`_listings_res_P.txt
get `eval date +%Y%m%d`_listings_res_UC.txt

get `eval date +%Y%m%d`_listings_lnd_A.txt
get `eval date +%Y%m%d`_listings_lnd_P.txt
get `eval date +%Y%m%d`_listings_lnd_UC.txt

get `eval date +%Y%m%d`_listings_cond_A.txt
get `eval date +%Y%m%d`_listings_cond_P.txt
get `eval date +%Y%m%d`_listings_cond_UC.txt

bye
END_OF_FTP
echo Done with ftp


mysql -h localhost --user=tharmon0717 --password=masterofthe6 denver <<**
DELETE FROM data;

LOAD DATA LOCAL INFILE
'/var/www/denverftp/`eval date +%Y%m%d`_listings_res_A.txt' REPLACE
INTO TABLE data FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
delete from data where PROPERTY_TYPE = "PROPERTY TYPE";

LOAD DATA LOCAL INFILE
'/var/www/denverftp/`eval date +%Y%m%d`_listings_res_P.txt' REPLACE
INTO TABLE data FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
delete from data where PROPERTY_TYPE = "PROPERTY TYPE";

LOAD DATA LOCAL INFILE
'/var/www/denverftp/`eval date +%Y%m%d`_listings_res_UC.txt' REPLACE
INTO TABLE data FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
delete from data where PROPERTY_TYPE = "PROPERTY TYPE";

LOAD DATA LOCAL INFILE
'/var/www/denverftp/`eval date +%Y%m%d`_listings_lnd_A.txt' REPLACE
INTO TABLE data FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
delete from data where PROPERTY_TYPE = "PROPERTY TYPE";

LOAD DATA LOCAL INFILE
'/var/www/denverftp/`eval date +%Y%m%d`_listings_lnd_P.txt' REPLACE
INTO TABLE data FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
delete from data where PROPERTY_TYPE = "PROPERTY TYPE";

LOAD DATA LOCAL INFILE
'/var/www/denverftp/`eval date +%Y%m%d`_listings_lnd_UC.txt' REPLACE
INTO TABLE data FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
delete from data where PROPERTY_TYPE = "PROPERTY TYPE";

LOAD DATA LOCAL INFILE
'/var/www/denverftp/`eval date +%Y%m%d`_listings_cond_A.txt' REPLACE
INTO TABLE data FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
delete from data where PROPERTY_TYPE = "PROPERTY TYPE";

LOAD DATA LOCAL INFILE
'/var/www/denverftp/`eval date +%Y%m%d`_listings_cond_P.txt' REPLACE
INTO TABLE data FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
delete from data where PROPERTY_TYPE = "PROPERTY TYPE";

LOAD DATA LOCAL INFILE
'/var/www/denverftp/`eval date +%Y%m%d`_listings_cond_UC.txt' REPLACE
INTO TABLE data FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n';
delete from data where PROPERTY_TYPE = "PROPERTY TYPE";

exit
**
echo finished with mysql work

rm -f *.txt
echo Cleaned up text files
echo Ready for use