diff options
Diffstat (limited to 'openbsc/tools/26c3-guru-import.py')
-rwxr-xr-x | openbsc/tools/26c3-guru-import.py | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/openbsc/tools/26c3-guru-import.py b/openbsc/tools/26c3-guru-import.py index 4d85bcf3c..b61a1f714 100755 --- a/openbsc/tools/26c3-guru-import.py +++ b/openbsc/tools/26c3-guru-import.py @@ -56,15 +56,15 @@ for x in web_tuple: # Not an IMSI if len(subscr) == 0: equip = hlr.execute(""" - SELECT id,imei FROM Equipment WHERE imei="%015u" - """ % (imxi) ).fetchall(); + SELECT id,imei FROM Equipment WHERE imei LIKE "%014u%%" + """ % (imxi/10) ).fetchall(); #print equip if len(equip) == 0: continue subscrid = hlr.execute(""" - SELECT * FROM EquipmentWatch WHERE equipment_id=%015u ORDER BY created LIMIT 1 + SELECT * FROM EquipmentWatch WHERE equipment_id=%u ORDER BY created LIMIT 1 """ % (int(equip[0]['id'])) ).fetchall(); #print subscrid |