def get_all_profiles():
session = get_session()
session = session()
profile_query = session.query(Profile).all()
session.close()
return profile_query
def delete_plant(scientific_name):
session = get_session()
session = session()
session.query(Animal).filter(
Animal.scientific_name == scientific_name).delete()
session.commit()
session.close()
def get_all_plants():
session = get_session()
session = session()
plant_query = session.query(Animal).all()
session.close()
return plant_query
def get_ssid(ssid_entry):
session = get_session()
session = session()
returning_ssid = session.query(SsidTable).filter(SsidTable.ssid == ssid_entry).all()
session.close()
if returning_ssid:
return returning_ssid[0].ssid
else:
return None
def get_all_macs():
session = get_session()
session = session()
list_of_macs = []
query = session.query(MacAdress).all()
session.close()
for mac in query:
list_of_macs.append(mac.mac)
return list_of_macs
def get_mac(mac_entry):
session = get_session()
session = session()
returning_mac = session.query(MacAdress).filter(MacAdress.mac == mac_entry).all()
session.close()
if returning_mac:
return returning_mac[0].mac
else:
return None
def get_all_ssids():
session = get_session()
session = session()
list_of_ssids = []
query = session.query(SsidTable).all()
session.close()
for returning_ssid in query:
list_of_ssids.append(returning_ssid.ssid)
return list_of_ssids
def get_line(line_entry):
session = get_session()
session = session()
returning_line = session.query(Mac_ssid).filter(and_(Mac_ssid.mac_adress == line_entry[0], Mac_ssid.ssid == line_entry[1])).all()
session.close()
if returning_line:
return True
else:
return None
def get_links():
session = get_session()
session = session()
output = []
returning_links = session.query(Link).filter(Link.adamic_score != 0).all()
session.close()
if returning_links:
for link in returning_links:
output.append((link.jaccard_score, link.adamic_score, link.mod_adamic_score, link.idf_score, link.idf_similarity_score))
return output
def search_user(login):
session = get_session()
session = session()
user_query = session.query(User).filter(User.login == login)
user_query = user_query[0]
user_obj = UserObj(user_query.login, user_query.password)
user_obj.set_type(user_query.user_type)
session.close()
return user_obj
def search_mac_by_ssid(ssid):
list_macs = []
session = get_session()
session = session()
mac_query = session.query(Mac_ssid).filter(Mac_ssid.ssid == ssid).all()
if mac_query:
for returned_macs in mac_query:
list_macs.append(returned_macs.ssid)
session.close()
return list_macs
def add_mac(mac_entry):
session = get_session()
session = session()
new_mac = MacAdress()
new_mac.mac = mac_entry
session.add(new_mac)
session.commit()
session.refresh(new_mac)
mac_id = new_mac.id
session.close()
return mac_id
def search_question(question):
session = get_session()
session = session()
question_query = session.query(Question).filter(
Question.question == question)
question_query = question_query[0]
question_obj = QuestionObj(question_query.questop)
question_obj.set_description(question_query.description)
session.close()
return question_obj
def search_profile(name):
session = get_session()
session = session()
profile_query = session.query(Profile).filter(Profile.login == name)
profile_query = profile_query[0]
profile_obj = ProfileObj(profile_query.name, profile_query.specialty)
# TODO the rest of the attributes need to be returned as well
profile_obj.set_id(profile_query.id)
session.close()
return profile_obj
def add_ssid(ssid_entry):
session = get_session()
session = session()
new_ssid = SsidTable()
new_ssid.ssid = ssid_entry
session.add(new_ssid)
session.commit()
session.refresh(new_ssid)
ssid_id = new_ssid.id
session.close()
return ssid_id
def get_all_ssid_apearences():
session = get_session()
session = session()
list_of_ssids = []
query = session.query(Mac_ssid).all()
session.close()
if query:
for returning_ssid in query:
list_of_ssids.append(returning_ssid.ssid)
return list_of_ssids
else:
return []
def search_ssid_by_mac(mac):
list_ssid = []
session = get_session()
session = session()
ssid_query = session.query(Mac_ssid).filter(Mac_ssid.mac_adress == mac).all()
print(ssid_query)
if ssid_query:
for returned_ssids in ssid_query:
list_ssid.append(returned_ssids.ssid)
print(list_ssid)
session.close()
return list_ssid
def rank_ssid_by_apearences():
list_of_ssids = get_all_ssids()
output = []
session = get_session()
session = session()
for ssid_uniq in list_of_ssids:
ssid_query = session.query(Mac_ssid).filter(Mac_ssid.ssid == ssid_uniq).all()
number_appearences = len(ssid_query)
output.append((ssid_uniq, number_appearences))
output.sort(key=lambda tup: tup[1])
session.close()
return output
def add_line(mac, new_ssid):
session = get_session()
session = session()
line = Mac_ssid()
line.mac_adress = mac
line.ssid = new_ssid
session.add(line)
session.commit()
session.refresh(line)
retuning_id = line.id
session.close()
return retuning_id
def get_link(mac1, mac2):
session = get_session()
session = session()
returning_link = session.query(Link).filter(and_(Link.mac_id == mac1,Link.mac2_id == mac2)).all()
session.close()
if returning_link:
returning_link = returning_link[0]
link_obj = LinkOBJ(returning_link[0], returning_link[1], returning_link[2], returning_link[3],
returning_link[4], returning_link[5], returning_link[6])
return link_obj
else:
return None
def search_plant(scientific_name):
session = get_session()
session = session()
animal_query = session.query(Animal).filter(
Animal.scientific_name == scientific_name)
animal_query = animal_query[0]
animal_obj = AnimalObj(animal_query.scrientific_name,
animal_query.popular_name)
# TODO the rest of the attributes need to be returned as well
animal_obj.set_animal_id(animal_query.id)
session.close()
return animal_obj
def search_plant(scientific_name):
session = get_session()
session = session()
plant_query = session.query(Plant).filter(
Plant.scientific_name == scientific_name)
plant_query = plant_query[0]
plant_obj = PlantObj(plant_query.scrientific_name,
plant_query.popular_name)
# TODO the rest of the attributes need to be returned as well
plant_obj.set_plant_id(plant_query.id)
session.close()
return plant_obj
def search_all_ssid_macs(ssid):
session = get_session()
session = session()
list_macs = []
query = session.query(Mac_ssid).filter(Mac_ssid.ssid == ssid).all()
if query:
for element in query:
list_macs.append(element.ssid)
session.close()
return list_macs
else:
session.close()
return []
def validate_user(login, password):
session = get_session()
session = session()
user_query = session.query(User).filter(User.login == login,
User.password == password).all()
if len(user_query) > 0:
user_query = user_query[0]
user_obj = UserObj(user_query.login, user_query.password)
user_obj.set_type(user_query.user_type)
session.close()
return user_obj
else:
session.close()
return None
def add_user(user_obj):
session = get_session()
session = session()
new_user = User()
new_user.login = user_obj.get_login()
new_user.password = user_obj.get_password()
new_user.active = user_obj.get_state()
new_user.user_type = user_obj.get_type()
session.add(new_user)
session.commit()
session.refresh(new_user)
user_id = new_user.id
session.close()
return user_id
def add_question(question_obj):
session = get_session()
session = session()
new_question = Question()
new_question.id_user = question_obj.get_user_id()
new_question.id_tag = question_obj.get_tag_id()
new_question.question = question_obj.get_question()
new_question.description = question_obj.get_description()
session.add(new_question)
session.commit()
session.refresh(new_question)
question_id = new_question.id
session.close()
return question_id
def add_plant(plant_obj):
session = get_session()
session = session()
new_plant = Plant()
new_plant.scientific_name = plant_obj.get_scientific_name()
new_plant.popular_name = plant_obj.get_popular_name()
new_plant.family = plant_obj.get_family()
new_plant.kingdom = plant_obj.get_kingdom()
new_plant.phylum = plant_obj.get_phylum()
new_plant.description = plant_obj.get_description()
session.add(new_plant)
session.commit()
session.refresh(new_plant)
plant_id = new_plant.id
session.close()
return plant_id
def add_animal(animal_obj):
session = get_session()
session = session()
new_animal = Animal()
new_animal.scientific_name = animal_obj.get_scientific_name()
new_animal.popular_name = animal_obj.get_popular_name()
new_animal.family = animal_obj.get_family()
new_animal.kingdom = animal_obj.get_kingdom()
new_animal.phylum = animal_obj.get_phylum()
new_animal.description = animal_obj.get_description()
session.add(new_animal)
session.commit()
session.refresh(new_animal)
animal_id = new_animal.id
session.close()
return animal_id
def add_link(mac1, mac2, jaccard, adamic, m_adamic, idf, idf_similarity):
session = get_session()
session = session()
new_link = Link()
new_link.mac_id = mac1
new_link.mac2_id = mac2
new_link.jaccard_score = jaccard
new_link.adamic_score = adamic
new_link.mod_adamic_score = m_adamic
new_link.idf_score = idf
new_link.idf_similarity_score = idf_similarity
session.add(new_link)
session.commit()
session.refresh(new_link)
session.close()
link_id = new_link.id
return link_id if link_id else None
def add_profile(profile):
session = get_session()
session = session()
new_profile = Profile()
new_profile.name = profile.get_name()
new_profile.birth = profile.get_birth()
new_profile.city = profile.get_city()
new_profile.level = profile.get_level()
new_profile.occupation = profile.get_occupation()
new_profile.telephone = profile.get_phone()
new_profile.specialty = profile.get_specialty()
session.add(new_profile)
session.commit()
session.refresh(new_profile)
profile_id = new_profile.id
session.close()
return profile_id
