| 83 | #[tokio::test] |
| 84 | #[ignore] |
| 85 | async fn postgres_fixed_bytes() { |
| 86 | const TABLE: &str = "fixed_bytes_test"; |
| 87 | let db = PgPool::connect("postgresql://").await.unwrap(); |
| 88 | db.execute(format!("CREATE TABLE IF NOT EXISTS {TABLE} (bytes bytea);").as_str()) |
| 89 | .await |
| 90 | .unwrap(); |
| 91 | db.execute(format!("TRUNCATE {TABLE};").as_str()) |
| 92 | .await |
| 93 | .unwrap(); |
| 94 | |
| 95 | let data: ByteArray<3> = ByteArray([1, 2, 3]); |
| 96 | sqlx::query(&format!("INSERT INTO {TABLE} (bytes) VALUES ($1);")) |
| 97 | .bind(data) |
| 98 | .execute(&db) |
| 99 | .await |
| 100 | .unwrap(); |
| 101 | let query = format!("SELECT * FROM {TABLE} LIMIT 1;"); |
| 102 | |
| 103 | // unprepared raw query |
| 104 | let row = db.fetch_one(query.as_str()).await.unwrap(); |
| 105 | let data_: ByteArray<3> = row.try_get(0).unwrap(); |
| 106 | assert_eq!(data.0, data_.0); |
| 107 | |
| 108 | // prepared query |
| 109 | let data_: ByteArray<3> = sqlx::query_scalar(&query).fetch_one(&db).await.unwrap(); |
| 110 | assert_eq!(data.0, data_.0); |
| 111 | |
| 112 | // wrong size error, raw query |
| 113 | let row = db.fetch_one(query.as_str()).await.unwrap(); |
| 114 | let result = row.try_get::<ByteArray<0>, _>(0); |
| 115 | assert!(result.is_err()); |
| 116 | |
| 117 | // wrong size error, prepared |
| 118 | let result = sqlx::query_scalar::<_, ByteArray<4>>(&query) |
| 119 | .fetch_one(&db) |
| 120 | .await; |
| 121 | assert!(result.is_err()); |
| 122 | } |
| 123 | } |