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 selectFileName($folder, $only_files = true)
{
while (true) {
$dirty_arr = scandir($folder);
// убираем все элементы, которые начинаются с .
$arr = [];
$index = 1;
foreach ($dirty_arr as $dir_item) {
if (!preg_match('@^\\.@', $dir_item)) {
$arr[$index] = $dir_item;
$index++;
}
}
echo "\n" . $folder . ":\n";
foreach ($arr as $index => $item) {
echo "\t" . str_pad($index, 8, '.') . $item . "\n";
}
echo "\nEnter file or directory index:\n";
$index = CliUtil::readStdinAnswer();
if (!array_key_exists($index, $arr)) {
echo "Index not found\n";
continue;
}
$selected_path = $folder . DIRECTORY_SEPARATOR . $arr[$index];
if (is_dir($selected_path)) {
if ($only_files) {
$folder = $selected_path;
continue;
}
echo CliUtil::delimiter();
echo "Selected directory: " . $selected_path . "\n";
echo "Use it or enter directory?\n\t1 use directory\n\tENTER enter directory\n";
// TODO: constants
$answer = CliUtil::readStdinAnswer();
switch ($answer) {
case 1:
// TODO: use constant
return $selected_path;
case '':
$folder = $selected_path;
break;
default:
throw new \Exception('Unknown answer');
}
continue;
}
return $selected_path;
}
}
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 static function process_db($db_id)
{
// checking DB connectivity
$db_obj = null;
try {
$db_obj = \OLOG\DB\DBFactory::getDB($db_id);
} catch (\Exception $e) {
echo $e->getMessage() . "\n\n";
}
if (!$db_obj) {
echo CliUtil::delimiter();
echo "Can't connect to database " . $db_id . "\n";
echo "Probable problems:\n";
echo "- misconfiguration. App config for database:\n";
//echo var_export(DBFactory::getConfigArr($db_id)) . "\n"; // TODO: fix
echo "- database server not accessible\n";
echo "- database not created. It must be created manually.\n";
exit;
}
$executed_queries_sql_arr = [];
try {
$executed_queries_sql_arr = \OLOG\DB\DBWrapper::readColumn($db_id, 'select sql_query from ' . self::EXECUTED_QUERIES_TABLE_NAME);
} catch (\Exception $e) {
echo CliUtil::delimiter();
echo "Can not load the executed queries list from " . self::EXECUTED_QUERIES_TABLE_NAME . " table:\n";
echo $e->getMessage() . "\n\n";
echo "Probably the " . self::EXECUTED_QUERIES_TABLE_NAME . " table was not created. Choose:\n";
echo "\tENTER to create table and proceed\n";
// TODO: constants
echo "\tany other key to exit\n";
$command_str = CliUtil::readStdinAnswer();
// TODO: switch
if ($command_str == '') {
// TODO: constants
\OLOG\DB\DBWrapper::query($db_id, 'create table ' . self::EXECUTED_QUERIES_TABLE_NAME . ' (id int not null auto_increment primary key, created_at_ts int not null, sql_query text) engine InnoDB default charset utf8');
} else {
exit;
}
}
$sql_arr = self::loadSqlArrForDB($db_id);
foreach ($sql_arr as $sql) {
if (!in_array($sql, $executed_queries_sql_arr)) {
echo CliUtil::delimiter();
echo $sql . "\n";
// TODO: constants
echo "\n";
echo "\t" . self::COMMAND_SKIP_QUERY . ": skip query now, do not mark as executed\n";
echo "\t" . self::COMMAND_IGNORE_QUERY . ": ignore query - mark as executed, but do not execute (you can execute one manually)\n";
echo "\tENTER execute query\n";
$command_str = CliUtil::readStdinAnswer();
switch ($command_str) {
case '':
\OLOG\DB\DBWrapper::query($db_id, $sql);
\OLOG\DB\DBWrapper::query($db_id, 'insert into ' . self::EXECUTED_QUERIES_TABLE_NAME . ' (created_at_ts, sql_query) values (?, ?)', array(time(), $sql));
echo "Query executed.\n";
break;
case self::COMMAND_IGNORE_QUERY:
\OLOG\DB\DBWrapper::query($db_id, 'insert into ' . self::EXECUTED_QUERIES_TABLE_NAME . ' (created_at_ts, sql_query) values (?, ?)', array(time(), $sql));
echo "Query marked as executed without execution.\n";
break;
case self::COMMAND_SKIP_QUERY:
echo "Query skipped.\n";
break;
default:
//echo "Unknown command.\n";
throw new \Exception('unknown command');
break;
// TODO: repeat entry?
}
}
}
}
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();
}
