如何在TypeOrm中使用Postgres DateRange类型

npm install typeorm pg

import { Entity, Column, PrimaryGeneratedColumn } from 'typeorm';

@Entity()
export class YourEntity {
  @PrimaryGeneratedColumn()
  id: number;

  @Column({
    type: 'daterange',
    nullable: true,
  })
  dateRange: string;
}

import { createConnection } from 'typeorm';

createConnection({
  type: 'postgres',
  host: 'localhost',
  port: 5432,
  username: 'your_username',
  password: 'your_password',
  database: 'your_database',
  entities: [YourEntity],
  synchronize: true,
}).then(connection => {
  // 连接成功
}).catch(error => {
  // 连接失败
});

const entity = new YourEntity();
entity.dateRange = '[2022-01-01, 2022-01-31]';

// 保存实体到数据库
await connection.manager.save(entity);

const entity = await connection.manager.findOne(YourEntity, 1);
console.log(entity.dateRange); // 输出：[2022-01-01, 2022-01-31]