class Session:
def __init__(self):
self.username = None
self.sessionId = None
self.database = Database()
self.randomKey = RandomKeyGenerator()
def createSession(self):
self.randomKey.getRandomKey()
chk = self.checkSessionId()
while chk == 0 or chk == -1:
if chk == -1:
print "Sorry we cannot create a a session for you."
break
self.randomKey.getRandomKey()
chk == self.checkSessionId()
self.sessionId = self.randomKey.randomKey
sql = ("insert into session values ('%s','%s')") % (self.sessionId,
self.username)
try:
self.database.cursor.execute(sql)
self.database.commit()
return 1
except:
self.database.rollback()
print("Not able to start the session.")
return 0
def checkSessionId(self):
try:
sql = "select * from session where session_id = '%s'" % self.randomKey.randomKey
check = self.database.cursor.execute(sql)
if check == 1L:
return 0
else:
return 1
except:
return -1
def deleteSession(self):
sql = 'delete from session where username = "******"' % self.username
a = self.database.execute(sql)
def checkUserSession(self):
try:
sql = 'select * from session where username = "******"' % (
self.username)
check = self.database.cursor.execute(sql)
if check == 1L:
return 0
else:
return 1
except:
return -1
def __init__(self):
self.username = None
self.firstName = None
self.lastName = None
self.password = None
self.address = None
self.question = None
self.answer = None
self.email = None
self.database = Database()
self.database.connect()
self.container_id = b[0]["Id"]
self.container_ip = b[0]["NetworkSettings"]["Networks"]["bridge"][
"IPAddress"]
self.status = b[0]["State"]["Status"]
self.start_time = b[0]["State"]["StartedAt"]
self.end_time = b[0]["State"]["FinishedAt"]
self.container_name = b[0]["Name"]
if self.status == "running":
return
else:
print("Conatiner does not start.")
return
if __name__ == "__main__":
dbase = Database()
try:
if dbase.db:
con = Container()
uname = con.getUserName(dbase.cursor)
ch = con.fetchValue()
if ch == "addpy":
py = Python()
py.fetchname(self)
d = py.runpy(self, uname, dbase.cursor)
if d == 1:
print("""<p>Name: %s
Id: %s
Status: %s
IP: %s </p>""" % (d["Name"], d["ID"], d["Status"], d["IP"]))
dbase.db.commit()
def __init__(self):
self.username = None
self.sessionId = None
self.database = Database()
self.randomKey = RandomKeyGenerator()
class User:
def __init__(self):
self.username = None
self.firstName = None
self.lastName = None
self.password = None
self.address = None
self.question = None
self.answer = None
self.email = None
self.database = Database()
self.database.connect()
def addUser(self):
sql = (
'INSERT INTO user VALUES ("%s","%s","%s","%s","%s","%s","%s","%s")'
) % (self.username, self.firstName, self.lastName, self.password,
self.address, self.question, self.answer, self.email)
return self.database.execute(sql)
def closeConnection(self):
self.database.close()
def createDatabaseUser(self):
sql = ('create user "%s"@"172.17.0.1" identified by "%s"' %
(self.username, self.password))
return self.database.execute(sql)
def getUsername(self):
return self.username
def isUserExisting(self):
try:
chk = self.database.cursor.execute(
'select * from user where username = "******" or email = "%s"' %
(self.username, self.email))
if chk == 1L:
return 0
else:
return 1
except Exception as e:
print e
return -1
def verifyUser(self):
try:
sql = (
'select * from user where username = "******" and password = "******"'
% (self.username, self.password))
chk = self.database.cursor.execute(sql)
if chk == 1L:
return 0
else:
return 1
except:
return -1
def deleteUser(self):
try:
sql = 'delete from user where username="******"' % (self.username)
return self.database.execute()
except:
return -1