The Definitive Guide to AdonisJs by Christopher Pitt

Author:Christopher Pitt
Language: eng
Format: epub, pdf
Publisher: Apress, Berkeley, CA

if (!customer) {

return view.render("oops", {

type: "PROFILE_MISSING",

})

}

const products = await Database.select("*")

.from("products")

.where("customer_id", customer.id)

return view.render("customer/profile", {

customer,

products,

})

}

Listing 9-16This is from threadbear/app/Controllers/Http/CustomerController.js

This is the second time we’re seeing the where query method . There are many variations of this, all of which relate to a specific kind of SQL where clause. You can use whereNot, whereIn, whereNull, and even whereRaw. Check the documentation ( http://dev.adonisjs.com/docs/4.0/query-builder#_where_clauses ) to get more details on how to use each of these.

Given the array of products, we can render these in the template. Listing 9-17 shows one way we can do this.

@layout("layout")

@section("header")

<h1>

{{ toTitleCase(customer.first_name) }}'s profile

</h1>

@endsection

@section("content")

@each(product in products)

<p>

{{ toTitleCase(product.name) }}

<strong>${{ product.price / 100 }}</strong>

</p>

@else

<p>

{{ toTitleCase(customer.first_name) }} doesn't have any products

</p>

@endeach

@endsection

Listing 9-17This is from threadbear/resources/views/customer/profile.edge

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.