refinery_cli: Escaped statements are printed

[no-miso]

my development environment
・windows10
・vscode(powershell)

This is the contents of refinery.toml created by setup.

[main]
db_type = "Postgres"
db_host = "localhost\r"
db_port = "5432\r"
db_user = "root\r"
db_pass = "root\r"
db_name = "postgres\r"
trust_cert = false

The value is escaped for some reason, and migration fails as it is.
If I remove the escaping it works fine.

[jxs]

Hi, can you provide the output of the error?
Thanks

[no-miso]

refinery_cli = "0.8.6"
rustc 1.62.0

Error: `could not connect to database`, `invalid connection string: invalid value for option `port``

Caused by:
    0: invalid connection string: invalid value for option `port`
    1: invalid value for option `port`

port number is correct.
I am using cargo install.

[jxs]

sorry, I don't have a windows machine near. Would you be able to debug what value is then being parsed as the port?

[no-miso]

sorry i don't know how. Please let me know if you know.
I think that the escape character of db_host is in the way and I can not read after the port number.

[jxs]

no worries, are you running refinery via refinery_cli? If not Config impls Debug so you can dbg!() before passing it to Runner::run.

[no-miso]

Could you please elaborate on the steps to do this?
I tried but I don't know how to debug the cli tool.

[jxs]

I meant in the code and before compiling refinery cli. You need to download rust clone the repo and cargo build -p refinery_cli

[no-miso]

I'm sorry to have kept you waiting.
Maybe solved.
The problem is that the input values passed to the config are trimmed in sqlite but not in the other database.

[refinery_cli\src\setup.rs:99] &config = Config {
    main: Main {
        db_type: Postgres,
        db_path: None,
        db_host: Some(
            "p\r",
        ),
        db_port: Some(
            "p\r",
        ),
        db_user: Some(
            "p\r",
        ),
        db_pass: Some(
            "p\r",
        ),
        db_name: Some(
            "p\r",
        ),
        trust_cert: false,
    },
}

Trim each input value before passing it to the config.

   refinery_cli\src\setup.rs

   // other...

    print!("Enter database host: ");
    io::stdout().flush()?;
    let mut db_host = String::new();
    io::stdin().read_line(&mut db_host)?;
    db_host.pop();
    // config = config.set_db_host(&db_host); 
    config = config.set_db_host(db_host.trim());

    // other...

print

[refinery_cli\src\setup.rs:99] &config = Config {
    main: Main {
        db_type: Postgres,
        db_path: None,
        db_host: Some(
            "p",
        ),
        db_port: Some(
            "p",
        ),
        db_user: Some(
            "p",
        ),
        db_pass: Some(
            "p",
        ),
        db_name: Some(
            "p",
        ),
        trust_cert: false,
    },
}

[jxs]

no worries :) But why are you passing carriage returns \r on the config file?

[no-miso]

The previous post is the output when building the code changed as below and entering the prescribed information from the terminal with the setup command.

refinery_cli\src\setup.rs

fn get_config_from_input() -> Result<Config> {

    // ...other

    print!("Enter database name: ");
    io::stdout().flush()?;
    let mut db_name = String::new();
    io::stdin().read_line(&mut db_name)?;
    db_name.pop();
    config = config.set_db_name(&db_name);

    dbg!(&config);    //add
    Ok(config)
}