Database

Lucid

9 Series
116 Lessons
33h 13m

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.

Series.

Snippets.

Lessons.

Video preview
Adocasts Plus Exclusive
Exclusive
Deleted Replacement

Replacing A Course's Deleted Difficulty

In this lesson, we'll add the ability to gracefully handle instances where a required relationship's record is being deleted. When a difficulty is being used by a course, we'll have our users select a replacement difficulty for the one being deleted.

Video preview
Adocasts Plus Exclusive
Exclusive
Deleting Difficulties

Confirming & Deleting Difficulties

In this lesson, we'll add the ability to delete an organization's difficulties. We'll also make use of our ConfirmDeleteDialog component to confirm the deletion action with our user.

Video preview
Adocasts Plus Exclusive
Exclusive
Updating Difficulties

Updating Difficulties

In this lesson, we'll add the ability to update an organization's difficulties using our useResourceActions composable.

Video preview
Adocasts Plus Exclusive
Exclusive
Listing and creating difficulties

Listing & Creating Difficulties

In this lesson, we'll create a page to list the active organization's difficulties. Then, we'll add the ability to create a new difficulty and add a new color picker type to our FormInput component.

Video preview
Adocasts Plus Exclusive
Exclusive
Confirm Delete Dialog

The Confirm Delete Dialog & Deleting the Active Organization

In this lesson, we'll create a reusable confirm deletion dialog and bind its state into our use resource actions composable. We'll then incorporate this all together to allow users to delete their active organization.

Video preview
Adocasts Plus Exclusive
Exclusive
Forgot Password

Forgot Password & Password Reset

In this lesson, we'll walk through setting up the complete forgot password flow including, creating a password reset token with time-expiry, sending an email notification with a password reset link, verifying the token, and resetting the users password.

Video preview
Adocasts Plus Exclusive
Exclusive
Model Types with DTOs

Typing Lucid Models in Inertia with DTOs

In this lesson, we'll learn how we can specify types for our Lucid Models easily using DTOs we'll generate directly from our models.

Video preview
Adocasts Plus Exclusive
Exclusive
Seeding Our Initial Data

Seeding Our Initial Database Data

In this lesson, we'll create a seeder file to create the initial data we'll need in our database to get going. For now, that's just going to be our application's roles.

Video preview
Adocasts Plus Exclusive
Exclusive
Lucid Model Relationship Mixin

Creating A Lucid Model Mixin for our Organization Relationship

In this lesson, we'll learn how we can extract repetitive relationships, and other model properties/methods, into a mixin. We'll also learn what to look out for when using decorators within a TypeScript mixin.

Video preview
Adocasts Plus Exclusive
Exclusive
Defining Our Lucid Models & Relationships

Defining Our Lucid Models & Relationships

In this lesson, we'll convert our migrations into Lucid Models and define both sides of the relationships so they're ready to go.

Video preview
Adocasts Plus Exclusive
Exclusive
Defining Our Migrations & Foreign Keys

Defining Our Migrations & Foreign Keys

In this lesson, we'll create our migrations, models, and some of our controllers. We'll then fill out our migrations and define our relationship's foreign key constraints.

Video preview
Adocasts Plus Exclusive
Exclusive
Database Schema

Understanding Our Database Schema

In this lesson, we'll walk through a diagram of our application's database schema to understand how things relate to one another.

Video preview
Allowing Admins to Delete Movies
Let's Learn AdonisJS 6 #11.10
・
Jun 29

Allowing Admins to Delete Movies and their Relationships

In this lesson, we'll learn how we can safely delete movies and their relationships. We'll discuss how we need to consider foreign key constraints, and what to do when our deletes aren't set to cascade.

Video preview
Managed Transactions and Syncing Movie Cast Members
Let's Learn AdonisJS 6 #11.9
・
Jun 26

Managed Transactions and Syncing Movie Cast Members

In this lesson, we'll learn how we can use what we learned in the last lesson to also sync our cast members. We'll then extract this functionality into a service and wrap it within a managed database transactions.

Video preview
Posting an Array of Objects with HTML Forms
Let's Learn AdonisJS 6 #11.8
・
Jun 26

Posting Objects, Arrays, and an Array of Objects in HTML Forms

In this lesson, we'll learn how we can use form field names to send an array of objects with our HTML form submission. We'll discuss pitfalls to watch out for and how we use AlpineJS to simplify index syncing within our field names.

Video preview
Allowing Admins to Update Movies and Clear Values
Let's Learn AdonisJS 6 #11.4
・
Jun 15

Allowing Admins to Update Movies and Clear Values

In this lesson, we'll recreate our movie form for the purpose of updating our movies. We'll also add the ability to clear values and discuss the difference between VineJS' optional and nullable chain options.

Video preview
Allowing Admins to Create Movies
Let's Learn AdonisJS 6 #11.3
・
Jun 12

Allowing Admins to Create Movies

In this lesson, we'll allow our administrators to create movies via our admin panel. We'll walk through getting the form set up, validated, and our movies created.

Video preview
Paginated Admin Movie Table
Let's Learn AdonisJS 6 #11.2
・
Jun 12

Paginated Admin Movie Table

In this lesson, we'll learn how we can create a paginated movie table for our administrators. We'll list the movies and some of their relationship data, like the number of crew and cast members associated with the movie.

Video preview
Counting Stats for our Admin Dashboard
Let's Learn AdonisJS 6 #11.1
・
Jun 06

Counting Stats for our Admin Dashboard

In this lesson, we'll perform various counts against our models to display on our admin dashboard page.

Video preview
Filtering, Preloading, and Sorting By Relationship
Let's Learn AdonisJS 6 #10.5
・
Jun 06

Filtering, Preloading, and Sorting By Relationship

In this lesson, we'll list the movies a user has watched on their profile. To do this, we'll filter, preload, and sort by the watchlist relationship where the user's watched at value is not null.

Showing 1 to 20 of 113 results