| 3090 | /* ── Node CRUD ──────────────────────────────────────────────────── */ |
| 3091 | |
| 3092 | int64_t cbm_store_upsert_node(cbm_store_t *s, const cbm_node_t *n) { |
| 3093 | sqlite3_stmt *stmt = |
| 3094 | prepare_cached(s, &s->stmt_upsert_node, |
| 3095 | "INSERT INTO nodes (project, label, name, qualified_name, file_path, " |
| 3096 | "start_line, end_line, properties) " |
| 3097 | "VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8) " |
| 3098 | "ON CONFLICT(project, qualified_name) DO UPDATE SET " |
| 3099 | "label=?2, name=?3, file_path=?5, start_line=?6, end_line=?7, properties=?8 " |
| 3100 | "RETURNING id;"); |
| 3101 | if (!stmt) { |
| 3102 | return CBM_STORE_ERR; |
| 3103 | } |
| 3104 | |
| 3105 | bind_text(stmt, SKIP_ONE, safe_str(n->project)); |
| 3106 | bind_text(stmt, ST_COL_2, safe_str(n->label)); |
| 3107 | bind_text(stmt, ST_COL_3, safe_str(n->name)); |
| 3108 | bind_text(stmt, ST_COL_4, safe_str(n->qualified_name)); |
| 3109 | bind_text(stmt, ST_COL_5, safe_str(n->file_path)); |
| 3110 | sqlite3_bind_int(stmt, ST_COL_6, n->start_line); |
| 3111 | sqlite3_bind_int(stmt, ST_COL_7, n->end_line); |
| 3112 | bind_text(stmt, ST_COL_8, safe_props(n->properties_json)); |
| 3113 | |
| 3114 | int rc = sqlite3_step(stmt); |
| 3115 | if (rc == SQLITE_ROW) { |
| 3116 | int64_t id = sqlite3_column_int64(stmt, 0); |
| 3117 | sqlite3_reset(stmt); /* unblock COMMIT — RETURNING leaves stmt active */ |
| 3118 | return id; |
| 3119 | } |
| 3120 | sqlite3_reset(stmt); |
| 3121 | store_set_error_sqlite(s, "upsert_node"); |
| 3122 | return CBM_STORE_ERR; |
| 3123 | } |
| 3124 | |
| 3125 | /* Scan a node from current row of stmt. Heap-allocates strings. */ |
| 3126 | static void scan_node(sqlite3_stmt *stmt, cbm_node_t *n) { |