Database

Lucid

8 Series
81 Lessons
27h 16m

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.

Lessons.

Video preview
Defining One to One Relationships
Let's Learn AdonisJS 6 #5.0
・
Mar 18

Defining One to One Relationships Within Lucid Models

In this lesson, we'll learn how to define one-to-one relationships within our Lucid Models. We'll learn about the belongs to and has one decorators, their options, and types that make this possible.

Video preview
Generating A Movie Slug Using Model Hooks
Let's Learn AdonisJS 6 #4.17
・
Mar 15

Generating A Unique Movie Slug With Model Hooks

In this lesson, we'll learn how we can use Model Hooks to generate a unique URL-safe slug based on the movie's title.

Video preview
Querying Recently Released and Releasing Soon Movies
Let's Learn AdonisJS 6 #4.16
・
Mar 15

Querying Recently Released and Coming Soon Movies

In this lesson, we'll learn how to use the Model Query Builder to query our movies that have been recently released. We'll then do a separate query to get movies that are coming soon.

Video preview
Altering Factory States
Let's Learn AdonisJS 6 #4.15
・
Mar 15

Tapping into Model Factory States

In this lesson, we'll dive a little bit deeper into Model Factories by introducing factory states. We'll also learn how we can use the tap method to alter a factory result prior to it persisting into the database

Video preview
Reusable Query Statements with Model Query Scopes
Let's Learn AdonisJS 6 #4.14
・
Mar 11

Reusable Query Statements with Model Query Scopes

In this lesson, we'll learn about Model Query Scopes and how we can use them to create easily reusable query statements that we can apply using the Model Query Builder.

Video preview
SQL Parameters and Injection Protection
Let's Learn AdonisJS 6 #4.13
・
Mar 11

SQL Parameters and Injection Protection

In this lesson, we'll learn about SQL Parameters, also called query bindings, and how using them helps safeguard our database from malicious attacks attempting to perform SQL Injection.

Video preview
Adding A User Profile Model, Migration, Factory, and Controller
Let's Learn AdonisJS 6 #4.12
・
Mar 11

Adding A Profile Model, Migration, Factory, and Controller

Uh oh, a new requirement has come in and now we also need to account for user profiles! In this lesson, we'll learn how we can easily create a new model, migration, factory, and controller for an entity in one fell swoop!

Video preview
Altering Tables with Migrations
Let's Learn AdonisJS 6 #4.11
・
Mar 05

Altering Tables with Migrations

In this lesson, we'll learn how to alter our database tables using migrations both while in development, where we can delete our data, and once our data has already hit production where we need to persist all data.

Video preview
Umapped and Computed Model Properties
Let's Learn AdonisJS 6 #4.10
・
Mar 05

Unmapped and Computed Model Properties

In this lesson, we'll learn how to add unmapped and computed properties to our Lucid Models. We'll discuss the differences between a model column, unmapped property, and a computed property.

Video preview
Querying Our Movies with the Query Builder
Let's Learn AdonisJS 6 #4.9
・
Mar 05

Querying Our Movies with the Query Builder

In this lesson, we'll introduce both the database and model query builder. We'll learn the differences between the two and the basics of how to use them.

Video preview
Fake Data Factories
Let's Learn AdonisJS 6 #4.8
・
Mar 02

Stubbing Fake Data with Model Factories

In this lesson, we'll learn how we can quickly and easily bulk-create dummy/fake data within our database for each of our Lucid Models using Model Factories

Video preview
Defining Required Data with Seeders
Let's Learn AdonisJS 6 #4.7
・
Mar 02

Defining Required Data with Seeders

Our database will have specific, non-changing, roles and movie statuses. In this lesson, we'll learn how we can quickly and easily create these records inside of our database using seeders.

Video preview
The Basics of CRUD
Let's Learn AdonisJS 6 #4.6
・
Mar 02

The Basics of CRUD

In this lesson, we'll walk through the basics of creating, reading, updating, and deleting (CRUD) data from our database using our Lucid Models.

Video preview
Defining Our Models
Let's Learn AdonisJS 6 #4.5
・
Feb 28

Defining Our Models

In this lesson, we'll walk through the process of defining all our database tables and columns as models and properties within our application.

Video preview
Introducing Lucid Models
Let's Learn AdonisJS 6 #4.4
・
Feb 28

Introducing Lucid Models

In this lesson, we'll introduce models using the Lucid ORM. We'll learn how we can map database columns to our model properties and specify special behavior for our date time columns.

Video preview
The Flow of Migrations
Let's Learn AdonisJS 6 #4.3
・
Feb 24

The Flow of Migrations

In this lesson, we'll learn about the various migration-based commands made available by the Ace CLI and how they interact with our migration files. We'll use these commands to run, rollback, and refresh our migrations against our database.

Video preview
Let's Learn AdonisJS 6 #4.2
・
Feb 24

Introducing and Defining Database Migrations

In this lesson, we'll introduce database migrations. We'll learn what they are, why they're great to have, and how we can create and use them to define our database tables and their columns.

Video preview
Let's Learn AdonisJS 6 #4.1
・
Feb 21

Understanding our Database Schema

In this lesson, we'll walk through how to understand a database schema diagram. We'll then discuss the schema we'll be working with throughout this series; describing the tables, columns, data types, and relationships.

Video preview
Configuring Lucid and our Database Connection
Let's Learn AdonisJS 6 #4.0
・
Feb 21

Configuring Lucid and our Database Connection

In this lesson, we'll learn how we can configure Lucid to use a different driver other than SQLite; PostgreSQL is shown but MySQL and MSSQL are much the same. Then, we'll set up our connection details so that we can successfully connect to our database.

Video preview
Structuring Data with Models
Let's Learn AdonisJS 6 #2.11
・
Jan 31

Defining A Structure for our Movie using Models

In this lesson, we'll introduce the concept of models by using one to define the properties our movies should contain. We'll then stub some methods that will mock calls we'll later be able to use to load data from our database.

Showing 21 to 40 of 80 results