public function get_last_edited_message(Database_Table $table, $id) { return 'Updated row ' . $id . ' from the ' . $table->get_name() . ' table.'; }
private function get_filename_for_table(Database_Table $table) { return $this->get_name() . '/' . $table->get_name() . '.txt'; }
public static function save_table_structure_in_directory(Database_Table $table, $table_specification_directory_name) { $debug = FALSE; #$debug = TRUE; $table_name = $table->get_name(); if ($debug) { echo '$table_name: ' . $table_name . PHP_EOL; } /* * Make sure that the dir exists. */ if (!is_dir($table_specification_directory_name)) { FileSystem_DirectoryHelper::mkdir_parents($table_specification_directory_name); } foreach ($db_table->get_fields() as $db_field) { $db_field_name = $db_field->get_name(); if ($debug) { echo '$db_field_name: ' . $db_field_name . PHP_EOL; } /* * Save the type. */ $db_field_type = $db_field->get_type(); if ($debug) { echo '$db_field_type: ' . $db_field_type . PHP_EOL; } $db_field_type_file_name = $table_specification_directory_name . DIRECTORY_SEPARATOR . $db_field_name . '.type'; if ($debug) { echo '$db_field_type_file_name: ' . $db_field_type_file_name . PHP_EOL; } if (!$debug) { if ($fh = fopen($db_field_type_file_name, 'w')) { fwrite($fh, $db_field_type . PHP_EOL); fclose($fh); } } /* * Save whether this field can be null or not */ $db_field_can_be_null = $db_field->can_be_null(); if ($debug) { echo '$db_field_can_be_null: ' . ($db_field_can_be_null ? 'YES' : 'NO') . PHP_EOL; } $db_field_can_be_null_file_name = $table_specification_directory_name . DIRECTORY_SEPARATOR . $db_field_name . '.can-be-null'; if ($debug) { echo '$db_field_can_be_null_file_name: ' . $db_field_can_be_null_file_name . PHP_EOL; } if (!$debug) { if ($fh = fopen($db_field_can_be_null_file_name, 'w')) { fwrite($fh, ($db_field_can_be_null ? 'YES' : 'NO') . PHP_EOL); fclose($fh); } } /* * Save the key */ $db_field_key = $db_field->get_key(); if (strlen($db_field_key) > 0) { if ($debug) { echo '$db_field_key: ' . $db_field_key . PHP_EOL; } $db_field_key_file_name = $table_specification_directory_name . DIRECTORY_SEPARATOR . $db_field_name . '.key'; if ($debug) { echo '$db_field_key_file_name: ' . $db_field_key_file_name . PHP_EOL; } if (!$debug) { if ($fh = fopen($db_field_key_file_name, 'w')) { fwrite($fh, $db_field_key . PHP_EOL); fclose($fh); } } } /* * Save the default */ $db_field_default = $db_field->get_default(); if (strlen($db_field_default) > 0) { if ($debug) { echo '$db_field_default: ' . $db_field_default . PHP_EOL; } $db_field_default_file_name = $table_specification_directory_name . DIRECTORY_SEPARATOR . $db_field_name . '.default'; if ($debug) { echo '$db_field_default_file_name: ' . $db_field_default_file_name . PHP_EOL; } if (!$debug) { if ($fh = fopen($db_field_default_file_name, 'w')) { fwrite($fh, $db_field_default . PHP_EOL); fclose($fh); } } } /* * Save any extra info. */ $db_field_extra = $db_field->get_extra(); if (strlen($db_field_extra) > 0) { if ($debug) { echo '$db_field_extra: ' . $db_field_extra . PHP_EOL; } $db_field_extra_file_name = $table_specification_directory_name . DIRECTORY_SEPARATOR . $db_field_name . '.extra'; if ($debug) { echo '$db_field_extra_file_name: ' . $db_field_extra_file_name . PHP_EOL; } if (!$debug) { if ($fh = fopen($db_field_extra_file_name, 'w')) { fwrite($fh, $db_field_extra . PHP_EOL); fclose($fh); } } } } #/* # * Save the indexes. # */ # #$dbh = DB::m(); # #$query = "SHOW INDEX FROM $table_name"; # #$result = mysql_query($query, $dbh); # #while ($row = mysql_fetch_assoc($result)) { # print_r($row); # # $index_file_name # = $table_specification_directory_name # . DIRECTORY_SEPARATOR . $row['Key_name'] . '.index'; # echo '$index_file_name: ' . $index_file_name . PHP_EOL; # # if ($fh = fopen($index_file_name, 'w')) { # foreach ( # explode(' ', 'Non_unique Column_name') # as # $key # ) { # fwrite( # $fh, # $key . ': ' . $row[$key] . PHP_EOL # ); # } # # fclose($fh); # } #} }