コード例 #1
0
ファイル: app.py プロジェクト: campusx-official/hit-db-demo
class Flipkart:
    def __init__(self):
        # connect to database
        self.db = DBhelper()
        self.user_menu()

    def loggedin_user_menu(self):
        user_input = input("""Hello how would you like to proceed?
        1. Enter 1 to see profile
        2. Enter 2 to update profile
        3. Enter 3 to delete profile
        4. Enter 4 to logout""")

    def user_menu(self):
        user_input = input("""Hello, how may I help you...
                1. Enter 1 to create an account
                2. Enter 2 to login 
                3. Press anything else to exit""")

        if user_input == "1":
            self.register()
        elif user_input == "2":
            self.login()
        else:
            sys.exit(0)

    def register(self):

        name = input("Enter your name")
        email = input("Enter your email")
        password = input("Enter your password")

        response = self.db.register(name, email, password)

        if response:
            print("Registration successful")
        else:
            print("Registration Failed")

        self.user_menu()

    def login(self):
        email = input("Enter your email")
        password = input("Enter your password")

        response = self.db.search(email, password)

        if len(response) != 0:
            print("Hello", response[0][1])
            self.loggedin_user_menu()
        else:
            print("Incorrect email/password")
            self.login()
コード例 #2
0
ファイル: tinder.py プロジェクト: Pravin971/Dating-App-MEET-
class Tinder(GUIhelper):
    def __init__(self):
        self.sessionId = 0
        self.db = DBhelper()
        super(Tinder, self).__init__(self.login, self.loadRegWindow)

    def login(self):
        print(self._emailInput.get())
        print(self._passwordInput.get())
        if self._emailInput.get() == "" or self._passwordInput.get() == "":
            self.label2.configure(text="please fill both the fields",
                                  bg="yellow",
                                  fg="red")
        else:
            if '@' not in self._emailInput.get():
                self.label2.configure(text="Invalid email format",
                                      bg="yellow",
                                      fg="red")
            else:
                # searching function from database
                data = self.db.search('email',
                                      self._emailInput.get(), 'password',
                                      self._passwordInput.get(), 'users')
                if len(data) == 1:
                    self.sessionId = data[0][0]
                    self.loadProfile()

                else:
                    self.label2.configure(text="login failed",
                                          bg="yellow",
                                          fg="red")

    def loadRegWindow(self):
        self.regWindow(self.registrationHandler)

    def registrationHandler(self):
        if self._nameInput.get() == "" or self._emailInput.get(
        ) == "" or self._passwordInput.get() == "" or self._genderInput.get(
        ) == "" or self._ageInput.get() == "" or self._cityInput.get() == "":
            self.label2.configure(text="Please Fill all the fields",
                                  bg="yellow",
                                  fg="red")
        else:
            regDict = {}

            regDict['user_id'] = "NULL"
            regDict['name'] = self._nameInput.get()
            regDict['email'] = self._emailInput.get()
            regDict['password'] = self._passwordInput.get()
            regDict['gender'] = self._genderInput.get()
            regDict['age'] = self._ageInput.get()
            regDict['city'] = self._cityInput.get()

            response = self.db.insert(regDict, 'users')

            if response == 1:
                self.label2.configure(
                    text="Registration Successful. Login to proceed",
                    bg="white",
                    fg="green")
                self._root.destroy()
                obj = Tinder()
            else:
                self.label2.configure(text="Registration Failed",
                                      bg="yellow",
                                      fg="red")

    def loadProfile(self):
        if self.sessionId != 0:
            data = self.db.searchOne('user_id', self.sessionId, 'users',
                                     "LIKE")
            self.mainWindow(self, data, mode=1)

    def viewProfile(self, num):
        if self.sessionId != 0:
            data = self.db.searchOne('user_id', self.sessionId, 'users',
                                     "NOT LIKE")
            if num == 0:
                new_data = []
                new_data.append(data[0])
                self.mainWindow(self, new_data, mode=2, num=num)
            elif num < 0:
                self.message("Error", "User Not Found")
            elif num > len(data) - 1:
                self.message("Error", "User Not Found")
            else:
                new_data = []
                new_data.append(data[num])
                self.mainWindow(self, new_data, mode=2, num=num)

    def propose(self, juliet_id):
        data = self.db.search('romeo_id', self.sessionId, 'juliet_id',
                              juliet_id, 'proposals')
        if len(data) == 0:
            propDict = {}
            propDict['romeo_id'] = str(self.sessionId)
            propDict['juliet_id'] = juliet_id

            response = self.db.insert(propDict, 'proposals', 1)

            if response == 1:
                self.message("Yayyyyyyyy", "Proposal sent. Fingers Crossed")
            else:
                self.message("Nayyyyyyyy", "Not Sent.")

        else:
            self.message("Invalid", "Proposal Already Sent")

    def myLogout(self):
        self._root.destroy()
        obj = Tinder()

    def editProfile(self):

        self.clean()
        if self.sessionId != 0:
            data = self.db.searchOne('user_id', self.sessionId, 'users',
                                     "LIKE")
            self.mainWindow(self, data, mode=3)

    def save(self, data):

        updateDict = {}

        if self._nameInput.get() == "":
            updateDict['name'] = data[0][1]
        else:
            updateDict['name'] = self._nameInput.get()

        if self._passwordInput.get() == "":
            updateDict['password'] = data[0][3]
        else:
            updateDict['password'] = self._passwordInput.get()

        if self._genderInput.get() == "":
            updateDict['gender'] = str(data[0][4])
        else:
            updateDict['gender'] = self._genderInput.get()

        if self._ageInput.get() == "":
            updateDict['age'] = str(data[0][5])
        else:
            updateDict['age'] = self._ageInput.get()

        if self._cityInput.get() == "":
            updateDict['city'] = data[0][6]
        else:
            updateDict['city'] = self._cityInput.get()

        response = self.db.update(updateDict, 'users', str(self.sessionId))

        if response == 1:
            self.message("Message", "Update Successful!!")
        else:
            self.message("Message", "Update Failed!!")

    def editProfilePic(self):
        filename = filedialog.askopenfilename(
            initialdir=r"C:\Users\AMAN\PycharmProjects\tinderb3\img",
            title="Select an image ",
            filetype=(("jpeg", "*.jpg"), (r"All files", "*.*")))
        filename = filename.split('/')[-1]
        self.db.setDp(filename, 'users', 'user_id', 'dp',
                      str(self.sessionIdkus))
