Page History

...

The data loaded into the database was obtained from the following files:

• Wiki Markup
  Country List \[[csv|^country_list.csv]\] (July 2009)

• Wiki Markup
  PingER

  NODEDETAILS csv 

  NODEDETAILS \[[csv|^nodedetails.csv]\]  (March 2009)

...

I wrote two scripts (listed below) to generate SQL commands from this raw data. The resulting SQL commands were then coalesced into a single sql file \[[nodedetails-schema.sql|^nodedetails-schema.sql]\] which was used to setup the server at NUST.

• Wiki Markup
  generate-sql-from-country-data \[[.pl|^generate-country-data-sql.pl]\]

• Wiki Markup
  generate-sql-from-pinger-nodedetails-data \[[.pl|^generate-nodedetails-sql.pl]\]