Method load_tbl_idxes

lib_acl_cpp/app/ndb/ctl_server/db_ctl.cpp:506–565

}

int db_ctl::load_tbl_idxes(void)
{
	const char* sql = "select id_idx, id_db, id_tbl, unique, type from tbl_tbl_idx";
	if ((ctl_conn_->sql_select(sql)) == false)
	{
		logger_error("sql(%s) error", sql);
		return -1;
	}

	const std::vector<acl::db_row*>* rows = ctl_conn_->get_rows();
	if (rows == NULL)
	{
		logger_warn("tbl_tbl_idx empty");
		return 0;
	}

	unsigned int id_idx, id_db, id_tbl, unique, type;

	size_t i;
	for (i = 0; i < rows->size(); i++)
	{
		const acl::db_row* row = (*rows)[i];
		if ((id_idx = row->field_int("id_idx", -1)) ==
			(unsigned int) -1)
		{
			logger_warn("id_idx invalid");
			continue;
		}
		else if ((id_db = row->field_int("id_db", -1)) ==
			(unsigned int) -1)
		{
			logger_warn("id_db invalid");
			continue;
		}
		else if ((id_tbl = row->field_int("id_tbl", -1)) ==
			(unsigned int) -1)
		{
			logger_warn("id_tbl invalid");
			continue;
		}
		type = row->field_int("type", -1);
		if (type < IDX_TYPE_STR || type > IDX_TYPE_INT64)
		{
			logger_warn("type(%d) invalid", type);
			continue;
		}

		unique = row->field_int("unique");
		TBL_IDX* idx = (TBL_IDX*) acl_mymalloc(sizeof(TBL_IDX));
		idx->id_idx = id_idx;
		idx->id_db = id_db;
		idx->id_tbl = id_tbl;
		idx->unique = unique ? true : false;
		idx->type = (idx_type_t) type;
		tbl_idxes_.push_back(idx);
	}

	ctl_conn_->free_result();