all: create

INPUT=input/orf_coding.fasta
TABLE=output/orf_coding.tab
DB=output/orf_coding.db

$(INPUT):
	wget -o input/orf_coding.fasta.gz ftp://genome-ftp.stanford.edu/pub/yeast/data_download/sequence/genomic_sequence/orf_dna/orf_coding.fasta.gz
	gunzip -c orf_coding.fasta.gz > $(INPUT)


create: $(TABLE)
	sqlite3 -echo $(DB) < script/create.sql

$(TABLE): $(INPUT)
	ruby script/fasta_reader.rb $(INPUT) > $(TABLE)

clean: 
	rm -f $(DB) $(TABLE)