コード例 #3
0
class Tinder(GUIhelper):
    def __init__(self):
        self.db = DBhelper()
        super(Tinder, self).__init__(self.login, self.loadRegWindow)

    def login(self):
        if self._emailInput.get() == "" or self._passwordInput.get() == "":
            self.label2.configure(text="Please fill both the fields",
                                  bg="yellow",
                                  fg="red")

        else:
            if '@' not in self._emailInput.get():
                self.label2.configure(text="Invalid email format",
                                      bg="yellow",
                                      fg="red")
            else:
                #login
                data = self.db.search('email',
                                      self._emailInput.get(), 'password',
                                      self._passwordInput.get(), 'users')
                if len(data) == 1:
                    self.sessionId = data[0][0]
                    self.loadProfile()
                    self.label2.configure(text="Login Successful",
                                          bg="green",
                                          fg="white")
                else:
                    self.label2.configure(text="Login Failed",
                                          bg="yellow",
                                          fg="red")

    def loadRegWindow(self):
        self.regWindow(self.registrationHandler)

    def registrationHandler(self):
        if self._nameInput.get() == "" or self._emailInput.get(
        ) == "" or self._passwordInput.get() == "" or self._genderInput.get(
        ) == "" or self._ageInput.get() == "" or self._cityInput.get() == "":
            self.label2.configure(text="Please fill all the fields",
                                  bg="yellow",
                                  fg="red")
        else:
            regDict = {}

            regDict['name'] = self._nameInput.get()
            regDict['email'] = self._emailInput.get()
            regDict['password'] = self._passwordInput.get()
            regDict['gender'] = self._genderInput.get()
            regDict['age'] = self._ageInput.get()
            regDict['city'] = self._cityInput.get()

            response = self.db.insert(regDict, 'users')
            if response == 1:
                self.label2.configure(text="Registration successful",
                                      bg="white",
                                      fg="green")
                self._root.destroy()
                self.obj = Tinder()
            else:
                self.label2.configure(text="Registration failed",
                                      bg="yellow",
                                      fg="red")

    def loadProfile(self):
        data = self.db.searchOne('user_id', self.sessionId, 'users', "LIKE")
        self.mainWindow(self, data, mode=1)

    def editProfile(self):
        filename = filedialog.askopenfilename(
            initialdir="C:/Users\MOHIT/Desktop/project_idle/img/",
            title="Select an image ",
            filetype=(("jpeg", "*.jpg"), ("All files", "*.*")))
        filename = filename.split('/')[-1]
        self.db.setDp(filename, 'users', 'user_id', 'dp', str(self.sessionId))
        self.loadProfile()

    def viewProfile(self, num, mode):
        if mode == 3:
            data = self.db.searchMyProposals('users', 'user_id', 'juliet_id',
                                             'proposals', 'romeo_id',
                                             str(self.sessionId))
        elif mode == 4:
            data = self.db.searchMyRequests('users', 'user_id', 'romeo_id',
                                            'proposals', 'juliet_id',
                                            str(self.sessionId))
        elif mode == 5:
            data = self.db.searchMyMatches('users', 'user_id', 'romeo_id',
                                           'proposals', 'juliet_id',
                                           str(self.sessionId))
        else:
            data = self.db.searchOne('user_id', self.sessionId, 'users',
                                     "NOT LIKE")
        if len(data) == 0:
            num = -1
        new_data = []
        if num == 0:
            new_data.append(data[0])
            self.mainWindow(self, data, mode, num=num)
        if num < 0:
            self.message("Error ", " Can not load data")
        if num >= len(data):
            self.message("Error ", " Can not load data")
        else:
            new_data.append(data[num])
            self.mainWindow(self, new_data, mode, num=num)

    def propose(self, juliet_Id):
        data = self.db.search('romeo_id', str(self.sessionId), 'juliet_id',
                              str(juliet_Id), 'proposals')
        if len(data) == 0:
            procDict = {}
            procDict['romeo_id'] = str(self.sessionId)
            procDict['juliet_id'] = str(juliet_Id)
            response = self.db.insert(procDict, 'proposals', 1)
            if response == 1:
                self.message("Congrats",
                             "Proposal sent successful. Fingers crossed!")
            else:
                self.message("Tough Luck", "Proposal failed. Try again !")
        else:
            self.message("Error", "Despo Sala")

    def logOut(self):
        #relogin
        self._root.destroy()
        self.obj = Tinder()
