I am facing a minor issue, can someone guide me on how to execute a query on views within a database? My scenario is based on the following example: view here
- The database name is bue (MySQL)
- The view I am working with is called v1
- I am using TYPEORM
This piece of code represents an entity:
import { ViewEntity, Connection } from 'typeorm';
@ViewEntity({
expression: (connection: Connection) => connection.createQueryBuilder()
.select('id')
.from(V1, 'v1'), })
}
export class V1 {
}
Upon checking my error logs in the console, I found the following information: https://i.sstatic.net/jpz4Q.png