예제 #1
0
        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);
        }
예제 #2
0
      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);
      }
예제 #3
0
        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);
        }
예제 #4
0
        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);
        }
예제 #5
0
        /// <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);
        }
예제 #6
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);