コード例 #4
0
class Tinder(GUIhelper):
    def __init__(self, ):
        self.db = DBhelper(
        )  #It will call the DBhelper class to connect the web app to the database
        super(Tinder, self).__init__(
            self.login,
            self.load_reg_window)  #parent class can use methods of child class

#this method will check if the correct log in details are filled by the user

    def login(self):
        if self._emailInput.get() == "" or self._passwordInput.get() == "":
            self.label2.configure(text="please fill both the fields",
                                  bg="yellow",
                                  fg="red")
        else:
            if '@' not in self._emailInput.get():
                self.label2.configure(text="Email input invalid",
                                      bg="yellow",
                                      fg="red")
            else:
                data = self.db.search("email",
                                      self._emailInput.get(), "password",
                                      self._passwordInput.get(), "users")
                if len(data) == 1:
                    self.sessionId = (data[0][0])
                    self.loadProfile()
                    #self.mainWindow(data)
                else:
                    self.label2.configure(text="Login Failed",
                                          bg="red",
                                          fg="white")

    def load_reg_window(self):
        num = 0
        self.regWindow(lambda: self.handleRegistration(num))

    def handleRegistration(self, num):
        #print("handle reg")
        # print(num)
        if self._emailInput.get() == "" or self._passwordInput.get(
        ) == "" or self._nameInput.get() == "" or self._cityInput.get(
        ) == "" or self._genderInput.get() == "" or self._ageInput.get(
        ) == "" or self._dpInput.get() == "":
            self.label2.configure(text="Please fill all the fields",
                                  bg="yellow",
                                  fg="red")
        else:
            if len(self._passwordInput.get()) < 6:
                self.label2.configure(
                    text="Password should be greater than 6 chars",
                    bg="yellow",
                    fg="red")
            else:
                #print("regdict")
                regDict = {}
                #regDict['user_id']='NULL'
                regDict['name'] = self._nameInput.get()
                regDict['email'] = self._emailInput.get()
                regDict['password'] = self._passwordInput.get()
                regDict['gender'] = self._genderInput.get()
                regDict['age'] = self._ageInput.get()
                regDict['city'] = self._cityInput.get()
                regDict['dp'] = self._dpInput.get()
                if num == 0:
                    data = self.db.searchOne('email', self._emailInput.get(),
                                             'users', 'LIKE')
                    print(len(data))
                    if len(data) == 1:
                        self.message("Registration Failed",
                                     "This Email Id is already registered")
                        self.regWindow(lambda: self.handleRegistration(num))
                    else:
                        response = self.db.insert(regDict, 'users')
                        if response == 1:
                            #GUIhelper(self.login,self.load_reg_window)
                            #self.label2.configure(text="Registration successful")
                            print("registration successful")
                            self._root.destroy()
                            Tinder()
                        else:
                            self.label2.configure(text="Registration failed")
                            print("registratioin failed")
                else:
                    response = self.db.update(regDict, 'users', self.sessionId)

                    if response == 1:
                        #GUIhelper(self.login,self.load_reg_window)
                        #self.label2.configure(text="Registration successful")
                        print("Update successful")
                        data = self.db.searchOne('user_id', self.sessionId,
                                                 'users', 'LIKE')
                        self.mainWindow(self, data, mode=1)

    def loadProfile(self):
        data = self.db.searchOne('user_id', self.sessionId, 'users', 'LIKE')
        self.mainWindow(self, data, mode=1)

