/* * Update a row in table */ int bdb_update(db_con_t* _h, db_key_t* _k, db_op_t* _o, db_val_t* _v, db_key_t* _uk, db_val_t* _uv, int _n, int _un) { bdb_srow_p s_r; /* search keys row */ bdb_urow_p u_r; /* update row */ int ret; s_r = NULL; u_r = NULL; if ((ret = bdb_srow_db2bdb(_h, _k, _o, _v, _n, &s_r)) < 0) { return -1; }; if ((ret = bdb_urow_db2bdb(_h, _uk, _uv, _un, &u_r)) < 0) { bdb_free_srow(s_r); return -1; }; if ((ret = bdb_update_table(_h, s_r, u_r)) < 0) { bdb_free_urow(u_r); bdb_free_srow(s_r); return -1; }; bdb_free_urow(u_r); bdb_free_srow(s_r); return 0; }
int bdb_urow_db2bdb(db_con_t* _h, db_key_t* _k, db_val_t* _v, int _n, bdb_urow_p *_r) { bdb_urow_p r; bdb_table_p t; bdb_column_p c; int found, found_key; int i, j; int c_idx; bdb_uval_p v; *_r = NULL; if (_n <= 0) { #ifdef BDB_EXTRA_DEBUG LOG(L_ERR, "BDB:bdb_urow_db2bdb: no defined keys to be updated\n"); #endif return -1; } if ((t = bdb_find_table(CON_TABLE(_h))) == NULL) { #ifdef BDB_EXTRA_DEBUG LOG(L_ERR, "BDB:bdb_urow_db2bdb: no table in use\n"); #endif return -1; }; /* check for dublicates in update set */ for (i = 1; i < _n; i++) { for (j = 0; j < i; j++) { if (!strcmp(_k[i], _k[j])) { #ifdef BDB_EXTRA_DEBUG LOG(L_ERR, "BDB:bdb_urow_db2bdb: dublicates keys in update set: '%s' and '%s'\n", _k[i], _k[j]); #endif return -1; } } } /* check if all columns exist */ for (i = 0; i < _n; i++) { found = 0; /* key column is always first one */ for (c = t->cols, found_key = 1; c != NULL; c = c->next, found_key = 0) { if (!strcmp(_k[i], c->name.s)) { found = 1; break; } } if (found_key == 1) { LOG(L_ERR, "BDB:bdb_urow_db2bdb: unable to update primary key value\n"); return -1; } if (!found) { LOG(L_ERR, "BDB:bdb_urow_db2bdb: column '%s' does not exist\n", _k[i]); return -1; } } r = pkg_malloc(sizeof(*r)); memset(r, 0, sizeof(*r)); /* filling data into row */ for (c = t->cols, c_idx = 0; c != NULL; c = c->next, c_idx++) { for (i = 0; i < _n; i++) { if (!strcmp(_k[i], c->name.s)) { #ifdef BDB_EXTRA_DEBUG LOG(L_NOTICE, "BDB:bdb_urow_db2bdb: filling column '%.*s', c_idx = %0d\n", c->name.len, c->name.s, c_idx); #endif v = pkg_malloc(sizeof(*v)); memset(v, 0, sizeof(*v)); v->c_idx = c_idx; bdb_push_ufield(r, v); if (bdb_ufield_db2bdb(v, &_v[i]) < 0) { bdb_free_urow(r); return -1; }; } } }; *_r = r; return 0; };