WARNING: relational database doesn't support {strict: false} mode. {strict: true} mode will be set for model instead.

[UsmanJavedAttari]

Steps to reproduce

Use {strict: false} in @model(settings : {}) property.

Current Behavior

Getting

WARNING: relational database doesn't support {strict: false} mode. {strict: true} mode will be set for model User instead.

Expected Behavior

The warning should not be here. As I updated the loopback cli and with that I updated loopback dependencies, after updating everything, I am getting this warning. It working fine in previous version. Using MySQL. Also getting these warnings if I get request on any URL.

Additional information

+-- @loopback/authentication@3.3.1
+-- @loopback/boot@1.7.2
+-- @loopback/context@2.0.0
+-- @loopback/core@1.12.2
+-- @loopback/openapi-v3@1.12.0
+-- @loopback/repository@1.18.0
+-- @loopback/rest@1.26.0
+-- @loopback/rest-explorer@1.4.8
+-- @loopback/service-proxy@1.3.15
+-- jsonwebtoken@8.5.1
+-- lodash@4.17.15
+-- loopback-connector-mysql@5.4.2

[dougal83]

working fine in previous version

I don't think it actual does anything for non-relational dbs. Does anything change when you don't set {strict: false}?

See: loopbackio/loopback-datasource-juggler#1817

@agnes512 Is this correct?

[agnes512]

Yes. Because {strict: false} mode is only supported by NoSQL databases. See #4042 and #4042 (comment).

[dougal83]

Hey @UsmanJavedAttari

Please remove {strict: false} from @model(settings : {}) property to remove the warning.

[UsmanJavedAttari]

@dougal83 then I am not able to add extra properties.
Let's say I want to add some extra properties in the response, I have to add those in model and make {strict: false}. Otherwise, it doesn't pick extra properties.

[UsmanJavedAttari]

And the question is why I didn't get any warnings in the previous version?🤔 Even though I was using {strict: false}.

[agnes512]

The warning was added lately. We didn't change anything but add the warning.

[UsmanJavedAttari]

@dougal83 then I am not able to add extra properties.
Let's say I want to add some extra properties in the response, I have to add those in model and make {strict: false}. Otherwise, it doesn't pick extra properties.

What about this?

[bajtos]

@UsmanJavedAttari if I understand your use case correctly, your model contains well-defined property (via @property()) that are stored in your MySQL database, but then you have some custom code that's adding additional properties to be returned in HTTP responses. When a HTTP request to create or modify a model includes those additional properties, they are silently discarded by LoopBack and that's the behavior you are looking for.

Is my description correct?

Where are you adding the extra properties to the response, is it in your controller method?

My recommendation is to convert your model to a plain data object first, and then add the extra properties.

class MyController {
  @get(/*...*/)
  async find(
    @param.query.object('filter', getFilterSchemaFor(TodoList))
    filter?: Filter<TodoList>,
  ): Promise<TodoList[]> {
    const result = this.todoListRepository.find(filter);
    return result.map(it => {
      const data = it.toJSON();
      // add your extra properties here
      return data;
    });
  }
}

There is a catch though: the OpenAPI spec will not describe the additional properties. I believe your original implementation has this problem too. A better solution is to create a new model class for your response data and explicitly describe the properties you are adding on top of the persisted data.

@model()
class CustomerResponse extends Customer {
  // all Product properties are inherited
  // let's add some extra data now
  @property()
  fullName: string;

  // we can fill extra properties in the constructor (for example)
  constructor(data: Partial<Customer>) {
    super(data);
    this.fullName = this.firstName + ' ' + this.lastName;
  }
}

class CustomerController {
  @get(
    // use schema: getModelSchemaRef(CustomerResponse, {includeRelations: true})
  )
  async find(
    // important! the filter object does not accept "extra" properties, 
   // create the filter schema using the base model class
    @param.query.object('filter', getFilterSchemaFor(Customer))
    filter?: Filter<Customer>,
  ): Promise<CustomerResponse[]> {
    const result = this.customerRepository.find(filter);
    return result.map(it => new CustomerResponse(it));
  }
}

[dougal83]

@UsmanJavedAttari It is possible to extend a model in the controller as follows:

@model()
export class CustomUserResponse extends User {
  @property({
    type: 'string',
    required: true,
  })
  extendedProp: string;
}

And make the required changes:

@post('/users', {
    responses: {
      '200': {
        description: 'User',
        content: {
          'application/json': {
            schema: {
              'x-ts-type': CustomUserResponse,
            },
          },
        },
      },
    },
  })
  async create(
    // ...
  ): Promise<CustomUserResponse> {
      // ...
      const savedUser = await this.userRepository.create() // ...
      // ...
      return Object.assign({ extendedProp: 'example' }, savedUser);
  }

Lol. Just beaten. :)