#this method will show profile of different people to the user

    def viewProfile(self, num):
        data = self.db.searchOne('user_id', self.sessionId, 'users',
                                 'NOT LIKE')
        if num == 0:
            self.mainWindow(self, data, mode=2, num=num)
        if num < 0:
            self.message("Error", "hobe na!")
        if num > len(data) - 1:
            self.message("Error", "hobe na!")
        else:
            new_data = []
            new_data.append(data[num])
            self.mainWindow(self, new_data, mode=2, num=num)

#this method will be used to edit the profile of the user

    def editProfile(self):
        num = 1
        data = self.db.searchOne('user_id', self.sessionId, 'users', 'LIKE')
        self.editWindow(data, lambda: self.handleRegistration(num))

#this method will be triggered wwhen purpose button will be clicked

    def propose(self, juliet_id):
        data = self.db.search('romeo_id', str(self.sessionId), 'juliet_id',
                              str(juliet_id), 'proposals')
        if len(data) == 0:
            propDict = {}
            propDict['romeo_id'] = str(self.sessionId)
            propDict['juliet_id'] = str(juliet_id)
            response = self.db.insert(propDict, 'proposals')
            if response == 1:
                self.message("congrats", "proposal sent")
            else:
                self.message("Error", "proposal failed")
        else:
            self.message("Error", "despo sala!")

#this method will be triggred when logout button will be clicked

    def logout(self):
        self._root.destroy()
        Tinder()
#this method will be triggered when my proposal button will be clicked

    def viewProposal(self, num):
        if self.sessionId != 0:
            data = self.db.searchOne('romeo_id', self.sessionId, 'proposals',
                                     "LIKE")
            #print(data)
            l1 = [val[2] for val in data]
            l1 = tuple(l1)
            #print(l1)
            if (len(l1) > 1):
                data = self.db.searchOneFromList('user_id', l1, 'users', "IN")
                print(data)

                if num == 0:
                    new_data = []
                    new_data.append(data[0])
                    self.mainWindow(self, new_data, mode=3, num=num)  #
                elif num < 0:
                    self.message("Error", "User Khtm")
                elif num > len(data) - 1:
                    self.message("Error", "User Khtm")
                else:
                    new_data = []
                    new_data.append(data[num])
                    self.mainWindow(self, new_data, mode=3, num=num)
            elif (len(l1) == 1):
                data = self.db.searchOne('user_id', l1[0], 'users', "LIKE")
                if num == 0:
                    new_data = []
                    new_data.append(data[0])
                    self.mainWindow(self, new_data, mode=3, num=num)  #
                elif num < 0:
                    self.message("Error", "User Khtm")
                elif num > len(data) - 1:
                    self.message("Error", "User Khtm")
                else:
                    new_data = []
                    new_data.append(data[num])
                    self.mainWindow(self, new_data, mode=3, num=num)
            else:
                self.message("", "No proposal Found")
