Azure / Azure/azure-functions-sql-extension
Feature request: Sql trigger params
- Dominant language
- C#
- Stars
- 130
- Forks
- 71
- Avg merge
- 4d 8h
- Merged PRs (30d)
- 4
Description
When triggering via SQL, it would be awesome if you could allow the columns in the trigger to be used in the input binding, like it is done with HTTP trigger params.
Example
```
{
"bindings": [
{
"name": "changes",
"type": "sqlTrigger",
"direction": "in",
"tableName": "[dbo].[Products]",
"params": ["Cost"]
"connectionStringSetting": "AzureSQLConnectionString"
},
{
"name": "products",
"type": "sql",
"direction": "in",
"commandText": "select * from Products where Cost = @Cost",
"commandType": "Text",
"parameters": "@Cost={cost}",
"connectionStringSetting": "SqlConnectionString"
}
]
}
```
Contributor guide
Research direction
The issue names SQL trigger and SQL input bindings but no files or tests. Start by tracing those binding entry points and comparing the requested column-parameter behavior with HTTP trigger parameters; done means trigger columns can populate parameters such as {cost} for the SQL query, with coverage for the example.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, csharp, sql
- Domain
- backend, databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100