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)