undefined

Lucid

Lucid is AdonisJS' Object Relational Mapping (ORM). It's a first-party package that follows the active record pattern. With it you can easily perform CRUD operations, add database hooks, normalize data, and so much more.

10 Series
152 Lessons
Database

Lessons

Video preview
Adocasts Plus Exclusive
Exclusive
Optional Relationship Loading
Video preview

User-Defined Relationship Loading

In this lesson, we'll let our users tell us which relationships they'd like to get back in our lesson search. We'll also discuss how to handle nested relationships and what to watch out for.

Video preview
Adocasts Plus Exclusive
Exclusive
Filtering by Publish Date
Video preview

Filtering Lessons by Publication Date

In this lesson, we'll add the ability to search lessons by their publish date and time. We'll utilize before and after properties to allow for filtering that can look forward, backward, or within a specific date range on our lesson's publish at column.

Video preview
Adocasts Plus Exclusive
Exclusive
Searching and Filtering Lessons
Video preview

Searching and Filtering Lessons

In this lesson, we'll take the filters we've created thus far and apply them to a new lessons search endpoint. We'll be able to search our lessons by name, status, access level, and module.

Video preview
Adocasts Plus Exclusive
Exclusive
Filtering by a Number or Array of Numbers
Video preview

Filtering by a Number or Array of Numbers

In this lesson, we'll implement our number filtering system in which we'll allow our search APIs to accept a single number or an array of numbers to filter the data by. To validate this, we'll use the union rule from VineJS.

Video preview
Adocasts Plus Exclusive
Exclusive
Advanced String Filtering
Video preview

Advanced String Filtering

In this lesson, we upgrade our course name filter to support both simple strings and advanced object-based queries using VineJS’ union rule. This allows users to specify not just what to search for, but how to search for it.

Video preview
Adocasts Plus Exclusive
Exclusive
Basic Course Filtering
Video preview

Basic Course Search & Filter

In this lesson, we'll add a new search endpoint for our courses and enable some basic filter functionality along with it. We'll be able to search by course name likeness, status, difficulty, and/or access level.

Video preview
Adocasts Plus Exclusive
Exclusive
Getting A Module's Lessons
Video preview

Getting A Module's Lessons

In this lesson, we'll remove our lesson's index method in favor of a module method whose purpose will be to fetch a module's specific lessons in their stored order.

Video preview
Adocasts Plus Exclusive
Exclusive
Get Modules Endpoint
Video preview

Getting Just Course Modules & Lessons

In this lesson, we'll remove our GET module route, using the except method on our resource. Then we'll refactor to add a GetModules action

Video preview
Adocasts Plus Exclusive
Exclusive
Course Modules Nested Resource
Video preview

Course Module Nested Resource

In this lesson, we'll work on nested resourceful endpoints for our course modules. We'll add endpoints to create, update, patch, and deleting modules from a specific course.

Video preview
Adocasts Plus Exclusive
Exclusive
Patching Course Tags
Video preview

Updating A Course's Difficulty, Status, or Access Level

In this lesson, we'll add a specific endpoint with the ability to patch a course's difficulty, status, or access level with a new value so our users have a way to update these without needing to send the entire course payload.

Video preview
Adocasts Plus Exclusive
Exclusive
Course Modules & Lessons
Video preview

Getting A Course's Details, Modules, & Lessons

In this lesson, we wrap up the Courses controller by adding a show method that fetches all the key info for a single course. That includes its modules and lessons, all nicely organized and ready to use in your API response.

Video preview
Adocasts Plus Exclusive
Exclusive
Paginating Courses
Video preview

Paginating our Course List

In this lesson, we'll transform our courses list endpoint into a pagination endpoint. We'll check and validate our query string for a page and per page parameter that we'll then use to fetch pages of our courses.

Video preview
Adocasts Plus Exclusive
Exclusive
Creating, Updating, and Deleting Courses
Video preview

Creating, Updating, and Deleting Courses

In this lesson, we'll add endpoints to allow creating, updating, and deleting courses from our API. We'll then use this to stub a number of test courses to give us wiggle room to play with our pagination.

Video preview
Adocasts Plus Exclusive
Exclusive
Listing Courses
Video preview

Listing Courses

Our goal in this step is to add an endpoint that lists our courses. We'll then build upon this endpoint further with the ultimate goal of getting a list of paginated courses.

Video preview
Adocasts Plus Exclusive
Exclusive
Access Level CRUD
Video preview

Access Level API CRUD

In this lesson, we'll walk through adding API endpoints for the full CRUD (create, read, update, and delete) flow for our organization's access levels.

Video preview
Adocasts Plus Exclusive
Exclusive
Deleting Access Tokens
Video preview

Deleting/Revoking Access Tokens

In this lesson, we'll add the ability for our users to revoke an access token by deleting it out of our database.

Video preview
Video preview

Overview of our Database Schema

In this lesson, we'll take a high level look at our database's schema so that we have an understanding at the entities and models at play and how they relate to one another within our application.

Video preview
Getting Up and Running
Video preview

Getting the Web Project Up & Running

We'll get our web project cloned down. Then, we'll get it configured by first creating our database and running our migrations and seeder. Lastly, we'll get a test SMTP email inbox set up through MailTrap.

Showing 1 to 18 of 150 results