Data Inconsistency When Editing Task (Missing Transaction)

### Describe your issue

When editing a task using saveEditedTaskInDB() in task_database.dart, the task details and associated tags are updated using separate database operations without a single transaction.

This can lead to data inconsistency if the app crashes or an error occurs between the task update and tag update operations.

As a result:

Task fields (description, project, etc.) may update successfully
Tags may remain stale or partially updated

This violates atomicity and can reduce user trust in data integrity.****

### Steps to reproduce

Open the app and navigate to any existing task
Edit the task (change description and tags)
Trigger a failure between operations (e.g., force close app after task update but before tag update)
Restart the app and fetch the task

### What was the expected result?

_No response_

### Put here any screenshots or videos (optional)

_No response_

### How can we contact you (optional)

Task update and tag update should be atomic
Either both updates succeed, or none are applied
No partial or inconsistent state should exist
Actual behavior
Task is updated successfully
Tags remain unchanged or partially updated
Database enters inconsistent state
Root cause

In saveEditedTaskInDB():

await _database!.update('Tasks', {...});

if (newTags.isNotEmpty) {
TaskForC? task = await getTaskByUuid(uuid);
await setTagsForTask(uuid, task?.id ?? 0, newTags.toList());
}
Multiple DB operations are executed outside a transaction
setTagsForTask() internally uses a separate transaction
getTaskByUuid() reads using _database, not transaction context
Proposed fix

Wrap all operations in a single database transaction and avoid nested transactions:

await _database!.transaction((txn) async {
await txn.update(...);

final taskMaps = await txn.query(...);
final taskId = taskMaps.first['id'];

await txn.delete(...);

for (String tag in newTags) {
await txn.insert(...);
}
});
**Additional notes**
Avoid calling _database inside a transaction → use txn
Avoid nested transactions (setTagsForTask() should accept txn)
Consider enforcing PRAGMA foreign_keys = ON for relational integrity
**Impact**
Data inconsistency
Partial updates
Poor user experience
Suggested priority

High – affects core data integrity

### Would you like to work on this issue?

Yes

### By submitting this issue, I have confirmed that:

- [x] I have starred the repo ⭐ and watched 👀 it on GitHub and followed the contribution guidelines.

Beginne in task_database.dart bei saveEditedTaskInDB() und sieh dir anschließend setTagsForTask() und getTaskByUuid() an, um die aktuellen Datenbankgrenzen zu verstehen. Reproduziere eine Bearbeitung, die Aufgabenfelder und Tags umfasst, einschließlich einer Unterbrechung zwischen den Vorgängen. Als erledigt gilt die Aufgabe, wenn Änderungen an Aufgabe und Tags gemeinsam erfolgreich sind oder keine von ihnen persistiert wird, ohne verschachtelten oder außerhalb der Transaktion erfolgenden Datenbankzugriff.

Vom Indexierungsmodell aus dem Issue-Text verfasst.