Incorrect table mapping when using EntityGenerator with entitySchema

[koneru9999]

Describe the bug
When using the EntityGenerator helper to generate the entities from existing database schema, the generated entity is mapped to wrong or non-existing table name especially when the table name has underscore (_).

This may be happening for other special characters as well.

Stack trace

...

To Reproduce
Steps to reproduce the behavior:

1. Create a table Address_lines

CREATE TABLE `Address_lines` (
`nodeId` char(25) CHARACTER SET utf8 NOT NULL,
`position` int(4) NOT NULL,
`value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`nodeId`,`position`),
KEY `value` (`value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

2. setup the entity generation

const orm = await init({
  // ... other config
  entitiesTs: [`./src/entities`],
  entityGenerator: {
    entitySchema: true,
    identifiedReferences: true,
  },
  type: 'mysql',
})

await orm.getEntityGenerator().generate({
  baseDir: path.join(__dirname, `./src/entities`),
  save: true,
})

await orm.close(true)

3. the following is the generated after the execusting the generation

  export class AddressLines {
    nodeId!: string
    position!: number
    value!: unknown
  }

export const AddressLinesSchema = new EntitySchema({
  class: AddressLines,
  tableName: 'AddressLines', // This is wrong and should be inferred as `Address_lines`
  properties: {
    nodeId: {
      primary: true,
      fieldName: 'nodeId',
      columnType: 'char(25)',
      length: 25 
    },
    position: { primary: true, type: 'number' },
    value: {
      type: 'unknown',
      columnType: 'mediumtext',
      length: 16777215,
      index: 'value',
    },
  },
})

Expected behavior
Entity class and schema files generated with corresponding table name.

tableName: 'Address_lines',

Additional context
A possible issue could be in this line https://github.com/mikro-orm/mikro-orm/blob/master/packages/entity-generator/src/EntitySchemaSourceFile.ts#L45

Versions

Dependency	Version
node	16.x
typescript	4.9.4
mikro-orm	5.6.3
your-driver	mysql

[koneru9999]

Hi @B4nan,
Thanks for following up on the PR.

Any plan on getting this released this week ?

[B4nan]

every commit to master is released as dev version, so you can use it right now. will do a stable release later this week, maybe even today

[koneru9999]

Thanks. good to know 👍