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

Let’s look at how we can fetch, add, update, and delete data from a database.

## Reading and writing to the products table

We will read and write to the `products` table.

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**. 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 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

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

#### Fetching data

In line 22, we use `Product.all()` to fetch all the records from the `products` table. Using `Product.all()` is similar to writing `SELECT * from products` in MySQL. We can also use static methods to perform common operations. For instance,
`await Product.findBy('id', 1)` would return the record where `id` equals `1`.
#### Adding data

In lines 27-31, we instantiate a `Product` instance and insert a new row into the `products` table.

#### Updating data

Look at lines 35-40. We use `await Product.find(id)` to find a record using the primary key. Next, we update the values and call `row.save()`. Note that the `save()` method determines whether to create a new row or update an existing row and the update query only takes place if something is changed.

#### Deleting data

In lines 44-45, we find the record where `id` equals `3` and delete it. Note that if a record where `id` equals `3` does not exist, we will get an error when we try to delete it. 

# Reading and writing to the products table

We will read and write to the `products` table.

> 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**. 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 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

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

### Fetching data

In line 22, we use `Product.all()` to fetch all the records from the `products` table. Using `Product.all()` is similar to writing `SELECT * from products` in MySQL. We can also use static methods to perform common operations. For instance,
`await Product.findBy('id', 1)` would return the record where `id` equals `1`.
### Adding data

In lines 27-31, we instantiate a `Product` instance and insert a new row into the `products` table.

### Updating data

Look at lines 35-40. We use `await Product.find(id)` to find a record using the primary key. Next, we update the values and call `row.save()`. Note that the `save()` method determines whether to create a new row or update an existing row and the update query only takes place if something is changed.

### Deleting data

In lines 44-45, we find the record where `id` equals `3` and delete it. Note that if a record where `id` equals `3` does not exist, we will get an error when we try to delete it. 

Learn to fetch, add, update, and delete data from a database.

Introduction

Routing and Middleware

Controllers and Views

Request and Response

Session, Validator, and Logger

Database

Hooks, Mail, and Events

Tests

Conclusion

Appendix

Fetching, Adding, Updating, and Deleting Data

Reading and writing to the products table