loopbackio / loopbackio/loopback-next
Loopback Connector Disregards Property Name
Nadie ha tomado este issue todavía.
- Lenguaje dominante
- TypeScript
- Estrellas
- 5.1k
- Forks
- 1.1k
- Merge medio
- 2 d 21 h
- PR fusionados (30 d)
- 27
Descripción
## Description / Steps to reproduce / Feature proposal
The @ property decorator has a name property which should specify the column name in the database in case it does not match with the field name in your model. However, the code in loopback-connector/sql.js does not utilize this metada so you only get the field name as it's defined in your model. In my case, I am using DB2 and this causes issues because the generated SQL select statement uses double-quotes around each field signify to DB2 that the field name matches exactly with what is specified in the DB (i.e. case sensitive).
To Reproduce:
Create a DB2 database w
1. ith a table "DRIVER" that contains field "DRIVER_ID".
2. Setup a basic Loopback4 project like the Todo Tutorial (replacing instances of Todo with Driver) but use a DB2 based datasource.
3. Create the Model like the following:
```typescript
@model({
name: 'DRIVER', // This corrects the case-sensitive issue at the Table level.
}
})
export class Driver extends Entity {
@property({
name: 'DRIVER_ID', // This is ignored by field mapping functions.
type: 'number',
id: true,
})
fooId?: number;
```
4. Use VS Code to start the server in Debug and issue a GET against drivers
5. In the sql.js --> buildColumnNames note that the name is 'fooId' instead of 'DRIVER_ID'
6. Continue execution, you will receive an SQL0206N error from DB2: "fooId" is not valid in the context where it used.
## Current Behavior
sql.js simply uses the field names as the DB column names.
## Expected Behavior
sql.js should map to the @ property 'name' property to determine the correct column names.
## Connectors to fix
- [x] SQL connectors - done by strongloop/loopback-connector#142
- [ ] MongoDB https://github.com/strongloop/loopback-connector-mongodb
- [ ] CouchDB2 https://github.com/strongloop/loopback-connector-couchdb2
- [ ] Cloudant https://github.com/strongloop/loopback-connector-cloudant (may depend on couchdb2)
- [ ] Cassandra https://github.com/strongloop/loopback-connector-cassandra
Guía de contribución
Primeros pasos
- Lee el issue completo y luego la guía de contribución del proyecto.
- Comenta en el issue que vas a ocuparte — evita que dos personas hagan lo mismo.
- Haz un fork del repositorio y trabaja en una rama.
- Abre un pull request que haga referencia al número del issue.
Línea de trabajo
Comienza en loopback-connector/sql.js, en buildColumnNames, y compara el tratamiento de los nombres de campo con los metadatos del nombre de propiedad mostrados en la reproducción. Comprueba el cambio referenciado del conector SQL antes de modificar este issue. Se considera terminado cuando las columnas SELECT generadas usan DRIVER_ID para la propiedad fooId y la reproducción de DB2 ya no produce SQL0206N.
Escrito por el modelo de indexación a partir del texto del issue.
Evaluación
- Stack tecnológico
- typescript
- Área
- database
- Tipo de issue
- Error
- Dificultad
- 3/5
- Tiempo estimado
- 1-2 días
- Estado de actividad
- Estancado
- Claridad
- Bastante claro
- Aptitud para principiantes
- 25/100