def save_carriers(elements):
from app.models.carrier import Carrier
for json_element in elements:
if json_element["mnc"] and json_element["mcc"] and json_element["name"]:
Carrier.add_new_carrier(mcc=json_element["mcc"],
mnc=json_element["mnc"],
name=json_element["name"])
def populate(self):
# devices
device1 = Device(device_id="1",
creation_date=datetime.now() + timedelta(days=-2))
device2 = Device(device_id="2", creation_date=datetime.now())
device3 = Device(device_id="3", creation_date=datetime.now())
device4 = Device(device_id="4", creation_date=datetime.now())
# sims
sim1 = Sim(serial_number="123")
sim2 = Sim(serial_number="456")
sim3 = Sim(serial_number="789")
sim1.devices.append(device1)
sim1.devices.append(device2)
sim2.devices.append(device3)
sim3.devices.append(device4)
# carriers
carrier1 = Carrier(name="test_carrier_1")
carrier2 = Carrier(name="test_carrier_2")
carrier1.sims.append(sim1)
carrier1.sims.append(sim2)
carrier2.sims.append(sim3)
db.session.add(carrier1)
db.session.add(carrier2)
db.session.commit()
def set_events_context(jsonvar):
from app.models.device import Device
device = Device.get_device_or_add_it(jsonvar["device_records"])
app_version_code = jsonvar["device_records"]["app_version_code"]
from app.models.sim import Sim
sim = Sim.get_sim_or_add_it(jsonvar["sim_records"])
if sim:
# Get carrier or add it, if it does not exist
from app.models.carrier import Carrier
carrier = Carrier.get_carrier_or_add_it(
mnc=jsonvar["sim_records"]["mnc"],
mcc=jsonvar["sim_records"]["mcc"])
# Link carrier with sim
carrier.add_sim(sim)
# Link sim with device
sim.add_device(device)
db.session.add(sim)
db.session.add(carrier)
# add new device, sim or carrier
try:
db.session.commit()
except Exception as e:
db.session.rollback()
application.logger.error("Error adding device or sim to database " +
str(e))
return device, sim, app_version_code
def set_events_context(jsonvar):
from app.models.device import Device
device = Device.get_device_or_add_it(jsonvar["device_records"])
app_version_code = jsonvar["device_records"]["app_version_code"]
from app.models.sim import Sim
sim = Sim.get_sim_or_add_it(jsonvar["sim_records"])
if sim:
# Get carrier or add it, if it does not exist
from app.models.carrier import Carrier
carrier = Carrier.get_carrier_or_add_it(mnc=jsonvar["sim_records"]["mnc"], mcc=jsonvar["sim_records"]["mcc"])
# Link carrier with sim
carrier.add_sim(sim)
# Link sim with device
sim.add_device(device)
db.session.add(sim)
db.session.add(carrier)
# add new device, sim or carrier
db.session.commit()
return device, sim, app_version_code
def populate(self):
# devices
device1 = Device(device_id="1")
device2 = Device(device_id="2")
device3 = Device(device_id="3")
device4 = Device(device_id="4")
# sims
sim1 = Sim(serial_number="123")
sim2 = Sim(serial_number="456")
sim3 = Sim(serial_number="789")
sim1.devices.append(device1)
sim1.devices.append(device2)
sim2.devices.append(device1)
sim2.devices.append(device3)
sim3.devices.append(device4)
# carriers
carrier1 = Carrier(name="test_carrier_1")
carrier2 = Carrier(name="test_carrier_2")
carrier1.sims.append(sim1)
carrier1.sims.append(sim2)
carrier2.sims.append(sim3)
# GSM events
event1 = GsmEvent(date=datetime.now() + timedelta(days=-2))
event2 = GsmEvent(date=datetime.now())
event3 = GsmEvent(date=datetime.now())
event4 = GsmEvent(date=datetime.now())
event5 = GsmEvent(date=datetime.now())
sim1.events.append(event1)
sim1.events.append(event2)
sim3.events.append(event3)
sim3.events.append(event4)
sim3.events.append(event5)
device1.events = [event1, event2]
device2.events = [event3]
device3.events = [event4, event5]
db.session.add(carrier1)
db.session.add(carrier2)
db.session.commit()
def populate(self):
# sims
sim1 = Sim(serial_number="123",
creation_date=datetime.now() + timedelta(days=-2))
sim2 = Sim(serial_number="456", creation_date=datetime.now())
sim3 = Sim(serial_number="789", creation_date=datetime.now())
# carriers
carrier1 = Carrier(name="test_carrier_1")
carrier2 = Carrier(name="test_carrier_2")
carrier1.sims.append(sim1)
carrier1.sims.append(sim2)
carrier2.sims.append(sim3)
db.session.add(carrier1)
db.session.add(carrier2)
db.session.commit()
def link_observation_with_carrier(event):
if event.mnc and event.mcc:
from app.models.carrier import Carrier
carrier = Carrier.get_carrier_or_add_it(mnc=event.mnc, mcc=event.mcc)
event.carrier_id = carrier.id
def link_observation_with_carrier(event):
if event.mnc and event.mcc:
from app.models.carrier import Carrier
carrier = Carrier.get_carrier_or_add_it(mnc=event.mnc, mcc=event.mcc)
event.carrier_id = carrier.id