lb4 discover does not handle BLOB fields

[flaviogoncalves]

Steps to reproduce

To reproduce this problem use lb4 discover in a MySQL table having a BLOB field. It will generate a model where BLOB is mapped to binary and does not start.

Current Behavior

The lb4 discover blob fields as binary fields

Expected Behavior

Blob fields should be discovered as buffer type.

Link to reproduction sandbox

Additional information

The created model property is like

  @property({
    type: 'Binary',
    required: true,
    length: 65535,
    mysql: {columnName: 'photo', dataType: 'blob', dataLength: 65535, dataPrecision: null, dataScale: null, nullable: 'N'},
  })
  // Binary is not defined so compiler fails
  // it should be Buffer
  photo: Binary;

Related Issues

No similar issues found.

See Reporting Issues for more tips on writing good issues

[jannyHou]

The problem is here:
createPropertyTemplateData

That function should handle type Binary, map its tstype to Buffer.

@flaviogoncalves Thank you for reporting this issue. Would you like to submit a PR fixing it?

[flaviogoncalves]

Unfortunately, I don't know how to fix it.

[trmaphi]

@jannyHou, it seems like we just one more else-if block to handle this specific case.