<div id="readability-page-1" class="page"><article itemscope="" itemtype="http://schema.org/Article"><header></header><div><ul>
<li>
<a href="#create">create</a>
<ul>
<li><a href="#sql">sql</a></li>
<li><a href="#sequelize-query">sequelize query</a></li>
</ul>
</li>
<li>
<a href="#%EC%A0%84%EC%B2%B4-row-%EC%A1%B0%ED%9A%8C">전체 row 조회</a>
<ul>
<li><a href="#sql-1">sql</a></li>
<li><a href="#sequelize-query-1">sequelize query</a></li>
</ul>
</li>
<li>
<a href="#%EC%9B%90%ED%95%98%EB%8A%94-%EC%BB%AC%EB%9F%BC%EB%A7%8C-%EC%A1%B0%ED%9A%8C">원하는 컬럼만 조회</a>
<ul>
<li><a href="#sql-2">sql</a></li>
<li><a href="#sequelize-query-2">sequelize query</a></li>
</ul>
</li>
<li>
<a href="#where">where</a>
<ul>
<li><a href="#sql-3">sql</a></li>
<li><a href="#sequelize-query-3">sequelize query</a></li>
</ul>
</li>
<li>
<a href="#order">order</a>
<ul>
<li><a href="#sql-4">sql</a></li>
<li><a href="#sequelize-query-4">sequelize query</a></li>
</ul>
</li>
<li>
<a href="#%EC%A1%B0%ED%9A%8C%ED%95%A0-%EB%A1%9C%EC%9A%B0-%EA%B0%9C%EC%88%98-%EC%84%A4%EC%A0%95--offset">조회할 로우 개수 설정 &amp; offset</a>
<ul>
<li><a href="#sql-5">sql</a></li>
<li><a href="#sequelize-query-5">sequelize query</a></li>
</ul>
</li>
<li>
<a href="#%EC%88%98%EC%A0%95">수정</a>
<ul>
<li><a href="#sql-6">sql</a></li>
<li><a href="#sequelize-query-6">sequelize query</a></li>
</ul>
</li>
<li>
<a href="#%EC%82%AD%EC%A0%9C">삭제</a>
<ul>
<li><a href="#sql-7">sql</a></li>
<li><a href="#sequelize-query-7">sequelize query</a></li>
</ul>
</li>
<li>
<a href="#%EA%B4%80%EA%B3%84-%EC%BF%BC%EB%A6%AC">관계 쿼리</a>
<ul>
<li><a href="#include">include</a></li>
<li><a href="#%EC%83%9D%EC%84%B1-%EC%88%98%EC%A0%95-%EC%82%AD%EC%A0%9C">생성, 수정, 삭제</a></li>
</ul>
</li>
</ul></div><section itemprop="articleBody"><h2 id="create">create<a href="#create" aria-label="create permalink"></a></h2>
<h2 id="sql">sql<a href="#sql" aria-label="sql permalink"></a></h2>
<div data-language="sql"><pre><code>insert into nodejs.users (name, age, married, comment) values ('lee', 27, 0, '안녕');</code></pre></div>
<h2 id="sequelize-query">sequelize query<a href="#sequelize-query" aria-label="sequelize query permalink"></a></h2>
<div data-language="javascript"><pre><code>User.create({ 
 name: 'lee', 
 age: 27, 
 married: false, 
 comment: '안녕',
});</code></pre></div>
<h2 id="전체-row-조회">전체 row 조회<a href="#%EC%A0%84%EC%B2%B4-row-%EC%A1%B0%ED%9A%8C" aria-label="전체 row 조회 permalink"></a></h2>
<h2 id="sql-1">sql<a href="#sql-1" aria-label="sql 1 permalink"></a></h2>
<div data-language="sql"><pre><code>select * from nodejs.users;</code></pre></div>
<h2 id="sequelize-query-1">sequelize query<a href="#sequelize-query-1" aria-label="sequelize query 1 permalink"></a></h2>

