def deleteTransaccion(self, transaccion):
sql = """DELETE FROM transaccion WHERE dni_pasajero LIKE %s and nombre_bus LIKE %s"""
try:
cur.execute(
sql,
(transaccion.getDniPasajero(), transaccion.getNombreBus()))
except mysql.connector.Error as error:
print(error)
def showPasajeros(self):
sql = "SELECT * FROM pasajero"
try:
cur.execute(sql)
pasajeros = cur.fetchall()
except mysql.connector.Error as error:
print(error)
return pasajeros
def showTransaccion(self, dni_pasajero):
sql = "select * from transaccion where dni_pasajero = %s"
try:
cur.execute(sql, (dni_pasajero, ))
transaccion = cur.fetchall()
except mysql.connector.Error as error:
print(error)
return transaccion
def deleteTransaccionPasajero(self, dni):
sql = """DELETE FROM transaccion WHERE dni_pasajero LIKE %s"""
try:
cur.execute(sql, (dni, ))
rows_deleted = cur.rowcount
except mysql.connector.Error as error:
print(error)
return rows_deleted
def showBus(self, nombre):
sql = "select * from bus where nombre = %s"
try:
cur.execute(sql, (nombre, ))
bus = cur.fetchall()
except mysql.connector.Error as error:
print(error)
return bus
def deletePasajero(self, dni):
sql = "DELETE FROM pasajero WHERE dni = %s"
try:
cur.execute(sql, (dni, ))
rows_deleted = cur.rowcount
except mysql.connector.Error as error:
print(error)
return rows_deleted
def showPasajero(self, dni):
sql = "select * from pasajero where dni = %s"
try:
cur.execute(sql, (dni, ))
pasajero = cur.fetchall()
except mysql.connector.Error as error:
print(error)
return pasajero
def showBuses(self):
sql = "SELECT * FROM bus"
try:
cur.execute(sql)
buses = cur.fetchall()
except mysql.connector.Error as error:
print(error)
return buses
def comprobarTransaccionBus(self, nombrebus):
sql = "select * from transaccion where nombre_bus = %s"
try:
cur.execute(sql, (nombrebus, ))
transaccion = cur.fetchall()
except mysql.connector.Error as error:
print(error)
return transaccion
def deleteTransaccionBus(self, nombrebus):
sql = """DELETE FROM transaccion WHERE nombre_bus LIKE %s"""
try:
cur.execute(sql, (nombrebus, ))
rows_deleted = cur.rowcount
except mysql.connector.Error as error:
print(error)
return rows_deleted
def deleteBus(self, nombre):
sql = "DELETE FROM bus WHERE nombre = %s"
try:
cur.execute(sql, (nombre, ))
rows_deleted = cur.rowcount
except mysql.connector.Error as error:
print(error)
return rows_deleted
def updatePlazasVendidas(self, plazasVendidas, nombre):
sql = """UPDATE bus SET plazas_vendidas = (%s) WHERE nombre = (%s)"""
try:
cur.execute(sql, (plazasVendidas, nombre))
rows_set = cur.rowcount
except mysql.connector.Error as error:
print(error)
return rows_set
def comprobarTransaccion(self, transaccion):
sql = "select * from transaccion where nombre_bus = %s and dni_pasajero = %s"
try:
cur.execute(
sql,
(transaccion.getNombreBus(), transaccion.getDniPasajero()))
transaccion = cur.fetchall()
except mysql.connector.Error as error:
print(error)
return transaccion
def mostrarPasajeros(self, nombre):
sql = """SELECT p.dni, p.nombre, p.apellido, p.direccion, t.cantidad_billetes, t.fecha_compra
FROM pasajero as p
JOIN transaccion as t ON p.dni=t.dni_pasajero
JOIN bus as b ON t.nombre_bus=b.nombre
WHERE b.nombre LIKE %s"""
try:
cur.execute(sql, (nombre, ))
pasajeros = cur.fetchall()
except mysql.connector.Error as error:
print(error)
return pasajeros
def insertBus(self, objbus):
rows_count = 0
sql = """INSERT INTO bus(
nombre, numero_plazas, plazas_disponibles, plazas_vendidas)
VALUES (%s, %s, %s, %s);"""
try:
cur.execute(sql, (objbus.getNombre(), objbus.getPlazas(),
objbus.getPlazas(), 0))
rows_count = cur.rowcount
except mysql.connector.Error as error:
print(error)
return rows_count
def comprarBilletes(self, transaccion):
rows_count = 0
sql = """INSERT INTO transaccion(
nombre_bus, dni_pasajero, cantidad_billetes)
VALUES (%s, %s, %s);"""
try:
cur.execute(
sql, (transaccion.getNombreBus(), transaccion.getDniPasajero(),
transaccion.getBilletesAcomprar()))
rows_count = cur.rowcount
except mysql.connector.Error as error:
print(error)
return rows_count
def devolverBilletes(self, transaccion, billetesAdevolver):
rows_set = 0
billetescomprados = self.comprobarTransaccion(transaccion)[0][2]
billetescomprados -= billetesAdevolver
sql = """UPDATE transaccion SET cantidad_billetes = %s WHERE dni_pasajero like %s and nombre_bus = %s"""
try:
cur.execute(sql, (billetescomprados, transaccion.getDniPasajero(),
transaccion.getNombreBus()))
rows_set = cur.rowcount
except mysql.connector.Error as error:
print(error)
return rows_set
def insertPasajero(self, objpasajero):
rows_count = 0
sql = """INSERT INTO pasajero(
dni, apellido, nombre, direccion)
VALUES (%s, %s, %s, %s);"""
try:
cur.execute(
sql, (objpasajero.getDni(), objpasajero.getNombre(),
objpasajero.getApellido(), objpasajero.getDireccion()))
rows_count = cur.rowcount
except mysql.connector.Error as error:
print(error)
return rows_count
