def task1(self):
self.cursor = self.conn.cursor()
# display all account managers under current supervisor
self.cursor.execute('''
select p.pid
from personnel p
where p.supervisor_pid = :supervisor_id
and p.pid in (
select pid from account_managers)
''',
{"supervisor_id": self.user_id}
)
# select one account manager's ID
rows = self.cursor.fetchall()
available_account_mgr = set()
print("Select an account manager listed below: ")
for row in rows:
print(row[0])
available_account_mgr.add(row[0])
# select an account
while True:
mgr_id = input("Select an account manager ID: ")
if mgr_id in available_account_mgr:
break
else:
print("The account manager is not under current supervisor!")
am = AccountManager(mgr_id, self.conn, self.cursor)
am.task2()
from selenium.webdriver import Chrome
from selenium.webdriver.chrome.options import Options
from AccountManager import AccountManager
if __name__ == "__main__":
opts = Options()
opts.headless = True
browser = Chrome(options=opts, keep_alive=True)
account_manager = AccountManager(browser, "accounts.txt")
account_manager.start()
if (pickledGame.exists() != True):
GM = GameManager()
serializeObject(GM, "Game.pickle")
print("Created and Serialized Game Manager")
else:
print("Loaded Pickled Game File")
pickledFile = open(pickledGame, "rb")
GM = pickle.load(pickledFile)
GM.purgePlayers()
GM.clearSessions()
pickledAccounts = Path(os.getcwd() + "/Accounts.pickle")
Accounts = None
if (pickledAccounts.exists() != True):
Accounts = AccountManager()
Accounts.registerAccount("wesley", "play", IsAdmin=True)
serializeObject(Accounts, "Accounts.pickle")
print("Created and Serialized Account Manager")
else:
print("Loaded Pickled Accounts File")
pickledFile = open(pickledAccounts, "rb")
Accounts = pickle.load(pickledFile)
GM.AccountManager = Accounts
pickleThread = threading.Thread(target=save, args=[GM, Accounts])
pickleThread.start()
while 1:
menu = input(
"Hello, How are you? Enter 1 to log in , 2 to sign up, 3 to exit: "
)
menu = int(menu)
if menu == 1:
y = check()
user_id = y.getUser_id()
username = y.getusername()
driver_id = y.getdriver_id()
role = sign_in()
if role == 'Dispatcher':
dispatcher = Dispatcher(user_id, conn, cursor)
dispatcher.dispatcher_menu()
elif role == 'Account Manager':
accountManager = AccountManager(username, conn, cursor)
accountManager.menu()
elif role == 'Driver':
driver = Driver(driver_id, conn, cursor)
driver.driver_menu()
elif role == 'Supervisor':
supervisor = Supervisor(user_id, conn, cursor)
supervisor.supervisor_menu()
elif menu == 2:
sign_up()
elif menu == 3:
sys.exit()
# print(role)
import sqlite3
from AccountManager import AccountManager
if __name__ == "__main__":
db_file_path = "waste_management.db"
conn = sqlite3.connect(db_file_path)
cursor = conn.cursor()
manager00 = AccountManager(23451, conn, cursor)
manager01 = AccountManager(23452, conn, cursor)
manager00.menu()
