CVS: phpweather/db pw_db_mysql.php,1.6,1.7 pw_db_null.php,1.4,1.5

[Etienne T. <eti...@us...>]

Update of /cvsroot/phpweather/phpweather/db
In directory sc8-pr-cvs1:/tmp/cvs-serv24907/db

Modified Files:
	pw_db_mysql.php pw_db_null.php 
Log Message:
Added TAF support.  Modified data_retrieval.php, defaults-dist.php, phpweather.php, pw_db_mysql.php, pw_db_null.php.  Needs to add output functionality and support all backends.

Index: pw_db_mysql.php
===================================================================
RCS file: /cvsroot/phpweather/phpweather/db/pw_db_mysql.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -3 -r1.6 -r1.7
--- pw_db_mysql.php	28 Aug 2002 10:05:55 -0000	1.6
+++ pw_db_mysql.php	8 Sep 2003 04:20:44 -0000	1.7
@@ -223,6 +223,53 @@
     return $this->fetch_row();
   }
 
+ /**
+   * Inserts a TAF into the database.
+   *
+   * @param   string   The ICAO of the station.
+   * @param   string   The raw TAF.
+   * @param   integer  A standard UNIX timestamp.
+   * @access  public
+   * @see update_taf()
+   */
+  function insert_taf($icao, $taf, $timestamp) {
+    $this->query(sprintf('INSERT INTO %s SET icao = "%s", ' .
+                         'taf = "%s", timestamp = FROM_UNIXTIME(%d)',
+                         $this->properties['db_tafs'], $icao,
+                         addslashes($taf), intval($timestamp)));
+  }
+
+  /**
+   * Updates an existing TAF in the database.
+   *
+   * @param   string   The ICAO of the station.
+   * @param   string   The raw TAF.
+   * @param   integer  A standard UNIX timestamp.
+   * @access  public
+   * @see insert_taf()
+   */
+  function update_taf($icao, $taf, $timestamp) {
+    $this->query(sprintf('UPDATE %s' .
+                         ' SET taf = "%s", timestamp = FROM_UNIXTIME(%d)' .
+                         ' WHERE icao = "%s"',
+                         $this->properties['db_tafs'], addslashes($taf),
+                         intval($timestamp), $icao));
+  }
+ 
+  /**
+   * Gets a TAF form the database.
+   *
+   * @param   string  The ICAO of the station.
+   * @return  string  The raw TAF as an array from the database.
+   * @access  public
+   */
+  function get_taf($icao) {
+    $this->query(sprintf('SELECT taf, UNIX_TIMESTAMP(timestamp)' .
+                         ' FROM %s WHERE icao = "%s"',
+                         $this->properties['db_tafs'], $icao));
+    return $this->fetch_row();
+  }
+
 
   /**
    * Creates the necessary tables in the database.
@@ -241,6 +288,15 @@
     $this->query('CREATE TABLE ' . $this->properties['db_metars'] . '(
    icao char(4) NOT NULL,
    metar varchar(255) NOT NULL,
+   timestamp timestamp(14),
+   PRIMARY KEY (icao),
+   UNIQUE icao (icao))');
+
+    /* First we make a table for the TAFs */
+    $this->query('DROP TABLE IF EXISTS ' . $this->properties['db_tafs']);
+    $this->query('CREATE TABLE ' . $this->properties['db_tafs'] . '(
+   icao char(4) NOT NULL,
+   taf varchar(255) NOT NULL,
    timestamp timestamp(14),
    PRIMARY KEY (icao),
    UNIQUE icao (icao))');

Index: pw_db_null.php
===================================================================
RCS file: /cvsroot/phpweather/phpweather/db/pw_db_null.php,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -3 -r1.4 -r1.5
--- pw_db_null.php	28 Aug 2002 10:05:55 -0000	1.4
+++ pw_db_null.php	8 Sep 2003 04:20:44 -0000	1.5
@@ -98,6 +98,44 @@
   }
 
   /**
+   * Pretends to insert a TAF into the database.
+   *
+   * @param   string   The ICAO of the station.
+   * @param   string   The raw TAF.
+   * @param   integer  A standard UNIX timestamp.
+   * @access  public
+   * @see     update_taf()
+   */
+  function insert_taf($station, $taf, $timestamp) {
+    ;
+  }
+
+  /**
+   * Pretends to update an existing TAF in the database.
+   *
+   * @param   string   The ICAO of the station.
+   * @param   string   The raw TAF.
+   * @param   integer  A standard UNIX timestamp.
+   * @access  public
+   * @see     insert_taf()
+   */
+  function update_taf($station, $taf, $timestamp) {
+    ;
+  }
+
+  /**
+   * Pretends to return a TAF form the database.
+   *
+   * @param   string  The ICAO of the station.
+   * @return  string  Since we don't have a database, we just return an
+   *                  empty string.
+   * @access  public
+   */
+  function get_taf($station) {
+    return '';
+  }
+
+  /**
    * Fetches information about an ICAO.
    *
    * @param   string  The ICAO one want's to translate.