Function should_validate_simple_select

tests/sqlite_query_parameters.rs:70–101

()

  #[test]
  fn should_validate_simple_select() -> Result<(), Box<dyn std::error::Error>> {
    let schema = "CREATE TABLE items (id INTEGER PRIMARY KEY NOT NULL, name TEXT NOT NULL, price REAL);";

    let ts_content = r#"
import { sql } from 'sqlx-ts'

const someQuery = sql`SELECT * FROM items`
"#;

    let (_, type_file) = run_sqlite_test(schema, ts_content, true)?;

    let expected = r#"
export type SomeQueryParams = [];

export interface ISomeQueryResult {
	id: number;
	name: string;
	price: number | null;
}

export interface ISomeQueryQuery {
	params: SomeQueryParams;
	result: ISomeQueryResult;
}
"#;

    assert_eq!(
      expected.trim().to_string().flatten(),
      type_file.trim().to_string().flatten()
    );
    Ok(())
  }

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