Method load_db_hosts

lib_acl_cpp/app/ndb/ctl_server/db_ctl.cpp:410–458

}

int db_ctl::load_db_hosts(void)
{
	const char* sql = "select id_db, id_idx_host, count from tbl_db_host";
	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_db_host empty");
		return 0;
	}

	unsigned int id_db, id_idx_host;
	acl_int64 count;

	size_t i;
	for (i = 0; i < rows->size(); i++)
	{
		const acl::db_row* row = (*rows)[i];
		if ((id_db = row->field_int("id_db", -1)) == (unsigned int) -1)
		{
			logger_warn("id_db(-1) invalid");
			continue;
		}
		else if ((id_idx_host = row->field_int("id_idx_host", -1))
			== (unsigned int) -1)
		{
			logger_warn("id_idx_host invalid");
			continue;
		}
		else if ((count = row->field_int64("count", -1)) == -1)
		{
			logger_warn("count invalid");
			continue;
		}
		DB_HOST* host = (DB_HOST*) acl_mymalloc(sizeof(DB_HOST));
		host->id_db = id_db;
		host->id_idx_host = id_idx_host;
		host->count = count;
		db_hosts_.push_back(host);
	}

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

int db_ctl::load_db_tbls(void)
{