def __get_person(self, person_label: Optional[str]) -> Optional[Person]:
gnd_id = ""
gender = ""
# )
return Person.optional(self._graph,
person_label,
gender=gender,
gnd_id=gnd_id)
def __get_person(self, person_label: Optional[str]) -> Optional[Person]:
gender_text = self.__sheet.get_from_table(Table.PERSONS, Column.name,
person_label, Column.gender)
gender = None
if gender_text == "M":
gender = Gender.MALE
elif gender_text == "F":
gender = Gender.FEMALE
gnd_id = self.__sheet.get_from_table(Table.PERSONS, Column.name,
person_label, Column.gnd_id)
return Person.optional(self._graph,
person_label,
gender=gender,
gnd_id=gnd_id)
from modules.person import Person
from modules.people import People
person1 = Person("Craig", "Chambers", "21/01/1968")
person2 = Person("Lance", "Smith", "23/12/2002")
people = People()
people.addPerson(person1)
people.addPerson(person2)
people.listPeople()
searching of person using id
'''
import base_dir
from modules.connection import DBConnection
from modules.person import Person
from modules.radix import RadixSorting
from modules.binary_searching import binary_search
import time
## connect to database
conn = DBConnection()
conn.connect()
## fetch all database rows
_person = Person(conn)
print("\n\tPlease Wait! Fetching all data from database...")
result = _person.read(random=True).fetchall()
# extract only the id and add the tuple to dictionary
base_list = []
base_dict = {}
for row in result:
base_list.append(row[0])
base_dict[row[0]] = row
## get search key from user
pid = int(input("\n\tEnter searching id? "))
print("\n\tPlease Wait! Searching data....")
9. sort by latitude
10. sort by media link
'''
import base_dir
from modules.connection import DBConnection
from modules.person import Person
from modules.radix import RadixSorting
from settings import COLUMN_ORDERS
import time
conn = DBConnection()
conn.connect()
_person = Person(conn)
print("\n\tPlease Wait! Fetching all data from database...")
result = _person.read(random=True).fetchall()
sort_by = int(input(__doc__+"\n Sort by: "))
if sort_by not in [0,1,2,3,4,5,6,7,8,9,10]: exit()
base_list = []
base_dict = {}
print("\n\tPlease Wait! Sorting data....")
start_time = time.clock()
if sort_by == 0: # if sort by id then only store id in base_list for keeping track of swappings
for row in result:
base_list.append(row[0])
def test_allocate_person(self):
self.test_allocate = Person()
self.allocate_person = {"Person": ["id"], Staff: True, Fellow: True}
self.assertTrue(self.allocate_person, True)
def test_check_duplicate_person_to_office(self):
'''test if person is already allocated.'''
self.allocate_person = Person()
self.assertEqual(self.allocate_person.view_allocated,
"Person already exists")
def test_add_person(self):
'''tests that person has been created'''
self.add_person = Person()
self.new_person = self.staff or self.fellow
self.assertEqual(self.new_person.add_person, {"emp_id": "name"})
import base_dir
from modules.validator import Validation
from modules.person import Person
from modules.connection import DBConnection
# create database connection
conn = DBConnection()
conn.connect()
# persons table relation
_person = Person(conn)
# for validating user inputs
validator = Validation()
while True:
option = int(input('''
1. Insert Person
2. Read All Persons
3. Read Person
4. Update Person
5. Delete Person
Enter your choice? '''))
if option == 1:
try:
name = validator.validate_name(input("\nEnter name* ? "))
phone = validator.validate_phone(input("Enter phone no.* ? "))
email = validator.validate_email(input("Enter email* ? "))