def verify_client_customer(conn, user_id, client):
sql = "SELECT * FROM queue_client qc, queue q where qc.id_queue = q.id_queue and id_queue_client = '" + client + "' and id_user = '******' and date_out is null"
rows = mysqlutils.execute(conn, sql, False)
if len(rows) > 0:
return True
else:
return False
def verify_user_queue(conn, user_id, queue_id):
sql = "SELECT * FROM queue WHERE id_user = '******' and id_queue = '"+queue_id+"'"
rows = mysqlutils.execute(conn, sql, False)
if len(rows) > 0:
return True
else:
return False
def get_user_queue(conn, user_id, queue_id):
sql = "SELECT * FROM queue WHERE id_user = '******'"
#if exists an id to bring an especific queue
if queue_id:
sql += " AND id_queue = '" + queue_id + "'"
rows = mysqlutils.execute(conn, sql, False)
return parse_queue(rows)
def lambda_handler(event, context):
#get body and token (Bearer)
queue = json.loads(event['body'])
token = get_token_from_headers(event['headers'])
#validate name
if 'name' not in queue or not queue['name']:
return response('Digite o nome da fila!', 400)
#validate maximum qtd caracteres in name
if (len(queue['name']) > int(os.environ['MAXIMUM_QTD_NAME'])):
return response(
'Nome nao pode conter mais que ' + os.environ['MAXIMUM_QTD_NAME'] +
' caracteres!', 400)
#validate maximum qtd caracteres in text and end queue
if (len(queue['text_queue']) > int(os.environ['MAXIMUM_QTD_TEXT'])):
return response(
'Texto da fila nao pode conter mais que ' +
os.environ['MAXIMUM_QTD_TEXT'] + ' caracteres!', 400)
if (len(queue['end_queue']) > int(os.environ['MAXIMUM_QTD_TEXT'])):
return response(
'Texto de chamada nao pode conter mais que ' +
os.environ['MAXIMUM_QTD_TEXT'] + ' caracteres!', 400)
#decode jwt and id_user
token_decoded = utils.jwt_decode(token,
ssmutils.get_parameter_store('TOKEN_KEY'))
#setting variables
id_queue = id = str(uuid.uuid1())
name = queue['name']
text_queue = queue['text_queue']
end_queue = queue['end_queue']
id_user = token_decoded['inf']['uuid']
#connection
conn = connection()
sql = "INSERT INTO queue(id_queue, name, text_queue, end_queue, date_register, id_user) VALUES ('" + id_queue + "', '" + name + "', '" + text_queue + "', '" + end_queue + "', NOW(),'" + id_user + "')"
mysqlutils.execute(conn, sql)
conn.close()
return response('ok', 200)
def get_user_queue(conn, client_id):
sql = "select q.id_queue, q.name as name_queue, q.text_queue, q.end_queue, q.logo, qc.name, qc.email, qc.telephone, qc.date_in, qc.date_out from queue_client qc, queue q where qc.id_queue = q.id_queue and id_queue_client = '" + client_id + "'"
rows = mysqlutils.execute(conn, sql, False)
return parse_queue(rows)
def update_client(conn, client):
sql = "UPDATE queue_client SET date_out = '" + str(
datetime.now()) + "' WHERE id_queue_client = '" + client + "'"
rows = mysqlutils.execute(conn, sql, False)
conn.commit()
def save_client(conn, client):
sql = "INSERT INTO queue_client(id_queue_client, name, email, telephone, date_in, removed, id_queue) VALUES ('"+client['id_queue_client']+"', '"+client['name']+"', '"+client['email']+"', '"+client['telephone']+"', '"+client['date_in']+"', '0', '"+client['queue']+"')"
mysqlutils.execute(conn, sql)