shell script for gps log data inserting into mysql database

[gudivada213]

Hi,

I am new to linux, i want shell script to insert the data from gps log.

Suppose Gps log like below,

Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
GPSD,R=1
$GPGSV,3,1,11,08,16,328,40,11,36,127,00,28,33,283, 39,20,11,165,00*71
$GPGSV,3,2,11,17,24,208,39,27,11,097,00,13,87,174, 00,19,31,042,00*70
$GPGSV,3,3,11,25,43,033,38,03,07,037,00,23,47,150, 00*44
$GPGGA,111503,0833.6323,N,07652.7685,E,1,04,1.60,1 6.69,M,-94.088,M,,*58
$GPRMC,111503,A,0833.6323,N,07652.7685,E,0.1866,25 6.540,220609,,*2A
$GPGSA,A,3,08,28,17,25,,,,,,,,,0.0,1.6,16.3*02
$GPGGA,111504,0833.6316,N,07652.7682,E,1,04,1.60,1 8.70,M,-94.088,M,,*58
-
-
--
--

When the line starting with $GPRMC and the line status having "A" after two commas, then the line details should be insert into mysql database.
line in log like below:
$GPRMC,111503,A,0833.6323,N,07652.7685,E,0.1866,25 6.540,220609,,*2A

database details:

dbname: project
tablename: gps

fields in table:

insert above line in table like this.

time : 111503
latitude : 0833.6323,N
longitude : 07652.7685,E
speed : 0.1866
date : 220609

Steps:

Script has to check whether the line starting with $GPRMC,
if it is: then Script has to check for status "A" after two commas
............... if it is
......................... data of that line should insert in mysql db
else
................ check next line....up to terminate the log


Please help me, how to achieve this task.

Thanks,
sravan

[burschik]

Are you quoting from your class assignment?