23 lines
1.1 KiB
Makefile
23 lines
1.1 KiB
Makefile
athlete_events_classified.csv: athlete_events_classified.sqlite3 query.sql
|
|
sqlite3 athlete_events_classified.sqlite3 -csv -header "SELECT * FROM classification;" > athlete_events_classified.csv
|
|
athlete_events_classified.sqlite3: athlete_events.sqlite3 query1.sql query.sql
|
|
cp -f athlete_events.sqlite3 athlete_events_classified.sqlite3~
|
|
sqlite3 athlete_events_classified.sqlite3~ -csv -header "$$(cat query1.sql)"
|
|
mv athlete_events_classified.sqlite3~ athlete_events_classified.sqlite3
|
|
query1.sql: query.sql
|
|
(echo -e "DROP TABLE IF EXISTS classification;"; echo ""; echo "CREATE TABLE classification AS"; cat query.sql) > query1.sql
|
|
athlete_events.sqlite3: tosqlite.py athlete_events.csv
|
|
python tosqlite.py athlete_events.sqlite3 athlete_events.csv
|
|
athlete_events.csv: Olympics_data.zip
|
|
unzip -p Olympics_data.zip athlete_events.csv > athlete_events.csv
|
|
Olympics_data.zip:
|
|
wget https://techtfq.com/s/Olympics_data.zip
|
|
clean:
|
|
rm -f Olympics_data.zip
|
|
rm -f athlete_events.csv
|
|
rm -f athlete_events.sqlite3
|
|
rm -f athlete_events_classified.csv
|
|
rm -f athlete_events_classified.sqlite3
|
|
rm -f query1.sql
|
|
rm -f db.sqlite3
|