public static void Test_bulk_operation()
{
short operation = 0, res = 0;
MarshalManage mb_int = new MarshalManage(4);
MarshalManage mb_indicator = new MarshalManage(4);
MarshalManage mb_data = new MarshalManage(16);
st_odbc_record record2 = new st_odbc_record();
record2.indicator_ptr = mb_indicator.buffer;
record2.data_ptr = mb_data.buffer;
record2.table_name = "test";
record2.record_number = 1;
MarshalManage mb_record2 = new MarshalManage(record2);
st_odbc_record record = new st_odbc_record();
record.indicator_ptr = mb_indicator.buffer;
record.data_ptr = mb_data.buffer;
record.next = mb_record2.buffer;
MarshalManage mb_record = new MarshalManage(record);
st_odbc_connection conn = new st_odbc_connection();
MarshalManage mb_conn = new MarshalManage(conn);
st_odbc_statement statement = new st_odbc_statement();
statement.conn = mb_conn.buffer;
st_odbc_desc desc = new st_odbc_desc();
desc.rows_processed_ptr = mb_int.buffer;
desc.max_count = 1;
desc.array_size = 1;
desc.records = mb_record.buffer;
MarshalManage mb_array_status_ptr = new MarshalManage(16);
desc.array_status_ptr = mb_array_status_ptr.buffer;
MarshalManage mb_desc = new MarshalManage(desc);
statement.apd = mb_desc.buffer;
statement.ipd = mb_desc.buffer;
statement.ard = mb_desc.buffer;
statement.ird = mb_desc.buffer;
res = SQLBulkOperations(ref statement, operation);
operation = 5;
res = SQLBulkOperations(ref statement, operation);
operation = 4;
res = SQLBulkOperations(ref statement, operation);
operation = 6;
res = SQLBulkOperations(ref statement, operation);
operation = 7;
res = SQLBulkOperations(ref statement, operation);
}
/// <summary>
/// Test OdbcTransaction class
/// </summary>
public static void Test_GetData()
{
StringBuilder sb_length = new StringBuilder(16);
st_odbc_statement odbc_statement = new st_odbc_statement();
odbc_statement.attr_simulate_cursor = 123456;
//SQLGetData(ref odbc_statement, 1, 1, "12",16,sb_length);
}
/// <summary>
/// Test OdbcInterface class
/// </summary>
public static void Test_GetData()
{
StringBuilder sb_length = new StringBuilder(16);
st_odbc_statement odbc_statement = new st_odbc_statement();
odbc_statement.attr_simulate_cursor = 123456;
//SQLGetData(ref odbc_statement, 1, 1, "12",16,sb_length);
}
public static void Test_bulk_operation()
{
short operation=0,res =0;
MarshalManage mb_int = new MarshalManage(4);
MarshalManage mb_indicator = new MarshalManage(4);
MarshalManage mb_data = new MarshalManage(16);
st_odbc_record record2 = new st_odbc_record();
record2.indicator_ptr = mb_indicator.buffer;
record2.data_ptr = mb_data.buffer;
record2.table_name = "test";
record2.record_number = 1;
MarshalManage mb_record2 = new MarshalManage(record2);
st_odbc_record record = new st_odbc_record();
record.indicator_ptr =mb_indicator.buffer;
record.data_ptr = mb_data.buffer;
record.next = mb_record2.buffer;
MarshalManage mb_record= new MarshalManage(record);
st_odbc_connection conn = new st_odbc_connection();
MarshalManage mb_conn = new MarshalManage(conn);
st_odbc_statement statement = new st_odbc_statement();
statement.conn = mb_conn.buffer;
st_odbc_desc desc = new st_odbc_desc();
desc.rows_processed_ptr = mb_int.buffer;
desc.max_count = 1;
desc.array_size = 1;
desc.records = mb_record.buffer;
MarshalManage mb_array_status_ptr= new MarshalManage(16);
desc.array_status_ptr = mb_array_status_ptr.buffer;
MarshalManage mb_desc = new MarshalManage(desc);
statement.apd = mb_desc.buffer;
statement.ipd = mb_desc.buffer;
statement.ard = mb_desc.buffer;
statement.ird = mb_desc.buffer;
res = SQLBulkOperations(ref statement, operation);
operation = 5;
res = SQLBulkOperations(ref statement, operation);
operation = 4;
res = SQLBulkOperations(ref statement, operation);
operation = 6;
res = SQLBulkOperations(ref statement, operation);
operation = 7;
res = SQLBulkOperations(ref statement, operation);
}
public static void Test_GetDiagField()
{
StringBuilder sb_length = new StringBuilder(64);
StringBuilder sb_diagInfo = new StringBuilder(64);
//env
st_odbc_env odbc_env = new st_odbc_env();
st_diag_record record = new st_diag_record();
record.number = 1;
record.sql_state = "IM";
record.native_code = 1;
MarshalManage mb_record = new MarshalManage(record);
st_diag diag = new st_diag();
diag.record = mb_record.buffer;
MarshalManage mb_diag = new MarshalManage(diag);
odbc_env.diag = mb_diag.buffer;
//statement
st_odbc_statement statement = new st_odbc_statement();
statement.current_tpl_pos = 1;
st_diag_record record_s = new st_diag_record();
record_s.number = 1;
record_s.sql_state = "IM";
record_s.native_code = 1;
MarshalManage mb_record_s = new MarshalManage(record_s);
st_diag diag_s = new st_diag();
diag_s.record = mb_record_s.buffer;
diag_s.rec_number = 1;
diag_s.retcode = 2;
MarshalManage mb_diag_s = new MarshalManage(diag_s);
statement.diag = mb_diag_s.buffer;
int res = 0;
//SQL_DIAG_ROW_COUNT 3
res = SQLGetDiagField_s(1, ref statement, 1, 3, sb_diagInfo, 16, sb_length);
Assert.IsTrue(res == -1);
//SQL_DIAG_CURSOR_ROW_COUNT -1249
res = SQLGetDiagField_s(1, ref statement, 1, -1249, sb_diagInfo, 16, sb_length);
Assert.IsTrue(res == -1);
//SQL_DIAG_NUMBER 2
res = SQLGetDiagField_s(1, ref statement, 1, 1, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 2);
//SQL_DIAG_RETURNCODE 1
res = SQLGetDiagField_s(1, ref statement, 1, 2, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 1);
//SQL_DIAG_CLASS_ORIGIN 8
res = SQLGetDiagField_s(1, ref statement, 1, 8, sb_diagInfo, 0, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 1);
//SQL_DIAG_COLUMN_NUMBER -1247
res = SQLGetDiagField_s(1, ref statement, 1, -1247, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 63);
//SQL_DIAG_CONNECTION_NAME 10
res = SQLGetDiagField_s(1, ref statement, 1, 10, sb_diagInfo, 16, sb_length);
Assert.IsTrue(res == 0);
res = SQLGetDiagField_s(1, ref statement, 1, 10, sb_diagInfo, 0, sb_length);
//SQL_DIAG_MESSAGE_TEXT 6
res = SQLGetDiagField_s(1, ref statement, 1, 6, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 91);
res = SQLGetDiagField_s(1, ref statement, 1, 6, sb_diagInfo, 0, sb_length);
//SQL_DIAG_NATIVE 5
res = SQLGetDiagField_s(1, ref statement, 1, 5, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 1);
//SQL_DIAG_ROW_NUMBER -1248
res = SQLGetDiagField_s(1, ref statement, 1, -1248, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 63);
//SQL_DIAG_SERVER_NAME 11
res = SQLGetDiagField_s(1, ref statement, 1, 11, sb_diagInfo, 0, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 63);
}
public static extern short SQLGetDiagField_s(short HandleType,
ref st_odbc_statement env,
short RecNumber,
short DiagIdentifier,
StringBuilder DiagInfo,
short BufferLength, StringBuilder StringLength);
public static void Test_SetStmtAttr()
{
Int32 length = 4;
Int32 sb_value = 0;
st_odbc_statement statement = new st_odbc_statement();
int res = 0,success=0,attrid=0;
//SQL_ATTR_APP_PARAM_DESC 10011
statement.apd = new IntPtr(0);
statement.i_apd = new IntPtr(1);
Assert.IsTrue(statement.apd != statement.i_apd);
sb_value = 2;
res = SQLSetStmtAttr(ref statement, 10011, sb_value, length);
Assert.IsTrue(statement.apd != statement.i_apd);
statement.apd = new IntPtr(0);
statement.i_apd = new IntPtr(1);
sb_value = 0;
res = SQLSetStmtAttr(ref statement, 10011, 0, 0);
Assert.IsTrue(statement.apd == statement.i_apd);
//SQL_ATTR_APP_ROW_DESC 10010
statement.ard = new IntPtr(0);
statement.i_ard = new IntPtr(1);
sb_value = 2;
Assert.IsTrue(statement.ard != statement.i_ard);
res = SQLSetStmtAttr(ref statement, 10010, sb_value, length);
Assert.IsTrue(statement.ard != statement.i_ard);
statement.ard = new IntPtr(0);
statement.i_ard = new IntPtr(1);
sb_value = 0;
res = SQLSetStmtAttr(ref statement, 10010, 0, 0);
Assert.IsTrue(statement.ard == statement.i_ard);
//SQL_ATTR_ASYNC_ENABLE 4
sb_value = 0;
res = SQLSetStmtAttr(ref statement, 4, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 3;//error:default
res = SQLSetStmtAttr(ref statement, 4, sb_value, length);
Assert.IsTrue(res != success);
//SQL_ATTR_CURSOR_SENSITIVITY -2
attrid = -2;
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 1;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 2;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 3;//error:default
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
//SQL_ATTR_CURSOR_SCROLLABLE -1
attrid = -1;
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 1;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 3;//error:default
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
//SQL_ATTR_CURSOR_TYPE 6
attrid = 6;
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 1;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 3;
statement.attr_concurrency = 1;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
statement.attr_concurrency = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 4;//error:default
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
//SQL_ATTR_FETCH_BOOKMARK_PTR 16
attrid = 16;
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_IMP_PARAM_DESC 10013
attrid = 10013;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
// SQL_ATTR_IMP_ROW_DESC 10012
attrid = 10012;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
//SQL_ATTR_METADATA_ID 10014
attrid = 10014;
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 1;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 3;//error:default
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
st_odbc_desc desc = new st_odbc_desc();
MarshalManage mb_desc = new MarshalManage(desc);
statement.apd = mb_desc.buffer;
statement.ipd = mb_desc.buffer;
statement.ard = mb_desc.buffer;
statement.ird = mb_desc.buffer;
//SQL_ATTR_PARAM_BIND_OFFSET_PTR 17
attrid = 17;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_BIND_TYPE 18
attrid = 18;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_OPERATION_PTR 19
attrid = 19;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_STATUS_PTR 20
attrid = 20;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAMS_PROCESSED_PTR 21
attrid = 21;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAMSET_SIZE 22
attrid = 22;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_ARRAY_SIZE 27
attrid = 27;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_BIND_OFFSET_PTR 23
attrid = 23;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_BIND_TYPE 5
attrid = 5;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_STATUS_PTR 25
attrid = 25;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_OPERATION_PTR 24
attrid = 24;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROWS_FETCHED_PTR 26
attrid = 26;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_NUMBER 14
attrid = 14;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
//default -10000
attrid = -10000;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
}
public static extern short SQLSetStmtAttr(ref st_odbc_statement ConnectionHandle,
int Attribute,
Int32 Value, Int32 StringLength);
public static void Test_GetStmtAttr()
{
MarshalManage sb_length = new MarshalManage(64);
StringBuilder sb_value = new StringBuilder(64);
st_odbc_desc desc = new st_odbc_desc();
MarshalManage mb_desc = new MarshalManage(desc);
st_odbc_statement statement = new st_odbc_statement();
int res = 0,error=-1,success=0;
//value == null
res = SQLGetStmtAttr(ref statement, 1, null, 64, sb_length.buffer);
Assert.IsTrue(res == error);
//default
res = SQLGetStmtAttr(ref statement, -10000, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == error);
//SQL_ATTR_APP_PARAM_DESC 10011
res = SQLGetStmtAttr(ref statement, 10011, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_APP_ROW_DESC 10010
res = SQLGetStmtAttr(ref statement, 10010, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_IMP_PARAM_DESC 10013
res = SQLGetStmtAttr(ref statement, 10013, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_IMP_ROW_DESC 10012
res = SQLGetStmtAttr(ref statement, 10012, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
statement.apd = mb_desc.buffer;
statement.ipd = mb_desc.buffer;
statement.ard = mb_desc.buffer;
statement.ird = mb_desc.buffer;
//SQL_ATTR_ASYNC_ENABLE 4
statement.attr_async_enable = 1;
res = SQLGetStmtAttr(ref statement, 4, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 1);
//SQL_ATTR_CURSOR_SCROLLABLE -1
statement.attr_cursor_scrollable = 2;
res = SQLGetStmtAttr(ref statement, -1, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 2);
//SQL_ATTR_METADATA_ID 10014
statement.attr_metadata_id = 3;
res = SQLGetStmtAttr(ref statement, 10014, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 3);
//SQL_ATTR_PARAM_BIND_OFFSET_PTR 17
res = SQLGetStmtAttr(ref statement, 17, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_BIND_TYPE 18
res = SQLGetStmtAttr(ref statement, 18, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_OPERATION_PTR 19
res = SQLGetStmtAttr(ref statement, 19, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_STATUS_PTR 20
res = SQLGetStmtAttr(ref statement, 20, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAMS_PROCESSED_PTR 21
res = SQLGetStmtAttr(ref statement, 21, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAMSET_SIZE 22
res = SQLGetStmtAttr(ref statement, 22, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_RETRIEVE_DATA 11
res = SQLGetStmtAttr(ref statement, 11, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 1);
//SQL_ATTR_ROW_ARRAY_SIZE 27
res = SQLGetStmtAttr(ref statement, 27, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_BIND_OFFSET_PTR 23
res = SQLGetStmtAttr(ref statement, 23, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_BIND_TYPE 5
res = SQLGetStmtAttr(ref statement, 5, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_STATUS_PTR 25
res = SQLGetStmtAttr(ref statement, 25, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_OPERATION_PTR 24
res = SQLGetStmtAttr(ref statement, 24, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROWS_FETCHED_PTR 26
res = SQLGetStmtAttr(ref statement, 26, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_NUMBER 14
statement.current_tpl_pos = 0;
res = SQLGetStmtAttr(ref statement, 14, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
statement.current_tpl_pos = 1;
res = SQLGetStmtAttr(ref statement, 14, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 1);
//SQL_ATTR_CURSOR_TYPE 6
statement.attr_cursor_type = 2;
res = SQLGetStmtAttr(ref statement, 6, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 2);
//SQL_ATTR_CONCURRENCY 7
statement.attr_concurrency = 7;
res = SQLGetStmtAttr(ref statement, 7, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 7);
//SQL_ATTR_CURSOR_SENSITIVITY -2
statement.attr_cursor_sensitivity = 2;
res = SQLGetStmtAttr(ref statement, -2, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 2);
//SQL_ATTR_ENABLE_AUTO_IPD 15
res = SQLGetStmtAttr(ref statement, 15, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_FETCH_BOOKMARK_PTR 16
res = SQLGetStmtAttr(ref statement, 16, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_KEYSET_SIZE 8
res = SQLGetStmtAttr(ref statement, 8, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_MAX_LENGTH 3
res = SQLGetStmtAttr(ref statement, 3, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_NOSCAN 2
res = SQLGetStmtAttr(ref statement, 2, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
Assert.IsTrue(sb_value.ToString()[0] == 1); // on
//SQL_ATTR_MAX_ROWS 1
res = SQLGetStmtAttr(ref statement, 1, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_QUERY_TIMEOUT 0
res = SQLGetStmtAttr(ref statement, 0, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_SIMULATE_CURSOR 10
res = SQLGetStmtAttr(ref statement, 10, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_USE_BOOKMARKS 12
statement.attr_use_bookmark = 12;
res = SQLGetStmtAttr(ref statement, 12, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 12);
}
public static extern short SQLSetStmtAttr(ref st_odbc_statement ConnectionHandle,
int Attribute,
Int32 Value, Int32 StringLength);
public static extern short SQLGetDiagField_s(short HandleType,
ref st_odbc_statement env,
short RecNumber,
short DiagIdentifier,
StringBuilder DiagInfo,
short BufferLength, StringBuilder StringLength);
public static extern int SQLGetData(
ref st_odbc_statement statement,
short ColumnNumber,
short TargetType,
string TargetValue,
int BufferLength, StringBuilder StrLen_or_Ind);
public static extern short SQLBulkOperations(ref st_odbc_statement statement, short operation);
public static extern short SQLBulkOperations(ref st_odbc_statement statement, short operation);
public static extern short SQLGetStmtAttr(ref st_odbc_statement ConnectionHandle,
int Attribute,
StringBuilder Value, Int32 BufferLength, IntPtr StringLength);
public static void Test_GetDiagField()
{
StringBuilder sb_length = new StringBuilder(64);
StringBuilder sb_diagInfo = new StringBuilder(64);
//env
st_odbc_env odbc_env = new st_odbc_env();
st_diag_record record = new st_diag_record();
record.number = 1;
record.sql_state = "IM";
record.native_code = 1;
MarshalManage mb_record = new MarshalManage(record);
st_diag diag = new st_diag();
diag.record = mb_record.buffer;
MarshalManage mb_diag = new MarshalManage(diag);
odbc_env.diag = mb_diag.buffer;
//statement
st_odbc_statement statement = new st_odbc_statement();
statement.current_tpl_pos = 1;
st_diag_record record_s = new st_diag_record();
record_s.number = 1;
record_s.sql_state = "IM";
record_s.native_code = 1;
MarshalManage mb_record_s = new MarshalManage(record_s);
st_diag diag_s = new st_diag();
diag_s.record = mb_record_s.buffer;
diag_s.rec_number = 1;
diag_s.retcode = 2;
MarshalManage mb_diag_s = new MarshalManage(diag_s);
statement.diag = mb_diag_s.buffer;
int res=0;
//SQL_DIAG_ROW_COUNT 3
res = SQLGetDiagField_s(1, ref statement, 1, 3, sb_diagInfo, 16, sb_length);
Assert.IsTrue(res == -1);
//SQL_DIAG_CURSOR_ROW_COUNT -1249
res = SQLGetDiagField_s(1, ref statement, 1, -1249, sb_diagInfo, 16, sb_length);
Assert.IsTrue(res == -1);
//SQL_DIAG_NUMBER 2
res = SQLGetDiagField_s(1, ref statement, 1, 1, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 2);
//SQL_DIAG_RETURNCODE 1
res = SQLGetDiagField_s(1, ref statement, 1,2, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 1);
//SQL_DIAG_CLASS_ORIGIN 8
res = SQLGetDiagField_s(1, ref statement, 1, 8, sb_diagInfo, 0, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 1);
//SQL_DIAG_COLUMN_NUMBER -1247
res = SQLGetDiagField_s(1, ref statement, 1, -1247, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 63);
//SQL_DIAG_CONNECTION_NAME 10
res = SQLGetDiagField_s(1, ref statement, 1, 10, sb_diagInfo, 16, sb_length);
Assert.IsTrue(res == 0);
res = SQLGetDiagField_s(1, ref statement, 1, 10, sb_diagInfo, 0, sb_length);
//SQL_DIAG_MESSAGE_TEXT 6
res = SQLGetDiagField_s(1, ref statement, 1, 6, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 91);
res = SQLGetDiagField_s(1, ref statement, 1, 6, sb_diagInfo, 0, sb_length);
//SQL_DIAG_NATIVE 5
res = SQLGetDiagField_s(1, ref statement, 1, 5, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 1);
//SQL_DIAG_ROW_NUMBER -1248
res = SQLGetDiagField_s(1, ref statement, 1, -1248, sb_diagInfo, 16, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 63);
//SQL_DIAG_SERVER_NAME 11
res = SQLGetDiagField_s(1, ref statement, 1, 11, sb_diagInfo, 0, sb_length);
Assert.IsTrue(sb_diagInfo.ToString()[0] == 63);
}
public static void Test_GetStmtAttr()
{
MarshalManage sb_length = new MarshalManage(64);
StringBuilder sb_value = new StringBuilder(64);
st_odbc_desc desc = new st_odbc_desc();
MarshalManage mb_desc = new MarshalManage(desc);
st_odbc_statement statement = new st_odbc_statement();
int res = 0, error = -1, success = 0;
//value == null
res = SQLGetStmtAttr(ref statement, 1, null, 64, sb_length.buffer);
Assert.IsTrue(res == error);
//default
res = SQLGetStmtAttr(ref statement, -10000, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == error);
//SQL_ATTR_APP_PARAM_DESC 10011
res = SQLGetStmtAttr(ref statement, 10011, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_APP_ROW_DESC 10010
res = SQLGetStmtAttr(ref statement, 10010, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_IMP_PARAM_DESC 10013
res = SQLGetStmtAttr(ref statement, 10013, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_IMP_ROW_DESC 10012
res = SQLGetStmtAttr(ref statement, 10012, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
statement.apd = mb_desc.buffer;
statement.ipd = mb_desc.buffer;
statement.ard = mb_desc.buffer;
statement.ird = mb_desc.buffer;
//SQL_ATTR_ASYNC_ENABLE 4
statement.attr_async_enable = 1;
res = SQLGetStmtAttr(ref statement, 4, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 1);
//SQL_ATTR_CURSOR_SCROLLABLE -1
statement.attr_cursor_scrollable = 2;
res = SQLGetStmtAttr(ref statement, -1, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 2);
//SQL_ATTR_METADATA_ID 10014
statement.attr_metadata_id = 3;
res = SQLGetStmtAttr(ref statement, 10014, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 3);
//SQL_ATTR_PARAM_BIND_OFFSET_PTR 17
res = SQLGetStmtAttr(ref statement, 17, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_BIND_TYPE 18
res = SQLGetStmtAttr(ref statement, 18, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_OPERATION_PTR 19
res = SQLGetStmtAttr(ref statement, 19, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_STATUS_PTR 20
res = SQLGetStmtAttr(ref statement, 20, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAMS_PROCESSED_PTR 21
res = SQLGetStmtAttr(ref statement, 21, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAMSET_SIZE 22
res = SQLGetStmtAttr(ref statement, 22, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_RETRIEVE_DATA 11
res = SQLGetStmtAttr(ref statement, 11, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 1);
//SQL_ATTR_ROW_ARRAY_SIZE 27
res = SQLGetStmtAttr(ref statement, 27, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_BIND_OFFSET_PTR 23
res = SQLGetStmtAttr(ref statement, 23, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_BIND_TYPE 5
res = SQLGetStmtAttr(ref statement, 5, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_STATUS_PTR 25
res = SQLGetStmtAttr(ref statement, 25, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_OPERATION_PTR 24
res = SQLGetStmtAttr(ref statement, 24, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROWS_FETCHED_PTR 26
res = SQLGetStmtAttr(ref statement, 26, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_NUMBER 14
statement.current_tpl_pos = 0;
res = SQLGetStmtAttr(ref statement, 14, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
statement.current_tpl_pos = 1;
res = SQLGetStmtAttr(ref statement, 14, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 1);
//SQL_ATTR_CURSOR_TYPE 6
statement.attr_cursor_type = 2;
res = SQLGetStmtAttr(ref statement, 6, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 2);
//SQL_ATTR_CONCURRENCY 7
statement.attr_concurrency = 7;
res = SQLGetStmtAttr(ref statement, 7, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 7);
//SQL_ATTR_CURSOR_SENSITIVITY -2
statement.attr_cursor_sensitivity = 2;
res = SQLGetStmtAttr(ref statement, -2, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 2);
//SQL_ATTR_ENABLE_AUTO_IPD 15
res = SQLGetStmtAttr(ref statement, 15, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_FETCH_BOOKMARK_PTR 16
res = SQLGetStmtAttr(ref statement, 16, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_KEYSET_SIZE 8
res = SQLGetStmtAttr(ref statement, 8, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_MAX_LENGTH 3
res = SQLGetStmtAttr(ref statement, 3, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_NOSCAN 2
res = SQLGetStmtAttr(ref statement, 2, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
Assert.IsTrue(sb_value.ToString()[0] == 1); // on
//SQL_ATTR_MAX_ROWS 1
res = SQLGetStmtAttr(ref statement, 1, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_QUERY_TIMEOUT 0
res = SQLGetStmtAttr(ref statement, 0, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_SIMULATE_CURSOR 10
res = SQLGetStmtAttr(ref statement, 10, sb_value, 64, sb_length.buffer);
Assert.IsTrue(res == success);
//SQL_ATTR_USE_BOOKMARKS 12
statement.attr_use_bookmark = 12;
res = SQLGetStmtAttr(ref statement, 12, sb_value, 64, sb_length.buffer);
Assert.IsTrue(sb_value.ToString()[0] == 12);
}
public static extern short SQLGetStmtAttr(ref st_odbc_statement ConnectionHandle,
int Attribute,
StringBuilder Value, Int32 BufferLength, IntPtr StringLength);
public static void Test_SetStmtAttr()
{
Int32 length = 4;
Int32 sb_value = 0;
st_odbc_statement statement = new st_odbc_statement();
int res = 0, success = 0, attrid = 0;
//SQL_ATTR_APP_PARAM_DESC 10011
statement.apd = new IntPtr(0);
statement.i_apd = new IntPtr(1);
Assert.IsTrue(statement.apd != statement.i_apd);
sb_value = 2;
res = SQLSetStmtAttr(ref statement, 10011, sb_value, length);
Assert.IsTrue(statement.apd != statement.i_apd);
statement.apd = new IntPtr(0);
statement.i_apd = new IntPtr(1);
sb_value = 0;
res = SQLSetStmtAttr(ref statement, 10011, 0, 0);
Assert.IsTrue(statement.apd == statement.i_apd);
//SQL_ATTR_APP_ROW_DESC 10010
statement.ard = new IntPtr(0);
statement.i_ard = new IntPtr(1);
sb_value = 2;
Assert.IsTrue(statement.ard != statement.i_ard);
res = SQLSetStmtAttr(ref statement, 10010, sb_value, length);
Assert.IsTrue(statement.ard != statement.i_ard);
statement.ard = new IntPtr(0);
statement.i_ard = new IntPtr(1);
sb_value = 0;
res = SQLSetStmtAttr(ref statement, 10010, 0, 0);
Assert.IsTrue(statement.ard == statement.i_ard);
//SQL_ATTR_ASYNC_ENABLE 4
sb_value = 0;
res = SQLSetStmtAttr(ref statement, 4, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 3;//error:default
res = SQLSetStmtAttr(ref statement, 4, sb_value, length);
Assert.IsTrue(res != success);
//SQL_ATTR_CURSOR_SENSITIVITY -2
attrid = -2;
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 1;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 2;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 3;//error:default
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
//SQL_ATTR_CURSOR_SCROLLABLE -1
attrid = -1;
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 1;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 3;//error:default
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
//SQL_ATTR_CURSOR_TYPE 6
attrid = 6;
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 1;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 3;
statement.attr_concurrency = 1;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
statement.attr_concurrency = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 4;//error:default
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
//SQL_ATTR_FETCH_BOOKMARK_PTR 16
attrid = 16;
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_IMP_PARAM_DESC 10013
attrid = 10013;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
// SQL_ATTR_IMP_ROW_DESC 10012
attrid = 10012;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
//SQL_ATTR_METADATA_ID 10014
attrid = 10014;
sb_value = 0;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 1;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
sb_value = 3;//error:default
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
st_odbc_desc desc = new st_odbc_desc();
MarshalManage mb_desc = new MarshalManage(desc);
statement.apd = mb_desc.buffer;
statement.ipd = mb_desc.buffer;
statement.ard = mb_desc.buffer;
statement.ird = mb_desc.buffer;
//SQL_ATTR_PARAM_BIND_OFFSET_PTR 17
attrid = 17;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_BIND_TYPE 18
attrid = 18;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_OPERATION_PTR 19
attrid = 19;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAM_STATUS_PTR 20
attrid = 20;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAMS_PROCESSED_PTR 21
attrid = 21;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_PARAMSET_SIZE 22
attrid = 22;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_ARRAY_SIZE 27
attrid = 27;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_BIND_OFFSET_PTR 23
attrid = 23;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_BIND_TYPE 5
attrid = 5;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_STATUS_PTR 25
attrid = 25;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_OPERATION_PTR 24
attrid = 24;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROWS_FETCHED_PTR 26
attrid = 26;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res == success);
//SQL_ATTR_ROW_NUMBER 14
attrid = 14;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
//default -10000
attrid = -10000;
res = SQLSetStmtAttr(ref statement, attrid, sb_value, length);
Assert.IsTrue(res != success);
}
public static extern int SQLGetData(
ref st_odbc_statement statement,
short ColumnNumber,
short TargetType,
string TargetValue,
int BufferLength, StringBuilder StrLen_or_Ind);