0000 000f DEBUG [query sent]: \x01\x04\x00\x00\x00\x0f\xb0\x0e DEBUG [response received]: \x01\x04\x1e\x00\x02\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x01\xc2\x00\x00\x02\xda\x00\x00\x00\x00\x1a\xac DEBUG [data]: \x00\x02\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x01\xc2\x00\x00\x02\xda\x00\x00\x00\x00 Array ( [0] => 00 [1] => 02 [2] => 00 [3] => 00 [4] => 00 [5] => 00 [6] => 00 [7] => 00 [8] => 00 [9] => 00 [10] => 00 [11] => 00 [12] => 00 [13] => 00 [14] => 00 [15] => 00 [16] => 00 [17] => 00 [18] => 00 [19] => 00 [20] => 01 [21] => c2 [22] => 00 [23] => 00 [24] => 02 [25] => da [26] => 00 [27] => 00 [28] => 00 [29] => 00 ) 000f 000f DEBUG [query sent]: \x01\x04\x00\x0f\x00\x0f\x80\x0d DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x00\x0a\x50\x00\x64\x09\x37\x04\xca\x17\x72\x04\xb0\x17\x72\x00\x00\x00\xfc\x01\x0e\x00\x18\x00\x00\x00\x00\x42\xd6 DEBUG [data]: \x00\x00\x00\x00\x0a\x50\x00\x64\x09\x37\x04\xca\x17\x72\x04\xb0\x17\x72\x00\x00\x00\xfc\x01\x0e\x00\x18\x00\x00\x00\x00 Array ( [0] => 00 [1] => 00 [2] => 00 [3] => 00 [4] => 0a [5] => 50 [6] => 00 [7] => 64 [8] => 09 [9] => 37 [10] => 04 [11] => ca [12] => 17 [13] => 72 [14] => 04 [15] => b0 [16] => 17 [17] => 72 [18] => 00 [19] => 00 [20] => 00 [21] => fc [22] => 01 [23] => 0e [24] => 00 [25] => 18 [26] => 00 [27] => 00 [28] => 00 [29] => 00 ) 001e 000f DEBUG [query sent]: \x01\x04\x00\x1e\x00\x0f\xd0\x08 DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x00\x00\x00\x00\x00\x00\x06\x00\x0d\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x4e\x25\x66\x8e DEBUG [data]: \x00\x00\x00\x00\x00\x00\x00\x00\x00\x06\x00\x0d\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x4e\x25 Array ( [0] => 00 [1] => 00 [2] => 00 [3] => 00 [4] => 00 [5] => 00 [6] => 00 [7] => 00 [8] => 00 [9] => 06 [10] => 00 [11] => 0d [12] => 00 [13] => 00 [14] => 00 [15] => 00 [16] => 00 [17] => 00 [18] => 00 [19] => 00 [20] => 00 [21] => 00 [22] => 00 [23] => 00 [24] => 00 [25] => 00 [26] => 00 [27] => 00 [28] => 4e [29] => 25 ) 002d 000f DEBUG [query sent]: \x01\x04\x00\x2d\x00\x0f\x20\x07 DEBUG [response received]: \x01\x04\x1e\x00\x01\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x2b\xde\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\xb7\x1c\x9f\x01 DEBUG [crc check failed]: (expected \x2c\x70 received \x9f\x01) 0 003c 000f DEBUG [query sent]: \x01\x04\x00\x3c\x00\x0f\x70\x02 DEBUG [response received]: \x DEBUG [no response] 0 004b 000f DEBUG [query sent]: \x01\x04\x00\x4b\x00\x0f\xc0\x18 DEBUG [response received]: \x01\x04\x1e\x00\x00\x02\x44\x00\x00\x02\x26\x00\x00\x00\x00\x00\x00\x00\x11\x00\x00\x00\x16\x00\x00\x00\x00\x00\x00\x2e\x00\x00\x00\xc5\x5f DEBUG [data]: \x00\x00\x02\x44\x00\x00\x02\x26\x00\x00\x00\x00\x00\x00\x00\x11\x00\x00\x00\x16\x00\x00\x00\x00\x00\x00\x2e\x00\x00\x00 Array ( [0] => 00 [1] => 00 [2] => 02 [3] => 44 [4] => 00 [5] => 00 [6] => 02 [7] => 26 [8] => 00 [9] => 00 [10] => 00 [11] => 00 [12] => 00 [13] => 00 [14] => 00 [15] => 11 [16] => 00 [17] => 00 [18] => 00 [19] => 16 [20] => 00 [21] => 00 [22] => 00 [23] => 00 [24] => 00 [25] => 00 [26] => 2e [27] => 00 [28] => 00 [29] => 00 ) 005a 000f DEBUG [query sent]: \x01\x04\x00\x5a\x00\x0f\x90\x1d DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x01\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x24\xbc DEBUG [data]: \x00\x00\x00\x01\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00 Array ( [0] => 00 [1] => 00 [2] => 00 [3] => 01 [4] => 00 [5] => 00 [6] => 00 [7] => 00 [8] => 00 [9] => 00 [10] => 00 [11] => 00 [12] => 00 [13] => 00 [14] => 00 [15] => 00 [16] => 00 [17] => 00 [18] => 00 [19] => 00 [20] => 00 [21] => 00 [22] => 00 [23] => 00 [24] => 00 [25] => 00 [26] => 00 [27] => 00 [28] => 00 [29] => 00 ) 0069 000f DEBUG [query sent]: \x01\x04\x00\x69\x00\x0f\x60\x12 DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\xda\x3e DEBUG [data]: \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00 Array ( [0] => 00 [1] => 00 [2] => 00 [3] => 00 [4] => 00 [5] => 00 [6] => 00 [7] => 00 [8] => 00 [9] => 00 [10] => 00 [11] => 00 [12] => 00 [13] => 00 [14] => 00 [15] => 00 [16] => 00 [17] => 00 [18] => 00 [19] => 00 [20] => 00 [21] => 00 [22] => 00 [23] => 00 [24] => 00 [25] => 00 [26] => 00 [27] => 00 [28] => 00 [29] => 00 ) 0078 000f DEBUG [query sent]: \x01\x04\x00\x78\x00\x0f\x30\x17 DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\xda\x3e DEBUG [data]: \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00 Array ( [0] => 00 [1] => 00 [2] => 00 [3] => 00 [4] => 00 [5] => 00 [6] => 00 [7] => 00 [8] => 00 [9] => 00 [10] => 00 [11] => 00 [12] => 00 [13] => 00 [14] => 00 [15] => 00 [16] => 00 [17] => 00 [18] => 00 [19] => 00 [20] => 00 [21] => 00 [22] => 00 [23] => 00 [24] => 00 [25] => 00 [26] => 00 [27] => 00 [28] => 00 [29] => 00 ) 0087 000f DEBUG [query sent]: \x01\x04\x00\x87\x00\x0f\x00\x27 DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\xda\x3e DEBUG [data]: \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00 Array ( [0] => 00 [1] => 00 [2] => 00 [3] => 00 [4] => 00 [5] => 00 [6] => 00 [7] => 00 [8] => 00 [9] => 00 [10] => 00 [11] => 00 [12] => 00 [13] => 00 [14] => 00 [15] => 00 [16] => 00 [17] => 00 [18] => 00 [19] => 00 [20] => 00 [21] => 00 [22] => 00 [23] => 00 [24] => 00 [25] => 00 [26] => 00 [27] => 00 [28] => 00 [29] => 00 ) 0096 000f DEBUG [query sent]: \x01\x04\x00\x96\x00\x0f\x50\x22 DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\xda\x3e DEBUG [data]: \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00 Array ( [0] => 00 [1] => 00 [2] => 00 [3] => 00 [4] => 00 [5] => 00 [6] => 00 [7] => 00 [8] => 00 [9] => 00 [10] => 00 [11] => 00 [12] => 00 [13] => 00 [14] => 00 [15] => 00 [16] => 00 [17] => 00 [18] => 00 [19] => 00 [20] => 00 [21] => 00 [22] => 00 [23] => 00 [24] => 00 [25] => 00 [26] => 00 [27] => 00 [28] => 00 [29] => 00 ) 00a5 000f DEBUG [query sent]: \x01\x04\x00\xa5\x00\x0f\xa0\x2d DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\xda\x3e DEBUG [data]: \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00 Array ( [0] => 00 [1] => 00 [2] => 00 [3] => 00 [4] => 00 [5] => 00 [6] => 00 [7] => 00 [8] => 00 [9] => 00 [10] => 00 [11] => 00 [12] => 00 [13] => 00 [14] => 00 [15] => 00 [16] => 00 [17] => 00 [18] => 00 [19] => 00 [20] => 00 [21] => 00 [22] => 00 [23] => 00 [24] => 00 [25] => 00 [26] => 00 [27] => 00 [28] => 00 [29] => 00 ) 00b4 000f DEBUG [query sent]: \x01\x04\x00\xb4\x00\x0f\xf0\x28 DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x04\x01\x24\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\xad\x0b DEBUG [data]: \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x04\x01\x24\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00 Array ( [0] => 00 [1] => 00 [2] => 00 [3] => 00 [4] => 00 [5] => 00 [6] => 00 [7] => 00 [8] => 00 [9] => 00 [10] => 00 [11] => 00 [12] => 00 [13] => 00 [14] => 00 [15] => 00 [16] => 04 [17] => 01 [18] => 24 [19] => 00 [20] => 00 [21] => 00 [22] => 00 [23] => 00 [24] => 00 [25] => 00 [26] => 00 [27] => 00 [28] => 00 [29] => 00 ) 00c3 000f DEBUG [query sent]: \x01\x04\x00\xc3\x00\x0f\x40\x32 DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\xda\x3e DEBUG [data]: \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00 Array ( [0] => 00 [1] => 00 [2] => 00 [3] => 00 [4] => 00 [5] => 00 [6] => 00 [7] => 00 [8] => 00 [9] => 00 [10] => 00 [11] => 00 [12] => 00 [13] => 00 [14] => 00 [15] => 00 [16] => 00 [17] => 00 [18] => 00 [19] => 00 [20] => 00 [21] => 00 [22] => 00 [23] => 00 [24] => 00 [25] => 00 [26] => 00 [27] => 00 [28] => 00 [29] => 00 ) 00d2 000f DEBUG [query sent]: \x01\x04\x00\xd2\x00\x0f\x10\x37 DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x48\x00\x00\x00\x00\x00\x00\x4e\x00\x00\x01\x00\x00\x00\x00\x00\xde\x9f\x91 DEBUG [data]: \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x48\x00\x00\x00\x00\x00\x00\x4e\x00\x00\x01\x00\x00\x00\x00\x00\xde Array ( [0] => 00 [1] => 00 [2] => 00 [3] => 00 [4] => 00 [5] => 00 [6] => 00 [7] => 00 [8] => 00 [9] => 00 [10] => 00 [11] => 00 [12] => 00 [13] => 48 [14] => 00 [15] => 00 [16] => 00 [17] => 00 [18] => 00 [19] => 00 [20] => 4e [21] => 00 [22] => 00 [23] => 01 [24] => 00 [25] => 00 [26] => 00 [27] => 00 [28] => 00 [29] => de ) Array ( [0] => 0002 [1] => 0000 [2] => 0000 [3] => 0000 [4] => 0000 [5] => 0000 [6] => 0000 [7] => 0000 [8] => 0000 [9] => 0000 [10] => 01c2 [11] => 0000 [12] => 02da [13] => 0000 [14] => 0000 [15] => 0000 [16] => 0000 [17] => 0a50 [18] => 0064 [19] => 0937 [20] => 04ca [21] => 1772 [22] => 04b0 [23] => 1772 [24] => 0000 [25] => 00fc [26] => 010e [27] => 0018 [28] => 0000 [29] => 0000 [30] => 0000 [31] => 0000 [32] => 0000 [33] => 0000 [34] => 0006 [35] => 000d [36] => 0000 [37] => 0000 [38] => 0000 [39] => 0000 [40] => 0000 [41] => 0000 [42] => 0000 [43] => 0000 [44] => 4e25 [45] => [46] => [47] => [48] => [49] => [50] => [51] => [52] => [53] => [54] => [55] => [56] => [57] => [58] => [59] => [60] => [61] => [62] => [63] => [64] => [65] => [66] => [67] => [68] => [69] => [70] => [71] => [72] => [73] => [74] => [75] => 0000 [76] => 0244 [77] => 0000 [78] => 0226 [79] => 0000 [80] => 0000 [81] => 0000 [82] => 0011 [83] => 0000 [84] => 0016 [85] => 0000 [86] => 0000 [87] => 0000 [88] => 2e00 [89] => 0000 [90] => 0000 [91] => 0001 [92] => 0000 [93] => 0000 [94] => 0000 [95] => 0000 [96] => 0000 [97] => 0000 [98] => 0000 [99] => 0000 [100] => 0000 [101] => 0000 [102] => 0000 [103] => 0000 [104] => 0000 [105] => 0000 [106] => 0000 [107] => 0000 [108] => 0000 [109] => 0000 [110] => 0000 [111] => 0000 [112] => 0000 [113] => 0000 [114] => 0000 [115] => 0000 [116] => 0000 [117] => 0000 [118] => 0000 [119] => 0000 [120] => 0000 [121] => 0000 [122] => 0000 [123] => 0000 [124] => 0000 [125] => 0000 [126] => 0000 [127] => 0000 [128] => 0000 [129] => 0000 [130] => 0000 [131] => 0000 [132] => 0000 [133] => 0000 [134] => 0000 [135] => 0000 [136] => 0000 [137] => 0000 [138] => 0000 [139] => 0000 [140] => 0000 [141] => 0000 [142] => 0000 [143] => 0000 [144] => 0000 [145] => 0000 [146] => 0000 [147] => 0000 [148] => 0000 [149] => 0000 [150] => 0000 [151] => 0000 [152] => 0000 [153] => 0000 [154] => 0000 [155] => 0000 [156] => 0000 [157] => 0000 [158] => 0000 [159] => 0000 [160] => 0000 [161] => 0000 [162] => 0000 [163] => 0000 [164] => 0000 [165] => 0000 [166] => 0000 [167] => 0000 [168] => 0000 [169] => 0000 [170] => 0000 [171] => 0000 [172] => 0000 [173] => 0000 [174] => 0000 [175] => 0000 [176] => 0000 [177] => 0000 [178] => 0000 [179] => 0000 [180] => 0000 [181] => 0000 [182] => 0000 [183] => 0000 [184] => 0000 [185] => 0000 [186] => 0000 [187] => 0000 [188] => 0401 [189] => 2400 [190] => 0000 [191] => 0000 [192] => 0000 [193] => 0000 [194] => 0000 [195] => 0000 [196] => 0000 [197] => 0000 [198] => 0000 [199] => 0000 [200] => 0000 [201] => 0000 [202] => 0000 [203] => 0000 [204] => 0000 [205] => 0000 [206] => 0000 [207] => 0000 [208] => 0000 [209] => 0000 [210] => 0000 [211] => 0000 [212] => 0000 [213] => 0000 [214] => 0000 [215] => 0000 [216] => 0048 [217] => 0000 [218] => 0000 [219] => 0000 [220] => 4e00 [221] => 0001 [222] => 0000 [223] => 0000 [224] => 00de ) string(1004) "0002,0000,0000,0000,0000,0000,0000,0000,0000,0000,01c2,0000,02da,0000,0000,0000,0000,0a50,0064,0937,04ca,1772,04b0,1772,0000,00fc,010e,0018,0000,0000,0000,0000,0000,0000,0006,000d,0000,0000,0000,0000,0000,0000,0000,0000,4e25,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0000,0244,0000,0226,0000,0000,0000,0011,0000,0016,0000,0000,0000,2e00,0000,0000,0001,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0401,2400,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0048,0000,0000,0000,4e00,0001,0000,0000,00de"
CREATE TABLE if not exists irx (serial text, dt text, csv text, PRIMARY KEY(serial, dt))
insert or replace into irx values('UKDGBMF010', datetime('now', 'localtime'), '0002,0000,0000,0000,0000,0000,0000,0000,0000,0000,01c2,0000,02da,0000,0000,0000,0000,0a50,0064,0937,04ca,1772,04b0,1772,0000,00fc,010e,0018,0000,0000,0000,0000,0000,0000,0006,000d,0000,0000,0000,0000,0000,0000,0000,0000,4e25,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0000,0244,0000,0226,0000,0000,0000,0011,0000,0016,0000,0000,0000,2e00,0000,0000,0001,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0401,2400,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0000,0048,0000,0000,0000,4e00,0001,0000,0000,00de')