/************************************************************************
* name: SQLGetCursorNameW
* arguments:
* returns/side-effects:
* description:
* NOTE:
************************************************************************/
ODBC_INTERFACE RETCODE SQL_API
SQLGetCursorNameW (SQLHSTMT hstmt, SQLWCHAR *cursor, SQLSMALLINT cursor_max,
SQLSMALLINT *cursor_len)
{
RETCODE ret = ODBC_ERROR;
char* cursor_name = NULL;
SQLSMALLINT cursor_name_len = 0;
ODBC_STATEMENT* stmt_handle = (ODBC_STATEMENT *) hstmt;
OutputDebugString ("SQLGetCursorNameW called.\n");
cursor_name = UT_ALLOC (cursor_max);
if (cursor_name == NULL && cursor_max > 0)
{
odbc_set_diag (stmt_handle->diag, "HY001", 0, "malloc failed");
return ODBC_ERROR;
}
memset (cursor_name, 0 , cursor_max);
ret = SQLGetCursorName(hstmt, cursor_name, cursor_max, &cursor_name_len);
if (ret == ODBC_ERROR)
{
UT_FREE (cursor_name);
return ret;
}
bytes_to_wide_char (cursor_name, cursor_name_len, &cursor, cursor_max, (int*)cursor_len, NULL);
UT_FREE(cursor_name);
return ret;
}
static int odbc_stmt_get_attr(pdo_stmt_t *stmt, zend_long attr, zval *val)
{
SQLRETURN rc;
pdo_odbc_stmt *S = (pdo_odbc_stmt*)stmt->driver_data;
switch (attr) {
case PDO_ATTR_CURSOR_NAME:
{
char buf[256];
SQLSMALLINT len = 0;
rc = SQLGetCursorName(S->stmt, buf, sizeof(buf), &len);
if (rc == SQL_SUCCESS || rc == SQL_SUCCESS_WITH_INFO) {
ZVAL_STRINGL(val, buf, len);
return 1;
}
pdo_odbc_stmt_error("SQLGetCursorName");
return 0;
}
case PDO_ODBC_ATTR_ASSUME_UTF8:
ZVAL_BOOL(val, S->assume_utf8 ? 1 : 0);
return 0;
default:
strcpy(S->einfo.last_err_msg, "Unknown Attribute");
S->einfo.what = "getAttribute";
strcpy(S->einfo.last_state, "IM001");
return -1;
}
}
static int odbc_dispatch4(void)
{
unsigned long retval;
PWord rval; int rtype;
PWord arg1; int type1;
PWord arg2; int type2;
PWord arg3; int type3;
PWord arg4; int type4;
PWord arg5; int type5;
PWord arg6; int type6;
PI_getan(&arg1,&type1,1);
if (type1 != PI_INT)
if (!CI_get_integer((unsigned long *)&arg1,type1))
PI_FAIL;
PI_getan(&arg2,&type2,2);
if (type2 != PI_INT)
if (!CI_get_integer((unsigned long *)&arg2,type2))
PI_FAIL;
PI_getan(&arg3,&type3,3);
if (type3 == PI_SYM)
arg3 = (unsigned long) PI_getsymname(0,arg3,0);
else if (!CI_get_integer((unsigned long *)&arg3,type3))
PI_FAIL;
PI_getan(&arg4,&type4,4);
if (type4 != PI_INT)
if (!CI_get_integer((unsigned long *)&arg4,type4))
PI_FAIL;
PI_getan(&arg5,&type5,5);
if (type5 != PI_INT)
if (!CI_get_integer((unsigned long *)&arg5,type5))
PI_FAIL;
PI_getan(&arg6,&type6,6);
switch(arg1)
{
case 0:
retval = (unsigned long) SQLGetCursorName(((SQLHSTMT ) arg2),((SQLCHAR * ) arg3),((SQLSMALLINT ) arg4),((SQLSMALLINT * ) arg5));
break;
default:
PI_FAIL;
}
PI_makedouble(&rval,&rtype,(double) retval);
if (PI_unify(arg6,type6,rval,rtype))
PI_SUCCEED;
PI_FAIL;
}
PassFail TestQueryID (TestInfo *pTestInfo)
{
TEST_DECLARE;
char Heading[MAX_STRING_SIZE];
RETCODE returncode;
SQLHANDLE henv, henv2;
SQLHANDLE hdbc, hdbc2 = (SQLHANDLE)NULL;
SQLHANDLE hstmt, hstmt2;
int loop = 0;
//char preparedStmt[1024];
char infoStatsStmt[ 1024 ];
SQLCHAR cursorName[ 1024 ];
CHAR jobid[SQL_MAX_SESSIONNAME_LEN];
CHAR queryID[256];
SQLINTEGER jobidlen;
SQLLEN queryIDPtr;
CHAR tempStr[256];
char *droptab = "DROP TABLE JOBID cascade";
char *createtab = "CREATE TABLE JOBID (C int) NO PARTITION";
char *inserttab = "INSERT INTO JOBID VALUES (10)";
char *selecttab = "SELECT * FROM JOBID";
struct
{
RETCODE returncode;
CHAR *jobID;
CHAR *jobIDExpected;
} jobIDMatrix[] = {
{ SQL_SUCCESS, "1" , "1"},
{ SQL_SUCCESS, "11" , "11"},
{ SQL_SUCCESS, "" , "" },
{ SQL_SUCCESS, "H" , "H" },
{ SQL_SUCCESS, "hh" , "hh" },
{ SQL_SUCCESS, "0" , "0" },
{ SQL_SUCCESS, "_" , "_" },
{ SQL_SUCCESS, "________________________" , "________________________" },
{ SQL_SUCCESS, "odbcqa" , "odbcqa" },
{ SQL_SUCCESS, "odbcqa00" , "odbcqa00" },
{ SQL_SUCCESS, "00odbcqa" , "00odbcqa" },
{ SQL_SUCCESS, "0123_HELLOKITTY" , "0123_HELLOKITTY" },
{ SQL_SUCCESS, "_Hello_Kitty_123" , "_Hello_Kitty_123" },
{ SQL_SUCCESS, "Hello_Kitty_Went_To_The_" , "Hello_Kitty_Went_To_The_" },
{ SQL_SUCCESS, "Hello_Kitty_Went_To_The_" , "Hello_Kitty_Went_To_The_" },
{ SQL_SUCCESS, "1234567890_1234567890" , "1234567890_1234567890" },
{ SQL_SUCCESS, "123456789012345678901234" , "123456789012345678901234" },
{ SQL_SUCCESS, "123456789012345678901234" , "123456789012345678901234" },
{ SQL_SUCCESS, "1234567890123456789012345" , "123456789012345678901234" },
{ SQL_SUCCESS, "Hello_Kitty_Went_To_The_Store_To_Buy" , "Hello_Kitty_Went_To_The_" },
{ SQL_SUCCESS_WITH_INFO, " " , "" },
{ SQL_SUCCESS_WITH_INFO, " HelloKitty" , "" },
{ SQL_SUCCESS_WITH_INFO, "Hello Kitty" , "" },
{ SQL_SUCCESS_WITH_INFO, "HelloKitty " , "" },
{ SQL_SUCCESS_WITH_INFO, "1 2" , "" },
{ SQL_SUCCESS_WITH_INFO, "12345.67890.123456789012" , "" },
{ SQL_SUCCESS_WITH_INFO, "Hello$Kitty" , "" },
{ SQL_SUCCESS_WITH_INFO, "\"HelloKitty\"" , "" },
{ SQL_SUCCESS_WITH_INFO, "'HelloKitty'" , "" },
{ SQL_SUCCESS_WITH_INFO, "\" \"" , "" },
{ SQL_SUCCESS_WITH_INFO, "\"\"" , "" },
{ SQL_SUCCESS_WITH_INFO, "\"#@*()-_=+[]{}|:;'<>,.?\"" , "" },
{ -101 , "" , "" }
};
//struct
//{
// RETCODE rtc;
// CHAR *queryID;
// CHAR *queryIDExpected;
//} queryIDMatrix[] = {
// { SQL_SUCCESS, "HELLOKITTY" , "HELLOKITTY" },
// { SQL_SUCCESS, "H" , "H" },
// { SQL_SUCCESS, "HELLOKITTYWENTTOTHESTORETOBUYDRI" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" },
// { SQL_SUCCESS, "HELLOKITTYWENTTOTHESTORETOBUYDRINKSFORTHEPARTY" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" },
// { SQL_SUCCESS, "HelloKitty" , "HELLOKITTY" },
// { SQL_SUCCESS, "h" , "H" },
// { SQL_SUCCESS, "HelloKittyWentToTheStoreToBuyDri" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" },
// { SQL_SUCCESS, "HelloKittyWentToTheStoreToBuyDrinksForTheParty" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" },
// { SQL_SUCCESS, "H_1" , "H_1" },
// { SQL_SUCCESS, "HELLO_KITTY_1234" , "HELLO_KITTY_1234" },
// { SQL_SUCCESS, "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" },
// { SQL_SUCCESS, "HELLO_KITTY_1234_ABCDEFGHIJKLMNOPQRSTUVWXYZ" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" },
// { SQL_SUCCESS, "Hello_Kitty_1234" , "HELLO_KITTY_1234" },
// { SQL_SUCCESS, "Hello_Kitty_1234_abcdefghijklmno" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" },
// { SQL_SUCCESS, "Hello_Kitty_1234_abcdefghijklmnopqrstuvwxyz" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" },
// { SQL_SUCCESS, "\"HELLOKITTY\"" , "HELLOKITTY" },
// { SQL_SUCCESS, "\"H\"" , "H" },
// { SQL_SUCCESS, "\"HELLOKITTYWENTTOTHESTORETOBUYDRI\"" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" },
// { SQL_SUCCESS, "\"HELLOKITTYWENTTOTHESTORETOBUYDRINKSFORTHEPARTY\"" , "HELLOKITTYWENTTOTHESTORETOBUYDRI" },
// { SQL_SUCCESS, "\"HelloKitty\"" , "HelloKitty" },
// { SQL_SUCCESS, "\"h\"" , "h" },
// { SQL_SUCCESS, "\"HelloKittyWentToTheStoreToBuyDri\"" , "HelloKittyWentToTheStoreToBuyDri" },
// { SQL_SUCCESS, "\"HelloKittyWentToTheStoreToBuyDrinksForTheParty\"" , "HelloKittyWentToTheStoreToBuyDri" },
// { SQL_SUCCESS, "\"H_1\"" , "H_1" },
// { SQL_SUCCESS, "\"HELLO_KITTY_1234\"" , "HELLO_KITTY_1234" },
// { SQL_SUCCESS, "\"HELLO_KITTY_1234_ABCDEFGHIJKLMNO\"" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" },
// { SQL_SUCCESS, "\"HELLO_KITTY_1234_ABCDEFGHIJKLMNOPQRSTUVWXYZ\"" , "HELLO_KITTY_1234_ABCDEFGHIJKLMNO" },
// { SQL_SUCCESS, "\"Hello_Kitty_1234\"" , "Hello_Kitty_1234" },
// { SQL_SUCCESS, "\"Hello_Kitty_1234_abcdefghijklmno\"" , "Hello_Kitty_1234_abcdefghijklmno" },
// { SQL_SUCCESS, "\"Hello_Kitty_1234_abcdefghijklmnopqrstuvwxyz\"" , "Hello_Kitty_1234_abcdefghijklmno" },
// { SQL_SUCCESS, "\"Hello Kitty\"" , "Hello Kitty" },
// { SQL_SUCCESS, "\"Hello Kitty says \"\"MEOW!\"\"\"" , "Hello Kitty says \"MEOW\"" },
// { SQL_SUCCESS, "\"Hello Kitty's Pruse\"" , "Hello Kitty's Purse" },
// { SQL_SUCCESS, "\"CREATE\"" , "CREATE" },
// { SQL_SUCCESS, "\"SELECT * FROM T1\"" , "SELECT * FROM T1" },
// { SQL_ERROR , "" , "" },
// { SQL_ERROR , " " , "" },
// { SQL_ERROR , "1HelloKitty" , "" },
// { SQL_ERROR , "_A" , "" },
// { SQL_ERROR , "Hello Kitty" , "" },
// { SQL_ERROR , "Hello$Kitty" , "" },
// { SQL_ERROR , "\"\\HelloKitty\"" , "" },
// { SQL_ERROR , "\"$HelloKitty\"" , "" },
// { SQL_ERROR , "\" \"" , "" },
// { SQL_ERROR , "\"\"" , "" },
// { SQL_ERROR , "\"@*()-_=+[]{}|:;'<>,.?\"" , "" },
// { SQL_ERROR , "CREATE" , "" },
// { -101 , "" , "" }
//};
//struct
//{
// char* sqlStmt;
//} sqlPrepareMatrix[] = {
// { "CREATE CATALOG STMNT" },
// { "CREATE SCHEMA STMNT.TEST" },
// { "CREATE TABLE T2 ( C1 INTEGER NOT NULL NOT DROPPABLE, C2 INTEGER, PRIMARY KEY( C1 ) )" },
// { "CREATE INDEX T2_INDEX ON T2 ( C1 ) NO POPULATE" },
// { "CREATE PROCEDURE T2_PROC (IN IN1 TIME) EXTERNAL NAME 'Procs.N4210' EXTERNAL PATH '/usr/spjqa/Testware/Class' LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL NO ISOLATE" },
// { "CREATE VIEW T2_VIEW AS SELECT C1 FROM T2" },
// { "INSERT INTO T2 VALUES ( 1 , 1) " },
// { "SELECT C1 FROM T2" },
// { "UPDATE T2 SET C2 = 2 WHERE C1 = 1" },
// { "DELETE FROM T2" },
// { "ALTER INDEX T2_INDEX ON T2 ( C2 ) NO POPULATE" },
// { "ALTER TABLE T2 ( C1 INTEGER NOT NULL NOT DROPPABLE, C2 INTEGER NOT NULL, PRIMARY KEY( C1 ) )" },
// { "ALTER TRIGGER" },
// { "DROP SCHEMA STMT.TEST" },
// { "DROP CATALOG STMT" },
// { "DROP INDEX T2_INDEX" },
// { "DROP VIEW T2_VIEW" },
// { "DROP PROCEDURE T2_PROC" },
// { "DROP TABLE T2" },
// { "STOP" }
//};
//======================================================================================================
LogMsg(LINEBEFORE+SHORTTIMESTAMP,"Begin testing API => JobID | QueryID | QueryID.cpp\n");
TEST_INIT;
TESTCASE_BEGIN("Setup for JobID tests\n");
if(!FullConnectWithOptions(pTestInfo, CONNECT_ODBC_VERSION_3))
{
LogMsg(NONE,"Unable to connect as ODBC3.0 application.\n");
TEST_FAILED;
TEST_RETURN;
}
henv = pTestInfo->henv;
hdbc = pTestInfo->hdbc;
hstmt = (SQLHANDLE)pTestInfo->hstmt;
returncode = SQLAllocStmt((SQLHANDLE)hdbc, &hstmt);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt"))
{
LogAllErrors(henv,hdbc,hstmt);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLExecDirect(hstmt, (SQLCHAR*)droptab,SQL_NTS);
returncode = SQLExecDirect(hstmt, (SQLCHAR*)createtab,SQL_NTS);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLExecDirect"))
{
LogAllErrors(henv,hdbc,hstmt);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLExecDirect(hstmt, (SQLCHAR*)inserttab,SQL_NTS);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLExecDirect"))
{
LogAllErrors(henv,hdbc,hstmt);
TEST_FAILED;
TEST_RETURN;
}
FullDisconnect(pTestInfo);
TESTCASE_END;
//======================================================================================================
sprintf(Heading,"Test positive functionality of SessionName, single connection\n");
TESTCASE_BEGIN( Heading);
// Allocate Environment Handle
returncode = SQLAllocEnv(&henv);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocEnv")) {
LogAllErrors(henv,hdbc,hstmt);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3, 0);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLSetEnvAttr"))
{
LogAllErrors(henv,hdbc,hstmt);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
// Allocate Connection handle
returncode = SQLAllocConnect(henv,&hdbc);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocConnect")) {
LogAllErrors(henv,hdbc,hstmt);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
TESTCASE_END;
loop = 0;
while( jobIDMatrix[ loop ].returncode != -101 )
{
sprintf(Heading,"Test #%d: Testing for jobID: %s\n", loop, jobIDMatrix[ loop ].jobID);
TESTCASE_BEGIN( Heading);
returncode = SQLSetConnectAttr(hdbc, (SQLINTEGER)SQL_ATTR_SESSIONNAME,(SQLCHAR*) jobIDMatrix[ loop ].jobID, SQL_NTS);
if (jobIDMatrix[ loop ].returncode == SQL_SUCCESS) {
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLSetConnectAttr")) {
LogAllErrors(henv,hdbc,hstmt);
TEST_FAILED;
loop++;
continue;
}
}
else {
#ifdef unixcli
if(returncode != SQL_ERROR) {
#else
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLSetConnectAttr")) {
#endif
LogAllErrors(henv,hdbc,hstmt);
TEST_FAILED;
loop++;
continue;
}
}
returncode = SQLGetConnectAttr(hdbc, (SQLINTEGER)SQL_ATTR_SESSIONNAME, jobid, SQL_MAX_SESSIONNAME_LEN, &jobidlen);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLGetConnectAttr")) {
LogAllErrors(henv,hdbc,hstmt);
TEST_FAILED;
loop++;
continue;
}
if (jobIDMatrix[ loop ].returncode == SQL_SUCCESS) {
if (strcmp(jobIDMatrix[ loop ].jobIDExpected, jobid) == 0) {
LogMsg(NONE, "JobIDs are matched. Expected: \"%s\", Actual: \"%s\" for SQLGetConnectAttr\n", jobIDMatrix[ loop ].jobIDExpected, jobid);
TESTCASE_END;
}
else {
LogMsg(ERRMSG, "JobIDs are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for SQLGetConnectAttr\n", jobIDMatrix[ loop ].jobIDExpected, jobid, __LINE__);
TEST_FAILED;
}
}
else {
#ifdef unixcli
if (strcmp(jobIDMatrix[ loop ].jobIDExpected, jobid) == 0) {
#else
if (strcmp(jobIDMatrix[ loop ].jobID, jobid) == 0) {
#endif
LogMsg(NONE, "JobIDs are matched. Expected: \"%s\", Actual: \"%s\" for SQLGetConnectAttr\n", jobIDMatrix[ loop ].jobID, jobid);
TESTCASE_END;
}
else {
LogMsg(ERRMSG, "JobIDs are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for SQLGetConnectAttr\n", jobIDMatrix[ loop ].jobID, jobid, __LINE__);
TEST_FAILED;
}
}
returncode = SQLConnect(hdbc,
(SQLCHAR*)pTestInfo->DataSource,(SWORD)strlen(pTestInfo->DataSource),
(SQLCHAR*)pTestInfo->UserID,(SWORD)strlen(pTestInfo->UserID),
(SQLCHAR*)pTestInfo->Password,(SWORD)strlen(pTestInfo->Password)
);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLConnect")) {
LogAllErrors(henv,hdbc,hstmt);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
#ifndef unixcli
if (jobIDMatrix[ loop ].returncode == SQL_SUCCESS_WITH_INFO) {
if (returncode != jobIDMatrix[ loop ].returncode) {
LogMsg(ERRMSG, "The retcode has to be SQL_SUCCESS_WITH_INFO, with the error message \"Driver's SQLSetConnectAttr failed.\" in it, at line=%d\n", __LINE__);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
// LogAllErrors(henv,hdbc,NULL);
if (!FindError("IM006",henv,hdbc,NULL)) {
LogMsg(ERRMSG, "Couldn't find state error IM006, with the error message \"Driver's SQLSetConnectAttr failed.\", at line=%d\n", __LINE__);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
}
#endif
returncode = SQLAllocStmt(hdbc,&hstmt);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt")) {
LogAllErrors(henv,hdbc,hstmt);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLAllocStmt(hdbc,&hstmt2);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt")) {
LogAllErrors(henv,hdbc,hstmt);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLPrepare( hstmt, (SQLCHAR *)selecttab, SQL_NTS );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLPrepare")) {
LogAllErrors(henv,hdbc,hstmt);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLGetCursorName(hstmt, cursorName, sizeof(cursorName), NULL );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLPrepare")) {
LogAllErrors(henv,hdbc,hstmt);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
//Get queryID
sprintf( infoStatsStmt, "INFOSTATS %s", (char*)cursorName );
returncode = SQLBindCol( hstmt2, 1, SQL_C_CHAR, &queryID, 256, &queryIDPtr );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLExecDirect( hstmt2, (SQLCHAR *)infoStatsStmt, SQL_NTS );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLFetch( hstmt2 );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
LogMsg(NONE, "queryID: \"%s\"\n", queryID);
SQLFreeStmt(hstmt2,SQL_CLOSE);
SQLFreeStmt(hstmt2,SQL_UNBIND);
//Get Jobid
if(isCharSet || isUCS2)
sprintf( infoStatsStmt, "SELECT queryid_extract( _ISO88591'%s',_ISO88591'SESSIONNAME') FROM JOBID", (char*)queryID );
else
sprintf( infoStatsStmt, "SELECT queryid_extract('%s','SESSIONNAME') FROM JOBID", (char*)queryID );
returncode = SQLBindCol( hstmt2, 1, SQL_C_CHAR, &queryID, 256, &queryIDPtr );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLExecDirect( hstmt2, (SQLCHAR *)infoStatsStmt, SQL_NTS );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLFetch( hstmt2 );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
LogMsg(NONE, "JobID: \"%s\"\n", queryID);
if (strcmp(jobIDMatrix[ loop ].jobIDExpected, queryID) == 0) {
LogMsg(NONE, "JobIDs are matched. Expected: \"%s\", Actual: \"%s\" for after queryid_extract\n", jobIDMatrix[ loop ].jobIDExpected, queryID);
TESTCASE_END;
}
else {
LogMsg(ERRMSG, "JobIDs are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for after queryid_extract\n", jobIDMatrix[ loop ].jobIDExpected, queryID, __LINE__);
TEST_FAILED;
}
SQLFreeStmt(hstmt,SQL_CLOSE);
SQLFreeStmt(hstmt,SQL_UNBIND);
SQLFreeStmt(hstmt2,SQL_CLOSE);
SQLFreeStmt(hstmt2,SQL_UNBIND);
returncode = SQLDisconnect(hdbc);
if (returncode != SQL_SUCCESS)
{
LogAllErrors(henv,hdbc,hstmt);
SQLDisconnect(hdbc);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
}
loop++;
}
returncode = SQLFreeConnect(hdbc);
if (returncode != SQL_SUCCESS)
{
LogAllErrors(henv,hdbc,hstmt);
SQLDisconnect(hdbc);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
}
returncode = SQLFreeEnv(henv);
if (returncode != SQL_SUCCESS)
{
LogAllErrors(henv,hdbc,hstmt);
SQLDisconnect(hdbc);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
}
//======================================================================================================
sprintf(Heading,"Test positive functionality of SessionName, mutiple connection using the same session name\n");
TESTCASE_BEGIN( Heading);
// Allocate Environment Handle
returncode = SQLAllocEnv(&henv);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocEnv")) {
LogAllErrors(henv,hdbc,hstmt);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLAllocEnv(&henv2);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocEnv2")) {
LogAllErrors(henv2,hdbc2,hstmt2);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3, 0);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLSetEnvAttr"))
{
LogAllErrors(henv,hdbc,hstmt);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLSetEnvAttr(henv2, SQL_ATTR_ODBC_VERSION, (SQLPOINTER) SQL_OV_ODBC3, 0);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLSetEnvAttr2"))
{
LogAllErrors(henv2,hdbc2,hstmt2);
SQLFreeEnv(henv2);
TEST_FAILED;
TEST_RETURN;
}
// Allocate Connection handle
returncode = SQLAllocConnect(henv,&hdbc);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocConnect")) {
LogAllErrors(henv,hdbc,hstmt);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLAllocConnect(henv2,&hdbc2);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocConnect2")) {
LogAllErrors(henv2,hdbc2,hstmt2);
SQLFreeEnv(henv2);
TEST_FAILED;
TEST_RETURN;
}
TESTCASE_END;
strcpy(tempStr,"123456789012345678901234");
sprintf(Heading,"Testing for jobID: %s\n", tempStr);
TESTCASE_BEGIN( Heading);
returncode = SQLSetConnectAttr(hdbc, (SQLINTEGER)SQL_ATTR_SESSIONNAME,(SQLCHAR*) tempStr, SQL_NTS);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLGetConnectAttr")) {
LogAllErrors(henv,hdbc,hstmt);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLSetConnectAttr(hdbc2, (SQLINTEGER)SQL_ATTR_SESSIONNAME,(SQLCHAR*) tempStr, SQL_NTS);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLGetConnectAttr2")) {
LogAllErrors(henv2,hdbc2,hstmt2);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLGetConnectAttr(hdbc, (SQLINTEGER)SQL_ATTR_SESSIONNAME, jobid, SQL_MAX_SESSIONNAME_LEN, &jobidlen);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLGetConnectAttr")) {
LogAllErrors(henv,hdbc,hstmt);
TEST_FAILED;
}
if (strcmp(tempStr, jobid) == 0) {
LogMsg(NONE, "JobID1 are matched. Expected: \"%s\", Actual: \"%s\" for hdbc\n", tempStr, jobid);
}
else {
LogMsg(ERRMSG, "JobID1 are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for hdbc\n", tempStr, jobid, __LINE__);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLGetConnectAttr(hdbc2, (SQLINTEGER)SQL_ATTR_SESSIONNAME, jobid, SQL_MAX_SESSIONNAME_LEN, &jobidlen);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLGetConnectAttr2")) {
LogAllErrors(henv2,hdbc2,hstmt2);
TEST_FAILED;
TEST_RETURN;
}
if (strcmp(tempStr, jobid) == 0) {
LogMsg(NONE, "JobID2 are matched. Expected: \"%s\", Actual: \"%s\" for hdbc2\n", tempStr, jobid);
}
else {
LogMsg(ERRMSG, "JobID2 are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for hdbc2\n", tempStr, jobid, __LINE__);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLConnect(hdbc,
(SQLCHAR*)pTestInfo->DataSource,(SWORD)strlen(pTestInfo->DataSource),
(SQLCHAR*)pTestInfo->UserID,(SWORD)strlen(pTestInfo->UserID),
(SQLCHAR*)pTestInfo->Password,(SWORD)strlen(pTestInfo->Password)
);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLConnect")) {
LogAllErrors(henv,hdbc,hstmt);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLConnect(hdbc2,
(SQLCHAR*)pTestInfo->DataSource,(SWORD)strlen(pTestInfo->DataSource),
(SQLCHAR*)pTestInfo->UserID,(SWORD)strlen(pTestInfo->UserID),
(SQLCHAR*)pTestInfo->Password,(SWORD)strlen(pTestInfo->Password)
);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLConnect2")) {
LogAllErrors(henv2,hdbc2,hstmt2);
SQLFreeConnect(hdbc2);
SQLFreeEnv(henv2);
TEST_FAILED;
TEST_RETURN;
}
for (loop=0; loop<2; loop++) {
if (loop == 0) {
returncode = SQLAllocStmt(hdbc,&hstmt);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt")) {
LogAllErrors(henv,hdbc,hstmt);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLAllocStmt(hdbc,&hstmt2);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt3")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
}
else {
returncode = SQLAllocStmt(hdbc2,&hstmt);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt")) {
LogAllErrors(henv2,hdbc2,hstmt);
SQLFreeConnect(hdbc2);
SQLFreeEnv(henv2);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLAllocStmt(hdbc2,&hstmt2);
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLAllocStmt3")) {
LogAllErrors(henv2,hdbc2,hstmt2);
SQLFreeConnect(hdbc2);
SQLFreeEnv(henv2);
TEST_FAILED;
TEST_RETURN;
}
}
returncode = SQLPrepare( hstmt, (SQLCHAR *)selecttab, SQL_NTS );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLPrepare")) {
LogAllErrors(henv,hdbc,hstmt);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLGetCursorName(hstmt, cursorName, sizeof(cursorName), NULL );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLPrepare")) {
LogAllErrors(henv,hdbc,hstmt);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
//Get queryID
sprintf( infoStatsStmt, "INFOSTATS %s", (char*)cursorName );
returncode = SQLBindCol( hstmt2, 1, SQL_C_CHAR, &queryID, 256, &queryIDPtr );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLExecDirect( hstmt2, (SQLCHAR *)infoStatsStmt, SQL_NTS );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLFetch( hstmt2 );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
LogMsg(NONE, "queryID%d: \"%s\"\n", loop, queryID);
SQLFreeStmt(hstmt2,SQL_CLOSE);
SQLFreeStmt(hstmt2,SQL_UNBIND);
//Get Jobid
if(isCharSet || isUCS2)
sprintf( infoStatsStmt, "SELECT queryid_extract( _ISO88591'%s', _ISO88591'SESSIONNAME') FROM JOBID", (char*)queryID );
else
sprintf( infoStatsStmt, "SELECT queryid_extract('%s','SESSIONNAME') FROM JOBID", (char*)queryID );
returncode = SQLBindCol( hstmt2, 1, SQL_C_CHAR, &queryID, 256, &queryIDPtr );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLExecDirect( hstmt2, (SQLCHAR *)infoStatsStmt, SQL_NTS );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLFetch( hstmt2 );
if(!CHECKRC(SQL_SUCCESS,returncode,"SQLBindCol")) {
LogAllErrors(henv,hdbc,hstmt2);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
TEST_FAILED;
TEST_RETURN;
}
LogMsg(NONE, "JobID%d: \"%s\"\n", loop, queryID);
if (strcmp(tempStr, queryID) == 0) {
LogMsg(NONE, "JobID%d are matched. Expected: \"%s\", Actual: \"%s\" for after queryid_extract\n", loop, tempStr, queryID);
TESTCASE_END;
}
else {
LogMsg(ERRMSG, "JobID%d are not matched. Expected: \"%s\", Actual: \"%s\", at line=%d for after queryid_extract\n", loop, tempStr, queryID, __LINE__);
TEST_FAILED;
}
SQLFreeStmt(hstmt,SQL_CLOSE);
SQLFreeStmt(hstmt,SQL_UNBIND);
SQLFreeStmt(hstmt2,SQL_CLOSE);
SQLFreeStmt(hstmt2,SQL_UNBIND);
}
returncode = SQLDisconnect(hdbc);
if (returncode != SQL_SUCCESS)
{
LogAllErrors(henv,hdbc,hstmt);
SQLDisconnect(hdbc);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
}
returncode = SQLDisconnect(hdbc2);
if (returncode != SQL_SUCCESS)
{
LogAllErrors(henv2,hdbc2,hstmt2);
SQLDisconnect(hdbc2);
SQLFreeConnect(hdbc2);
SQLFreeEnv(henv2);
}
returncode = SQLFreeConnect(hdbc);
if (returncode != SQL_SUCCESS)
{
LogAllErrors(henv,hdbc,hstmt);
SQLDisconnect(hdbc);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
}
returncode = SQLFreeConnect(hdbc2);
if (returncode != SQL_SUCCESS)
{
LogAllErrors(henv2,hdbc2,hstmt2);
SQLDisconnect(hdbc2);
SQLFreeConnect(hdbc2);
SQLFreeEnv(henv2);
}
returncode = SQLFreeEnv(henv);
if (returncode != SQL_SUCCESS)
{
LogAllErrors(henv,hdbc,hstmt);
SQLDisconnect(hdbc);
SQLFreeConnect(hdbc);
SQLFreeEnv(henv);
}
returncode = SQLFreeEnv(henv2);
if (returncode != SQL_SUCCESS)
{
LogAllErrors(henv2,hdbc2,hstmt2);
SQLDisconnect(hdbc2);
SQLFreeConnect(hdbc2);
SQLFreeEnv(henv2);
}
//=========================================================================================
//FullDisconnect(pTestInfo);
LogMsg(SHORTTIMESTAMP+LINEAFTER,"End testing API => JobID.\n");
TEST_RETURN;
}
/*
---------------------------------------------------------
TestSQLDrivers
No negative tests since this functionality is done at
driver manager level.
---------------------------------------------------------
*/
PassFail TestInfoStats(TestInfo *pTestInfo)
{
TEST_DECLARE;
SQLHANDLE secHandle;
SQLSMALLINT outLen = SQL_NTS;
char tempStr[MAX_STR_LEN*2];
int i,j;
char cursorName[MAX_STR_LEN] = "";
RETCODE returncode;
char* strs[5];
struct _test_data {
char front[2];
char back[MAX_SIZE];
RETCODE retcode;
BOOL cursor;
char *stmt;
} testData[] = {{"", "", SQL_SUCCESS, TRUE, ""},
{"", "", SQL_SUCCESS, TRUE, ""},
{"", "", SQL_SUCCESS, TRUE, ""},
{"", "SQL_CUR_2", SQL_ERROR, FALSE, ""},
{"", "", SQL_ERROR, FALSE, ""}, // empty statement
{"'", "'", SQL_SUCCESS, TRUE, ""},
{"\"", "\"", SQL_SUCCESS, TRUE, ""},
{"", "SQL_CUR_9 ",SQL_ERROR, FALSE, ""},
{"\"", "", SQL_ERROR, TRUE, ""},
{"\"", "\"", SQL_SUCCESS, FALSE, ""}, // strs[3].txt
{"'", "'", SQL_SUCCESS, FALSE, ""}, // strs[3].txt
{"'", "", SQL_ERROR, FALSE, ""}, // strs[3].txt
{"\"", "", SQL_ERROR, FALSE, ""}, // strs[3].txt
{"", "\"", SQL_ERROR, FALSE, ""}, // strs[3].txt
{"", "'", SQL_ERROR, FALSE, ""}, // strs[3].txt
{"'", "'", SQL_ERROR, FALSE, ""}, // strs[4].txt
{"\"", "\"", SQL_ERROR, FALSE, ""}, // strs[4].txt
{"", "end"}
};
//===========================================================================================================
var_list_t *var_list;
var_list = load_api_vars("InfoStats", charset_file);
if (var_list == NULL) return FAILED;
strs[0] = var_mapping("InfoStats_strs_0", var_list);
strs[1] = var_mapping("InfoStats_strs_1", var_list);
strs[2] = var_mapping("InfoStats_strs_2", var_list);
strs[3] = var_mapping("InfoStats_strs_3", var_list);
strs[4] = var_mapping("InfoStats_strs_4", var_list);
strs[5] = var_mapping("InfoStats_strs_5", var_list);
testData[9].stmt = strs[3];
testData[10].stmt = strs[3];
testData[11].stmt = strs[3];
testData[12].stmt = strs[3];
testData[13].stmt = strs[3];
testData[14].stmt = strs[3];
testData[15].stmt = strs[4];
testData[16].stmt = strs[4];
//===========================================================================================================
LogMsg(LINEBEFORE+SHORTTIMESTAMP,"Begin testing => InfoStats | InfoStats | infostats.cpp\n");
TEST_INIT;
if(!FullConnectWithOptions(pTestInfo, CONNECT_ODBC_VERSION_3))
{
LogMsg(NONE,"Unable to connect\n");
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLAllocStmt((SQLHANDLE)pTestInfo->hdbc, &(pTestInfo->hstmt));
if (returncode != SQL_SUCCESS) {
TEST_FAILED;
TEST_RETURN;
}
returncode = SQLAllocStmt((SQLHANDLE)pTestInfo->hdbc, &secHandle);
if(returncode != SQL_SUCCESS) {
TEST_FAILED;
TEST_RETURN;
}
for(j = 0; j < 2; j++) {
i = 0;
while (strcmp(testData[i].back,"end")!=0) {
if((j == 0) || (i==0)) { // setup table and data
LogMsg(NONE,"Setting up table and data\n");
returncode = SQLExecDirect(pTestInfo->hstmt, (SQLCHAR*)strs[0], SQL_NTS);
returncode = SQLExecDirect(pTestInfo->hstmt, (SQLCHAR*)strs[1], SQL_NTS);
returncode = SQLExecDirect(pTestInfo->hstmt, (SQLCHAR*)strs[2], SQL_NTS);
returncode = SQLEndTran(SQL_HANDLE_DBC, pTestInfo->hdbc, SQL_COMMIT);
returncode = SQLFreeStmt(pTestInfo->hstmt, SQL_CLOSE);
}
returncode = SQLPrepare(pTestInfo->hstmt, (SQLCHAR*)strs[3], SQL_NTS);
strcpy(cursorName, "");
returncode = SQLGetCursorName(pTestInfo->hstmt, (SQLCHAR*)cursorName, sizeof(cursorName), &outLen);
if(returncode != SQL_SUCCESS)
LogAllErrors(pTestInfo->henv, pTestInfo->hdbc, pTestInfo->hstmt);
returncode = SQLExecute(pTestInfo->hstmt);
sprintf(tempStr, "Starting test number %d\n", i);
TESTCASE_BEGIN(tempStr);
if(testData[i].cursor == TRUE)
sprintf(tempStr, "INFOSTATS %s%s%s", testData[i].front, cursorName, testData[i].back);
else
sprintf(tempStr, "INFOSTATS %s%s%s", testData[i].front, testData[i].stmt, testData[i].back);
returncode = execute(pTestInfo, secHandle, tempStr, testData[i].retcode);
if(returncode == FALSE)
TEST_FAILED;
returncode = SQLFreeStmt(secHandle, SQL_CLOSE);
returncode = SQLFreeStmt(pTestInfo->hstmt,SQL_CLOSE);
TESTCASE_END;
i++;
}
returncode = SQLExecDirect(pTestInfo->hstmt, (SQLCHAR*)strs[0], SQL_NTS);
}
//==========================================================================================
FullDisconnect3(pTestInfo);
free_list(var_list);
LogMsg(SHORTTIMESTAMP+LINEAFTER,"End testing => InfoStats.\n");
TEST_RETURN;
}
