def createSession(user): try: db = callDB('wordpress', 'wpuser', 'password', '127.0.0.1', '5432') assert db != False C = cookies.SimpleCookie() user_id = db.queryDB( '''select id from customers where username=%s''', user) assert user_id != False user_id = user_id[0][0] session_id = db.addSessionDB( '''insert into session(customer_id,created,user_timeout) values(%s,now(),now() + interval '30 minutes') returning id;''', user_id) assert session_id != False C['session_id'] = session_id C['session_id']['expires'] = 86400 C['session_id']['path'] = '/' except: logs.adminLog.error("Error while creating the session") logs.devLog.exception("Error while creating the session") print("There is a huge traffic in the store. Try again later.") finally: db.closeDB()
def createSession(user): try: site_db = callDB('wordpress','wpuser','password','127.0.0.1','5432') timeout = site_db.queryDB('''select c.id,p.user_timeout,p.auto_logout from customers c,pass_auth p where username=%s''',user) user_id = int(timeout[0][0]) user_timeout = datetime.now() + timedelta(seconds=timeout[0][1]) auto_logout = datetime.now() + timedelta(seconds=timeout[0][2]) user_timeout = user_timeout.strftime("%Y-%m-%d %H:%M:%S") auto_logout = auto_logout.strftime("%Y-%m-%d %H:%M:%S") check = site_db.executeDB('''insert into session(customer_id,timestamp,user_timeout,auto_logout) values(%s,%s,to_timestamp(%s,\'YYYY-MM-DD HH24:MI:SS\'), (select to_timestamp(%s,\'YYYY-MM-DD HH24:MI:SS\')))''', user_id,'now()',user_timeout,auto_logout) session_id = site_db.queryDB("""select id from session where customer_id = %s and auto_logout = %s""",user_id,auto_logout) #assert number lines == 1 return session_id[0][0] except (Exception,psycopg2.Error) as error: print("Error while creating session:",error) return False finally: site_db.closeDB()
def validate(session_id): try: db = callDB('wordpress', 'wpuser', 'password', '127.0.0.1', '5432') assert db != False check = db.queryDB( '''select (select user_timeout from session where id=%s) > now();''', session_id) assert check != False check = check[0][0] if check == True: return True else: return False except: logs.adminLog.error("Error while validating the session of %s" % (session_id)) logs.devLog.exception("Error while validating the session of %s" % (session_id)) print("This page is on huge load. Please try again later.") return False finally: db.closeDB()
def deleteSession(session_id): try: site_db = callDB('wordpress','wpuser','password','127.0.0.1','5432') site_db.executeDB("delete from session where id =%s",session_id) except (Exception,psycopg2.Error) as error: print("Error while deleting the session:",error) return False finally: site_db.closeDB()
def isValidSession(session_id): try: site_db = callDB('wordpress','wpuser','password','127.0.0.1','5432') timeout = site_db.queryDB('select user_timeout from session where id=%s;', session_id) if datetime.now() >= timeout[0][0]: return False else: return True except (Exception,psycopg2.Error) as error: return False finally: site_db.closeDB()
def deleteSession(session_id): try: db = callDB('wordpress','wpuser','password','127.0.0.1','5432') assert db != False delete = db.executeDB('''delete from session where id=%s''', session_id) assert delete != False except: logs.adminLog.error("Error while deleting the session of user with id: %s"%(session_id)) logs.devLog.exception("Error while deleting the session of user with id: %s"%(session_id)) print("Sorry we can't log you out now. Please try again in a moment !") return False finally: db.closeDB()
def renew(session_id): try: db = callDB('wordpress','wpuser','password','127.0.0.1','5432') assert db != False update = db.executeDB('''update session set user_timeout = now() + interval '30 minutes' where id=%s''', session_id) assert update != False except: logs.adminLog.error("Error while renewing the session of user with id: %s"%(session_id)) logs.devLog.exception("Error while renewing the session of user with id: %s"%(session_id)) print("Oops we ran into a problem. Please try again later !") return False finally: db.closeDB()
def renew(session_id): try: site_db = callDB('wordpress','wpuser','password','127.0.0.1','5432') timeout = site_db.queryDB('select user_timeout from pass_auth;') user_timeout = datetime.now() + timedelta(seconds=timeout[0][0]) user_timeout = user_timeout.strftime("%Y-%m-%d %H:%M:%S") site_db.executeDB('''update session set user_timeout = %s where id = %s;''',user_timeout,session_id) return session_id except (Exception,psycopg2.Error) as error: print("Error while creating session:",error) return False finally: site_db.closeDB()
import cgi, cgitb from passlib.hash import pbkdf2_sha256 import psycopg2 import datetime from callDB import callDB form = cgi.FieldStorage() user = form.getvalue('username') password = form.getvalue('psw') password_repeat = form.getvalue('psw_repeat') mail = form.getvalue('mail') country = form.getvalue('country') phone = form.getvalue('phone') wp_db = callDB('wordpress', 'wpuser', 'password', '127.0.0.1', '5432') user_data = wp_db.queryDB( 'select cu.username,cu.email,c.country,cu.phone\ from customers as cu,countries as c\ where username=%s and cu.country_id=c.id;', user) error = "" #if user != user_data[0][0]: # change = wp_db.executeDB('update customers set username=%s\ # where username=%s;',user,user_data[0][0]) # if change == False: # error += "The username already exists. Please use a different username. <br>" if password != None:
""") form = cgi.FieldStorage() user = form['acc'].value username = form.getvalue('username') password = form.getvalue('psw') password_repeat = form.getvalue('psw_repeat') mail = form.getvalue('mail') country = form.getvalue('country') address = form.getvalue('address') phone = form.getvalue('phone') wp_db = callDB('wordpress', 'wpuser', 'password', '127.0.0.1', '5432') user_data = wp_db.queryDB( 'select cu.username,cu.email,c.country,cu.address,cu.phone\ from customers as cu,countries as c\ where username=%s and cu.country_id=c.id;', user) wp_db.closeDB() ekatte_db = callDB('ekatte', 'ekatte_read', '1111', '127.0.0.1', '5432') print(user) ekatte_data = ekatte_db.queryDB('select id,name from settlements where id=%s;', user_data[0][3]) if len(ekatte_data) == 0: ekatte_data = ekatte_db.queryDB( 'select id,name from settlements where id=%s;', username)
#!/usr/bin/python3 # -*- coding: utf-8 -*- import cgi,cgitb import json from callDB import callDB wp_db = callDB('ekatte','ekatte_read','1111','127.0.0.1','5432') users = wp_db.queryDB('select name from settlements where id =6') print(users) user = users[0][0] info = user print("""Content-type:text/html\r\n\r\n <html> <head> <meta charset="UTF-8"> </head> %s """%info)