<h2 id="원하는-컬럼만-조회">원하는 컬럼만 조회<a href="#%EC%9B%90%ED%95%98%EB%8A%94-%EC%BB%AC%EB%9F%BC%EB%A7%8C-%EC%A1%B0%ED%9A%8C" aria-label="원하는 컬럼만 조회 permalink"></a></h2>
<h2 id="sql-2">sql<a href="#sql-2" aria-label="sql 2 permalink"></a></h2>
<div data-language="sql"><pre><code>select name, married from nodejs.users;</code></pre></div>
<h2 id="sequelize-query-2">sequelize query<a href="#sequelize-query-2" aria-label="sequelize query 2 permalink"></a></h2>
<div data-language="javascript"><pre><code>User.findAll({
 attributes: ['name', 'married'],
});</code></pre></div>
<h2 id="where">where<a href="#where" aria-label="where permalink"></a></h2>
<h2 id="sql-3">sql<a href="#sql-3" aria-label="sql 3 permalink"></a></h2>
<div data-language="sql"><pre><code>select name, age from nodejs.users where married = 1 and age &gt; 30;
select id, name from nodejs.users where married = 1 or age &gt; 30;</code></pre></div>
<h2 id="sequelize-query-3">sequelize query<a href="#sequelize-query-3" aria-label="sequelize query 3 permalink"></a></h2>
<div data-language="javascript"><pre><code>const { Op } = require('sequelize');
const { User } = require('../models');

User.findAll({
 attributes: ['name', 'age'],
 where: {
 married: true,
 age: { [Op.gt]: 30},
 }
});

User.findAll({
 attribues: ['id', 'name'],
 where: {
 [Op.or] : [{married: false}, {age: [Op.gt]: 30}],
 }
});</code></pre></div>
<h2 id="order">order<a href="#order" aria-label="order permalink"></a></h2>
<h2 id="sql-4">sql<a href="#sql-4" aria-label="sql 4 permalink"></a></h2>
<div data-language="sql"><pre><code>select id, name from nodejs.users order by age desc;</code></pre></div>
<h2 id="sequelize-query-4">sequelize query<a href="#sequelize-query-4" aria-label="sequelize query 4 permalink"></a></h2>
<div data-language="javascript"><pre><code>User.findAll({
 attributes: ['id', 'name'],
 order: [['age', 'DESC']],
});</code></pre></div>
<h2 id="조회할-로우-개수-설정--offset">조회할 로우 개수 설정 &amp; offset<a href="#%EC%A1%B0%ED%9A%8C%ED%95%A0-%EB%A1%9C%EC%9A%B0-%EA%B0%9C%EC%88%98-%EC%84%A4%EC%A0%95--offset" aria-label="조회할 로우 개수 설정 offset permalink"></a></h2>
<h2 id="sql-5">sql<a href="#sql-5" aria-label="sql 5 permalink"></a></h2>
<div data-language="sql"><pre><code>select id, name from nodejs.users order by age desc limit 1 offset 1; </code></pre></div>
<h2 id="sequelize-query-5">sequelize query<a href="#sequelize-query-5" aria-label="sequelize query 5 permalink"></a></h2>
<div data-language="javascript"><pre><code>User.findAll({
 attributes: ['id', 'name'],
 order: [['age', 'DESC']],
 limit: 1,
 offset: 1,
});</code></pre></div>
<h2 id="수정">수정<a href="#%EC%88%98%EC%A0%95" aria-label="수정 permalink"></a></h2>
<h2 id="sql-6">sql<a href="#sql-6" aria-label="sql 6 permalink"></a></h2>
<div data-language="sql"><pre><code>update nodejs.user set comment = '바꿀 내용' where id = 2;</code></pre></div>
<h2 id="sequelize-query-6">sequelize query<a href="#sequelize-query-6" aria-label="sequelize query 6 permalink"></a></h2>
<div data-language="javascript"><pre><code>User.update({
 comment: '바꿀내용',
}, {
 where: { id: 2 },
})</code></pre></div>
<h2 id="삭제">삭제<a href="#%EC%82%AD%EC%A0%9C" aria-label="삭제 permalink"></a></h2>
<h2 id="sql-7">sql<a href="#sql-7" aria-label="sql 7 permalink"></a></h2>
<div data-language="sql"><pre><code>delete from nodejs.users where id = 2;</code></pre></div>
<h2 id="sequelize-query-7">sequelize query<a href="#sequelize-query-7" aria-label="sequelize query 7 permalink"></a></h2>
<div data-language="javascript"><pre><code>User.destroy({
 where: { id: 2 },
});</code></pre></div>
<h2 id="관계-쿼리">관계 쿼리<a href="#%EA%B4%80%EA%B3%84-%EC%BF%BC%EB%A6%AC" aria-label="관계 쿼리 permalink"></a></h2>
<code>findOne</code>이나 <code>findAll</code> 메서드를 호출할 때 Promise의 결과로 모델을 반환한다.
<div data-language="javascript"><pre><code>const user = await User.findOne({});
console.log(user.nickname);</code></pre></div>
<h2 id="include">include<a href="#include" aria-label="include permalink"></a></h2>
hasMany - belongsTo 관계가 맺어진 모델 (User(1) : Comment(N)) 에서, 특정 사용자를 조회할 때 그 사람의 댓글 까지 조회하려는 경우 <code>include</code> 속성을 사용한다.
<div data-language="javascript"><pre><code>const user = await User.findOne({
 include: [{
 model: Comment,
 }]
});

