d8d-vite-starter/src/server/data-source.ts

import "reflect-metadata"
import { DataSource } from "typeorm"
import process from 'node:process'

// 实体类导入
import { UserEntity as User } from "./modules/users/user.entity"
import { Role } from "./modules/users/role.entity"
import { File } from "./modules/files/file.entity"
import { Company } from "./modules/silver-jobs/company.entity"
import { Job } from "./modules/silver-jobs/job.entity"
import { Application } from "./modules/silver-jobs/application.entity"
import { Favorite } from "./modules/silver-jobs/favorite.entity"
import { ViewRecord } from "./modules/silver-jobs/view-record.entity"
import { CompanyImage } from "./modules/silver-jobs/company-image.entity"
import { SilverUserProfile } from "./modules/silver-users/silver-user-profile.entity"
import { SilverPoint } from "./modules/silver-users/silver-point.entity"
import { SilverPointTransaction } from "./modules/silver-users/silver-point-transaction.entity"
import { SilverTimeBank } from "./modules/silver-users/silver-time-bank.entity"
import { SilverKnowledge } from "./modules/silver-users/silver-knowledge.entity"
import { SilverKnowledgeCategory } from "./modules/silver-users/silver-knowledge-category.entity"
import { SilverKnowledgeTag } from "./modules/silver-users/silver-knowledge-tag.entity"
import { SilverKnowledgeTagRelation } from "./modules/silver-users/silver-knowledge-tag-relation.entity"
import { SilverKnowledgeStats } from "./modules/silver-users/silver-knowledge-stats.entity"
import { SilverKnowledgeInteraction } from "./modules/silver-users/silver-knowledge-interaction.entity"

export const AppDataSource = new DataSource({
  type: "mysql",
  host: process.env.DB_HOST || "localhost",
  port: parseInt(process.env.DB_PORT || "3306"),
  username: process.env.DB_USERNAME || "root",
  password: process.env.DB_PASSWORD || "",
  database: process.env.DB_DATABASE || "d8dai",
  entities: [
    User, Role, File, Company, Job, Application, Favorite, ViewRecord, CompanyImage,
    SilverUserProfile, SilverPoint, SilverPointTransaction, SilverTimeBank,
    SilverKnowledge, SilverKnowledgeCategory, SilverKnowledgeTag,
    SilverKnowledgeTagRelation, SilverKnowledgeStats, SilverKnowledgeInteraction,
  ],
  migrations: [],
  synchronize: process.env.DB_SYNCHRONIZE !== "false",
  logging: process.env.DB_LOGGING === "true",
});