Password is asked when running models tests

[volatiletech]

Password is asked when running models tests

[nullbio]

@nubunto We've released the fix in 2.0.2.

[nullbio]

Hi @nubunto. Where is your sqlboiler.toml file located and where is your models folder located?

The test suite should not ask you for a password if one is defined in your sqlboiler.toml. Are you certain it is loading the correct sqlboiler.toml, not one without a password defined? You don't have a config defined anywhere else in your system, and you aren't using environment variables?

Also, what command did you use to generate your models?

[nubunto]

Hey!

So the tree for the project looks like this:

project/
|___ src/
     |____ sqlboiler.toml
     |____ models/

I tend to cd into src/ and run sqlboiler -b schema_migrations postgres

To answer your other questions: that may be the case, maybe the wrong sqlboiler.toml is being loaded. But I only have one in the entire system, so I doubt that. And no, I'm not using env variables.

[nullbio]

Okay. That should be good. And you're certain there is a password defined in your sqlboiler.toml? As far as I'm aware, you should only ever get a password prompt if the password is missing from your config file.

[nubunto]

Yes, I'm 99% positive there is a "pass" field on sqlboiler.toml. Since sqlboiler generates the structs, I can assume it has a password, and it is valid. I will investigate a little more on this whenever I get the chance.

[aarondl]

We seem to have a recreate, will work on this. :)

[aarondl]

Found some bugs in the pgpassfile things. It was erroneously using my real pgpass file when I created and I didn't notice somehow. Sorry about that.

We also have to create a new entry in the pgpassfile for the "postgres" database, because of the way createdb/dropdb work, they attempt to switch to that database before performing any operations. We can't really get away from this since you can't drop a database without being on another database. Anyway it should be fixed in the dev branch @ 0dc68e7

[nubunto]

Back with the tests, then 😄