Method load_dat_hosts

lib_acl_cpp/app/ndb/ctl_server/db_ctl.cpp:361–408

}

int db_ctl::load_dat_hosts(void)
{
	const char* sql = "select id, addr, count, priority from tbl_host_dat";
	if (ctl_conn_->sql_select(sql) == false)
	{
		logger_error("sql(%s) invalid", sql);
		return -1;
	}

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

	unsigned int id;
	const char* addr;
	acl_int64 count;
	int   priority;

	size_t i;
	for (i = 0; i < rows->size(); i++)
	{
		const acl::db_row* row = (*rows)[i];
		if ((id = row->field_int("id", -1)) == (unsigned int) -1)
		{
			logger_warn("id(-1) invalid");
			continue;
		}
		else if ((addr = row->field_string("addr")) == NULL)
		{
			logger_warn("addr null");
			continue;
		}
		else if ((count = row->field_int64("count", -1)) == -1)
		{
			logger_warn("count(-1) invalid");
			continue;
		}
		priority = row->field_int("priority", 0);
		dat_host* host = new dat_host(id, addr, count, priority);
		dat_hosts_.push_back(host);
	}

	ctl_conn_->free_result();
	return (int) i;
}

int db_ctl::load_db_hosts(void)
{