import os
import pymssql
user = 'sa'
password = 'persie@220'
db = 'subs_data'
host = '178.128.196.245'
con = pymssql.connect(host, user, password, db)
cursor = con.cursor()

os.system("sudo tshark -i lo -Y 'e212.imsi' -V 2>&1 -a duration:30| sed 's/^[ \t]*//;s/[ \t]*$//' 2>&1 | grep 'IMSI:' > imsi.txt")
imsi_list =  open('imsi.txt', 'r')
imsi_list = imsi_list.read().splitlines()
imsi = []
for i in imsi_list:
    imsi.append(i.strip("IMSI: "))
os.remove('imsi.txt')

imsi = list(set(imsi))
print(imsi)

for x in imsi:
    query = "select * from dbo.Ufone where imsi = '"+ x +"'"
    cursor.execute(query)
    for row in cursor:
        print(row)