Function postgres_db_url_test

tests/cli.rs:230–276

()

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

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

    // Create a demo SQL file
    let mut sql_file = fs::File::create(&sql_file_path)?;
    writeln!(sql_file, "INSERT INTO items (name) VALUES ($1)")?;

    // Create config file with wrong DB settings (should be overridden by --db-url)
    let mut config_file = fs::File::create(&config_file_path)?;
    let config_content = r#"
{
    "generate_types": {
        "enabled": false
    },
    "connections": {
        "default": {
            "DB_TYPE": "mysql",
            "DB_HOST": "127.0.0.1",
            "DB_PORT": 54321,
            "DB_USER": "mysql",
            "DB_PASS": "postgres",
            "DB_NAME": "wrong"
        }
    }
}"#;
    writeln!(config_file, "{config_content}")?;

    // EXECUTE
    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://postgres:postgres@localhost:54321/postgres");

    cmd.assert().success();

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

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