/www/proggenOrg/dedupe/export/trunk/test/unittest/testsqlitewrapper.cpp

Go to the documentation of this file.

#include "testsqlitewrapper.h"

Dedupe::Test::TSqliteWrapperFixture::TSqliteWrapperFixture() :
Wrapper( ":memory:")
{
  Wrapper.SqlExec(
  "CREATE TABLE IF NOT EXISTS testtable (Nr integer, Name varchar(20));" );

  Wrapper.SqlExec(
  "INSERT INTO testtable (Nr, Name) VALUES (1,'Teststring');" );

  Wrapper.SqlExec(
  "INSERT INTO testtable (Nr, Name) VALUES (89,'one more string');" );
}

BOOST_FIXTURE_TEST_SUITE( TSqliteWrapper, Dedupe::Test::TSqliteWrapperFixture )

  BOOST_AUTO_TEST_CASE( TSqlExec )
  {
    BOOST_CHECK_NO_THROW( Wrapper.SqlExec( "SELECT * FROM testtable;" ) );
    BOOST_CHECK_THROW(
           Wrapper.SqlExec( "SadkT * FROM testtable;" ), std::runtime_error );

    Wrapper.FreeResult();
  }

  BOOST_AUTO_TEST_CASE( TGetTableData )
  {
    Dedupe::Dataholding::SqliteWrapper::Row ReturningRow;
    std::string actual, expected = "Teststring";

    //Check if only one tablerow is returning
    Wrapper.SqlExec( "SELECT Name FROM testtable WHERE Nr=1;" );
    BOOST_CHECK_EQUAL(1u, Wrapper.GetTabledata().size() );

    //check if the correct value is selected
    ReturningRow = Wrapper.GetTabledata()[ 0 ];

    actual = ReturningRow[ "Name" ];
    BOOST_CHECK_EQUAL( expected, actual );

    //Check if the result is deleted
    Wrapper.FreeResult();
    BOOST_CHECK_EQUAL( Wrapper.GetTabledata().size() , 0u );
  }

BOOST_AUTO_TEST_SUITE_END()