def test_delete_project(self): Projects.Delete_project(self.con, 13) cursorObj = self.con.cursor() cursorObj.execute('Select * from Projects where Projectid=?', (13, )) output = cursorObj.fetchone() self.assertIsNone(output)
def BDO(buname): while True: print( "\nMenu\n(1)Create GPM accounts\n(2)Delete GPM accounts\n(3)Update GPM\n(4)Create Project\n(5)Update " "Project\n(6)Delete Project\n(7)Show GPM accounts\n(8)Show Projects\n(9)Show member accounts\n(10)See " "the complaints\n(11)Approve Pending Requests\n(12)Previous Menu" ) choice = input(">>> ").lower().rstrip() if choice == "1": print('Here you can add new GPM accounts') bdoid = buname User.sign_up(con, 'gpm', bdoid) elif choice == "2": print('Here you can delete GPM accounts') gpms = Grama.List_of_gpms(con, buname) pd.set_option('display.width', None) df = pd.DataFrame(gpms) df.columns = [ 'name', 'username', 'area', 'pincode', 'BdoUsername' ] print(df) uname = input("Please enter a username to be deleted : ") User.delete_account(con, uname, 'gpm') elif choice == "3": print('Here you can Update GPM accounts') gpms = Grama.List_of_gpms(con, buname) pd.set_option('display.width', None) df = pd.DataFrame(gpms) df.columns = [ 'name', 'username', 'area', 'pincode', 'BdoUsername' ] print(df) gpmid = input('Enter the GpmId you want to update : ') Grama.Update_GPM(con, buname, gpmid) elif choice == "4": print('Here you can Create a project') Projects.Create_project(con) elif choice == "5": cursorObj = con.cursor() print('Here you can Update a ProjectMain') Projects.show_projects(con) projid = input( 'Enter the id of the project you want to edit : ') cursorObj.execute('SELECT * from Projects where Projectid=?', (projid, )) projects = cursorObj.fetchone() if projects is not None: Projects.Update_project(con, projid) else: print('No project found with the id', projid) elif choice == "6": print('Here you can Delete a project') Projects.show_projects(con) projid = input( 'Enter the id of the project you want to delete : ') Projects.Delete_project(con, projid) elif choice == "7": print('Here you can see all the accounts') gpms = Grama.List_of_gpms(con, buname) pd.set_option('display.width', None) df = pd.DataFrame(gpms) df.columns = [ 'name', 'username', 'area', 'pincode', 'BdoUsername' ] print(df) elif choice == "8": print('Here you can see all the projects') Projects.show_projects(con) elif choice == "9": print('Here you can see all the member accounts') cursorObj = con.cursor() cursorObj.execute( 'SELECT Members.username,Members.Gpmapproved,Members.Bdoapproved,Members.WorkingDays,' 'Members.pincode,Members.wage,Members.attendance,Members.projectid from GPM INNER JOIN ' 'Members on GPM.username=Members.Gpmid ' 'where GPM.Bdo_id=?', (buname, )) member_under_bdos = cursorObj.fetchall() pd.set_option('display.width', None) df = pd.DataFrame(member_under_bdos) df.columns = [ 'Username', 'Gpm_Approved', 'Bdo_Approved', 'WorkingDays', 'Pincode', 'Wage', 'Attendance', 'ProjectId' ] print(df) elif choice == "10": print( 'Here you can see all the issues raised by the member under you' ) cursorObj = con.cursor() cursorObj.execute( 'SELECT Members.username from GPM INNER JOIN Members on GPM.username=Members.Gpmid ' 'where GPM.Bdo_id=?', (buname, )) memberid = cursorObj.fetchall() for member in memberid: cursorObj.execute( 'SELECT * from Complaints where memberid= ? ', (member[0], )) Complaints_received = cursorObj.fetchall() pd.set_option('display.width', None) df = pd.DataFrame(Complaints_received) try: df.columns = [ 'Id', 'Issue', 'MemberId', 'Bdo_remarks', 'Gpm_remarks' ] print(df) except: print('') main.BDO(buname) elif choice == "11": Projects.show_projects(con) cursorObj = con.cursor() cursorObj.execute( 'SELECT Members.username,Members.Gpmapproved,Members.Bdoapproved,Members.WorkingDays,' 'Members.pincode,Members.wage,Members.attendance,Members.projectid from GPM INNER JOIN ' 'Members on GPM.username=Members.Gpmid ' 'where GPM.Bdo_id=?', (buname, )) member_under_bdos = cursorObj.fetchall() pd.set_option('display.width', None) df = pd.DataFrame(member_under_bdos) df.columns = [ 'Username', 'Gpm_Approved', 'Bdo_Approved', 'WorkingDays', 'Pincode', 'Wage', 'Attendance', 'ProjectId' ] print(df) memuname = input( 'Enter the member username you want to approve : ') Projects.Approve_Projects(con, memuname) elif choice == "12": main.Login_master(con) else: print("Invalid choice, please choose again\n")