Function postgres_db_url_failure_test

tests/cli.rs:414–460

()

  #[test]
  fn postgres_db_url_failure_test() -> Result<(), Box<dyn std::error::Error>> {
    // SETUP
    let demo_dir = tempdir()?;
    let demo_path = demo_dir.path();
    let ts_file_path = demo_path.join("test-query.ts");

    let config_dir = tempdir()?;
    let config_file_path = config_dir.path().join(".sqlxrc.json");

    // Create a demo TS file with SQL query
    let mut ts_file = fs::File::create(&ts_file_path)?;
    writeln!(ts_file, "const someQuery = sql`INSERT INTO items (name) VALUES ($1);`")?;

    // Create config file
    let mut config_file = fs::File::create(&config_file_path)?;
    let config_content = r#"
{
    "generate_types": {
        "enabled": false
    },
    "connections": {
        "default": {
            "DB_TYPE": "postgres",
            "DB_HOST": "127.0.0.1",
            "DB_PORT": 54321,
            "DB_USER": "postgres",
            "DB_PASS": "postgres",
            "DB_NAME": "postgres"
        }
    }
}"#;
    writeln!(config_file, "{config_content}")?;

    // EXECUTE - Pass in wrong db-url that should fail
    let mut cmd = cargo_bin_cmd!("sqlx-ts");
    cmd
      .arg(demo_path.to_str().unwrap())
      .arg("--ext=ts")
      .arg(format!("--config={}", config_file_path.to_str().unwrap()))
      .arg("--db-type=postgres")
      .arg("--db-url=postgres://wronguser:wrongpass@localhost:99999/wrongdb");

    cmd.assert().failure();

    // Cleanup happens automatically when demo_dir and config_dir go out of scope
    Ok(())
  }

  #[test]
  fn mysql_db_url_failure_test() -> Result<(), Box<dyn std::error::Error>> {