|
The program I've written to interpret the station data file is designed
to do two things:
- convert the station data into a set of equivalent SQL insert
statements (see Why SQL?)
- provide some reporting facilities which allow the data to be
verified
At this time, I'm not going to explain very much of this. The data
structures and equivalent database tables are explained elsewhere, and
the verification reports aren't really very good. Fundamentally, I would
say "Use the source!"
What I will say is that the program works by reading the data file into
a set of data structures internally representing data, and then
traverses the data in different ways to produce the SQL output and so
on.
The program is written in C++ using MFC data structures (because they're
the ones I know best, not because they're any good particularly) and is
compiled to run on Win32 platforms (well, I've run it on two).
I would also add that I would probably write this kind of text processing
application in Perl now, but I did not know Perl then.
|
