def registration(mobile_no, password,date_of_birth,dis_name,sec_qn,sec_ans): query = ("Insert into REGISTER_G15" "(mobile,password,recent_password,dob,name,security_que,security_ans)" "VALUES(%(mobile)s,%(password)s,%(recent_password)s,%(dob)s,%(name)s,%(security_que)s,%(security_ans)s)") args = (mobile_no, password, password, date_of_birth, dis_name, sec_qn, sec_ans) data = { 'mobile': mobile_no, 'password': password, 'recent_password': password, 'dob': date_of_birth, 'name': dis_name, 'security_que': sec_qn, 'security_ans': sec_ans, } try: con=DbConnectivity.create_connection() cur=con.cursor() cur.execute(query,data) con.commit() set_values.set_values(mobile_no) print("Registration Successful") return True except IntegrityError: raise MobileNumberAlreadyExists() except: raise InvalidDateException finally: cur.close() con.commit() con.close()
def get_credentials(mob): try: '''con=DbConnectivity.create_connection() cur = con.cursor() sql=("select password,name,to_char(last_login),login,abs(to_date(sysdate)-to_date(to_char(substr(last_login,1,9)),'dd-mon-yy')), \ to_char(to_date(to_char(substr(last_login,1,9)),'dd-mon-yy'),'Dy'),attempts from Register_G15 where mobile=%(mob)s") bind={"mob":mob,} cur.execute(sql,bind) list2=[]''' usr=set_values.set_values(mob) list2=[] list2.append(usr) ''' for password,name,last_login,login,totaldays,day,attempts in cur: list2.append(totaldays) list2.append(day) if (usr.get_mobile_no()==None): raise InvalidMobileNumberException()''' return list2 except: print ("some error in database connection") finally: '''cur.close() con.commit() con.close()''' pass
def login_page(mobile_no): print("What would you like to do?") print("1. Check My Chats") #print("2. Change Password") print("3. Logout") choice=raw_input("Choice") usr=set_values.set_values(mobile_no) status = False while status==False: if choice == '1' : check_my_chats.check_my_chats(usr) t=1 status=True elif choice == '21' : change_password.change_password(mobile_no, 0) status=True t=1 elif choice =='3': status=True t=0 break else: raw_input("Input valid Choice") if(t==1): login_page(mobile_no)
def set_recent_password(mobile_no,new_password): usr=set_values.set_values(mobile_no) list1=['','',''] if(usr.get_recent_password().count(',')!=0): recent_password=usr.get_recent_password().split(",") list1=recent_password for i in range(2,0,-1): list1[i]=list1[i-1] list1[0]=new_password else: list1[1]=usr.get_recent_password() list1[0]=new_password new_recent_password=new_password for i in range(1,len(list1)): new_recent_password+=','+list1[i] return new_recent_password
def change_password(mobile_no,flag): try: f=1 usr=set_values.set_values(mobile_no) if(flag==0): old_password=raw_input("Old Password:"******"New password:"******"Confirm Password:"******"Password Changed") #update_attempts(mobile_no,0) f=0 except PasswordMismatchException as e: print(e) except PasswordLengthException as e: print(e) except InvalidPasswordException as e: print(e) except RecentPasswordException as e: print(e) finally: if(flag==1): pass elif(flag==0): st=True while(st==True): if(f==0): break print("Do you wish to continue (Y/N)?") status = raw_input() if(status.upper()=='Y'): change_password(mobile_no,0) st=False elif(status.upper()=='N'): st=False else: print("Enter a valid Choice")
def Forgot_Password(): try: f=0 mobile_no=raw_input("Enter Mobile Number:") usr=set_values(mobile_no) validate_mobile_no.validate_mobile_no(mobile_no) dob=usr.get_dob() #dob=datetime.date(dob) #dob=str(dob).split('-') #print("Enter Date Of Birth:") #list1=['YYYY','MM','DD'] #x=random.randrange(0,2) #val=raw_input(list1[x]) #3validate_dob_security(dob[x],val) sec_qn=usr.get_sec_qn() print(sec_qn,"answe to you security question is") ans=raw_input("Answer : ") sec_ans=usr.get_sec_ans() validate_security.validate_security(sec_ans, ans) change_password(mobile_no,1) f=1 except InvalidMobileNumberException as e: print(e) except SecurityException as e: print(e) except InvalidDateException as e: print(e) except: print("Error") finally: if(f!=1): st=True while(st==True): print("Do you wish to continue(Y/N)?") status =raw_input() if(status.upper()=='Y'): Forgot_Password() st=False elif(status.upper()=='N'): st=False else: print("Enter a valid Choice")
def validate_mobile_no(mobile_no): usr=set_values.set_values(mobile_no) if(usr.get_mobile_no()==None): raise InvalidMobileNumberException()
def validate_login_password(mobile_no,password): usr=set_values.set_values(mobile_no) if(password!=usr.get_password()): #attempts+=1 #update_attempts(mobile_no,attempts) raise LoginUnSuccessfullException()