Function run_sqlite_test

tests/sqlite_query_parameters.rs:14–67

Helper: creates a temporary SQLite database with the given schema, then runs sqlx-ts on the given TS content, and returns the generated types.

(
    schema_sql: &str,
    ts_content: &str,
    generate_types: bool,
  )

  /// Helper: creates a temporary SQLite database with the given schema,
  /// then runs sqlx-ts on the given TS content, and returns the generated types.
  fn run_sqlite_test(
    schema_sql: &str,
    ts_content: &str,
    generate_types: bool,
  ) -> Result<(String, String), Box<dyn std::error::Error>> {
    let dir = tempdir()?;
    let parent_path = dir.path();

    // Create the SQLite database and populate it with the schema
    let db_path = parent_path.join("test.db");
    let conn = rusqlite::Connection::open(&db_path)?;
    conn.execute_batch(schema_sql)?;
    drop(conn);

    // Write the TS file
    let file_path = parent_path.join("index.ts");
    let mut temp_file = fs::File::create(&file_path)?;
    writeln!(temp_file, "{}", ts_content)?;

    // Run sqlx-ts
    let mut cmd = cargo_bin_cmd!("sqlx-ts");
    cmd
      .arg(parent_path.to_str().unwrap())
      .arg("--ext=ts")
      .arg("--db-type=sqlite")
      .arg(format!("--db-name={}", db_path.display()));

    if generate_types {
      cmd.arg("-g");
    }

    let output = cmd.output()?;
    let stdout = String::from_utf8_lossy(&output.stdout).to_string();
    let stderr = String::from_utf8_lossy(&output.stderr).to_string();

    assert!(
      output.status.success(),
      "sqlx-ts failed!\nstdout: {stdout}\nstderr: {stderr}"
    );
    assert!(
      stdout.contains("No SQL errors detected!"),
      "Expected success message in stdout: {stdout}"
    );

    // Read generated types
    let type_file_path = parent_path.join("index.queries.ts");
    let type_file = if type_file_path.exists() {
      fs::read_to_string(type_file_path)?
    } else {
      String::new()
    };

    Ok((stdout, type_file))
  }

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