04 · 특수 컬럼 — 날짜·버전·소프트삭제

@Column({ default: () => 'CURRENT_TIMESTAMP' })
createdAt!: Date            // ⚠️ INSERT 때만 자동, UPDATE는 별도 코드 필요
 
// vs
 
@CreateDateColumn()
createdAt!: Date            // ✅ INSERT 시 TypeORM이 자동 세팅

import { Entity, PrimaryGeneratedColumn, Column, CreateDateColumn } from 'typeorm'
 
@Entity()
class Article {
  @PrimaryGeneratedColumn('uuid') id!: string
  @Column() title!: string
 
  @CreateDateColumn()
  createdAt!: Date
}

@UpdateDateColumn()
updatedAt!: Date

// repo.save() — TypeORM 라이프사이클 거침
await repo.save({ id: 'X', title: 'new' })   // ✅ updatedAt 갱신됨
 
// queryBuilder.update() — TypeORM이 컬럼 자동 세팅 안 함
await repo.createQueryBuilder()
  .update().set({ title: 'new' })
  .where('id = :id', { id: 'X' })
  .execute()                                  // ❌ MySQL 외엔 updatedAt 안 바뀜

import { DeleteDateColumn } from 'typeorm'
 
@Entity()
class Article {
  @PrimaryGeneratedColumn('uuid') id!: string
  @Column() title!: string
 
  @DeleteDateColumn()
  deletedAt?: Date | null      // 삭제 안 됐으면 null
}

// 1. delete()는 더 이상 SQL DELETE를 안 부른다
await repo.softDelete('X')         // UPDATE article SET deleted_at = now() WHERE id = 'X'
 
// 2. find()는 deleted_at IS NULL을 자동으로 붙인다
await repo.find()                  // SELECT ... WHERE deleted_at IS NULL
 
// 3. 삭제된 row도 보려면 명시
await repo.find({ withDeleted: true })
 
// 4. 복원
await repo.restore('X')            // UPDATE article SET deleted_at = NULL
 
// 진짜 DELETE를 하고 싶으면
await repo.delete('X')             // SQL DELETE (hard delete, soft delete 무시)

@Entity()
class User {
  @OneToMany(() => Article, a => a.author) articles!: Article[]
}
 
const user = await userRepo.findOne({
  where: { id: 'X' },
  relations: ['articles'],            // 삭제된 article 제외 (자동)
})

import { VersionColumn } from 'typeorm'
 
@Entity()
class Article {
  @PrimaryGeneratedColumn('uuid') id!: string
  @Column() title!: string
 
  @VersionColumn()
  version!: number                  // INSERT 시 1, UPDATE마다 +1
}

-- TypeORM이 생성
UPDATE article SET title = ?, version = version + 1
WHERE id = ? AND version = ?    -- version 조건이 추가됨

const a = await repo.findOneBy({ id: 'X' })    // version = 3
// ...
// 다른 트랜잭션이 같은 row를 update해서 version = 4가 됨
 
a.title = 'new'
await repo.save(a)                              // UPDATE ... WHERE version = 3 → 0 rows → 에러

@CreateDateColumn({
  type: 'timestamp with time zone',     // PG: timestamptz
  precision: 6,                         // microsecond
  name: 'created_at',
  comment: '생성 시각',
})
createdAt!: Date

@UpdateDateColumn({
  type: 'timestamp with time zone',
  precision: 6,
  name: 'updated_at',
})
updatedAt!: Date

@DeleteDateColumn({
  type: 'timestamp with time zone',
  precision: 6,
  name: 'deleted_at',
})
deletedAt?: Date | null

@VersionColumn({
  name: 'version',
  default: 1,
})
version!: number

import {
  Entity, PrimaryGeneratedColumn, Column,
  CreateDateColumn, UpdateDateColumn, DeleteDateColumn, VersionColumn,
} from 'typeorm'
 
@Entity()
class Document {
  @PrimaryGeneratedColumn('uuid')
  id!: string
 
  @Column() title!: string
  @Column({ type: 'text' }) body!: string
 
  @CreateDateColumn({ type: 'timestamp with time zone' })
  createdAt!: Date
 
  @UpdateDateColumn({ type: 'timestamp with time zone' })
  updatedAt!: Date
 
  @DeleteDateColumn({ type: 'timestamp with time zone' })
  deletedAt?: Date | null
 
  @VersionColumn()
  version!: number
}

// 시나리오
await repo.softDelete('email_unique_X')      // deleted_at만 세팅
await repo.save({ email: 'X', ... })          // ❌ unique constraint violation

// 1. partial unique index (PG)
@Index('idx_email_unique', ['email'], { unique: true, where: 'deleted_at IS NULL' })
 
// 2. unique를 (email, deletedAt) 복합으로
@Index(['email', 'deletedAt'], { unique: true })

await repo.delete('X')        // 항상 SQL DELETE — soft delete 무시
await repo.softDelete('X')    // soft delete (deletedAt 세팅)
await repo.remove(entity)     // soft delete *무시*하고 hard delete

// ❌ updatedAt이 안 바뀐다 (MySQL 외)
await repo.createQueryBuilder()
  .update().set({ title: 'new' })
  .where('id = :id', { id: 'X' })
  .execute()

// 트랜잭션 A
const a = await repo.findOneBy({ id: 'X' })   // version=3
a.title = 'newA'
 
// 트랜잭션 B 동시 진행
const b = await repo.findOneBy({ id: 'X' })   // version=3
b.title = 'newB'
await repo.save(b)                             // version=4
 
// 트랜잭션 A 계속
await repo.save(a)                             // ❌ OptimisticLockVersionMismatchError

await repo.save({ id: 'X', title: 't', createdAt: new Date('2020-01-01') })

@CreateDateColumn() createdAt!: Date     // PG default: timestamp (no tz!)

@CreateDateColumn({ type: 'timestamp with time zone' })
createdAt!: Date