Azure / Azure/data-api-builder

[Bug]: auto-config-simulate - fails to read config

Offen
#3,791 1 Kommentar 0 Reaktionen 0 zugewiesene Personen Auf GitHub ansehen
bug triage
Vorherrschende Sprache
C#
Sterne
1.5k
Forks
370
Ø Merge
3 T. 22 Std.
Gemergte PRs (30 T.)
9

Beschreibung

### What happened?

Getting an error when trying to use `auto-config-simulate` against a local sql server container. But it works and exposes the entities successfully when I do `dab start`

1. create the config against local dbatools container (password is shared online so not a concern)
```powershell
dab init --database-type "mssql" --host-mode "Development" --connection-string "Server=localhost,2500;User Id=sqladmin;Database=pubs;Password=dbatools.IO;TrustServerCertificate=True;Encrypt=True;"
```

2. add the `dbo.%` pattern
```powershell
dab auto-config pubs-tables `
--patterns.include "dbo.%" `
--permissions "anonymous:read"
```

3. view the config it looks good

```powershell
cat .\dab-config.json
```

```text
{
"$schema": "https://github.com/Azure/data-api-builder/releases/download/v2.0.12/dab.draft.schema.json",
"data-source": {
"database-type": "mssql",
"connection-string": "Server=localhost,2500;User Id=sqladmin;Database=pubs;Password=dbatools.IO;TrustServerCertificate=True;Encrypt=True;",
"options": {
"set-session-context": false
}
},
"runtime": {
"rest": {
"enabled": true,
"path": "/api",
"request-body-strict": false
},
"graphql": {
"enabled": true,
"path": "/graphql",
"allow-introspection": true
},
"mcp": {
"enabled": true,
"path": "/mcp"
},
"host": {
"cors": {
"origins": [],
"allow-credentials": false
},
"authentication": {
"provider": "Unauthenticated"
},
"mode": "development"
},
"telemetry": {
"open-telemetry": {
"enabled": true,
"endpoint": "@env('OTEL_EXPORTER_OTLP_ENDPOINT')",
"headers": "@env('OTEL_EXPORTER_OTLP_HEADERS')",
"service-name": "@env('OTEL_SERVICE_NAME')"
}
}
},
"autoentities": {
"pubs-tables": {
"patterns": {
"include": [
"dbo.%"
]
},
"permissions": [
{
"role": "anonymous",
"actions": [
{
"action": "read"
}
]
}
]
}
},
"entities": {}
}
```

4. run the simulate
```powershell
❯ dab auto-config-simulate -c .\dab-config.json
```
get errors
```text
info: Microsoft.DataApiBuilder 2.0.12
info: User provided config file: .\dab-config.json
fail: Failed to read the config file: .\dab-config.json.
fail: Failed to simulate autoentities.
```

But if I do `dab start` the config is fine and all the dbo tables are exposed.

### Version

Microsoft.DataApiBuilder 2.0.12+0b38aa7cbf4118034ad8dee1f2712b1c4bac4c32

### What database are you using?

Azure SQL

### What hosting model are you using?

Local (including CLI)

### Which API approach are you accessing DAB through?

REST

### Relevant log output

```Text

```

### Code of Conduct

- [x] I agree to follow this project's Code of Conduct

Beitragsleitfaden

Beitragsleitfaden öffnen

Rechercherichtung

Beginnen Sie mit dem `auto-config-simulate`-CLI-Einstiegspunkt und vergleichen Sie dessen Konfigurationsladepfad mit `dab start`, wobei Sie die bereitgestellte `.\dab-config.json` gegen den lokalen SQL-Container verwenden. Reproduzieren Sie den Fehler mit Version 2.0.12 und überprüfen Sie, dass die Simulation die gültige Konfiguration liest und die `autoentities`-Definition erfolgreich verarbeitet.

Vom Indexierungsmodell aus dem Issue-Text verfasst.

Bewertung

Tech-Stack
csharp, sql
Bereich
cli, databases
Issue-Typ
Bug
Schwierigkeit
3/5
Geschätzter Aufwand
1-2 Tage
Aktivitätsstatus
Aktiv
Klarheit
Größtenteils klar
Anfängerfreundlichkeit
67/100

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.