prosody
d4a534e6bd7c
tools/jabberd14sql2prosody.lua

Find changesets by keywords by author, files, the commit message, revision number or hash, or revset expression.

Software / code / prosody

Annotate

tools/jabberd14sql2prosody.lua @ 9758:d4a534e6bd7c

mod_mam: Handle expiry of messages that expire in the middle of the cut-off day
author Kim Alvefur <zash@zash.se>
date Sun, 06 Jan 2019 09:44:55 +0100
parent 6149:2ae6e9063e88
child 11681:e270d22b11d9
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
1 #!/usr/bin/env lua
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
2
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
3
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
4 do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
5
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
6
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
7 local _parse_sql_actions = { [0] =
5776
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
8 0, 1, 0, 1, 1, 2, 0, 2, 2, 0, 9, 2, 0, 10, 2, 0, 11, 2, 0, 13,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
9 2, 1, 2, 2, 1, 6, 3, 0, 3, 4, 3, 0, 3, 5, 3, 0, 3, 7, 3, 0,
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
10 3, 8, 3, 0, 3, 12, 4, 0, 2, 3, 7, 4, 0, 3, 8, 11
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
11 };
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
12
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
13 local _parse_sql_trans_keys = { [0] =
5776
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
14 0, 0, 45, 45, 10, 10, 42, 42, 10, 42, 10, 47, 82, 82,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
15 69, 69, 65, 65, 84, 84, 69, 69, 32, 32, 68, 84, 65,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
16 65, 84, 84, 65, 65, 66, 66, 65, 65, 83, 83, 69, 69,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
17 9, 47, 9, 96, 45, 45, 10, 10, 42, 42, 10, 42, 10, 47,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
18 10, 96, 10, 96, 9, 47, 9, 59, 45, 45, 10, 10, 42,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
19 42, 10, 42, 10, 47, 65, 65, 66, 66, 76, 76, 69, 69,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
20 32, 32, 73, 96, 70, 70, 32, 32, 78, 78, 79, 79, 84, 84,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
21 32, 32, 69, 69, 88, 88, 73, 73, 83, 83, 84, 84, 83,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
22 83, 32, 32, 96, 96, 10, 96, 10, 96, 32, 32, 40, 40,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
23 10, 10, 32, 41, 32, 32, 75, 96, 69, 69, 89, 89, 32, 32,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
24 96, 96, 10, 96, 10, 96, 10, 10, 82, 82, 73, 73, 77,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
25 77, 65, 65, 82, 82, 89, 89, 32, 32, 75, 75, 69, 69,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
26 89, 89, 32, 32, 78, 78, 73, 73, 81, 81, 85, 85, 69, 69,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
27 32, 32, 75, 75, 10, 96, 10, 96, 10, 10, 10, 59, 10,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
28 59, 82, 82, 79, 79, 80, 80, 32, 32, 84, 84, 65, 65,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
29 66, 66, 76, 76, 69, 69, 32, 32, 73, 73, 70, 70, 32, 32,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
30 69, 69, 88, 88, 73, 73, 83, 83, 84, 84, 83, 83, 32,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
31 32, 96, 96, 10, 96, 10, 96, 59, 59, 78, 78, 83, 83,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
32 69, 69, 82, 82, 84, 84, 32, 32, 73, 73, 78, 78, 84, 84,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
33 79, 79, 32, 32, 96, 96, 10, 96, 10, 96, 32, 32, 40,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
34 86, 10, 41, 32, 32, 86, 86, 65, 65, 76, 76, 85, 85,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
35 69, 69, 83, 83, 32, 32, 40, 40, 39, 78, 10, 92, 10, 92,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
36 41, 44, 44, 59, 32, 78, 48, 57, 41, 57, 48, 57, 41,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
37 57, 85, 85, 76, 76, 76, 76, 34, 116, 79, 79, 67, 67,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
38 75, 75, 32, 32, 84, 84, 65, 65, 66, 66, 76, 76, 69, 69,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
39 83, 83, 32, 32, 96, 96, 10, 96, 10, 96, 32, 32, 87,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
40 87, 82, 82, 73, 73, 84, 84, 69, 69, 69, 69, 84, 84,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
41 32, 32, 10, 59, 10, 59, 78, 83, 76, 76, 79, 79, 67, 67,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
42 75, 75, 32, 32, 84, 84, 65, 65, 66, 66, 76, 76, 69,
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
43 69, 83, 83, 69, 69, 9, 85, 0
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
44 };
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
45
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
46 local _parse_sql_key_spans = { [0] =
5776
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
47 0, 1, 1, 1, 33, 38, 1, 1, 1, 1, 1, 1, 17, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
48 39, 88, 1, 1, 1, 33, 38, 87, 87, 39, 51, 1, 1, 1, 33, 38, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
49 1, 24, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
50 1, 10, 1, 22, 1, 1, 1, 1, 87, 87, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
51 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 50, 50, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
52 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
53 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 47, 32, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
54 1, 1, 1, 1, 40, 83, 83, 4, 16, 47, 10, 17, 10, 17, 1, 1, 1, 83, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
55 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 87, 87, 1, 1, 1, 1, 1, 1, 1, 1,
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
56 1, 50, 50, 6, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 77
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
57 };
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
58
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
59 local _parse_sql_index_offsets = { [0] =
5776
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
60 0, 0, 2, 4, 6, 40, 79, 81, 83, 85, 87, 89, 91, 109, 111, 113, 115, 117, 119, 121,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
61 123, 163, 252, 254, 256, 258, 292, 331, 419, 507, 547, 599, 601, 603, 605, 639, 678, 680, 682, 684,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
62 686, 688, 713, 715, 717, 719, 721, 723, 725, 727, 729, 731, 733, 735, 737, 739, 741, 829, 917, 919,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
63 921, 923, 934, 936, 959, 961, 963, 965, 967, 1055, 1143, 1145, 1147, 1149, 1151, 1153, 1155, 1157, 1159, 1161,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
64 1163, 1165, 1167, 1169, 1171, 1173, 1175, 1177, 1179, 1181, 1269, 1357, 1359, 1410, 1461, 1463, 1465, 1467, 1469, 1471,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
65 1473, 1475, 1477, 1479, 1481, 1483, 1485, 1487, 1489, 1491, 1493, 1495, 1497, 1499, 1501, 1503, 1591, 1679, 1681, 1683,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
66 1685, 1687, 1689, 1691, 1693, 1695, 1697, 1699, 1701, 1703, 1705, 1793, 1881, 1883, 1931, 1964, 1966, 1968, 1970, 1972,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
67 1974, 1976, 1978, 1980, 1982, 2023, 2107, 2191, 2196, 2213, 2261, 2272, 2290, 2301, 2319, 2321, 2323, 2325, 2409, 2411,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
68 2413, 2415, 2417, 2419, 2421, 2423, 2425, 2427, 2429, 2431, 2433, 2521, 2609, 2611, 2613, 2615, 2617, 2619, 2621, 2623,
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
69 2625, 2627, 2678, 2729, 2736, 2738, 2740, 2742, 2744, 2746, 2748, 2750, 2752, 2754, 2756, 2758, 2760
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
70 };
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
71
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
72 local _parse_sql_indicies = { [0] =
5776
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
73 0, 1, 2, 0, 3, 1, 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
74 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 5, 3,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
75 4, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
76 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 3, 5, 3, 3, 3, 3, 6, 3, 7,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
77 1, 8, 1, 9, 1, 10, 1, 11, 1, 12, 1, 13, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
78 1, 1, 1, 1, 1, 1, 1, 14, 1, 15, 1, 16, 1, 17, 1, 18, 1, 19, 1, 20,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
79 1, 21, 1, 22, 23, 22, 22, 22, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
80 1, 1, 1, 1, 1, 1, 22, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 24,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
81 1, 25, 1, 22, 23, 22, 22, 22, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
82 1, 1, 1, 1, 1, 1, 22, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 24,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
83 1, 25, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
84 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
85 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 26, 1, 27, 1, 23, 27, 28, 1, 29, 28,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
86 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
87 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 30, 28, 29, 28, 28, 28, 28, 28, 28, 28,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
88 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28, 28,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
89 28, 28, 28, 28, 30, 28, 28, 28, 28, 22, 28, 32, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
90 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
91 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
92 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
93 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 1, 31, 32,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
94 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
95 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
96 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
97 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31, 31,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
98 31, 31, 31, 31, 31, 33, 31, 34, 35, 34, 34, 34, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
99 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 34, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
100 1, 1, 1, 36, 1, 37, 1, 34, 35, 34, 34, 34, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
101 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 34, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
102 1, 1, 1, 36, 1, 37, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 6, 1, 38,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
103 1, 35, 38, 39, 1, 40, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
104 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 41, 39, 40,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
105 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
106 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 39, 41, 39, 39, 39, 39, 34, 39, 42, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
107 43, 1, 44, 1, 45, 1, 46, 1, 47, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
108 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 48, 1, 49, 1, 50, 1, 51, 1, 52,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
109 1, 53, 1, 54, 1, 55, 1, 56, 1, 57, 1, 58, 1, 59, 1, 60, 1, 61, 1, 48,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
110 1, 63, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
111 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
112 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
113 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62, 62,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
114 62, 62, 62, 62, 62, 62, 62, 1, 62, 65, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
115 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
116 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
117 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
118 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 64, 66, 64, 67, 1, 68,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
119 1, 69, 1, 70, 1, 1, 1, 1, 1, 1, 1, 1, 71, 1, 72, 1, 73, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
120 1, 74, 1, 1, 1, 1, 75, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 76, 1, 77,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
121 1, 78, 1, 79, 1, 80, 1, 82, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
122 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
123 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
124 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
125 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 1, 81, 82, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
126 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
127 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
128 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
129 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81, 81,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
130 81, 83, 81, 69, 83, 84, 1, 85, 1, 86, 1, 87, 1, 88, 1, 89, 1, 90, 1, 91,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
131 1, 92, 1, 93, 1, 83, 1, 94, 1, 95, 1, 96, 1, 97, 1, 98, 1, 99, 1, 73,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
132 1, 101, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
133 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
134 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
135 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100, 100,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
136 100, 100, 100, 100, 100, 100, 100, 1, 100, 103, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
137 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
138 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
139 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
140 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 102, 104, 102, 105, 83, 106,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
141 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
142 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
143 71, 71, 71, 71, 71, 71, 71, 71, 107, 71, 108, 71, 71, 71, 71, 71, 71, 71, 71, 71,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
144 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
145 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 71, 107,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
146 71, 109, 1, 110, 1, 111, 1, 112, 1, 113, 1, 114, 1, 115, 1, 116, 1, 117, 1, 118,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
147 1, 119, 1, 120, 1, 121, 1, 122, 1, 123, 1, 124, 1, 125, 1, 126, 1, 127, 1, 128,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
148 1, 129, 1, 131, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
149 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
150 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
151 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
152 130, 130, 130, 130, 130, 130, 130, 130, 130, 1, 130, 131, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
153 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
154 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
155 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
156 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 130, 132, 130, 6,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
157 1, 133, 1, 134, 1, 135, 1, 136, 1, 137, 1, 138, 1, 139, 1, 140, 1, 141, 1, 142,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
158 1, 143, 1, 144, 1, 146, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
159 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
160 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
161 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
162 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 145, 1, 145, 148, 147, 147, 147, 147, 147, 147,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
163 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
164 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
165 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
166 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 147, 149,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
167 147, 150, 1, 151, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
168 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
169 1, 1, 1, 1, 1, 1, 1, 1, 1, 152, 1, 153, 151, 151, 151, 151, 151, 151, 151, 151,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
170 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151, 151,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
171 151, 151, 154, 151, 155, 1, 152, 1, 156, 1, 157, 1, 158, 1, 159, 1, 160, 1, 161, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
172 162, 1, 163, 1, 1, 1, 1, 1, 164, 1, 1, 165, 165, 165, 165, 165, 165, 165, 165, 165,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
173 165, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
174 1, 166, 1, 168, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
175 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 169, 167, 167, 167, 167, 167, 167, 167,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
176 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
177 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167, 167,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
178 167, 167, 167, 167, 167, 170, 167, 172, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
179 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 173, 171, 171, 171,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
180 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
181 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171, 171,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
182 171, 171, 171, 171, 171, 171, 171, 171, 171, 174, 171, 175, 1, 1, 176, 1, 161, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
183 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 177, 1, 178, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
184 163, 1, 1, 1, 1, 1, 164, 1, 1, 165, 165, 165, 165, 165, 165, 165, 165, 165, 165, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
185 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 166,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
186 1, 179, 179, 179, 179, 179, 179, 179, 179, 179, 179, 1, 180, 1, 1, 181, 1, 182, 1, 179,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
187 179, 179, 179, 179, 179, 179, 179, 179, 179, 1, 183, 183, 183, 183, 183, 183, 183, 183, 183, 183,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
188 1, 180, 1, 1, 181, 1, 1, 1, 183, 183, 183, 183, 183, 183, 183, 183, 183, 183, 1, 184,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
189 1, 185, 1, 186, 1, 171, 1, 1, 171, 1, 171, 1, 1, 1, 1, 1, 1, 1, 1, 171,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
190 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
191 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
192 1, 171, 1, 171, 1, 1, 171, 1, 1, 171, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
193 1, 171, 1, 1, 1, 171, 1, 171, 1, 187, 1, 188, 1, 189, 1, 190, 1, 191, 1, 192,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
194 1, 193, 1, 194, 1, 195, 1, 196, 1, 197, 1, 198, 1, 200, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
195 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
196 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
197 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
198 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
199 199, 200, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
200 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
201 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
202 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199, 199,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
203 199, 199, 199, 199, 199, 199, 199, 201, 199, 202, 1, 203, 1, 204, 1, 205, 1, 206, 1, 132,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
204 1, 207, 1, 208, 1, 209, 1, 210, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
205 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
206 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 211, 209, 2, 209,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
207 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
208 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209, 209,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
209 209, 209, 209, 209, 209, 209, 209, 211, 209, 212, 1, 1, 1, 1, 213, 1, 214, 1, 215, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
210 216, 1, 217, 1, 218, 1, 219, 1, 220, 1, 221, 1, 222, 1, 223, 1, 132, 1, 127, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
211 6, 2, 6, 6, 6, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
212 1, 1, 1, 6, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 224, 1, 225, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
213 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 6, 1, 1, 1, 1, 1, 1, 1, 226, 227,
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
214 1, 1, 1, 1, 228, 1, 1, 229, 1, 1, 1, 1, 1, 1, 230, 1, 231, 1, 0
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
215 };
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
216
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
217 local _parse_sql_trans_targs = { [0] =
5776
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
218 2, 0, 196, 4, 4, 5, 196, 7, 8, 9, 10, 11, 12, 13, 36, 14, 15, 16, 17, 18,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
219 19, 20, 21, 21, 22, 24, 27, 23, 25, 25, 26, 28, 28, 29, 30, 30, 31, 33, 32, 34,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
220 34, 35, 37, 38, 39, 40, 41, 42, 56, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
221 54, 55, 57, 57, 57, 57, 58, 59, 60, 61, 62, 92, 63, 64, 71, 82, 89, 65, 66, 67,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
222 68, 69, 69, 70, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 83, 84, 85, 86, 87, 88,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
223 90, 90, 90, 90, 91, 70, 92, 93, 196, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
224 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 116, 117, 119, 120, 121, 122, 123, 124, 125,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
225 126, 127, 128, 129, 130, 131, 131, 131, 131, 132, 133, 134, 137, 134, 135, 136, 138, 139, 140, 141,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
226 142, 143, 144, 145, 150, 151, 154, 146, 146, 147, 157, 146, 146, 147, 157, 148, 149, 196, 144, 151,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
227 148, 149, 152, 153, 155, 156, 147, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
228 171, 172, 173, 174, 175, 176, 177, 179, 180, 181, 181, 182, 184, 195, 185, 186, 187, 188, 189, 190,
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
229 191, 192, 193, 194, 1, 3, 6, 94, 118, 158, 178, 183
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
230 };
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
231
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
232 local _parse_sql_trans_actions = { [0] =
5776
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
233 1, 0, 3, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
234 1, 1, 1, 3, 1, 1, 1, 1, 1, 3, 1, 1, 3, 1, 1, 3, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
235 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
236 1, 1, 5, 20, 1, 3, 30, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
237 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
238 5, 20, 1, 3, 26, 3, 3, 1, 23, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
239 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
240 1, 1, 1, 1, 1, 5, 20, 1, 3, 42, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
241 1, 1, 11, 1, 5, 5, 1, 5, 20, 46, 5, 1, 3, 34, 1, 14, 1, 17, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
242 51, 38, 1, 1, 1, 1, 8, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1,
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
243 3, 1, 1, 1, 1, 1, 1, 1, 1, 1, 3, 1, 1, 1, 1, 1, 1, 1, 1, 1,
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
244 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
245 };
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
246
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
247 local parse_sql_start = 196;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
248 local parse_sql_first_final = 196;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
249 local parse_sql_error = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
250
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
251 local parse_sql_en_main = 196;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
252
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
253
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
254
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
255
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
256 local _sql_unescapes = setmetatable({
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
257 ["\\0"] = "\0";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
258 ["\\'"] = "'";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
259 ["\\\""] = "\"";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
260 ["\\b"] = "\b";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
261 ["\\n"] = "\n";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
262 ["\\r"] = "\r";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
263 ["\\t"] = "\t";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
264 ["\\Z"] = "\26";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
265 ["\\\\"] = "\\";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
266 ["\\%"] = "%";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
267 ["\\_"] = "_";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
268 },{ __index = function(t, s) assert(false, "Unknown escape sequences: "..s); end });
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
269
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
270 function parse_sql(data, h)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
271 local p = 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
272 local pe = #data + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
273 local cs;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
274
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
275 local pos_char, pos_line = 1, 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
276
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
277 local mark, token;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
278 local table_name, columns, value_lists, value_list, value_count;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
279
5776
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
280
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
281 cs = parse_sql_start;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
282
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
283 -- ragel flat exec
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
284
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
285 local testEof = false;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
286 local _slen = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
287 local _trans = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
288 local _keys = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
289 local _inds = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
290 local _acts = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
291 local _nacts = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
292 local _tempval = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
293 local _goto_level = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
294 local _resume = 10;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
295 local _eof_trans = 15;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
296 local _again = 20;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
297 local _test_eof = 30;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
298 local _out = 40;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
299
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
300 while true do -- goto loop
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
301 local _continue = false;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
302 repeat
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
303 local _trigger_goto = false;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
304 if _goto_level <= 0 then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
305
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
306 -- noEnd
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
307 if p == pe then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
308 _goto_level = _test_eof;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
309 _continue = true; break;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
310 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
311
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
312
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
313 -- errState != 0
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
314 if cs == 0 then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
315 _goto_level = _out;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
316 _continue = true; break;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
317 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
318 end -- _goto_level <= 0
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
319
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
320 if _goto_level <= _resume then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
321 _keys = cs * 2; -- LOCATE_TRANS
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
322 _inds = _parse_sql_index_offsets[cs];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
323 _slen = _parse_sql_key_spans[cs];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
324
5776
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
325 if _slen > 0 and
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
326 _parse_sql_trans_keys[_keys] <= data:byte(p) and
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
327 data:byte(p) <= _parse_sql_trans_keys[_keys + 1] then
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
328 _trans = _parse_sql_indicies[ _inds + data:byte(p) - _parse_sql_trans_keys[_keys] ];
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
329 else _trans =_parse_sql_indicies[ _inds + _slen ]; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
330
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
331 cs = _parse_sql_trans_targs[_trans];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
332
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
333 if _parse_sql_trans_actions[_trans] ~= 0 then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
334 _acts = _parse_sql_trans_actions[_trans];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
335 _nacts = _parse_sql_actions[_acts];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
336 _acts = _acts + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
337
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
338 while _nacts > 0 do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
339 _nacts = _nacts - 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
340 _acts = _acts + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
341 _tempval = _parse_sql_actions[_acts - 1];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
342
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
343 -- start action switch
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
344 if _tempval == 0 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
345 -- line 34 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
346 pos_char = pos_char + 1; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
347 elseif _tempval == 1 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
348 -- line 35 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
349 pos_line = pos_line + 1; pos_char = 1; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
350 elseif _tempval == 2 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
351 -- line 38 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
352 mark = p; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
353 elseif _tempval == 3 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
354 -- line 39 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
355 token = data:sub(mark, p-1); -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
356 elseif _tempval == 4 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
357 -- line 52 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
358 table.insert(columns, token); columns[#columns] = token; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
359 elseif _tempval == 5 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
360 -- line 58 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
361 table_name,columns = token,{}; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
362 elseif _tempval == 6 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
363 -- line 59 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
364 h.create(table_name, columns); -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
365 elseif _tempval == 7 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
366 -- line 65 "sql.rl" -- end of line directive
5776
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
367
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
368 value_count = value_count + 1; value_list[value_count] = token:gsub("\\.", _sql_unescapes);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
369 -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
370 elseif _tempval == 8 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
371 -- line 68 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
372 value_count = value_count + 1; value_list[value_count] = tonumber(token); -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
373 elseif _tempval == 9 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
374 -- line 69 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
375 value_count = value_count + 1; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
376 elseif _tempval == 10 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
377 -- line 71 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
378 value_list,value_count = {},0; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
379 elseif _tempval == 11 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
380 -- line 71 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
381 table.insert(value_lists, value_list); -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
382 elseif _tempval == 12 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
383 -- line 74 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
384 table_name,value_lists = token,{}; -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
385 elseif _tempval == 13 then --4 FROM_STATE_ACTION_SWITCH
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
386 -- line 75 "sql.rl" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
387 h.insert(table_name, value_lists); -- ACTION
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
388 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
389 -- line 355 "sql.lua" -- end of line directive
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
390 -- end action switch
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
391 end -- while _nacts
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
392 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
393
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
394 if _trigger_goto then _continue = true; break; end
5776
bd0ff8ae98a8 Remove all trailing whitespace
Florian Zeitz <florob@babelmonkeys.de>
parents: 5696
diff changeset
395 end -- endif
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
396
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
397 if _goto_level <= _again then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
398 if cs == 0 then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
399 _goto_level = _out;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
400 _continue = true; break;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
401 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
402 p = p + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
403 if p ~= pe then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
404 _goto_level = _resume;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
405 _continue = true; break;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
406 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
407 end -- _goto_level <= _again
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
408
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
409 if _goto_level <= _test_eof then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
410 end -- _goto_level <= _test_eof
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
411
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
412 if _goto_level <= _out then break; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
413 _continue = true;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
414 until true;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
415 if not _continue then break; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
416 end -- endif _goto_level <= out
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
417
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
418 -- end of execute block
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
419
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
420
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
421 if cs < parse_sql_first_final then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
422 print("parse_sql: there was an error, line "..pos_line.." column "..pos_char);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
423 else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
424 print("Success. EOF at line "..pos_line.." column "..pos_char)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
425 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
426 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
427
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
428 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
429
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
430 -- import modules
6147
852bd69ba148 tools/jabberd14sql2prosody: Fix package.path (thanks daurnimator)
Kim Alvefur <zash@zash.se>
parents: 5696
diff changeset
431 package.path = package.path..";../?.lua;";
5696
9fba74a28e0c package{,c}path fixes for migration tools
Vadim Misbakh-Soloviov <mva@mva.name>
parents: 5216
diff changeset
432
9fba74a28e0c package{,c}path fixes for migration tools
Vadim Misbakh-Soloviov <mva@mva.name>
parents: 5216
diff changeset
433 local my_name = arg[0];
9fba74a28e0c package{,c}path fixes for migration tools
Vadim Misbakh-Soloviov <mva@mva.name>
parents: 5216
diff changeset
434 if my_name:match("[/\\]") then
9fba74a28e0c package{,c}path fixes for migration tools
Vadim Misbakh-Soloviov <mva@mva.name>
parents: 5216
diff changeset
435 package.path = package.path..";"..my_name:gsub("[^/\\]+$", "../?.lua");
9fba74a28e0c package{,c}path fixes for migration tools
Vadim Misbakh-Soloviov <mva@mva.name>
parents: 5216
diff changeset
436 package.cpath = package.cpath..";"..my_name:gsub("[^/\\]+$", "../?.so");
9fba74a28e0c package{,c}path fixes for migration tools
Vadim Misbakh-Soloviov <mva@mva.name>
parents: 5216
diff changeset
437 end
9fba74a28e0c package{,c}path fixes for migration tools
Vadim Misbakh-Soloviov <mva@mva.name>
parents: 5216
diff changeset
438
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
439
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
440 -- ugly workaround for getting datamanager to work outside of prosody :(
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
441 prosody = { };
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
442 prosody.platform = "unknown";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
443 if os.getenv("WINDIR") then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
444 prosody.platform = "windows";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
445 elseif package.config:sub(1,1) == "/" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
446 prosody.platform = "_posix";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
447 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
448 package.loaded["util.logger"] = {init = function() return function() end; end}
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
449
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
450 local dm = require "util.datamanager";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
451 dm.set_data_path("data");
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
452
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
453 local datetime = require "util.datetime";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
454
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
455 local st = require "util.stanza";
5216
63db6f281708 tools/jabberd14sql2prosody: Use util.xml.
Waqas Hussain <waqas20@gmail.com>
parents: 5109
diff changeset
456 local parse_xml = require "util.xml".parse;
5109
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
457
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
458 function store_password(username, host, password)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
459 -- create or update account for username@host
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
460 local ret, err = dm.store(username, host, "accounts", {password = password});
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
461 print("["..(err or "success").."] stored account: "..username.."@"..host.." = "..password);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
462 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
463
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
464 function store_vcard(username, host, stanza)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
465 -- create or update vCard for username@host
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
466 local ret, err = dm.store(username, host, "vcard", st.preserialize(stanza));
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
467 print("["..(err or "success").."] stored vCard: "..username.."@"..host);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
468 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
469
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
470 function store_roster(username, host, roster_items)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
471 -- fetch current roster-table for username@host if he already has one
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
472 local roster = dm.load(username, host, "roster") or {};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
473 -- merge imported roster-items with loaded roster
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
474 for item_tag in roster_items:childtags() do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
475 -- jid for this roster-item
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
476 local item_jid = item_tag.attr.jid
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
477 -- validate item stanzas
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
478 if (item_tag.name == "item") and (item_jid ~= "") then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
479 -- prepare roster item
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
480 -- TODO: is the subscription attribute optional?
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
481 local item = {subscription = item_tag.attr.subscription, groups = {}};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
482 -- optional: give roster item a real name
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
483 if item_tag.attr.name then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
484 item.name = item_tag.attr.name;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
485 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
486 -- optional: iterate over group stanzas inside item stanza
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
487 for group_tag in item_tag:childtags() do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
488 local group_name = group_tag:get_text();
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
489 if (group_tag.name == "group") and (group_name ~= "") then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
490 item.groups[group_name] = true;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
491 else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
492 print("[error] invalid group stanza: "..group_tag:pretty_print());
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
493 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
494 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
495 -- store item in roster
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
496 roster[item_jid] = item;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
497 print("[success] roster entry: " ..username.."@"..host.." - "..item_jid);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
498 else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
499 print("[error] invalid roster stanza: " ..item_tag:pretty_print());
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
500 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
501
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
502 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
503 -- store merged roster-table
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
504 local ret, err = dm.store(username, host, "roster", roster);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
505 print("["..(err or "success").."] stored roster: " ..username.."@"..host);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
506 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
507
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
508 function store_subscription_request(username, host, presence_stanza)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
509 local from_bare = presence_stanza.attr.from;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
510
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
511 -- fetch current roster-table for username@host if he already has one
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
512 local roster = dm.load(username, host, "roster") or {};
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
513
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
514 local item = roster[from_bare];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
515 if item and (item.subscription == "from" or item.subscription == "both") then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
516 return; -- already subscribed, do nothing
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
517 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
518
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
519 -- add to table of pending subscriptions
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
520 if not roster.pending then roster.pending = {}; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
521 roster.pending[from_bare] = true;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
522
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
523 -- store updated roster-table
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
524 local ret, err = dm.store(username, host, "roster", roster);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
525 print("["..(err or "success").."] stored subscription request: " ..username.."@"..host.." - "..from_bare);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
526 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
527
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
528 local os_date = os.date;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
529 local os_time = os.time;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
530 local os_difftime = os.difftime;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
531 function datetime_parse(s)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
532 if s then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
533 local year, month, day, hour, min, sec, tzd;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
534 year, month, day, hour, min, sec, tzd = s:match("^(%d%d%d%d)%-?(%d%d)%-?(%d%d)T(%d%d):(%d%d):(%d%d)%.?%d*([Z+%-]?.*)$");
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
535 if year then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
536 local time_offset = os_difftime(os_time(os_date("*t")), os_time(os_date("!*t"))); -- to deal with local timezone
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
537 local tzd_offset = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
538 if tzd ~= "" and tzd ~= "Z" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
539 local sign, h, m = tzd:match("([+%-])(%d%d):?(%d*)");
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
540 if not sign then return; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
541 if #m ~= 2 then m = "0"; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
542 h, m = tonumber(h), tonumber(m);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
543 tzd_offset = h * 60 * 60 + m * 60;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
544 if sign == "-" then tzd_offset = -tzd_offset; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
545 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
546 sec = (sec + time_offset) - tzd_offset;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
547 return os_time({year=year, month=month, day=day, hour=hour, min=min, sec=sec, isdst=false});
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
548 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
549 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
550 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
551
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
552 function store_offline_messages(username, host, stanza)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
553 -- TODO: maybe use list_load(), append and list_store() instead
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
554 -- of constantly reopening the file with list_append()?
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
555 --for ch in offline_messages:childtags() do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
556 --print("message :"..ch:pretty_print());
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
557 stanza.attr.node = nil;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
558
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
559 local stamp = stanza:get_child("x", "jabber:x:delay");
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
560 if not stamp or not stamp.attr.stamp then print(2) return; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
561
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
562 for i=1,#stanza do if stanza[i] == stamp then table.remove(stanza, i); break; end end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
563 for i=1,#stanza.tags do if stanza.tags[i] == stamp then table.remove(stanza.tags, i); break; end end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
564
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
565 local parsed_stamp = datetime_parse(stamp.attr.stamp);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
566 if not parsed_stamp then print(1, stamp.attr.stamp) return; end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
567
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
568 stanza.attr.stamp, stanza.attr.stamp_legacy = datetime.datetime(parsed_stamp), datetime.legacy(parsed_stamp);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
569 local ret, err = dm.list_append(username, host, "offline", st.preserialize(stanza));
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
570 print("["..(err or "success").."] stored offline message: " ..username.."@"..host.." - "..stanza.attr.from);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
571 --end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
572 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
573
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
574 -- load data
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
575 local arg = ...;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
576 local help = "/? -? ? /h -h /help -help --help";
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
577 if not arg or help:find(arg, 1, true) then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
578 print([[XEP-227 importer for Prosody
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
579
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
580 Usage: jabberd14sql2prosody.lua filename.sql
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
581 ]]);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
582 os.exit(1);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
583 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
584 local f = io.open(arg);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
585 local s = f:read("*a");
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
586 f:close();
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
587
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
588 local table_count = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
589 local insert_count = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
590 local row_count = 0;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
591 -- parse
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
592 parse_sql(s, {
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
593 create = function(table_name, columns)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
594 --[[print(table_name);]]
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
595 table_count = table_count + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
596 end;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
597 insert = function(table_name, value_lists)
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
598 --[[print(table_name, #value_lists);]]
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
599 insert_count = insert_count + 1;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
600 row_count = row_count + #value_lists;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
601
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
602 for _,value_list in ipairs(value_lists) do
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
603 if table_name == "users" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
604 local user, realm, password = unpack(value_list);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
605 store_password(user, realm, password);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
606 elseif table_name == "roster" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
607 local user, realm, xml = unpack(value_list);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
608 local stanza,err = parse_xml(xml);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
609 if stanza then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
610 store_roster(user, realm, stanza);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
611 else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
612 print("[error] roster: XML parsing failed for "..user.."@"..realm..": "..err);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
613 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
614 elseif table_name == "vcard" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
615 local user, realm, name, email, nickname, birthday, photo, xml = unpack(value_list);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
616 if xml then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
617 local stanza,err = parse_xml(xml);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
618 if stanza then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
619 store_vcard(user, realm, stanza);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
620 else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
621 print("[error] vcard: XML parsing failed for "..user.."@"..realm..": "..err);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
622 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
623 else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
624 --print("[warn] vcard: NULL vCard for "..user.."@"..realm..": "..err);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
625 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
626 elseif table_name == "storedsubscriptionrequests" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
627 local user, realm, fromjid, xml = unpack(value_list);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
628 local stanza,err = parse_xml(xml);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
629 if stanza then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
630 store_subscription_request(user, realm, stanza);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
631 else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
632 print("[error] storedsubscriptionrequests: XML parsing failed for "..user.."@"..realm..": "..err);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
633 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
634 elseif table_name == "messages" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
635 --local user, realm, node, correspondent, type, storetime, delivertime, subject, body, xml = unpack(value_list);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
636 local user, realm, type, xml = value_list[1], value_list[2], value_list[5], value_list[10];
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
637 if type == "offline" and xml ~= "" then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
638 local stanza,err = parse_xml(xml);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
639 if stanza then
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
640 store_offline_messages(user, realm, stanza);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
641 else
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
642 print("[error] offline messages: XML parsing failed for "..user.."@"..realm..": "..err);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
643 print(unpack(value_list));
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
644 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
645 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
646 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
647 end
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
648 end;
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
649 });
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
650
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
651 print("table_count", table_count);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
652 print("insert_count", insert_count);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
653 print("row_count", row_count);
12fb961c8f27 tools/jabberd14sql2prosody: Initial commit. Accounts, rosters, vCards, subscriptions and offline messages supported (thanks halfdan for all the testing).
Waqas Hussain <waqas20@gmail.com>
parents:
diff changeset
654