#this method will be triggerd when My Request button will be clicked

    def viewRequest(self, num):
        if self.sessionId != 0:
            data = self.db.searchOne('juliet_id', self.sessionId, 'proposals',
                                     "LIKE")
            print(data)
            l1 = [val[1] for val in data]
            l1 = tuple(l1)
            print(l1)
            if (len(l1) > 1):
                data = self.db.searchOneFromList('user_id', l1, 'users', "IN")
                #print(data)

                if num == 0:
                    new_data = []
                    new_data.append(data[0])
                    self.mainWindow(self, new_data, mode=4, num=num)  #
                elif num < 0:
                    self.message("Error", "User Khtm")
                elif num > len(data) - 1:
                    self.message("Error", "User Khtm")
                else:
                    new_data = []
                    new_data.append(data[num])
                    self.mainWindow(self, new_data, mode=4, num=num)
            elif (len(l1) == 1):
                data = self.db.searchOne('user_id', l1[0], 'users', "LIKE")
                if num == 0:
                    new_data = []
                    new_data.append(data[0])
                    self.mainWindow(self, new_data, mode=4, num=num)  #
                elif num < 0:
                    self.message("Error", "User Khtm")
                elif num > len(data) - 1:
                    self.message("Error", "User Khtm")
                else:
                    new_data = []
                    new_data.append(data[num])
                    self.mainWindow(self, new_data, mode=4, num=num)
            else:
                self.message("So Sad!!", "No Requests Found")


#this method will be triggered when My Matches button will be clicked

    def viewMatching(self, num):
        if (self.sessionId != 0):
            proposal_data = self.db.searchOne('romeo_id', self.sessionId,
                                              'proposals', "LIKE")
            #print(proposal_data)
            proposal_list = [val[2] for val in proposal_data]
            #print(proposal_list)
            request_data = self.db.searchOne('juliet_id', self.sessionId,
                                             'proposals', "LIKE")
            request_list = [val[1] for val in request_data]
            #print(request_list)
            l1 = tuple(set(proposal_list) & set(request_list))
            #print(l1)
            if (len(l1) > 1):
                data = self.db.searchOneFromList('user_id', l1, 'users', "IN")
                #print(data)

                if num == 0:
                    new_data = []
                    new_data.append(data[0])
                    self.mainWindow(self, new_data, mode=5, num=num)
                elif num < 0:
                    self.message("Error", "User Khtm")
                elif num > len(data) - 1:
                    self.message("Error", "User Khtm")
                else:
                    new_data = []
                    new_data.append(data[num])
                    self.mainWindow(self, new_data, mode=5, num=num)
            elif (len(l1) == 1):
                data = self.db.searchOne('user_id', l1[0], 'users', "LIKE")
                if num == 0:
                    new_data = []
                    new_data.append(data[0])
                    self.mainWindow(self, new_data, mode=5, num=num)  #
                elif num < 0:
                    self.message("Error", "User Khtm")
                elif num > len(data) - 1:
                    self.message("Error", "User Khtm")
                else:
                    new_data = []
                    new_data.append(data[num])
                    self.mainWindow(self, new_data, mode=4, num=num)
            else:
                self.message("So Sad!!", "No Matchings Found")
