public static function run() { while (true) { echo CliUtil::delimiter(); echo "Choose PHPModel function:\n"; echo "\t" . self::FUNCTION_EXECUTE_SQL . ": execute new SQL queries from registry\n"; echo "\t" . self::FUNCTION_CREATE_MODEL . ": create model\n"; echo "\t" . self::FUNCTION_ADD_MODEL_FIELD . ": add field to existing model\n"; echo "\t" . self::FUNCTION_MODEL_FIELD_EXTRAS . ": extra operations on model field\n"; echo "\tENTER: exit\n"; $command_str = CliUtil::readStdinAnswer(); switch ($command_str) { case self::FUNCTION_EXECUTE_SQL: CLIExecuteSql::executeSqlScreen(); break; case self::FUNCTION_CREATE_MODEL: CLICreateModel::enterClassNameScreen(); break; case self::FUNCTION_ADD_MODEL_FIELD: $cli_add_field_obj = new CLIAddFieldToModel(); $cli_add_field_obj->addField(); break; case self::FUNCTION_MODEL_FIELD_EXTRAS: $cli_add_field_obj = new CLIAddFieldToModel(); $cli_add_field_obj->extraFieldFunctionsScreen(); break; default: exit; } } }
public static function generateClass() { // $cwd = getcwd(); // TODO: model_namespace_for_path may have leading '/' - remove it? $model_filename = $cwd . DIRECTORY_SEPARATOR . self::$model_namespace_for_path . DIRECTORY_SEPARATOR . self::$model_class_name . '.php'; $model_tablename = mb_strtolower(self::$model_namespace_for_class . "\\" . self::$model_class_name); $model_tablename = preg_replace('@\\W@', '_', $model_tablename); // // creating model class file // $class_file = self::getClassTemplate(); // TODO: use common variable replacemnt method $class_file = str_replace('TEMPLATECLASS_CLASSNAME', self::$model_class_name, $class_file); $class_file = str_replace('TEMPLATECLASS_NAMESPACE', self::$model_namespace_for_class, $class_file); $class_file = str_replace('TEMPLATECLASS_TABLENAME', $model_tablename, $class_file); $class_file = str_replace('TEMPLATECLASS_DBID', self::$model_db_id, $class_file); self::file_force_contents($model_filename, $class_file); echo "\nModel file created: " . $model_filename . "\n"; // // altering database sql file // $class_sql = self::getClassSQL(); // TODO: use common variable replacemnt method $class_sql = str_replace('TEMPLATECLASS_TABLENAME', $model_tablename, $class_sql); CLIExecuteSql::addSqlToRegistry(self::$model_db_id, $class_sql); echo "\nSQL registry updated\n"; echo "\nType ENTER to execute SQL queries, Ctrl+C to exit.\n"; $command_str = CliUtil::readStdinAnswer(); if ($command_str == '') { CLIExecuteSql::executeSqlScreen(); } return; }
public function addField() { echo CliUtil::delimiter(); echo "Choose model class file:\n"; $this->model_file_path = CLIFileSelector::selectFileName(getcwd()); echo "\nClass file: " . $this->model_file_path . "\n"; $class_file_obj = new PHPClassFile($this->model_file_path); echo 'Class to be updated: ' . $class_file_obj->class_namespace . "\\" . $class_file_obj->class_name . "\n"; $this->field_name = $this->askFieldName($class_file_obj); /** @var FieldDataType $field_data_type */ $field_data_type = $this->askDataType(); $default_value = $this->askDefaultValue($field_data_type); // // // $class_field_default_value_str = ''; $sql_default_value_str = ''; if ($default_value != '') { $class_field_default_value_str = ' = ' . $default_value; $sql_default_value_str = ' default ' . $default_value; } $field_string_for_class = ' const ' . self::constantNameForFieldName($this->field_name) . ' = \'' . $this->field_name . '\';' . "\n"; $field_string_for_class .= ' protected $' . $this->field_name . $class_field_default_value_str . ';' . "\n"; $class_file_obj->insertAboveIdField($field_string_for_class); $getters_setters_template = self::gettersSettersTemplate(); $getters_setters_template = self::replaceFieldNamePlaceholders($getters_setters_template, $this->field_name); $class_file_obj->insertBelowIdField($getters_setters_template); $class_file_obj->save(); echo "\nModel class file updated\n"; // // // $sql_field_is_nullable_str = ''; if ($field_data_type->can_be_null) { echo CliUtil::delimiter(); echo "Choose whether database field is nullable:\n\tn: null\n\tENTER: not null\n"; // TODO: use constants $is_nullable_reply = trim(fgets(STDIN)); switch ($is_nullable_reply) { case 'n': // TODO: use constant $sql_field_is_nullable_str = ''; break; case '': // TODO: use constant $sql_field_is_nullable_str = ' not null '; break; default: throw new \Exception('Unsupported answer'); } } // // adding sql // $model_db_id = $this->getDbIdFromClassFile(); $model_table_name = $this->getTableNameFromClassFile(); $this->db_table_field_name = $this->field_name; $sql = 'alter table ' . $model_table_name . ' add column ' . $this->db_table_field_name . ' ' . $field_data_type->sql_type_name . ' ' . $sql_field_is_nullable_str . ' ' . $sql_default_value_str . ' /* rand' . rand(0, 999999) . ' */;'; CLIExecuteSql::addSqlToRegistry($model_db_id, $sql); echo "\nSQL registry updated\n"; echo CliUtil::delimiter(); echo "Press ENTER to execure SQL queries, enter n to skip:\n"; $command_str = CliUtil::readStdinAnswer(); if ($command_str == '') { CLIExecuteSql::executeSqlScreen(); } $this->extraFieldFunctionsScreen(); }