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