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();
}