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_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_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 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);
}
/// <summary>
/// Test OdbcTransaction class
/// </summary>
///
public static void Test_GetDescField()
{
StringBuilder sb_length = new StringBuilder(16);
StringBuilder sb_value = new StringBuilder(16);
st_odbc_desc odbc_descFiel = new st_odbc_desc();
st_odbc_record record = new st_odbc_record();
record.record_number = 1;
record.datetime_interval_code = 101;
//将托管内存转换为非托管内存
MarshalManage mb = new MarshalManage(record);
odbc_descFiel.records = mb.buffer;
odbc_descFiel.alloc_type = 1;
odbc_descFiel.array_size = 2;
odbc_descFiel.bind_type = 3;
odbc_descFiel.fetched_size = 5;
odbc_descFiel.handle_type = 6;
odbc_descFiel.max_count = 7;
//调用非托管方法
//SQL_DESC_ALLOC_TYPE 1099
SQLGetDescField(ref odbc_descFiel, 1, 1099, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.ToString()[0] == 1);
//SQL_DESC_ARRAY_SIZE 20
SQLGetDescField(ref odbc_descFiel, 1, 20, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.ToString()[0] == 2);
//SQL_DESC_ARRAY_STATUS_PTR 21
SQLGetDescField(ref odbc_descFiel, 1, 21, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_BIND_OFFSET_PTR 24
SQLGetDescField(ref odbc_descFiel, 1, 24, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_BIND_TYPE 25
SQLGetDescField(ref odbc_descFiel, 1, 25, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.ToString()[0] == 3);
//SQL_DESC_CASE_SENSITIVE 12
SQLGetDescField(ref odbc_descFiel, 1, 12, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_DATETIME_INTERVAL_CODE 1007
SQLGetDescField(ref odbc_descFiel, 1, 1007, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.ToString()[0] == 101);
//SQL_DESC_DATETIME_INTERVAL_PRECISION 26
SQLGetDescField(ref odbc_descFiel, 1, 26, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_DISPLAY_SIZE 6
SQLGetDescField(ref odbc_descFiel, 1, 6, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_FIXED_PREC_SCALE 9
SQLGetDescField(ref odbc_descFiel, 1, 9, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_COLUMN_LENGTH 3
SQLGetDescField(ref odbc_descFiel, 1, 3, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_LITERAL_PREFIX 27
SQLGetDescField(ref odbc_descFiel, 1, 27, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_LITERAL_SUFFIX 28
SQLGetDescField(ref odbc_descFiel, 1, 28, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_LOCAL_TYPE_NAME 29
SQLGetDescField(ref odbc_descFiel, 1, 29, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_NUM_PREC_RADIX 32
SQLGetDescField(ref odbc_descFiel, 1, 32, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_PARAMETER_TYPE 33
SQLGetDescField(ref odbc_descFiel, 1, 33, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_SEARCHABLE 13
SQLGetDescField(ref odbc_descFiel, 1, 13, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_TYPE 1002
SQLGetDescField(ref odbc_descFiel, 1, 1002, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_UNNAMED 1012
SQLGetDescField(ref odbc_descFiel, 1, 1012, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_ROWVER 35
SQLGetDescField(ref odbc_descFiel, 1, 35, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
}
public static extern short SQLGetDescField(
ref st_odbc_desc desc,
short RecNumber,
short FieldIdentifier,
StringBuilder Value,
int BufferLength, StringBuilder StrLen_or_Ind);
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 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);
}
/// <summary>
/// Test OdbcTransaction class
/// </summary>
///
public static void Test_GetDescField()
{
StringBuilder sb_length = new StringBuilder(16);
StringBuilder sb_value = new StringBuilder(16);
st_odbc_desc odbc_descFiel = new st_odbc_desc();
st_odbc_record record = new st_odbc_record();
record.record_number = 1;
record.datetime_interval_code = 101;
//将托管内存转换为非托管内存
MarshalManage mb = new MarshalManage(record);
odbc_descFiel.records = mb.buffer;
odbc_descFiel.alloc_type = 1;
odbc_descFiel.array_size = 2;
odbc_descFiel.bind_type = 3;
odbc_descFiel.fetched_size = 5;
odbc_descFiel.handle_type=6;
odbc_descFiel.max_count = 7;
//调用非托管方法
//SQL_DESC_ALLOC_TYPE 1099
SQLGetDescField(ref odbc_descFiel, 1, 1099, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.ToString()[0] == 1);
//SQL_DESC_ARRAY_SIZE 20
SQLGetDescField(ref odbc_descFiel, 1, 20, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.ToString()[0] == 2);
//SQL_DESC_ARRAY_STATUS_PTR 21
SQLGetDescField(ref odbc_descFiel, 1, 21, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_BIND_OFFSET_PTR 24
SQLGetDescField(ref odbc_descFiel, 1, 24, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_BIND_TYPE 25
SQLGetDescField(ref odbc_descFiel, 1, 25, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.ToString()[0] == 3);
//SQL_DESC_CASE_SENSITIVE 12
SQLGetDescField(ref odbc_descFiel, 1, 12, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_DATETIME_INTERVAL_CODE 1007
SQLGetDescField(ref odbc_descFiel, 1, 1007, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.ToString()[0] == 101);
//SQL_DESC_DATETIME_INTERVAL_PRECISION 26
SQLGetDescField(ref odbc_descFiel, 1, 26, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_DISPLAY_SIZE 6
SQLGetDescField(ref odbc_descFiel, 1, 6, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_FIXED_PREC_SCALE 9
SQLGetDescField(ref odbc_descFiel, 1, 9, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_COLUMN_LENGTH 3
SQLGetDescField(ref odbc_descFiel, 1, 3, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_LITERAL_PREFIX 27
SQLGetDescField(ref odbc_descFiel, 1, 27, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_LITERAL_SUFFIX 28
SQLGetDescField(ref odbc_descFiel, 1, 28, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_LOCAL_TYPE_NAME 29
SQLGetDescField(ref odbc_descFiel, 1, 29, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_NUM_PREC_RADIX 32
SQLGetDescField(ref odbc_descFiel, 1, 32, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_PARAMETER_TYPE 33
SQLGetDescField(ref odbc_descFiel, 1, 33, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_SEARCHABLE 13
SQLGetDescField(ref odbc_descFiel, 1, 13, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_TYPE 1002
SQLGetDescField(ref odbc_descFiel, 1, 1002, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_UNNAMED 1012
SQLGetDescField(ref odbc_descFiel, 1, 1012, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
//SQL_DESC_ROWVER 35
SQLGetDescField(ref odbc_descFiel, 1, 35, sb_value, 16, sb_length);
Assert.IsTrue(sb_value.Length == 0);
}
public static extern short SQLGetDescField(
ref st_odbc_desc desc,
short RecNumber,
short FieldIdentifier,
StringBuilder Value,
int BufferLength, StringBuilder StrLen_or_Ind);