def retrievePassagemWithLocalizador(localizador):
sql = "SELECT id FROM passagens WHERE localizador = %s"
where = (localizador, )
try:
connection = db.connect(False)
connection["cursor"].execute(sql, where)
passagemId = transformPassagem(connection["cursor"].fetchone())
db.closeConnect(connection)
return passagemId
except mysql.connector.Error as err:
return 0
def insertCheckin(self):
sql = "INSERT INTO despachos (passagem, pagamento) VALUES (%s, %s)"
val = (self.passagem, self.pagamento)
try:
connection = db.connect(False)
connection["cursor"].execute(sql, val)
connection["connection"].commit()
db.closeConnect(connection)
return True
except mysql.connector.Error as err:
if err.errno == errorcode.ER_DUP_ENTRY:
return False
def retrieveVoosByDataOrigemDestino(data, origem, destino):
sql = "SELECT * FROM voos WHERE data = %s AND origem = %s AND destino = %s"
where = (data, origem, destino)
try:
connection = db.connect(False)
connection["cursor"].execute(sql, where)
voos = transformVoos(connection["cursor"].fetchall())
db.closeConnect(connection)
return voos
except mysql.connector.Error as err:
print(err)
return 0
def isBagagemPendent(passagemId):
sql = "SELECT COUNT(passagem) FROM despachos WHERE passagem = %s"
where = (passagemId, )
try:
connection = db.connect(False)
connection["cursor"].execute(sql, where)
checkin = connection["cursor"].fetchone()
print(checkin)
db.closeConnect(connection)
if checkin[0] > 0:
return False
return True
except mysql.connector.Error as err:
print(err)
return 0
import db.connectDatabase as db
import db.scripts.createTables as tables
try:
credential = db.connect(True)
credential["cursor"].execute("CREATE DATABASE airport;")
print("Criando banco de dados! Aguarde!")
credential["connection"].commit()
except:
print("Banco já existe! Solicitando a criação das tabelas!")
finally:
print("Executando de qualquer forma")
tables.createTables(credential)
db.closeConnect(credential)