コード例 #5
0
class Tinder(GUIhelper):
    
    def __init__(self):
        self.sessionId=0
        self.db=DBhelper()
        super(Tinder, self).__init__(self.login, self.loadRegWindow)

    def login(self):
        if self._emailInput.get()=="" or self._passwordInput.get()=="":
            self.label2.configure(text="Please fill both the fields",bg="yellow",fg="red")
        else:
            if '@' not in self._emailInput.get():
                self.label2.configure(text="Email input invalid",bg="yellow",fg="red")
            else:
                data=self.db.search('email',self._emailInput.get(),'password',self._passwordInput.get(),'users')
                if len(data)==1:
                    self.clean()
                    self.sessionId=data[0][0]
                    self.loadProfile()
                    #self.mainWindow(data)
                else:
                    self.label2.configure(text="Login Failed",bg="red", fg="white")




    def loadRegWindow(self):
        num=0
        self.regWindow(lambda:self.registrationHandler(num))
        #self.clean()

    def registrationHandler(self,num):
        if self._nameInput.get()=="" or self._emailInput.get()=="" or self._passwordInput.get()=="" or self._genderInput.get()=="" or self._ageInput.get()=="" or self._cityInput.get()=="" or self._dpInput.get()=="":
            self.label2.configure(text="Please fill all the fields",bg="yellow",fg="red")
        else:
            regDict={}
    
            #regDict['user_id']="NULL"
            regDict['name']=self._nameInput.get()
            regDict['email']=self._emailInput.get()
            regDict['password']=self._passwordInput.get()
            regDict['gender']=self._genderInput.get()
            regDict['age']=self._ageInput.get()
            regDict['city']=self._cityInput.get()
            regDict['Dp']=self._dpInput.get()

            if num==0:

                response=self.db.insert(regDict,'users')
            else:
                response=self.db.update(regDict,'users',self.sessionId)
            #print(response)
            if response==1:
                
                #self.clean()
                #obj=GUIhelper(self.login,self.loadRegWindow)
                self.label2.configure(text="Registration Successful. Login to proceed", bg="white", fg="green")
                self._root.destroy()
                obj=Tinder()

                
            else:
                
                self.label2.configure(text="Registration Failed", bg="yellow", fg="red")

#-----------------------------------------------------------------    #Self Added
    def logout(self):
        self._root.destroy()
      #self.label2.configure(text="Logout Successfully", bg="yellow", fg="red")
        obj=Tinder()
#-------------------------------------------------------------------------------------   
    
#-----------------------------------------------------------------------------
    def editProfile(self):
        num=1
        data=self.db.searchOne('user_id',self.sessionId,'users','LIKE')
        self.editWindow(data,lambda:self.registrationHandler(num))


    
