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()
