Gitiles
Code Review Sign In
gerrit.osmocom.org / osmo-hlr / a8045daeef048ee1181f2a3c9bc15e7cd6c1dfca / . / tests / db_upgrade / db_upgrade_test.ok
blob: c1f0f9df109d32ee8501eb16e86bd382971b8f84 [file] [log] [blame]
Neels Hofmeyr5b654612019-10-31 02:03:48 +0100[diff] [blame]1Creating db in schema version 0
2
3Version 0 db:
4
5Table: auc_2g
6name|type|notnull|dflt_value|pk
7algo_id_2g|INTEGER|1||0
8ki|VARCHAR(32)|1||0
9subscriber_id|INTEGER|0||1
10
11Table auc_2g contents:
12algo_id_2g|ki|subscriber_id
131|BeefedCafeFaceAcedAddedDecadeFee|1
142|33333333333333333333333333333333|4
154|55555555555555555555555555555555|6
16
17Table: auc_3g
18name|type|notnull|dflt_value|pk
19algo_id_3g|INTEGER|1||0
20ind_bitlen|INTEGER|1|5|0
21k|VARCHAR(32)|1||0
22op|VARCHAR(32)|0||0
23opc|VARCHAR(32)|0||0
24sqn|INTEGER|1|0|0
25subscriber_id|INTEGER|0||1
26
27Table auc_3g contents:
28algo_id_3g|ind_bitlen|k|op|opc|sqn|subscriber_id
295|5|C01ffedC1cadaeAc1d1f1edAcac1aB0a||CededEffacedAceFacedBadFadedBeef|0|1
305|5|44444444444444444444444444444444|44444444444444444444444444444444||0|5
315|5|55555555555555555555555555555555||55555555555555555555555555555555|0|6
32
33Table: subscriber
34name|type|notnull|dflt_value|pk
35ggsn_number|VARCHAR(15)|0||0
36gmlc_number|VARCHAR(15)|0||0
37hlr_number|VARCHAR(15)|0||0
38id|INTEGER|0||1
39imeisv|VARCHAR|0||0
40imsi|VARCHAR(15)|1||0
41lmsi|INTEGER|0||0
42ms_purged_cs|BOOLEAN|1|0|0
43ms_purged_ps|BOOLEAN|1|0|0
44msisdn|VARCHAR(15)|0||0
45nam_cs|BOOLEAN|1|1|0
46nam_ps|BOOLEAN|1|1|0
47periodic_lu_tmr|INTEGER|0||0
48periodic_rau_tau_tmr|INTEGER|0||0
49sgsn_address|VARCHAR|0||0
50sgsn_number|VARCHAR(15)|0||0
51smsc_number|VARCHAR(15)|0||0
52vlr_number|VARCHAR(15)|0||0
53
54Table subscriber contents:
55ggsn_number|gmlc_number|hlr_number|id|imeisv|imsi|lmsi|ms_purged_cs|ms_purged_ps|msisdn|nam_cs|nam_ps|periodic_lu_tmr|periodic_rau_tau_tmr|sgsn_address|sgsn_number|smsc_number|vlr_number
56|||1||123456789012345||0|0|098765432109876|1|1||||||MSC-1
57|||2||111111111||1|0||1|1||||||
58|||3||222222222||0|1|22222|1|1||||||
59|||4||333333||0|0|3|0|1||||||
60|||5||444444444444444||0|0|4444|1|0||||||
61|||6||5555555||0|0|55555555555555|0|0||||||
62
63Table: subscriber_apn
64name|type|notnull|dflt_value|pk
65apn|VARCHAR(256)|1||0
66subscriber_id|INTEGER|0||0
67
68Table subscriber_apn contents:
69
70Table: subscriber_multi_msisdn
71name|type|notnull|dflt_value|pk
72msisdn|VARCHAR(15)|1||0
73subscriber_id|INTEGER|0||0
74
75Table subscriber_multi_msisdn contents:
76
77Launching osmo-hlr to upgrade db:
78osmo-hlr --database $db --db-upgrade --db-check --config-file $srcdir/osmo-hlr.cfg
79rc = 0
80DMAIN hlr starting
81DDB using database: <PATH>test.db
82DDB Database <PATH>test.db' has HLR DB schema version 0
Neels Hofmeyra8045da2019-10-31 01:19:44 +0100[diff] [blame^]83DDB Database <PATH>test.db' has been upgraded to HLR DB schema version 3
Neels Hofmeyr5b654612019-10-31 02:03:48 +0100[diff] [blame]84DMAIN Cmdline option --db-check: Database was opened successfully, quitting.
85
86Resulting db:
87
88Table: auc_2g
89name|type|notnull|dflt_value|pk
90algo_id_2g|INTEGER|1||0
91ki|VARCHAR(32)|1||0
92subscriber_id|INTEGER|0||1
93
94Table auc_2g contents:
95algo_id_2g|ki|subscriber_id
961|BeefedCafeFaceAcedAddedDecadeFee|1
972|33333333333333333333333333333333|4
984|55555555555555555555555555555555|6
99
100Table: auc_3g
101name|type|notnull|dflt_value|pk
102algo_id_3g|INTEGER|1||0
103ind_bitlen|INTEGER|1|5|0
104k|VARCHAR(32)|1||0
105op|VARCHAR(32)|0||0
106opc|VARCHAR(32)|0||0
107sqn|INTEGER|1|0|0
108subscriber_id|INTEGER|0||1
109
110Table auc_3g contents:
111algo_id_3g|ind_bitlen|k|op|opc|sqn|subscriber_id
1125|5|C01ffedC1cadaeAc1d1f1edAcac1aB0a||CededEffacedAceFacedBadFadedBeef|0|1
1135|5|44444444444444444444444444444444|44444444444444444444444444444444||0|5
1145|5|55555555555555555555555555555555||55555555555555555555555555555555|0|6
115
116Table: subscriber
117name|type|notnull|dflt_value|pk
118ggsn_number|VARCHAR(15)|0||0
119gmlc_number|VARCHAR(15)|0||0
Neels Hofmeyr5b654612019-10-31 02:03:48 +0100[diff] [blame]120id|INTEGER|0||1
121imei|VARCHAR(14)|0||0
122imeisv|VARCHAR|0||0
123imsi|VARCHAR(15)|1||0
124last_lu_seen|TIMESTAMP|0|NULL|0
125lmsi|INTEGER|0||0
126ms_purged_cs|BOOLEAN|1|0|0
127ms_purged_ps|BOOLEAN|1|0|0
Neels Hofmeyra8045da2019-10-31 01:19:44 +0100[diff] [blame^]128msc_number|VARCHAR(15)|0||0
Neels Hofmeyr5b654612019-10-31 02:03:48 +0100[diff] [blame]129msisdn|VARCHAR(15)|0||0
130nam_cs|BOOLEAN|1|1|0
131nam_ps|BOOLEAN|1|1|0
132periodic_lu_tmr|INTEGER|0||0
133periodic_rau_tau_tmr|INTEGER|0||0
134sgsn_address|VARCHAR|0||0
135sgsn_number|VARCHAR(15)|0||0
136smsc_number|VARCHAR(15)|0||0
137vlr_number|VARCHAR(15)|0||0
138
139Table subscriber contents:
Neels Hofmeyra8045da2019-10-31 01:19:44 +0100[diff] [blame^]140ggsn_number|gmlc_number|id|imei|imeisv|imsi|last_lu_seen|lmsi|ms_purged_cs|ms_purged_ps|msc_number|msisdn|nam_cs|nam_ps|periodic_lu_tmr|periodic_rau_tau_tmr|sgsn_address|sgsn_number|smsc_number|vlr_number
141||1|||123456789012345|||0|0||098765432109876|1|1||||||MSC-1
142||2|||111111111|||1|0|||1|1||||||
143||3|||222222222|||0|1||22222|1|1||||||
144||4|||333333|||0|0||3|0|1||||||
145||5|||444444444444444|||0|0||4444|1|0||||||
146||6|||5555555|||0|0||55555555555555|0|0||||||
Neels Hofmeyr5b654612019-10-31 02:03:48 +0100[diff] [blame]147
148Table: subscriber_apn
149name|type|notnull|dflt_value|pk
150apn|VARCHAR(256)|1||0
151subscriber_id|INTEGER|0||0
152
153Table subscriber_apn contents:
154
155Table: subscriber_multi_msisdn
156name|type|notnull|dflt_value|pk
157msisdn|VARCHAR(15)|1||0
158subscriber_id|INTEGER|0||0
159
160Table subscriber_multi_msisdn contents:
161
162Verify that osmo-hlr can open it:
163osmo-hlr --database $db --db-check --config-file $srcdir/osmo-hlr.cfg
164rc = 0
165DMAIN hlr starting
166DDB using database: <PATH>test.db
Neels Hofmeyra8045da2019-10-31 01:19:44 +0100[diff] [blame^]167DDB Database <PATH>test.db' has HLR DB schema version 3
Neels Hofmeyr5b654612019-10-31 02:03:48 +0100[diff] [blame]168DMAIN Cmdline option --db-check: Database was opened successfully, quitting.