[go: up one dir, main page]

Menu

[r30]: / client / testsql.cpp  Maximize  Restore  History

Download this file

37 lines (26 with data), 653 Bytes

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
#include "sqlclient.h"
using namespace cb;
int main(int argc, char** argv)
{
SQLClient sqlclient;
sqlclient.connect(argv[1], atoi(argv[2]));
cout << "connected\n";
vector<DataAttr> attr;
sqlclient.getSemantics("stream.dat", attr);
Semantics::display(attr);
Query* q = sqlclient.createQueryHandle();
q->open("SELECT * FROM stream.dat;");
char res[80];
int rows = 10;
int size = 80;
q->fetch(res, rows, size);
char* p = res;
for (int i = 0; i < rows; ++ i)
{
cout << *(int*)p << " " << *(float*)(p + 4) << endl;
p += 8;
}
q->close();
sqlclient.releaseQueryHandle(q);
return 0;
}