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)