console.log(user.Comments);</code></pre></div>
또는
<div data-language="javascript"><pre><code>const user = await User.findOne({});
const comments = await user.getComments();
console.log(comments);</code></pre></div>
댓글을 가져올 때 id가 1인 댓글만 가져오고, 컬럼도 id만 가져오는 경우
<div data-language="javascript"><pre><code>const user = await User.findOne({});
const comment = await user.getComments({
 where: {
 id: 1,
 },
 attributes: ['id'],
});</code></pre></div>
<h2 id="생성-수정-삭제">생성, 수정, 삭제<a href="#%EC%83%9D%EC%84%B1-%EC%88%98%EC%A0%95-%EC%82%AD%EC%A0%9C" aria-label="생성 수정 삭제 permalink"></a></h2>
<div data-language="javascript"><pre><code>const user = User.findOne({});
const comment = await Comment.create();
await user.addComment(comment);

// or 
await user.addComment(comment.id); 

// 배열로 
const comment1 = await Comment.create();
const comment2 = await Comment.create();

await.addCommen([comment1, comment2]);</code></pre></div></section></article></div>

Seulog💘

이예슬

create
sql
insert into nodejs.users (name, age, married, comment) values ('lee', 27, 0, '안녕');
sequelize query
User.create({ 
    name: 'lee', 
    age: 27, 
    married: false, 
    comment: '안녕',
});
전체 row 조회
sql
select * from nodejs.users;
sequelize query
User.findAll({});
원하는 컬럼만 조회
sql
select name, married from nodejs.users;
sequelize query
User.findAll({
    attributes: ['name', 'married'],
});
where
sql
select name, age from nodejs.users where married = 1 and age > 30;
select id, name from nodejs.users where married = 1 or age > 30;
sequelize query
const { Op } = require('sequelize');
const { User } = require('../models');
User.findAll({
    attributes: ['name', 'age'],
    where: {
        married: true,
        age: { [Op.gt]: 30},
    }
});
User.findAll({
    attribues: ['id', 'name'],
    where: {
        [Op.or] : [{married: false}, {age: [Op.gt]: 30}],
    }
});
order
sql
select id, name from nodejs.users order by age desc;
sequelize query
User.findAll({
    attributes: ['id', 'name'],
    order: [['age', 'DESC']],
});
조회할 로우 개수 설정 & offset
sql
select id, name from nodejs.users order by age desc limit 1 offset 1; 
sequelize query
User.findAll({
    attributes: ['id', 'name'],
    order: [['age', 'DESC']],
    limit: 1,
    offset: 1,
});
수정
sql
update nodejs.user set comment = '바꿀 내용' where id = 2;
sequelize query
User.update({
    comment: '바꿀내용',
}, {
    where: { id: 2 },
})
삭제
sql
delete from nodejs.users where id = 2;
sequelize query
User.destroy({
    where: { id: 2 },
});
관계 쿼리
findOne이나 findAll 메서드를 호출할 때 Promise의 결과로 모델을 반환한다.
const user = await User.findOne({});
console.log(user.nickname);
include
hasMany - belongsTo 관계가 맺어진 모델 (User(1) : Comment(N)) 에서, 특정 사용자를 조회할 때 그 사람의 댓글 까지 조회하려는 경우 include 속성을 사용한다.
const user = await User.findOne({
    include: [{
        model: Comment,
    }]
});
console.log(user.Comments);
또는
const user = await User.findOne({});
const comments = await user.getComments();
console.log(comments);
댓글을 가져올 때 id가 1인 댓글만 가져오고, 컬럼도 id만 가져오는 경우
const user = await User.findOne({});
const comment = await user.getComments({
    where: {
        id: 1,
    },
    attributes: ['id'],
});
생성, 수정, 삭제
const user = User.findOne({});
const comment = await Comment.create();
await user.addComment(comment);
// or 
await user.addComment(comment.id); 
// 배열로 
const comment1 = await Comment.create();
const comment2 = await Comment.create();
await.addCommen([comment1, comment2]);

[Node.js 교과서] - 7장 Sequelize

댓글