HasOneSql is not merging imported field seed properly

[mkrecek234]

Steps to reproduce:

1. You have a model and addExpression which by nature is non-editable.
2. You for example relate to that model with a hasOne relation, and import that expression as a field

Error TypeError: Atk4\Data\Field::isEditable(): Return value must be of type bool, array returned
in Model:730

The issue is in line 734, as isEditable is not existing as a property for SqlExpressionField.

[mvorisek]

@mkrecek234 please do not add MAJOR to (every) bug, MAJOR is something conceptually wrong or with major impact on most users.

Also, please copy/screenshot full backtrace in case you want to refer to it. Refering to a line number without knowing the file is almost useless. The same for the exception message, as the reason might depend on a context which is shown in exceptions params (added by Exception::addMoreInfo()).

[mkrecek234]

[mvorisek]

The issue is in line 734, as isEditable is not existing as a property for SqlExpressionField.

There is no isEditable property in atk4/data. There is only Field::isEditable() method, which by inheritance available in SqlExpressionField. Can you please post a minimalistic code to reproduce or is it possible to reproduce it on atk4/ui demos?

[mkrecek234]

Correct - it relates to the missing isEditable() property of SqlExpressionField. In Model::getFields() the following code is not compatible with SqlExpressionField:

                    ($f === 'system' && $field->system)
                    || ($f === 'not system' && !$field->system)
                    || ($f === 'editable' && $field->isEditable())
                    || ($f === 'visible' && $field->isVisible())
                ) {

As I cannot create minimalistic code on demo today, here already the info to reproduce:

1. Add an expression to any model.
   $model->addExpression('expressionfield', ['expr' => "1"]);

In a child model create a hasOne and import that expression:
$childmodel->hasOne('model_id', ['model' => [Model::class]])->addFields(['expressionfield']);

Then simple check it in a crud:
$crud->setModel($childmodel);

[mkrecek234]

I checked further, the issue is that $this->ui['editable']in Field:457 returns an array which includes true and false, rather than just a boolean value.

[mvorisek]

Thank you for the code. I am looking into it.

it relates to the missing isEditable() property of SqlExpressionField

really a property? I seached ->(is)?editable(?!\(), no such property is accessed in the whole project

I belive the issue is caused by ui['editable'] beiing an array -

data/src/Field.php

Line 457 in 0892a70

return $this->ui['editable'] ?? !$this->readOnly && !$this->neverPersist && !$this->system;

[mkrecek234]

[mvorisek]

yes, doesn't it come from your code?

[mkrecek234]

No, I haven't touched anything there, just standard model definitions

[mvorisek]

issue is here:

data/src/Reference/HasOneSql.php

Line 87 in 0892a70

$fieldExpression = $this->_addField($fieldName, false, $theirFieldName, array_merge_recursive([

array_merge_recursive is not merging the seed properly - https://3v4l.org/4Tgo8