test_select.cc

#include "Bruinbase.h"
#include "SqlEngine.h"
#include "string.h"
#include "stdio.h"
using namespace std;

int main(){
	RC rc;

	rc = SqlEngine::load("xsmall","xsmall.del", false);
	//rc = SqlEngine::load("small","small.del", true);
	//rc = SqlEngine::load("medium","medium.del", true);
	//rc = SqlEngine::load("large","large.del", true);
	//rc = SqlEngine::load("xlarge","xlarge.del", true);

	//if(rc < 0)
	//	printf("there is an error in LOAD\n");
	
	SelCond a;
	a.attr = 1;
	a.comp = SelCond::LT;
	string a_value = "2500";
	a.value = (char*)a_value.c_str();

	SelCond b;
	b.attr = 1;
	b.comp = SelCond::LT;
	string b_value = "500";
	b.value = (char*)b_value.c_str();
	
	SelCond c;
	c.attr = 1;
	c.comp = SelCond::GT;
	string c_value = "100";
	c.value = (char*)c_value.c_str();

	SelCond d;
	d.attr = 1;
	d.comp = SelCond::LT;
	string d_value = "400000";
	d.value = (char*)d_value.c_str();
	
	std::vector<SelCond> cond;
	
	cond.push_back(a);
	//cond.push_back(b);
	//cond.push_back(c);
	//cond.push_back(d);

	//SqlEngine::select(3, "xlarge", cond);
	SqlEngine::select(3, "xsmall", cond);
	
	return 0;
}