File: wp2sql

package info (click to toggle)
gpsdrive 2.09-2sarge1
  • links: PTS
  • area: main
  • in suites: sarge
  • size: 4,844 kB
  • ctags: 3,774
  • sloc: ansic: 24,501; sh: 7,771; cpp: 3,160; perl: 941; makefile: 115; sql: 26
file content (10 lines) | stat: -rwxr-xr-x 447 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
 
echo put waypoints into database
echo "use geoinfo;" > wp.sql
cat ~/.gpsdrive/way-*.txt|awk '{print "insert into waypoints \
(name,lat,lon,type) values (\"" $1 "\",\"" $2  "\",\"" $3  "\",\"Own\");" }' >>wp.sql

# if you have other files (i.e. WLAN Access points in way_*) use
# the line below.
#cat ~/.gpsdrive/way_*.txt|awk '{print "insert into waypoints \
(name,lat,lon,type) values (\"" $1 "\",\"" $2  "\",\"" $3  "\",\"WLAN\");" }' >>wp.sql