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