Example #1
0
/*
 * 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;
}
Example #2
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;
};