Can't customize Primary Key type or name

[ferminminetto]

Informations

• Node.js: 10.0.8
• npm: 6.2.0
• Strapi: 3.0.0-alpha.13.1
• Database: MySQL
• Operating system: Ubuntu 18.04

What is the current behavior?
I'm using Strapi to connect with an existing table in a MySQL table. Sadly, the id column of such table it's not called id, it's called work_id. To solve this I used in my model's JSON settings file the following configuration:

{
  "connection": "default",
  "collectionName": "works",
  "primaryKey": "work_id",
  "info": {
    "name": "Works",
    "description": "",
    "mainField": "work_id"
  },
  "attributes": {
    "work_id": {
      "type": "integer",
      "required": true
    },
   ...

It lists the objects from the database well, but when I try to enter the details of an object it throws an error saying: Error: Undefined binding(s) detected when compiling SELECT query: select `works`.* from `works` where `works`.`work_id` = ? limit ?`

Steps to reproduce the problem
Connect to an existing table of a database using a different PK name.

What is the expected behavior?
I should be able to enter the detail view of the object from that type of content.

Suggested solutions
I'm not sure!

[lauriejim]

Hello @ferminmine , thank you for reporting this issue. We are currently on another feature and bug fix. Since time is lacking on our side, feel free investigate and submit a PR, we’ll appreciate your contribution on this issue!

Check out the contributing guide to get started: https://github.com/strapi/strapi/blob/master/CONTRIBUTING.md

[takahiro-yonei]

I really appreciate if there is any update.
Is there any update?

Thank you always for great works!

[lauriejim]

We (Strapi core team) don't have time now to work on. Need you (the community) investigate and work on this issue.

[lauriejim]

I update your issue to more global issue.
Actually you can't customize the Primary Key.

[chaitanyya]

While working on the custom timestamps I discovered the hardcoded primary key name. I can pick this issue and use the idAttribute to create custom primary key column name.

For further clarification can you guys tell me how is primaryKey attribute different from idAttribute?

[derrickmehaffy]

@chaitanyya idAttritbute is how the key is stored I believe by default it is just int but in theory you should be able to use a UUID thus you would store it as a string. Unlike postgres though MySQL can't automatically generate them so work on it was put on hold as Strapi would need to generate the UUID value.

[chaitanyya]

I believe that's idAttributeType, from the documentation:

idAttribute: This tells the model which attribute to expect as the unique identifier for each database row (typically an auto-incrementing primary key named 'id'). Only valid for strapi-hook-bookshelf

This seems very similar to what primaryKey does. Is there a reason for having them both?