class Film:
def __init__(self):
self.db = DB("cineAdmin", "p@ssw0rd", "prueba")
def films(self):
sql = f"select nombre, img, autor, descripcion, clasificacion, estreno, video from peliculas;"
peliculas = self.db.run(sql)
return peliculas
def search(self, search):
sql = f"select nombre, img, autor, descripcion, clasificacion, estreno, video from peliculas where nombre like '%{search}%';"
write_log(sql)
return self.db.run(sql)
class User:
def __init__(self, name, email, password):
self.name = name
self.email = email
self.password = password
self.db = DB("cineAdmin", "p@ssw0rd", "prueba")
def add_user(self):
sql = "insert into users (name, email, password) \
values ('%s', '%s', '%s')" % (self.name, self.email, self.password)
#print(sql)
write_log(sql)
self.db.run(sql)
class EditProfile:
def __init__(self, name, email, password, session):
self.name = name
self.email = email
self.password = password
self.session = session
self.db = DB("cineAdmin", "p@ssw0rd", "prueba")
def edit(self):
sql = f"update users set name = '{self.name}', email = '{self.email}', password = '******' \
where name = '{self.session}'"
write_log(sql)
self.db.run(sql)
class Login:
def __init__(self, email, password):
self.email = email
self.password = password
self.db = DB("cineAdmin", "p@ssw0rd", "prueba")
def login(self):
sql = f'select password, email, name from users where password = "******" \
and email = "{self.email}"'
result = self.db.run(sql)
try:
return result[0]["name"]
except IndexError:
return None
write_log(sql)
from mysql import DB
db = DB("aragorn", "arazorn", "commands")
cmd = input("Introduzca el comando: ")
desc = input("Introduzca la descripción: ")
sql = "insert into commands values ('{}', '{}')".format(cmd, desc)
db.run(sql)
sql = "select * from commands order by name"
print(db.run(sql))
class VirtualMachine:
def __init__(self, id):
self.db = DB("emmet", "78636756dD.", "vmweb")
sql = f"select * from vmachine where id={id}"
query = self.db.query(sql)
self.name = query[0]["name"]
self.ram = query[0]["ram"]
self.cpu = query[0]["cpu"]
self.hdd = query[0]["hdd"]
self.os = query[0]["os"]
self.id = id
def stop(self):
sql = f"delete from process where vmachine_id={self.id}"
self.db.run(sql)
sql = f"update vmachine set status=0 where id={self.id}"
self.db.run(sql)
def start(self):
sql = f"update vmachine set status=1 where id={self.id}"
self.db.run(sql)
def suspend(self):
sql = f"update vmachine set status=2 where id={self.id}"
self.db.run(sql)
self.status = 2
def reboot(self):
self.stop()
self.start()
def get_processes(self):
sql = "select * from process where vmachine_id=1"
return self.db.query(sql)
def run(self, pid, ram, cpu, hdd):
sql = f"insert into process (pid, ram, cpu, hdd, vmachine_id) values ({pid}, {ram}, {cpu}, {hdd}, {self.id})"
self.db.run(sql)
def ram_usage(self):
ram = 0
for p in self.get_processes():
ram += p["ram"]
return ram * 100 / self.ram
def cpu_usage(self):
cpu = 0
for p in self.get_processes():
cpu += p["cpu"]
return cpu * 100 / self.cpu
def hdd_usage(self):
hdd = 0
for p in self.get_processes():
hdd += p["hdd"]
return hdd * 100 / self.hdd
def get_status(self):
sql = "select status from vmachine where id=1"
query = self.db.query(sql)
status = query[0]["status"]
if status == 0:
return "Stopped"
elif status == 1:
return "Running"
elif status == 2:
return "Suspended"
def __str__(self):
return """
{} <{}> [{}]
{:.2f}% RAM used | {:.2f}% CPU used | {:.2f}% HDD used
""".format(self.os, self.name, self.get_status(), self.ram_usage(),
self.cpu_usage(), self.hdd_usage())
class VirtualMachine:
def __init__(self, id):
self.db = DB("emmet", "brown", "vmweb")
sql = "select * from vmachine where id={}".format(id)
query = self.db.run(sql)
self.id = id
self.name = query[0]["name"]
self.ram = query[0]["ram"]
self.cpu = query[0]["cpu"]
self.hdd = query[0]["hdd"]
self.os = query[0]["os"]
def stop(self):
self.set_status(0)
sql = "delete from process where vmachine_id={}".format(self.id)
self.db.run(sql)
def start(self):
self.set_status(1)
def suspend(self):
self.set_status(2)
def reboot(self):
self.stop()
self.start()
def get_processes(self):
sql = "select * from process where vmachine_id={} order by pid".\
format(self.id)
return self.db.run(sql)
def run(self, pid, ram, cpu, hdd):
sql = "insert into process (pid, ram, cpu, hdd, vmachine_id) \
values({}, {}, {}, {}, {})".format(pid, ram, cpu, hdd, self.id)
self.db.run(sql)
def ram_usage(self):
ram = 0
for p in self.get_processes():
ram += p["ram"]
return ram * 100 / self.ram
def cpu_usage(self):
cpu = 0
for p in self.get_processes():
cpu += p["cpu"]
return cpu * 100 / self.cpu
def hdd_usage(self):
hdd = 0
for p in self.get_processes():
hdd += p["hdd"]
return hdd * 100 / self.hdd
def set_status(self, new_status):
sql = "update vmachine set status={} where id={}".format(
new_status, self.id)
self.db.run(sql)
def get_status(self):
sql = "select status from vmachine where id={}".format(self.id)
r = self.db.run(sql)
status = r[0]["status"]
if status == 0:
return "Stopped"
elif status == 1:
return "Running"
elif status == 2:
return "Suspended"
from mysql import DB
db = DB("gandalf", "Aragorn_3", "commands")
cmd = input("Introduzca el comando: ")
desc = input("Introduzca la descripción: ")
sql = "insert into commands values ('{}', '{}')".format(cmd, desc)
db.run(sql)
sql = "select * from commands order by name"
print(db.query(sql))
class VirtualMachine:
def __init__(self, id):
self.db = DB("abraham", "79072387cC$", "db_web")
sql = f"select * from vmachine where id={id}"
run = self.db.query(sql)
self.id = run[0]["id"]
self.name = run[0]["name"]
self.ram = run[0]["ram"]
self.cpu = run[0]["cpu"]
self.hdd = run[0]["hdd"]
self.os = run[0]["os"]
self.status = 0
# self.proc = list()
def stop(self):
sql = "update vmachine set status=0 where id=1"
self.db.run(sql)
sql = "delete from process where id=1"
self.db.run(sql)
self.status = 0
# self.proc = list()
def start(self):
sql = "update vmachine set status=1 where id=1"
self.db.run(sql)
self.status = 1
def suspend(self):
sql = "update vmachine set status=2 where id=1"
self.db.run(sql)
self.status = 2
def reboot(self):
self.stop()
self.start()
def get_process(self):
sql = f"select * from process where vmachine_id={self.id}"
return self.db.query(sql)
def run(self, pid, ram, cpu, hdd):
sql = f"insert into process (pid, ram, cpu, hdd, vmachine_id) values ({pid}, {ram}, {cpu}, {hdd}, 1)"
self.db.run(sql)
# self.proc.append(
# {
# "pid": pid,
# "ram": ram,
# "cpu": cpu,
# "hdd": hdd
# }
# )
def ram_usage(self):
ram = 0
for p in self.get_process():
ram += p["ram"]
return ram * 100 / self.ram
def cpu_usage(self):
cpu = 0
for p in self.get_process():
cpu += p["cpu"]
return cpu * 100 / self.cpu
def hdd_usage(self):
hdd = 0
for p in self.get_process():
hdd += p["hdd"]
return hdd * 100 / self.hdd
def get_status(self):
if self.status == 0:
return "Stopped"
elif self.status == 1:
return "Running"
elif self.status == 2:
return "Suspended"
def __str__(self):
return """
{} <{}> [{}]
{:.2f}% RAM used | {:.2f}% CPU used | {:.2f}% HDD used
""".format(self.os, self.name, self.get_status(), self.ram_usage(),
self.cpu_usage(), self.hdd_usage())
