admin管理员组文章数量:1122826
Trying to set up our first Static Web App in Azure, connecting it to our SQL Server in Azure, but struggling to get off the ground. When I add the "Database Connection (preview)" environment, it says
The database connection configuration file is missing from your repository.
In the Azure portal, we have 3 resources: SQL server, SQL database, and Static Web App.
I've created a dab-config.json, a SWA-4.database.config.json, and a staticwebapp.database.config.json. All 3 files are in my GitHub repository's root level. 3, because it's unclear to my untrained brain if the file prefix needs to match my Static Web App name, if it should just be staticwebapp., or if it should be dab-config.
All 3 JSON files have the same content
{
"$schema": ".2.14/dab.draft.schema.json",
"data-source": {
"database-type": "mssql",
"connection-string": "Server=tcp:REMOVED,1433;Initial Catalog=REMOVED;Persist Security Info=False;User ID=REMOVED;Password=REMOVED;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;",
"options": {
"set-session-context": false
}
},
"runtime": {
"rest": {
"enabled": true,
"path": "/api",
"request-body-strict": true
},
"graphql": {
"enabled": true,
"path": "/graphql",
"allow-introspection": true
},
"host": {
"cors": {
"origins": [],
"allow-credentials": false
},
"authentication": {
"provider": "StaticWebApps"
},
"mode": "production"
}
},
"entities": {
........ continued ..............
When I look at my GitHub Actions… one of the Static Web Apps workflows is successful, but the other two, Update dab-config.json and "ci: add Azure Static Web Apps workflow file" both give the same error
The content server has rejected the request with: BadRequest. Reason: No matching Static Web App was found or the api key was invalid."
Index.html
<html>
<head>
<meta http-equiv="Content-Security-Policy" content="default-src 'self'; script-src 'self' 'unsafe-inline'">
<script src="/script.js"></script>
</head>
<button id="list" onclick="list()">List</button>
</html>
script.js
async function list() {
const response = await fetch('/data-api/rest/VirtuousAI_Matches');
const data = await response.json();
console.table(data.value);
}
At this point I'm completely unsure of which step I've messed up. Any help is appreciated
Trying to set up our first Static Web App in Azure, connecting it to our SQL Server in Azure, but struggling to get off the ground. When I add the "Database Connection (preview)" environment, it says
The database connection configuration file is missing from your repository.
In the Azure portal, we have 3 resources: SQL server, SQL database, and Static Web App.
I've created a dab-config.json, a SWA-4.database.config.json, and a staticwebapp.database.config.json. All 3 files are in my GitHub repository's root level. 3, because it's unclear to my untrained brain if the file prefix needs to match my Static Web App name, if it should just be staticwebapp., or if it should be dab-config.
All 3 JSON files have the same content
{
"$schema": "https://github.com/Azure/data-api-builder/releases/download/v1.2.14/dab.draft.schema.json",
"data-source": {
"database-type": "mssql",
"connection-string": "Server=tcp:REMOVED,1433;Initial Catalog=REMOVED;Persist Security Info=False;User ID=REMOVED;Password=REMOVED;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;",
"options": {
"set-session-context": false
}
},
"runtime": {
"rest": {
"enabled": true,
"path": "/api",
"request-body-strict": true
},
"graphql": {
"enabled": true,
"path": "/graphql",
"allow-introspection": true
},
"host": {
"cors": {
"origins": [],
"allow-credentials": false
},
"authentication": {
"provider": "StaticWebApps"
},
"mode": "production"
}
},
"entities": {
........ continued ..............
When I look at my GitHub Actions… one of the Static Web Apps workflows is successful, but the other two, Update dab-config.json and "ci: add Azure Static Web Apps workflow file" both give the same error
The content server has rejected the request with: BadRequest. Reason: No matching Static Web App was found or the api key was invalid."
Index.html
<html>
<head>
<meta http-equiv="Content-Security-Policy" content="default-src 'self'; script-src 'self' 'unsafe-inline'">
<script src="/script.js"></script>
</head>
<button id="list" onclick="list()">List</button>
</html>
script.js
async function list() {
const response = await fetch('/data-api/rest/VirtuousAI_Matches');
const data = await response.json();
console.table(data.value);
}
At this point I'm completely unsure of which step I've messed up. Any help is appreciated
Share Improve this question edited Nov 27, 2024 at 14:09 adam asked Nov 21, 2024 at 16:26 adamadam 2,9708 gold badges56 silver badges89 bronze badges 4 |1 Answer
Reset to default 0Below are steps to Publish Azure Static Web Apps with Data API Builder.After writing code for list, get, update, create, and delete in index.html, use the following:
<button id="list" onclick="list()">List</button>
async function list() {
const response = await fetch('/data-api/rest/Person');
const data = await response.json();
console.table(data.value);
}
In cmd install the Static Web Apps CLI using the command:
npm install -g @azure/static-web-apps-cli .
I referred to this documentation for connecting to a database with Azure Static Web Apps.
Then use the command swa db init --database-type mssql to initialize a database connection for your Azure Static Web App project with a Microsoft SQL Server database.
Open the staticwebapp.database.config.json file and add the following content:
{
"$schema": "https://github.com/Azure/data-api-builder/releases/latest/download/dab.draft.schema.json",
"data-source": {
"database-type": "mssql",
"options": {
"set-session-context": false
},
"connection-string": "Server=tcp:<your_server>.database.windows.net,1433;Database=<your_db>;User ID=<your_user>;Password=<your_password>;Encrypt=true;"
},
"runtime": {
"rest": {
"enabled": true,
"path": "/rest"
},
"graphql": {
"allow-introspection": true,
"enabled": true,
"path": "/graphql"
},
"host": {
"mode": "production",
"cors": {
"origins": ["*"],
"allow-credentials": false
},
"authentication": {
"provider": "StaticWebApps"
}
}
},
"entities": {
"Person": {
"source": "dbo.MyTestPersonTable",
"permissions": [
{
"actions": ["*"],
"role": "anonymous"
}
]
}
}
}
I referred to thislink for configuring Azure Static Web Apps and this documentation for swa-cli.config.json.
Use the command swa init to create a swa-cli.config.json file like the following:
{
"$schema": "https://aka.ms/azure/static-web-apps-cli/schema",
"configurations": {
"new-folder-(6)": {
"appLocation": "scr\\public",
"outputLocation": ".",
"dataApiLocation": "swa-db-connections",
"appDevserverUrl": "http://localhost:4280"
}
}
}
- Create
staticwebapp.config.jsonin the main and addstaticwebapp.config.jsonwith the following content:
{
"navigationFallback": {
"rewrite": "/index.html",
"exclude": [
"/api/*",
"/static/*"
]
},
"routes": [
{
"route": "/api/*",
"allowedRoles": ["authenticated"]
},
{
"route": "/admin",
"allowedRoles": ["admin"]
},
{
"route": "/",
"rewrite": "/index.html"
},
{
"route": "/static/*",
"headers": {
"cache-control": "max-age=31536000"
}
}
],
"responseOverrides": {
"404": {
"rewrite": "/404.html"
},
"403": {
"rewrite": "/403.html"
}
},
"globalHeaders": {
"X-Content-Type-Options": "nosniff",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains; preload",
"Content-Security-Policy": "default-src 'self'; script-src 'self'; style-src 'self'; img-src 'self' data:; connect-src 'self'; frame-src 'none';"
},
"platform": {
"apiRuntime": "node:18"
},
"networking": {
"allowedIpRanges": [
"0.0.0.0/0"
]
}
}
Create the dbo.MyTestPersonTable in Azure SQL .Allow public network access and allow azure service and sevices to acess the service. Then Start the app locally using:
swa start ./scr/public --data-api-location swa-db-connections
If you encounter firewall issues during swa start, add the necessary firewall rules in SQL Server.
Push the code, .env, staticwebapp.config.json, swa-cli.config.json, and staticwebapp.database.config.json to GitHub.
Modify the GitHub YAML configuration file as follows, replace app_location according to your folder structure:
app_location: "./scr/public"
api_location: ""
output_location: "."
Go to the Database connection in Static Web Apps => link the existing database, and view the app in the browser. Output:
本文标签： sql serverPublish new Azure Static Web Apps from Data API BuilderStack Overflow
版权声明：本文标题：sql server - Publish new Azure Static Web Apps from Data API Builder - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736308945a1933840.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
staticwebapp.database.config.json– Sampath Commented Nov 22, 2024 at 3:40swa db init --database-type mssqlin local and usedab add Item -c "staticwebapp.database.config.json" --source dbo.ShoppingItems --permissions "anonymous:*". SO you see Data API will be accessed via<WEB APP URL>/data-api/rest/<ENTITY>– Sampath Commented Nov 22, 2024 at 3:51staticwebapp.database.config.jsonconfiguration. – Sampath Commented Nov 22, 2024 at 3:58