CRUD operations with Sequelize in Express - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a new record using Sequelize.

Express

const newUser = await User.[1]({ name: 'Alice', email: '[e-mail]' });

Drag options to blanks, or click blank then click option'

Acreate

BfindAll

Cupdate

Ddestroy

Attempts:

3 left

💡 Hint

Common Mistakes

Using findAll instead of create will only fetch data, not add new data.

Using update or destroy will modify or delete data, not create.

The create method is used to add a new record to the database in Sequelize.

2fill in blank

medium

Complete the code to find all users with Sequelize.

Express

const users = await User.[1]();

Drag options to blanks, or click blank then click option'

Adestroy

Bcreate

CfindAll

Dupdate

Attempts:

3 left

💡 Hint

Common Mistakes

Using create will add data, not fetch it.

Using update or destroy will change or delete data, not fetch.

The findAll method retrieves all records from the database table.

3fill in blank

hard

Fix the error in the update operation code.

Express

await User.[1]({ name: 'Bob' }, { where: { id: 5 } });

Drag options to blanks, or click blank then click option'

Adestroy

Bcreate

CfindAll

Dupdate

Attempts:

3 left

💡 Hint

Common Mistakes

Using create will add new data instead of updating.

Using findAll fetches data but does not update.

The update method updates existing records matching the where condition.

4fill in blank

hard

Fill both blanks to delete a user by id using Sequelize.

Express

await User.[1]({ where: { id: [2] } });

Drag options to blanks, or click blank then click option'

Adestroy

Bupdate

C5

Dcreate

Attempts:

3 left

💡 Hint

Common Mistakes

Using update or create will not delete records.

Passing a wrong id will delete the wrong user or none.

The destroy method deletes records matching the where condition. Here, the user with id 5 is deleted.

5fill in blank

hard

Fill all three blanks to find a user by primary key and update their email.

Express

const user = await User.[1](10);
if (user) {
  await user.[2]({ email: '[e-mail]' });
  await user.[3]();
}

Drag options to blanks, or click blank then click option'

AfindByPk

Bupdate

Csave

Ddestroy

Attempts:

3 left

💡 Hint

Common Mistakes

Using destroy will delete the user instead of updating.

Not calling save after update may not persist changes.

findByPk finds a record by its primary key. Then update changes the email field. Finally, save saves the changes to the database.