int main(int argc, const char * argv[])
{
RecordManager recordManager;
// must initialize
recordManager.Initialize();
// Table structure definition
Table InsT;
Attribute a;
InsT.attrNumber = 4;
a.attrName = "uuid";
a.dataType = Uuid;
a.attrType = 1;
InsT.attributes.push_back(a);
a.attrName = "att1";
a.dataType = Int;
a.indexName = "null";
InsT.attributes.push_back(a);
a.attrName = "att2";
a.dataType = Int;
a.indexName = "null";
InsT.attributes.push_back(a);
a.attrName = "att3";
a.dataType = String;
a.dataLength = 5;
a.indexName = "null";
InsT.attributes.push_back(a);
InsT.tableName = "table_test";
InsT.recordNum = 0;
InsT.tableNum = 1;
Record *rec = new Record;
UUID *uuid = new UUID(1);
int *aaa = new int(255);
int *bbb = new int(0xabcd);
string *str = new string("wxyz");
rec->data.push_back(static_cast<void *>(uuid));
rec->data.push_back(static_cast<void *>(aaa));
rec->data.push_back(static_cast<void *>(bbb));
rec->data.push_back(static_cast<void *>(str));
rec->next = NULL;
// create a table
recordManager.CreateTable(&InsT);
// must load tables
recordManager.LoadTable(&InsT);
uint T = InsT.tableNum;
#define N 4
int t;
// insert record
// let's do a stress testing
for (int i=0; i<N; i++) {
recordManager.NewQuery();
recordManager.AppendValue(i);
recordManager.AppendValue(0xab);
recordManager.AppendValue("ops");
//recordManager.ChooseTable(T); // NOTE: optional
recordManager.InsertRecord(T);
InsT.recordNum++;
}
cout<<"insert done "<<endl;
cin>>t;
// recordManager.NewQuery();
// recordManager.ChooseTable(T); // NOTE: choose is mandatory for selection
//
// recordManager.PushLogicOp("(");
// recordManager.PushCondition(T, 1, Equal, 10);
// recordManager.PushLogicOp("or");
// recordManager.PushCondition(T, 1, Greater, 11);
// recordManager.PushLogicOp(")");
// recordManager.PushLogicOp("and");
// recordManager.PushLogicOp("(");
// recordManager.PushCondition(T, 1, Less, 11);
// recordManager.PushLogicOp("or");
// recordManager.PushCondition(T, 1, Equal, 11);
// recordManager.PushLogicOp(")");
// recordManager.SelectRecord();
recordManager.NewQuery();
recordManager.ChooseTable(T); // NOTE: choose is mandatory for selection
recordManager.PushCondition(T, 1, Equal, 2);
recordManager.PushLogicOp("or");
recordManager.PushCondition(T, 3, Equal, "ying");
vector<vector<Record*>> results;
results = recordManager.SelectRecord();
cout<<"select done, results:"<<endl;
for (int i=0; i<results.at(0).size(); i++) {
cout<<*((UUID*)results.at(0).at(i)->data.at(0))<<"\t";
}
cin>>t;
for (int i=10000; i<10002; i++) {
// delete record
recordManager.NewQuery();
//recordManager.ChooseTable(T);
recordManager.PushCondition(T, 0, Equal, i);
recordManager.DeleteRecord(T);
// should be updated in the catalog
InsT.recordNum--;
}
cout<<"delete done "<<endl;
cin>>t;
// select * from T
recordManager.NewQuery();
recordManager.ChooseTable(T);
results = recordManager.SelectRecord();
// cout<<"select * done, results:"<<endl;
// for (int i=0; i<results.at(0).size(); i++) {
// cout<<*((UUID*)results.at(0).at(i)->data.at(0))<<"\t";
// }
// cin>>t;
// drop a table
//recordManager.DropTable(&InsT);
// must call when quit
recordManager.OnQuit();
return 0;
// TODO merge select and add select from no where
#if TEST
recordManager.root = new Record;
recordManager.root->next = NULL;
recordManager.lastRecord = recordManager.root;
#endif
struct Table tableStruct;
{
tableStruct.tableName = "test";
tableStruct.attrNumber = 1;
tableStruct.recordNum = 0;
tableStruct.tableNum = 0;
vector<Attribute> attributes;
struct Attribute attr;
// attr.attrName = "id";
// attr.dataType = String;
// attr.dataLength = 10;
// attr.attrType = 0;
// attr.indexName = "null";
// attributes.push_back(attr);
attr.attrName = "num";
attr.dataType = Int;
attr.dataLength = 8;
attr.attrType = 0;
attr.indexName = "null";
attributes.push_back(attr);
// attr.attrName = "name";
// attr.dataType = String;
// attr.dataLength = 5;
// attr.attrType = 0;
// attr.indexName = "null";
// attributes.push_back(attr);
tableStruct.attributes = attributes;
}
// uint T = tableStruct.tableNum;
string id = "qwerty12";
int num = 10;
string name = "abcde";
recordManager.NewQuery();
//recordManager.AppendValue(id);
recordManager.AppendValue(num);
//recordManager.AppendValue(name);
//recordManager.ChooseTable(T);
recordManager.InsertRecord(T);
return 0;
num = 11;
recordManager.NewQuery();
//recordManager.AppendValue(id);
recordManager.AppendValue(num);
//recordManager.AppendValue(name);
//recordManager.ChooseTable(T);
recordManager.InsertRecord(T);
num = 12;
recordManager.NewQuery();
//recordManager.AppendValue(id);
recordManager.AppendValue(num);
//recordManager.AppendValue(name);
//recordManager.ChooseTable(T);
recordManager.InsertRecord(T);
#if TEST
recordManager.PrintRecord(T);
#endif
//recordManager.PrintSingle(recordManager.GetRecord(0, 0));
recordManager.OnQuit();
return 0;
/* no longer used test codes
uint T = 0;
vector<DataType> dataT;
dataT.push_back(String);
dataT.push_back(Int);
dataT.push_back(String);
vector<bool> isIndexBuilt;
isIndexBuilt.push_back(true);
isIndexBuilt.push_back(false);
isIndexBuilt.push_back(false);
recordManager.SetTableDescriptions(T, dataT, isIndexBuilt);
*/
/*
a table is created as follows:
create table T (
id varchar(10)
num int,
name char(5)
);
create table S (
key char(5)
value int,
);
*/
/*
uint T = 2;
// set the data types of a table
// data types can be read from catalog manager
vector<DataType> dataType;
dataType.clear();
dataType.push_back(String);
dataType.push_back(Int);
dataType.push_back(String);
recordManager.SetTableAttributeDataType(T, dataType);
// insert into T values ("qwerty12", 10, "abcde");
string id = "qwerty12";
int num = 10;
string name = "abcde";
recordManager.NewQuery();
recordManager.ChooseTable(T);
recordManager.AppendValue(id);
recordManager.AppendValue(num);
recordManager.AppendValue(name);
// select T.num,S.key from T,S where T.num<100 and S.key!="k0001" or T.name=S.key
recordManager.NewQuery();
uint T_index=2;
uint S_index=3;
recordManager.ChooseTable(T_index);
recordManager.ChooseTable(S_index);
recordManager.PushCondition(T_index, 1, Less, 100);
recordManager.PushLogicOp(And);
recordManager.PushCondition(S_index, 0, NotEqual, "k0001");
recordManager.PushLogicOp(Or);
recordManager.PushCondition(T_index, 2, Equal, S_index, 0);
*/
// delete is much like select, only difference is...
return 0;
}
