How To Connect with Datasource?

[pallid breach]

I'm not really sure how to use Datasource, I tried putting it in a new file but when I run npm run start:dev I get
ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)... MissingDriverError: Wrong driver: "undefined" given. Supported drivers are: "aurora-mysql",

[vernal cedar]

What's your TypeOrm.forRoot() configuration look like?

[pallid breach]

https://github.com/khaldgh/Wejhat-back

[vernal cedar]

https://github.com/khaldgh/Wejhat-back/blob/master/src/app.module.ts#L33
This is invalid with TypeORM 0.3.0 because there's no longer a reading from an ormconfig. How are you tyring to actually use the datasource.ts file? What are you needing it for?

[pallid breach]

I know that ormconfig is no longer valid, that's why I commented it and replaced it with datasource

as for datasource I'm not really sure how to use it, I'm trying to replace it with Repository and call entities and query them

[vernal cedar]

as for datasource I'm not really sure how to use it,
Why do you want to use it?

[pallid breach]

to connect to the database

MissingDriverError: Wrong driver: "undefined" given. Supported drivers are: "aurora-mysql",

this is the error I get

[vernal cedar]

Okay, but why not just pass the options to TypeOrmModule.forRoot() or TypeOrmModule.forRootAsync()? Why do you need a datasource file?

[pallid breach]

it worked and the connection is made.
but now when I send a request using Repository i get a 400 error

export class CategoriesService {
  constructor(
    @InjectRepository(Category) private repo: Repository<Category>,
    @InjectRepository(User) private userRepo: Repository<User>,
  ) {}

  getCategories() {
    return this.repo.createQueryBuilder().select('*')
    .where('category_id NOT IN (75, 135, 145)')
      .getRawMany();
  }

[vernal cedar]

What error do you get?

[pallid breach]

I just get a 400 bad request in postman

[vernal cedar]

Anything else? any other information?

[vernal cedar]

Okay, so then where do you throw the error from?

[pallid breach]

the error ususally comes from Postman, strangely now it doesn't

only the 400 bad request

[vernal cedar]

Do you have some sort of filter in place?

There's not enough info here to know what's happening

[pallid breach]

what do you mean by filter? like a guard?

[vernal cedar]

An exception filter

[pallid breach]

then no

[vernal cedar]

Do you throw an error anywhere? A throw new BadRequestException() or similar?

[pallid breach]

no, but back when ormconfig was working, errors were showing up without exceptions

[vernal cedar]

That doesn't help me, because I don't know what it looked like before hand, nor why this error is showing up. There's no info here

From a brief check of your repo, I can't see where that would be generating an error from.

[pallid breach]

I made it work, now I'm confused how to dynamically choose the current database?

[vernal cedar]

You have multiple databases?

Or is this a per-environment change?

[pallid breach]

yes

[vernal cedar]

Use forRootAsync and the ConfigService like the docs show how to do

https://docs.nestjs.com/techniques/database#async-configuration

TypeOrmModule.forRootAsync({
  imports: [ConfigModule],
  useFactory: (configService: ConfigService) => ({
    type: 'mysql',
    host: configService.get('HOST'),
    port: +configService.get('PORT'),
    username: configService.get('USERNAME'),
    password: configService.get('PASSWORD'),
    database: configService.get('DATABASE'),
    entities: [],
    synchronize: true,
  }),
  inject: [ConfigService],
});

[pallid breach]

thanks

[pallid breach]

I used this, with .env.development and I got this error
Error: Access denied for user 'kall-'@'localhost' (using password: YES)

[vernal cedar]

Do you have a user for the daycaredatabase you're currently running?

[pallid breach]

what do you mean by daycare?

[vernal cedar]

A typo from my phone

[pallid breach]

yes, and it should be root instead of kall-

kall- is my machine's username

[vernal cedar]

How did you set up the config service? Seems it ndidn't read your .env. file

[pallid breach]

@Module({
  imports: [
    ConfigModule.forRoot({
      isGlobal: true,
      envFilePath: `.env.development`,
    }),
    TypeOrmModule.forRootAsync({
      // imports: [ConfigModule],
      useFactory: (configService: ConfigService) => ({
        type: 'mysql',
        host: configService.get('HOST'),
        port: +configService.get('PORT'),
        username:configService.get('USERNAME'),
        password:configService.get('PASSWORD'),
        database:configService.get('DATABASE'),
        entities:['**/*.js'],
      }),
      inject: [ConfigService]
    }),

[vernal cedar]

As the module is global you don't need to import it again

[pallid breach]

so it should be like this?

[vernal cedar]

Looks right now

[pallid breach]

still the same error

[vernal cedar]

And your .env.development file has USERNAME=root and is in the workspace root?

[pallid breach]

yes

[vernal cedar]

If you log out console.log(configService.get('USERNAME')) inside of the useFactory what do you get?

[pallid breach]

kall- !

strange, it's root in the .env.development file

[vernal cedar]

Yeah, something doesn't seem right there. Is this the only place you have ConfigModule.forRoot()?

[pallid breach]

yes

[vernal cedar]

Weird. Is your updated code on GitHub?

[pallid breach]

https://github.com/khaldgh/Wejhat-back

[pallid breach]

juust updated

[vernal cedar]

It's reading the .env.development file just fine for me. I'd suggest removing the dist and restarting the server

[pallid breach]

I changed USERNAME to USER and it worked

but now I'm getting
Error: EMFILE: too many open files, open 'D:\Apps\Wejhat-back\node_modules\class-transformer\esm5\TransformOperationExecutor.js'

I tried deleting dist and node_modules and it also didn't work