#------------------------------------------------------------------



    def loadProfile(self):
        if self.sessionId!=0:
            
            data=self.db.searchOne('user_id',self.sessionId,'users',"LIKE")
            self.mainWindow(self,data,mode=1)
            
            
            
    def viewProfile(self,num):
        if self.sessionId!=0:
            data=self.db.searchOne('user_id',self.sessionId,'users',"NOT LIKE")
            #print(data)
            if num==0:
                new_data=[]
                new_data.append(data[0])
                self.mainWindow(self,new_data,mode=2,num=num)    #
            elif num<0:
                self.message("Error","User Khtm")
            elif num>len(data)-1:
                self.message("Error","User Khtm")
            else:
                new_data=[]
                new_data.append(data[num])
                self.mainWindow(self,new_data,mode=2,num=num)
                
                
    def propose(self,juliet_id):
        data=self.db.search('romeo_id',self.sessionId,'juliet_id',juliet_id,'proposals')
        if len(data)==0:
            propDict={}
            propDict['romeo_id']=str(self.sessionId)
            propDict['juliet_id']=juliet_id
            response=self.db.insert(propDict,'proposals')
            if response==1:
                self.message("Yayyyy","Proposal sent.Fingers Crossed")
            else:
                self.message("Nayyyyy","Nai gya manhoos")
        else:


            self.message("Invalid","Despo sale")    
        
    #functions for view_proposals    
    def viewProposal(self,num):
        if self.sessionId!=0:
            data=self.db.searchOne('romeo_id',self.sessionId,'proposals',"LIKE")
            #print(data)
            l1 =[val[2] for val in data]
            l1=tuple(l1)
            #print(l1)
            if (len(l1)>1):
                data=self.db.searchOneFromList('user_id',l1,'users',"IN")
                print(data)
            
                if num==0:
                    new_data=[]
                    new_data.append(data[0])
                    self.mainWindow(self,new_data,mode=3,num=num)    #
                elif num<0:
                    self.message("Error","User Khtm")
                elif num>len(data)-1:
                    self.message("Error","User Khtm")
                else:
                    new_data=[]
                    new_data.append(data[num])
                    self.mainWindow(self,new_data,mode=3,num=num)
            elif(len(l1)==1):
                data=self.db.searchOne('user_id',l1[0],'users',"LIKE")
                if num==0:
                    new_data=[]
                    new_data.append(data[0])
                    self.mainWindow(self,new_data,mode=3,num=num)    #
                elif num<0:
                    self.message("Error","User Khtm")
                elif num>len(data)-1:
                    self.message("Error","User Khtm")
                else:
                    new_data=[]
                    new_data.append(data[num])
                    self.mainWindow(self,new_data,mode=3,num=num)
            else:
                self.message("","No proposal Found")
                
    #functions for view Requests
    def viewRequest(self,num):
        if self.sessionId!=0:
            data=self.db.searchOne('juliet_id',self.sessionId,'proposals',"LIKE")
            print(data)
            l1 =[val[1] for val in data]
            l1=tuple(l1)
            print(l1)
            if(len(l1)>1):
                data=self.db.searchOneFromList('user_id',l1,'users',"IN")
                #print(data)

                if num==0:
                    new_data=[]
                    new_data.append(data[0])
                    self.mainWindow(self,new_data,mode=4,num=num)    #
                elif num<0:
                    self.message("Error","User Khtm")
                elif num>len(data)-1:
                    self.message("Error","User Khtm")
                else:
                    new_data=[]
                    new_data.append(data[num])
                    self.mainWindow(self,new_data,mode=4,num=num)
            elif(len(l1)==1):
                data=self.db.searchOne('user_id',l1[0],'users',"LIKE")
                if num==0:
                    new_data=[]
                    new_data.append(data[0])
                    self.mainWindow(self,new_data,mode=4,num=num)    #
                elif num<0:
                    self.message("Error","User Khtm")
                elif num>len(data)-1:
                    self.message("Error","User Khtm")
                else:
                    new_data=[]
                    new_data.append(data[num])
                    self.mainWindow(self,new_data,mode=4,num=num)
            else:
                self.message("So Sad!!","No Requests Found")
    
    #function to see the matchings
    def viewMatching(self,num):
        if (self.sessionId!=0):
            proposal_data=self.db.searchOne('romeo_id',self.sessionId,'proposals',"LIKE")
            #print(proposal_data)
            proposal_list=[val[2] for val in proposal_data]
            #print(proposal_list)
            request_data=self.db.searchOne('juliet_id',self.sessionId,'proposals',"LIKE")
            request_list=[val[1] for val in request_data]
            #print(request_list)
            l1=tuple(set(proposal_list)&set(request_list))
            #print(l1)
            if(len(l1)>1):
                data=self.db.searchOneFromList('user_id',l1,'users',"IN")
                #print(data)

                if num==0:
                    new_data=[]
                    new_data.append(data[0])
                    self.mainWindow(self,new_data,mode=5,num=num)    #
                elif num<0:
                    self.message("Error","User Khtm")
                elif num>len(data)-1:
                    self.message("Error","User Khtm")
                else:
                    new_data=[]
                    new_data.append(data[num])
                    self.mainWindow(self,new_data,mode=5,num=num)
            elif(len(l1)==1):
                data=self.db.searchOne('user_id',l1[0],'users',"LIKE")
                if num==0:
                    new_data=[]
                    new_data.append(data[0])
                    self.mainWindow(self,new_data,mode=5,num=num)    #
                elif num<0:
                    self.message("Error","User Khtm")
                elif num>len(data)-1:
                    self.message("Error","User Khtm")
                else:
                    new_data=[]
                    new_data.append(data[num])
                    self.mainWindow(self,new_data,mode=4,num=num)
            else:
                self.message("So Sad!!","No Matchings Found")