TestAtTableInTheOutput.cc

Go to the documentation of this file.

/*
 * (C) Copyright 1996-2012 ECMWF.
 * 
 * This software is licensed under the terms of the Apache Licence Version 2.0
 * which can be obtained at http://www.apache.org/licenses/LICENSE-2.0. 
 * In applying this licence, ECMWF does not waive the privileges and immunities 
 * granted to it by virtue of its status as an intergovernmental organisation nor
 * does it submit to any jurisdiction.
 */
 
/// \file TestAtTableInTheOutput.h
///
/// @author Piotr Kuchta, ECMWF, Feb 2009
 
#include "odc/Comparator.h"
#include "odc/core/MetaData.h"
#include "odc/Select.h"
#include "odc/Reader.h"
 
#include "odc/Writer.h"
#include "TestCase.h"
 
using namespace std;
using namespace eckit;
using namespace odc;
 
static void setUp()
{
    odc::Writer<> f("TestAtTableInTheOutput_A.odb");
    odc::Writer<>::iterator it = f.begin();
 
    it->setNumberOfColumns(4);
    it->setColumn(0, "lat@hdr", odc::api::REAL);
    it->setColumn(1, "lon@hdr", odc::api::REAL);
    it->setColumn(2, "obsvalue", odc::api::REAL);
 
    eckit::sql::BitfieldDef bfDef;
    bfDef.first.push_back("x");
    bfDef.second.push_back(1);
    bfDef.first.push_back("y");
    bfDef.second.push_back(2);
 
    it->setBitfieldColumn(3, "bf", odc::api::BITFIELD, bfDef);
 
    it->writeHeader();
 
    for (size_t i = 1; i <= 2; i++)
    {
        (*it)[0] = i; // col 0
        (*it)[1] = i; // col 1
        (*it)[2] = i; // col 2
        ++it;
    }
}
 
static void selectIntoSecondFile()
{
    const string fileName = "TestAtTableInTheOutput_A.odb";
    string sql = "select lat,lon,obsvalue,bf into \"TestAtTableInTheOutput_B.odb\"";
    sql += " from \"" + fileName + "\" ;";
 
    odc::Select f(sql); //, fileName);
    odc::Select::iterator it = f.begin();
 
    //string c0 = it.columns()[0]->name();
    //string c1 = it.columns()[1]->name();
    //string c2 = it.columns()[2]->name();
 
    ++it; // this is needed to push the second row to the INTO file 
 
    //Log::info()  << "c0=" << c0 << ", c1=" << c1 << ", c2=" << c2 << std::endl;
    ///ASSERT("");
}
 
static void compareFiles()
{
    odc::Reader oda1("TestAtTableInTheOutput_A.odb");
    odc::Reader oda2("TestAtTableInTheOutput_B.odb");
 
    odc::Reader::iterator it1(oda1.begin());
    odc::Reader::iterator end1(oda1.end());
    odc::Reader::iterator it2(oda2.begin());
    odc::Reader::iterator end2(oda2.end());
    
    odc::Comparator().compare(it1, end1, it2, end2, "TestAtTableInTheOutput_A.odb", "TestAtTableInTheOutput_B.odb");
}
 
 
static void test()
{
    selectIntoSecondFile();
    compareFiles();
}
 
 
 
static void tearDown(){}
 
SIMPLE_TEST(AtTableInTheOutput)