Avoid maintaining lingering database requests in MQTT event handler #5489

	name: Backend

	on:
	push:
	branches:
	- main
	pull_request:
	branches:
	- main

	defaults:
	run:
	working-directory: backend

	jobs:
	build_backend:
	runs-on: ubuntu-latest
	steps:
	- name: Checkout
	uses: actions/checkout@v4

	- name: Set up .NET
	uses: actions/setup-dotnet@v4
	with:
	dotnet-version: "8.0.x"
	- name: Build project and dependencies
	run: dotnet build

	test_backend:
	runs-on: ubuntu-latest
	steps:
	- name: Checkout
	uses: actions/checkout@v4

	- name: Set up .NET
	uses: actions/setup-dotnet@v4
	with:
	dotnet-version: "8.0.x"

	- name: Build project and dependencies
	run: dotnet build -warnaserror

	- name: Run tests
	run: dotnet test

	check_formatting:
	runs-on: ubuntu-latest
	steps:
	- uses: actions/checkout@v4

	- name: Setup .NET Core
	uses: actions/setup-dotnet@v4
	with:
	dotnet-version: "8.0.x"

	# Dotnet format is included in the .NET8 SDK
	# By default, the task ensures the exit code is 0
	# If a file needs to be edited by dotnet format, the exit code will be a non-zero value
	# We are using severity level 'info' here.
	- name: Run dotnet format
	run: dotnet format --severity info --verbosity diagnostic --verify-no-changes --exclude ./api/migrations

	- name: Run csharpier format
	run: \|
	dotnet tool restore
	dotnet csharpier --check

Provide feedback