phpweather-checkins Mailing List for PHP Weather (Page 4)

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

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.





2001	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct (1)	Nov	Dec (7)
2002	Jan (1)	Feb (1)	Mar (184)	Apr (31)	May (45)	Jun (15)	Jul (11)	Aug (40)	Sep (19)	Oct (8)	Nov (6)	Dec (17)
2003	Jan (5)	Feb	Mar (12)	Apr (5)	May (2)	Jun (3)	Jul (3)	Aug (3)	Sep (17)	Oct (10)	Nov	Dec (4)
2004	Jan (21)	Feb (11)	Mar	Apr	May (3)	Jun (7)	Jul	Aug	Sep	Oct	Nov	Dec
2005	Jan (4)	Feb	Mar	Apr (1)	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2006	Jan	Feb	Mar (2)	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec

phpweather-checkins Mailing List for PHP Weather (Page 4)

phpweather-checkins — CVS checkins are sent to this list.