iccsa-21-wind

Wind Simulation Using High-Frequency Velocity Component Measurements
git clone https://git.igankevich.com/iccsa-21-wind.git
Log | Files | Refs

hold-peak-import (297B)

      1 #!/bin/sh
      2 db=hold-peak.sqlite3
      3 sqlite3 $db << 'EOF'
      4 CREATE TABLE IF NOT EXISTS hold_peak_samples (timestamp INTEGER, speed FLOAT);
      5 DELETE FROM hold_peak_samples;
      6 EOF
      7 
      8 tmp=$(mktemp)
      9 for i in hold-peak/*.dat
     10 do
     11     sed 's/ /|/g' "$i"
     12 done > $tmp
     13 sqlite3 $db ".import $tmp hold_peak_samples"
     14 rm $tmp