From 6c5bea4d45d158e9e793a9409b23be05a5dfb144 Mon Sep 17 00:00:00 2001
From: Olaf Wintermann <olaf.wintermann@gmail.com>
Date: Mon, 2 Jun 2025 19:07:02 +0200
Subject: [PATCH] order noteobooks by position

---
 application/store.c | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/application/store.c b/application/store.c
index 6f2f231..c70071a 100644
--- a/application/store.c
+++ b/application/store.c
@@ -55,7 +55,7 @@
     ")\n" \
     "select n.*, r.resource_id as [__resources__resource_id], r.* from cols r\n" \
     "left join notebooks n on r.resource_id = n.resource_id\n" \
-    "order by path;"
+    "order by depth, position;"
 
 #define SQL_NOTEBOOK_GET_NOTES \
     "select n.*, r.resource_id as [__resources__resource_id], r.parent_id, " \
@@ -799,6 +799,8 @@ typedef struct CreateNotebookJob {
 } CreateNotebookJob;
 
 static int qthr_new_notebook(CreateNotebookJob *job) {
+    // TODO: maybe use transactions
+    
     DBUQuery *q = connection->createQuery(connection, NULL);
     dbuQuerySetSQL(q, SQL_NOTEBOOK_RES_NEW);
     dbuQuerySetParamInt64(q, 1, job->resource->parent_id);
-- 
2.43.5