{code}
var client = require('../index.js').createDefaultCUBRIDDemodbConnection(),
Result2Array = require('../src/resultset/Result2Array');
var sql = 'select * from game';
client.connect(function (err) {
if (err) {
throw err.message;
} else {
console.log('Connected successfully to ' + client.brokerServer + ':' + client.connectionBrokerPort + '.');
client.getEngineVersion(function (err, result) {
if (err) {
throw err.message;
} else {
console.log('CUBRID Engine version is: ' + result);
console.log('Querying: [' + sql + ']');
client.query(sql, function (err, queryResults, queryHandle) {
if (err) {
throw err.message;
} else {
console.log('Query results - Rows count: ' + Result2Array.GetResultsCount(queryResults));
console.log('Query results - Column names: ' + Result2Array.GetResultsColumnNamesArray(queryResults));
console.log('Query results - Column data types: ' + Result2Array.GetResultsColumnsTypeArray(queryResults));
console.log('Query results - Data [displaying only the first 10 rows]:');
var arr = Result2Array.GetResultsArray(queryResults);
for (var j = 0; j 10; j++) {
console.log(arr[j].toString());
}
console.log('Fetching more results:');
client.fetch(queryHandle, function (err, result) {
if (err) {
throw err.message;
} else {
if (result) {
console.log('Fetch results - Data [displaying only the first 10 rows]:');
var arr = Result2Array.GetResultsArray(result);
for (var k = 0; k 10; k++) {
console.log(arr[k].toString());
}
} else {
console.log('There is no more data to fetch.');
}
client.closeRequest(queryHandle, function (err) {
if (err) {
throw err.message;
} else {
console.log('Query closed.');
client.close(function (err) {
if (err) {
throw err.message;
} else {
console.log('Connection closed.');
}
})
}
})
}
})
}
})
}
})
}
});
{code}
gives the output:
{code}
Connected successfully to localhost:33001.
CUBRID Engine version is: 8.4.1.6004
Querying: [select * from game]
C:\Users\user\Desktop\CUBRID-node-cubrid-313d164\test\test.js:21
console.log('Query results - Rows count: ' + Result2Array.GetResults
^
TypeError: Object #Object has no method 'GetResultsCount'
at CUBRIDConnection.anonymous (C:\Users\user\Desktop\CUBRID-node-cubrid-313d164\test\test.js:21:71)
at CUBRIDConnection.query (C:\Users\user\Desktop\CUBRID-node-cubrid-313d164\src\CUBRIDConnection.js:539:18)
at Socket.CUBRIDConnection.query.ActionQueue.enqueue.self.queryPending (C:\Users\user\Desktop\CUBRID-node-cubrid-313d164\src\CUBRIDConnection.js:526:18)
at Socket.EventEmitter.emit (events.js:93:17)
at TCP.onread (net.js:396:14)
{code}