ScrollableCursor.cpp

/*
 * MIT License
 *
 * Copyright (c) 2026 F.D.Castel
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
 * SOFTWARE.
 */

#include "TestUtil.h"
#include "fb-cpp/Statement.h"
#include "fb-cpp/Transaction.h"


BOOST_AUTO_TEST_SUITE(ScrollableCursorSuite)

BOOST_AUTO_TEST_CASE(defaultCursorTypeIsForwardOnly)
{
	StatementOptions options;
	BOOST_CHECK(options.getCursorType() == CursorType::FORWARD_ONLY);
}

BOOST_AUTO_TEST_CASE(scrollableCursorSupportsFetchMethods)
{
	const auto database = getTempFile("ScrollableCursor-fetchMethods.fdb");

	Attachment attachment{CLIENT, database, AttachmentOptions().setCreateDatabase(true).setForcedWrites(false)};
	FbDropDatabase attachmentDrop{attachment};

	Transaction transaction{attachment};

	Statement ddl{attachment, transaction, "create table t (col integer)"};
	(void) ddl.execute(transaction);
	transaction.commitRetaining();

	Statement insert{attachment, transaction, "insert into t (col) values (?)"};
	for (int i = 1; i <= 5; ++i)
	{
		insert.setInt32(0, i);
		(void) insert.execute(transaction);
	}

	Statement select{attachment, transaction, "select col from t order by col",
		StatementOptions().setCursorType(CursorType::SCROLLABLE)};
	BOOST_REQUIRE(select.execute(transaction));
	BOOST_CHECK_EQUAL(select.getInt32(0).value(), 1);

	// fetchNext
	BOOST_REQUIRE(select.fetchNext());
	BOOST_CHECK_EQUAL(select.getInt32(0).value(), 2);

	// fetchFirst
	BOOST_REQUIRE(select.fetchFirst());
	BOOST_CHECK_EQUAL(select.getInt32(0).value(), 1);

	// fetchLast
	BOOST_REQUIRE(select.fetchLast());
	BOOST_CHECK_EQUAL(select.getInt32(0).value(), 5);

	// fetchPrior
	BOOST_REQUIRE(select.fetchPrior());
	BOOST_CHECK_EQUAL(select.getInt32(0).value(), 4);

	// fetchAbsolute
	BOOST_REQUIRE(select.fetchAbsolute(3));
	BOOST_CHECK_EQUAL(select.getInt32(0).value(), 3);

	// fetchRelative
	BOOST_REQUIRE(select.fetchRelative(2));
	BOOST_CHECK_EQUAL(select.getInt32(0).value(), 5);

	BOOST_REQUIRE(select.fetchRelative(-1));
	BOOST_CHECK_EQUAL(select.getInt32(0).value(), 4);
}

BOOST_AUTO_TEST_SUITE_END()