Cleaner scripting via shell variables
Because SQL queries, by nature, can be long and complex, we will frequently need to deal with line breaks while passing in SQL queries to csvkit commands.
One way to work around this is to store the SQL queries as a shell variable, then pass in the shell variable in place of the SQL query where needed.
Diese Übung ist Teil des Kurses
<Kurs>Data Processing in Shell</Kurs>Übungsanweisungen
- Fill in the
csvsqlcommand by calling upon the bash variable containing the SQL query instead of writing out the SQL query in full.
Interaktive praktische Übung
Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.
# Preview CSV file
ls
# Store SQL query as shell variable
sqlquery="SELECT * FROM Spotify_MusicAttributes ORDER BY duration_ms LIMIT 1"
# Apply SQL query to Spotify_MusicAttributes.csv
csvsql --query "$___" Spotify_MusicAttributes.csv