You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
15 lines
492 B
15 lines
492 B
const dbAnimals = _db.query("select animal.nome as nome_animal, animal.quantidade as animal_quantidade, parque.nome as parque_nome"
|
|
+ " from animal inner join parque on parque.id = animal.parque_id");
|
|
|
|
const animals = _val.list();
|
|
|
|
for(dbAnimal of dbAnimals) {
|
|
animals.add(
|
|
_val.map()
|
|
.set("animal",dbAnimal.getString("nome_animal"))
|
|
.set("quantidade",dbAnimal.getInt("animal_quantidade"))
|
|
.set("parque",dbAnimal.getString("parque_nome"))
|
|
)
|
|
}
|
|
|
|
_out.json(animals);
|