]> git.mxchange.org Git - city.git/blobdiff - application/city/main/database/frontend/city/class_CityInformationDatabaseWrapper.php
Updated 'core'.
[city.git] / application / city / main / database / frontend / city / class_CityInformationDatabaseWrapper.php
index 932228052356ec01de3f5478313e9396f942603a..6624b56100f39db126518f70953e9099e8bd38ad 100644 (file)
@@ -94,7 +94,7 @@ class CityInformationDatabaseWrapper extends BaseDatabaseWrapper implements City
         * @param       $requestInstance        An instance of a Requestable class
         * @return      void
         */
-       public function registerCityId (BaseCity $cityInstance, Requestable $requestInstance) {
+       public function registerCityId (BaseCityDaemon $cityInstance, Requestable $requestInstance) {
                // Get a dataset instance
                $dataSetInstance = ObjectFactory::createObjectByConfiguredName('dataset_criteria_class', array(self::DB_TABLE_CITY_INFORMATION));
 
@@ -222,6 +222,43 @@ class CityInformationDatabaseWrapper extends BaseDatabaseWrapper implements City
                // Post-check name
                assert($this->ifCityExists($cityName));
        }
+
+       /**
+        * Getter for all city ids as an array
+        *
+        * @return      $cityIds        All city ids as an array
+        */
+       public function getAllCityIds () {
+               // Init empty search instance
+               $searchInstance = ObjectFactory::createObjectByConfiguredName('search_criteria_class');
+
+               // And run it on the database
+               $resultInstance = $this->doSelectByCriteria($searchInstance);
+
+               // Init array
+               $cityIds = array();
+
+               // Anything found?
+               if ($resultInstance->count() == 0) {
+                       // Nothing found
+                       return $cityIds;
+               } // END - if
+
+               // Now get all 'city_id' columns
+               while ($resultInstance->next()) {
+                       // Get current entry
+                       $current = $resultInstance->current();
+
+                       // 'city_id' should be there
+                       assert(isset($current[self::DB_COLUMN_CITY_ID]));
+
+                       // Add it to the array
+                       array_push($cityIds, $current[self::DB_COLUMN_CITY_ID]);
+               } // END - while
+
+               // Return result
+               return $cityIds;
+       }
 }
 
 // [EOF]