From b1956aa73a533702ccbc3d7713ea90dd5ae44b9b Mon Sep 17 00:00:00 2001 From: Anders Betts Date: Mon, 21 Sep 2026 09:47:50 +0200 Subject: commands: db_row_json and db_exec_bound helpers Co-Authored-By: Claude Opus 5 --- src/cmd_customers.c | 33 ++++----------------------------- 1 file changed, 4 insertions(+), 29 deletions(-) (limited to 'src/cmd_customers.c') diff --git a/src/cmd_customers.c b/src/cmd_customers.c index d259a8e..b90b87f 100644 --- a/src/cmd_customers.c +++ b/src/cmd_customers.c @@ -19,35 +19,10 @@ static yyjson_mut_val *customer_json(struct req *r, sqlite3_stmt *st) { - yyjson_mut_val *o = yyjson_mut_obj(r->rdoc); - yyjson_mut_obj_add_int(r->rdoc, o, "id", sqlite3_column_int64(st, 0)); - yyjson_mut_obj_add_strcpy(r->rdoc, o, "name", - sq(sqlite3_column_text(st, 1))); - yyjson_mut_obj_add_strcpy(r->rdoc, o, "address", - sq(sqlite3_column_text(st, 2))); - yyjson_mut_obj_add_strcpy(r->rdoc, o, "postal_code", - sq(sqlite3_column_text(st, 3))); - yyjson_mut_obj_add_strcpy(r->rdoc, o, "city", - sq(sqlite3_column_text(st, 4))); - yyjson_mut_obj_add_strcpy(r->rdoc, o, "country", - sq(sqlite3_column_text(st, 5))); - yyjson_mut_obj_add_strcpy(r->rdoc, o, "vat_nr", - sq(sqlite3_column_text(st, 6))); - yyjson_mut_obj_add_strcpy(r->rdoc, o, "email", - sq(sqlite3_column_text(st, 7))); - yyjson_mut_obj_add_strcpy(r->rdoc, o, "your_ref", - sq(sqlite3_column_text(st, 8))); - yyjson_mut_obj_add_int(r->rdoc, o, "payment_days", - sqlite3_column_int64(st, 9)); - yyjson_mut_obj_add_strcpy(r->rdoc, o, "notes", - sq(sqlite3_column_text(st, 10))); - yyjson_mut_obj_add_bool(r->rdoc, o, "active", - sqlite3_column_int(st, 11) != 0); - yyjson_mut_obj_add_strcpy(r->rdoc, o, "created_at", - sq(sqlite3_column_text(st, 12))); - yyjson_mut_obj_add_strcpy(r->rdoc, o, "updated_at", - sq(sqlite3_column_text(st, 13))); - return o; + return db_row_json(r->rdoc, st, + "id:i,name:s,address:s,postal_code:s,city:s,country:s," + "vat_nr:s,email:s,your_ref:s,payment_days:i,notes:s," + "active:b,created_at:s,updated_at:s"); } struct customer_input { -- cgit v1.3