从TypeORM中的列名数组中查找列的where结果

import { Entity, Column, PrimaryGeneratedColumn, createConnection } from "typeorm";

@Entity()
class User {
  @PrimaryGeneratedColumn()
  id: number;

  @Column()
  name: string;

  @Column()
  age: number;
}

async function findColumnByNames(columnNames: string[]): Promise<User[]> {
  const connection = await createConnection({
    type: "mysql",
    host: "localhost",
    port: 3306,
    username: "root",
    password: "password",
    database: "database",
    entities: [User],
    synchronize: true,
  });

  const userRepository = connection.getRepository(User);
  const users = await userRepository.find({
    where: columnNames.map((columnName) => ({ [columnName]: Not(IsNull()) })),
  });

  await connection.close();

  return users;
}

// 调用示例
const columnNames = ["name", "age"];
findColumnByNames(columnNames)
  .then((users) => {
    console.log(users);
  })
  .catch((error) => {
    console.error(error);
  });