Loopback-next: @belongsTo doesn't create relations in database

[odykyi]

User Model:

import { Entity, model, property } from '@loopback/repository';

export class Users extends Entity {
  @property({
    type: 'string',
    id: true,
    generated: true
  })
  id?: string;

  @property({
    type: 'string',
    required: true,
  })
  full_name: string;

  constructor(data?: Partial<Users>) {
    super(data);
  }
}

export interface UsersRelations {
  // describe navigational properties here
}

export type UsersWithRelations = Users & UsersRelations;

---

User Device Model:

import { Entity, model, property, belongsTo } from '@loopback/repository';
import { Users } from './users.model';

export class UserDevice extends Entity {
  @property({
    type: 'string',
    id: true,
    generated: true,
  })
  id?: string;

  @property({
    type: 'string',
    required: true,
  })
  device_id: string;


  @belongsTo(() => Users)
  user_id: string;

  constructor(data?: Partial<UserDevice>) {
    super(data);
  }
}

export interface UserDeviceRelations {
  // describe navigational properties here
}

export type UserDeviceWithRelations = UserDevice & UserDeviceRelations;

[odykyi]

@fabien @rmg @klassicd @ceefour

[odykyi]

@achrinza

[achrinza]

LoopBack 4 does not create database constraints at the moment: #2331

I'll close this so that we can consolidate discussion to the epic.

Feel free to comment if I misunderstood the issue.

[achrinza]

Duplicate of #2331

[odykyi]

@achrinza I mean references in sql FK

[achrinza]

Apologies for the confusion; I believe we’re talking about the same thing, just different wording.

database constraints = foreign key constraints

[odykyi]

this works for me

@model({
  settings: {
    foreignKeys: {
      fk_todo_todoListId: {
        name: 'fk_todo_todoListId',
        entity: 'TodoList',
        entityKey: 'id',
        foreignKey: 'todolistid',
      },
    },
  },
})
export class Todo extends Entity {
  //etc.
}

https://loopback.io/doc/en/lb4/todo-list-tutorial-sqldb.html#specify-the-foreign-key-constraints-in-todo-model

[achrinza]

Apologies, didn’t know your requirement was PostgreSQL/MySQL

Glad you’ve found a solution.

Unfortunately this isn’t universal across other connectors as LoopBack doesn’t provide a common interface. For example, the MSSQL connector doesn’t support this natively.

[odykyi]

I use mysql