username

password

Gain insights into AdonisJs fundamentals. Delve into routes, controllers, middleware, and hooks. Discover practical examples, illustrations, and quizzes to confidently build your full-stack applications.

sim.tar.gz

volad

volad-copy

volad-try

volad-copy-copy

volad-try-copy

logger

This course is a detailed guide to AdonisJs. AdonisJs, inspired by Laravel, is a Node.js framework that allows developers to build full-stack web applications and micro-API servers. 

In this course, you will cover the fundamentals: routes, controllers, middleware, hooks, and more. Each chapter contains code examples and illustrations to enhance your learning, and you will also be able to quiz yourself on the materials covered. 

By the time you are done with the course, you'll have plenty of hands-on practice, and will be able to confidently write your full-stack applications in AdonisJs.

Building Full-Stack Web Applications with AdonisJs

We can interact with SQL databases using the **query builder** as well, as we will now see.

## Reading and writing to the products table

Let's see how we can fetch, add, update, and delete data from the `products` table using the query builder.

FROM ubuntu:18.04

RUN apt-get update && apt-get install -y docker.io && \
    apt-get install -y curl && apt-get install -y wget

RUN curl -sL https://deb.nodesource.com/setup_10.x -o nodesource_setup.sh && \
    bash nodesource_setup.sh && \
    apt-get -y install nodejs && \
    npm i -g n

RUN curl -L "https://github.com/docker/compose/releases/download/1.24.1/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose && chmod +x /usr/local/bin/docker-compose && ln -s /usr/local/bin/docker-compose /usr/bin/docker-compose

COPY . /ucode

RUN cd /ucode && \
    pwd && \
    ls && \
    npm i -g @adonisjs/cli && \
    npm install

ADD https://github.com/ufoscout/docker-compose-wait/releases/download/2.2.1/wait /wait

RUN chmod +x /wait

## Launch the wait tool and then your application
CMD pwd && /wait && cd /ucode && npm install && adonis key:generate && adonis migration:run --seed && adonis serve --dev --polling

HOST=0.0.0.0
PORT=3333
NODE_ENV=development
APP_URL=http://${HOST}:${PORT}
CACHE_VIEWS=false
APP_KEY=
DB_CONNECTION=mysql
DB_HOST=mysql
DB_PORT=3306
DB_USER=root
DB_PASSWORD=root
DB_DATABASE=newsletter
DB_SOCKETPATH=
SESSION_DRIVER=cookie
HASH_DRIVER=bcrypt

'use strict'

/*
|--------------------------------------------------------------------------
| Ace Commands
|--------------------------------------------------------------------------
|
| The ace file is just a regular Javascript file but with no extension. You
| can call `node ace` followed by the command name and it just works.
|
| Also you can use `adonis` followed by the command name, since the adonis
| global proxy all the ace commands.
|
*/

const { Ignitor } = require('@adonisjs/ignitor')

new Ignitor(require('@adonisjs/fold'))
  .appRoot(__dirname)
  .fireAce()
  .catch(console.error)


'use strict'

/*
|--------------------------------------------------------------------------
| Http server
|--------------------------------------------------------------------------
|
| This file bootstrap Adonisjs to start the HTTP server. You are free to
| customize the process of booting the http server.
|
| """ Loading ace commands """
|     At times you may want to load ace commands when starting the HTTP server.
|     Same can be done by chaining `loadCommands()` method after
|
| """ Preloading files """
|     Also you can preload files by calling `preLoad('path/to/file')` method.
|     Make sure to pass relative path from the project root.
*/

const { Ignitor } = require('@adonisjs/ignitor')

new Ignitor(require('@adonisjs/fold'))
  .appRoot(__dirname)
  .fireHttpServer()
  .catch(console.error)


React

Dart

GoJS React

Typescript React

Vue.js

> Press Run. Type **cd ucode** in the terminal after the processes have run and you see the # prompt to enter into the special browser environment that is running the application (if you are not already there). Now, run **adonis migration:run --seed** and wait for the welcome page to be displayed in the Output tab. Then, click on the link under the run button and append:
> * **/products** to fetch and view data from the `products` table. 
> * **/product_create** to add data to the `products` table.
> * **/product_update/id** to update some data. `id` can be 1, 2, and so on depending on the records in the database.
> * **/product_delete** to delete the row where `id` equals 3. <br>
<br>
> You are encouraged to verify if the `products` table is being updated by visiting the **/products** route after adding, updating, and deleting data. If you make any change in the migration or seed files, press Run and re-run **adonis migration:run --seed** in the terminal for the changes to be reflected.

### Explanation

Take a look at **start/routes.js**. In line 19, we call the `Product` model that we created earlier.

#### Fetching data

In line 23, we use `Product.query().fetch()` to fetch all the records from the `products` table. We can conditionally select data as well. For instance, `Product.query().where('id', 1).fetch()` selects the row where `id` equals `1`.

#### Adding data

In lines 29-33, we insert a new record into the table.

#### Updating Data

In lines 38-44, we update the product whose `id` equals the   `id` that we get via the `params` object.

#### Deleting data

We delete the product where `id` equals `3` in lines 48-50.

# Reading and writing to the products table

Let's see how we can fetch, add, update, and delete data from the `products` table using the query builder.

> Press Run. Type **cd ucode** in the terminal after the processes have run and you see the # prompt to enter into the special browser environment that is running the application (if you are not already there). Now, run **adonis migration:run --seed** and wait for the welcome page to be displayed in the Output tab. Then, click on the link under the run button and append:
> * **/products** to fetch and view data from the `products` table. 
> * **/product_create** to add data to the `products` table.
> * **/product_update/id** to update some data. `id` can be 1, 2, and so on depending on the records in the database.
> * **/product_delete** to delete the row where `id` equals 3. <br>
<br>
> You are encouraged to verify if the `products` table is being updated by visiting the **/products** route after adding, updating, and deleting data. If you make any change in the migration or seed files, press Run and re-run **adonis migration:run --seed** in the terminal for the changes to be reflected.

## Explanation

Take a look at **start/routes.js**. In line 19, we call the `Product` model that we created earlier.

### Fetching data

In line 23, we use `Product.query().fetch()` to fetch all the records from the `products` table. We can conditionally select data as well. For instance, `Product.query().where('id', 1).fetch()` selects the row where `id` equals `1`.

### Adding data

In lines 29-33, we insert a new record into the table.

### Updating Data

In lines 38-44, we update the product whose `id` equals the   `id` that we get via the `params` object.

### Deleting data

We delete the product where `id` equals `3` in lines 48-50.

Use the query builder to interact with SQL databases.

Introduction

Routing and Middleware

Controllers and Views

Request and Response

Session, Validator, and Logger

Database

Hooks, Mail, and Events

Tests

Conclusion

Appendix

Query Builder

Reading and writing to the products table