0018.4 TypeORM 💾

• 0018 Javascript ☕️
• 공식문서
• sequelize, a MySQL ORM for javascript
• https://docs.nestjs.com/techniques/database

---

README

sequalize와의 차이점 위주로 CRUD, 엔티티, repository, relation 위주로 빠르게 정리하겠습니다.

눈여겨 볼만한 주제들

• entities & columns
• entity manager?
• repository
• associations (relations)
• eager & lazy relations
• cascades

톺아보기...

And your domain logic looks like this:

const userRepository = MyDataSource.getRepository(User);

const user = new User();
user.firstName = "Timber";
user.lastName = "Saw";
user.age = 25;
await userRepository.save(user);

const allUsers = await userRepository.find();
const firstUser = await userRepository.findOneBy({
    id: 1,
});
const timber = await userRepository.fineOneBy({
    firstName: "Timber",
    lastName: "Saw",
});
timber.age = 26;
await userRepository.save(timber);
const [users, userCount] = await userRepository.findAndCount();
await userRepository.remove(timber);

• Column Types {typeorm}
• DataSource {typeorm}
• EntityManager {typeorm}
• Repository {typeorm}
• JoinColumn options {typeorm}
• save related entities only with PK {typeorm}
• save both relations {typeorm}
• cascade option {typeorm}
• Bidirectional relationships using inverse relation {typeorm}

더 알아보기

• find options {typeorm}
• Migrations
• DateColumn Decorators {typeorm}
• enum column type {typeorm}
• Validation {typeorm}
• typeorm 연관 컬럼을 객체가 아니라 id number로 불러오기
• indexing

postgresql

• EC2 Postgresql을 장고 기본 데이터베이스로 활용하기 ⟶ 얘는 장고 사용하면서 겪었던 개고생 모아놓은 문서
• postgresql on docker 단순 명령어 모음
• rds postgresql ssl 인증서 발급하여 접속하기