PHP Database_DatabaseHelper::get_tables Examples

Example #1

File: Database_TableSpecificationTests.inc.php Project: saulhoward/haddock-cms

 public static function dtest_all_db_fields_have_correct_type_in_specification()
 {
     foreach (Database_DatabaseHelper::get_tables() as $db_table) {
         $specified_table = Database_TableSpecificationHelper::get_table($db_table->get_name());
         foreach ($db_table->get_fields() as $db_field) {
             if ($db_field->get_type() != $specified_table->get_field_type($db_field->get_name())) {
                 return FALSE;
             }
         }
     }
     return TRUE;
 }

Example #2

File: Database_TableSpecificationHelper.inc.php Project: saulhoward/haddock-cms

 /**
  * This function makes the table specification
  * like the database.
  */
 public static function sync_database_with_table_specification()
 {
     $debug = FALSE;
     #$debug = TRUE;
     foreach (Database_DatabaseHelper::get_tables() as $db_table) {
         $table_specification_directory_name = self::get_table_specification_directory_name($db_table->get_name());
         if ($debug) {
             echo '$table_specification_directory_name: ' . $table_specification_directory_name . PHP_EOL;
         }
         self::save_table_structure_in_directory($table_name, $table_specification_directory_name);
     }
 }