// SelectQuery_t.cxx

#include "dataset_sql/SelectQuery.h"
#include <string>
#include <iostream>

using std::string;
using std::cout;
using std::endl;

using dset::SelectQuery;

// Display messsage.
void msg(string txt) {
  cout << "--- " << txt << " ---" << endl;
}

int SelectQuery_t() {
  msg("BEGIN TESTING SelectQuery");
  SelectQuery query;
  
  msg("Testing is_valid");
  assert( query.is_valid() == true );

  msg("Testing set Sql query");
  query.set("id,numevents,ami","numevents < 2000");

  msg("Testing get_columns");
  cout << query.get_columns() << endl;

  msg("Testing get_constraint");
  cout << query.get_constraint() << endl;

  msg("Testing Reset");
  query.reset();
  assert( query.get_constraint() == "" );
  assert( query.get_columns() == "" );

  msg("Testing AND constraint to Sql query");
  const string constraint1 = "numevents>3000";
  const string constraint2 = "aminame LIKE '%higgs%'"; 
  query.andconstraint(constraint1).andconstraint(constraint2); 
  cout << query.get_constraint() << endl;

  msg("Testing OR constraint to Sql query");
  const string constraint3 = "aminame LIKE '%gamma%'";
  query.orconstraint(constraint3);
  cout << query.get_constraint() << endl;

  msg("End testing SelectQuery");
  return 0;
}

#ifdef CTEST_MAIN
int main() {
  return SelectQuery_t();
}
#endif