0000
000f
DEBUG [query sent]: \x01\x04\x00\x00\x00\x0f\xb0\x0e
DEBUG [response received]: \x04\x1e\x00\x02\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x01\xb8\x00\x00\x03\x20\x00\x00\x00\x00\xd8\x0b
DEBUG [crc check failed]: (expected \xe1\x9f received \xd8\x0b)
0
000f
000f
DEBUG [query sent]: \x01\x04\x00\x0f\x00\x0f\x80\x0d
DEBUG [response received]: \x01\xcc\x0c\x00\x00\x0a\x63\x64\x09\x48\x04\xcb\x17\x72\x04\xb2\x17\x70\x00\x00\x01\x13\x01\x25\x00\x1a\x00\x00\x00\x00\x45\x26\x01\x03\x1e\x00\x0d\x00\x25\x00\x15\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\xb2\xed
DEBUG [crc check failed]: (expected \x70\xd4 received \xb2\xed)
0
001e
000f
DEBUG [query sent]: \x01\x04\x00\x1e\x00\x0f\xd0\x08
DEBUG [response received]: \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 [crc check failed]: (expected \xf6\x4b received \x66\x8e)
0
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\x0a\xbc\x5d\x58
DEBUG [data]: \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\x0a\xbc
Array
(
[0] => 00
[1] => 01
[2] => 00
[3] => 00
[4] => 00
[5] => 00
[6] => 00
[7] => 00
[8] => 00
[9] => 00
[10] => 00
[11] => 00
[12] => 2b
[13] => de
[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] => 0a
[29] => bc
)
003c
000f
DEBUG [query sent]: \x01\x04\x00\x3c\x00\x0f\x70\x02
DEBUG [response received]: \x01\x04\x1e\x00\x00\x00\x00\x00\x00\x1f\x78\x00\x00\x00\x06\x00\x00\x0e\x3f\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x01\xd6\x91\x19
DEBUG [data]: \x00\x00\x00\x00\x00\x00\x1f\x78\x00\x00\x00\x06\x00\x00\x0e\x3f\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x01\xd6
Array
(
[0] => 00
[1] => 00
[2] => 00
[3] => 00
[4] => 00
[5] => 00
[6] => 1f
[7] => 78
[8] => 00
[9] => 00
[10] => 00
[11] => 06
[12] => 00
[13] => 00
[14] => 0e
[15] => 3f
[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] => 01
[29] => d6
)
004b
000f
DEBUG [query sent]: \x01\x04\x00\x4b\x00\x0f\xc0\x18
DEBUG [response received]: \x01\x04\x1e\x00\x00\x02\x26\x00\x00\x01\xfe\x00\x00\x00\x00\x00\x00\x00\x10\x00\x00\x00\x15\x00\x00\x00\x06\x00\x00\x30\x1a\x00\x00\xa6\x91
DEBUG [data]: \x00\x00\x02\x26\x00\x00\x01\xfe\x00\x00\x00\x00\x00\x00\x00\x10\x00\x00\x00\x15\x00\x00\x00\x06\x00\x00\x30\x1a\x00\x00
Array
(
[0] => 00
[1] => 00
[2] => 02
[3] => 26
[4] => 00
[5] => 00
[6] => 01
[7] => fe
[8] => 00
[9] => 00
[10] => 00
[11] => 00
[12] => 00
[13] => 00
[14] => 00
[15] => 10
[16] => 00
[17] => 00
[18] => 00
[19] => 15
[20] => 00
[21] => 00
[22] => 00
[23] => 06
[24] => 00
[25] => 00
[26] => 30
[27] => 1a
[28] => 00
[29] => 00
)
005a
000f
DEBUG [query sent]: \x01\x04\x00\x5a\x00\x0f\x90\x1d
DEBUG [response received]: \x01
DEBUG [no response]
0
0069
000f
DEBUG [query sent]: \x01\x04\x00\x69\x00\x0f\x60\x12
DEBUG [response received]: \x
DEBUG [no response]
0
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\x00\x00\x01\x00\x03\x00\x00\x00\x00\x00\xad\xd7
DEBUG [data]: \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x48\x00\x00\x00\x00\x00\x00\x00\x00\x01\x00\x03\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] => 48
[14] => 00
[15] => 00
[16] => 00
[17] => 00
[18] => 00
[19] => 00
[20] => 00
[21] => 00
[22] => 01
[23] => 00
[24] => 03
[25] => 00
[26] => 00
[27] => 00
[28] => 00
[29] => 00
)
Array
(
[0] =>
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
[6] =>
[7] =>
[8] =>
[9] =>
[10] =>
[11] =>
[12] =>
[13] =>
[14] =>
[15] =>
[16] =>
[17] =>
[18] =>
[19] =>
[20] =>
[21] =>
[22] =>
[23] =>
[24] =>
[25] =>
[26] =>
[27] =>
[28] =>
[29] =>
[30] =>
[31] =>
[32] =>
[33] =>
[34] =>
[35] =>
[36] =>
[37] =>
[38] =>
[39] =>
[40] =>
[41] =>
[42] =>
[43] =>
[44] =>
[45] => 0001
[46] => 0000
[47] => 0000
[48] => 0000
[49] => 0000
[50] => 0000
[51] => 2bde
[52] => 0000
[53] => 0000
[54] => 0000
[55] => 0000
[56] => 0000
[57] => 0000
[58] => 0000
[59] => 0abc
[60] => 0000
[61] => 0000
[62] => 0000
[63] => 1f78
[64] => 0000
[65] => 0006
[66] => 0000
[67] => 0e3f
[68] => 0000
[69] => 0000
[70] => 0000
[71] => 0000
[72] => 0000
[73] => 0000
[74] => 01d6
[75] => 0000
[76] => 0226
[77] => 0000
[78] => 01fe
[79] => 0000
[80] => 0000
[81] => 0000
[82] => 0010
[83] => 0000
[84] => 0015
[85] => 0000
[86] => 0006
[87] => 0000
[88] => 301a
[89] => 0000
[90] =>
[91] =>
[92] =>
[93] =>
[94] =>
[95] =>
[96] =>
[97] =>
[98] =>
[99] =>
[100] =>
[101] =>
[102] =>
[103] =>
[104] =>
[105] =>
[106] =>
[107] =>
[108] =>
[109] =>
[110] =>
[111] =>
[112] =>
[113] =>
[114] =>
[115] =>
[116] =>
[117] =>
[118] =>
[119] =>
[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] => 0000
[221] => 0100
[222] => 0300
[223] => 0000
[224] => 0000
)
string(824) ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0001,0000,0000,0000,0000,0000,2bde,0000,0000,0000,0000,0000,0000,0000,0abc,0000,0000,0000,1f78,0000,0006,0000,0e3f,0000,0000,0000,0000,0000,0000,01d6,0000,0226,0000,01fe,0000,0000,0000,0010,0000,0015,0000,0006,0000,301a,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,0000,0100,0300,0000,0000"
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'), ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,0001,0000,0000,0000,0000,0000,2bde,0000,0000,0000,0000,0000,0000,0000,0abc,0000,0000,0000,1f78,0000,0006,0000,0e3f,0000,0000,0000,0000,0000,0000,01d6,0000,0226,0000,01fe,0000,0000,0000,0010,0000,0015,0000,0006,0000,301a,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,0000,0100,0300,0000,0000')