MCPcopy Create free account
hub / github.com/cowprotocol/services / postgres_fixed_bytes

Function postgres_fixed_bytes

crates/database/src/byte_array.rs:85–122  ·  view source on GitHub ↗
()

Source from the content-addressed store, hash-verified

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}

Callers

nothing calls this directly

Calls 7

ByteArrayClass · 0.85
unwrapMethod · 0.80
connectFunction · 0.50
queryFunction · 0.50
executeMethod · 0.45
as_strMethod · 0.45
bindMethod · 0.45

Tested by

no test coverage detected