// Read one record completely and return it as a Ruby String object.
static VALUE sedna_read(SC *conn, int strip_n)
{
int bytes_read = 0;
char buffer[RESULT_BUF_LEN];
VALUE str = rb_str_buf_new(0);
OBJ_TAINT(str);
do {
bytes_read = SEgetData(conn, buffer, RESULT_BUF_LEN - 1);
if(bytes_read == SEDNA_ERROR) {
sedna_err(conn, SEDNA_ERROR);
} else {
if(bytes_read > 0) {
if(strip_n) {
// Strange bug adds newlines to beginning of every result
// except the first. Strip them! This a known issue in the
// network protocol and serialization mechanism.
// See: http://sourceforge.net/mailarchive/forum.php?thread_name=3034886f0812030132v3bbd8e2erd86480d3dc640664%40mail.gmail.com&forum_name=sedna-discussion
STR_CAT(str, buffer + 1, bytes_read - 1);
// Do not strip newlines from subsequent buffer reads.
strip_n = 0;
} else {
STR_CAT(str, buffer, bytes_read);
}
}
}
} while(bytes_read > 0);
return str;
}
int main()
{
struct SednaConnection conn = SEDNA_CONNECTION_INITIALIZER;
int bytes_read, res, value;
char buf[1024];
const char* url = "localhost";
const char* db_name = "testdb";
const char* login = "******";
const char* password = "******";
printf("Client started.\n");
value = SEDNA_AUTOCOMMIT_OFF;
res = SEsetConnectionAttr(&conn, SEDNA_ATTR_AUTOCOMMIT, (void*)&value, sizeof(int));
//connecting to database "testdb" with login "SYSTEM", password "MANAGER"
res = SEconnect(&conn, url, db_name, login, password);
if(res != SEDNA_SESSION_OPEN)
{
printf("Session starting failed: \n%s\n", SEgetLastErrorMsg(&conn));
return -1;
}
//begin transaction
res = SEbegin(&conn);
if(res != SEDNA_BEGIN_TRANSACTION_SUCCEEDED)
{
printf("Begin transaction failed: \n%s\n", SEgetLastErrorMsg(&conn));
//closing session
SEclose(&conn);
return -1;
}
// load data from file "region.xml" into the document "region"
res = SEexecute(&conn, "LOAD \"..\\data\\region.xml\" \"region\"");
if(res != SEDNA_BULK_LOAD_SUCCEEDED)
{
printf("Bulk load failed: \n%s\n", SEgetLastErrorMsg(&conn));
// closing session
SEclose(&conn);
return -1;
}
// execute XQuery query
res = SEexecute(&conn, "doc(\"region\")/*/*");
if(res != SEDNA_QUERY_SUCCEEDED)
{
printf("Query failed: \n%s\n", SEgetLastErrorMsg(&conn));
//closing session
SEclose(&conn);
return -1;
}
// iterate over the result sequence and retrieve the result data
while((res = SEnext(&conn)) != SEDNA_RESULT_END)
{
if (res == SEDNA_ERROR)
{
printf("Failed to get next result item from server: \n%s\n", SEgetLastErrorMsg(&conn));
//closing session
SEclose(&conn);
return -1;
}
printf("\nresult item:\n");
do
{
bytes_read = SEgetData(&conn, buf, 1024 - 1);
if(bytes_read == SEDNA_ERROR)
{
printf("Failed to get result data from server: \n%s\n", SEgetLastErrorMsg(&conn));
//closing session
SEclose(&conn);
return -1;
}
buf[bytes_read] = '\0';
printf("%s", buf);
}while(bytes_read > 0);
printf("\n");
}
// Drop document "region"
res = SEexecute(&conn, "DROP DOCUMENT \"region\"");
if(res != SEDNA_UPDATE_SUCCEEDED)
{
printf("Drop document failed: \n%s\n", SEgetLastErrorMsg(&conn));
// closing session
SEclose(&conn);
return -1;
}
//commiting transaction
res = SEcommit(&conn);
if(res != SEDNA_COMMIT_TRANSACTION_SUCCEEDED)
{
printf("Commit transaction failed: \n%s\n", SEgetLastErrorMsg(&conn));
//closing session
SEclose(&conn);
return -1;
}
//closing session
res = SEclose(&conn);
if(res != SEDNA_SESSION_CLOSED)
{
printf("An error occured while trying to close session: \n%s\n", SEgetLastErrorMsg(&conn));
return -1;
}
return 0;
}
