use sqlx::Sqlite;
use sqlx::Transaction;
use super::super::super::utils::insert_key_value_batch;
pub(crate) async fn insert_security_headers(
tx: &mut Transaction<'_, Sqlite>,
url_status_id: i64,
security_headers: &std::collections::HashMap<String, String>,
) -> Result<(), sqlx::Error> {
if security_headers.is_empty() {
return Ok(());
}
let headers: Vec<(&String, &String)> = security_headers.iter().collect();
insert_key_value_batch(
tx,
"url_security_headers",
"url_status_id",
"header_name",
"header_value",
url_status_id,
&headers,
Some("ON CONFLICT(url_status_id, header_name) DO UPDATE SET header_value=excluded.header_value"),
)
.await
}
pub(crate) async fn insert_http_headers(
tx: &mut Transaction<'_, Sqlite>,
url_status_id: i64,
http_headers: &std::collections::HashMap<String, String>,
) -> Result<(), sqlx::Error> {
if http_headers.is_empty() {
return Ok(());
}
let headers: Vec<(&String, &String)> = http_headers.iter().collect();
insert_key_value_batch(
tx,
"url_http_headers",
"url_status_id",
"header_name",
"header_value",
url_status_id,
&headers,
Some("ON CONFLICT(url_status_id, header_name) DO UPDATE SET header_value=excluded.header_value"),
)
.await
}
#[cfg(test)]
mod tests {
use super::*;
use sqlx::Row;
use std::collections::HashMap;
use crate::storage::test_helpers::{create_test_pool, create_test_url_status_default};
#[tokio::test]
async fn test_insert_security_headers_basic() {
let pool = create_test_pool().await;
let url_status_id = create_test_url_status_default(&pool).await;
let mut tx = pool.begin().await.expect("Failed to start transaction");
let mut security_headers = HashMap::new();
security_headers.insert(
"Strict-Transport-Security".to_string(),
"max-age=31536000".to_string(),
);
security_headers.insert(
"Content-Security-Policy".to_string(),
"default-src 'self'".to_string(),
);
insert_security_headers(&mut tx, url_status_id, &security_headers)
.await
.expect("insert");
tx.commit().await.expect("Failed to commit transaction");
let rows = sqlx::query(
"SELECT header_name, header_value FROM url_security_headers WHERE url_status_id = ? ORDER BY header_name",
)
.bind(url_status_id)
.fetch_all(&pool)
.await
.expect("Failed to fetch security headers");
assert_eq!(rows.len(), 2);
assert_eq!(
rows[0].get::<String, _>("header_name"),
"Content-Security-Policy"
);
assert_eq!(
rows[1].get::<String, _>("header_name"),
"Strict-Transport-Security"
);
}
#[tokio::test]
async fn test_insert_security_headers_upsert() {
let pool = create_test_pool().await;
let url_status_id = create_test_url_status_default(&pool).await;
let mut tx1 = pool.begin().await.expect("Failed to start transaction");
let mut security_headers1 = HashMap::new();
security_headers1.insert(
"Strict-Transport-Security".to_string(),
"max-age=31536000".to_string(),
);
insert_security_headers(&mut tx1, url_status_id, &security_headers1)
.await
.expect("insert");
tx1.commit().await.expect("Failed to commit transaction");
let mut tx2 = pool.begin().await.expect("Failed to start transaction");
let mut security_headers2 = HashMap::new();
security_headers2.insert(
"Strict-Transport-Security".to_string(),
"max-age=63072000".to_string(),
);
insert_security_headers(&mut tx2, url_status_id, &security_headers2)
.await
.expect("insert");
tx2.commit().await.expect("Failed to commit transaction");
let row = sqlx::query(
"SELECT header_value FROM url_security_headers WHERE url_status_id = ? AND header_name = 'Strict-Transport-Security'",
)
.bind(url_status_id)
.fetch_one(&pool)
.await
.expect("Failed to fetch security header");
assert_eq!(row.get::<String, _>("header_value"), "max-age=63072000");
}
#[tokio::test]
async fn test_insert_http_headers_basic() {
let pool = create_test_pool().await;
let url_status_id = create_test_url_status_default(&pool).await;
let mut tx = pool.begin().await.expect("Failed to start transaction");
let mut http_headers = HashMap::new();
http_headers.insert("Server".to_string(), "nginx/1.18.0".to_string());
http_headers.insert("X-Powered-By".to_string(), "PHP/7.4".to_string());
insert_http_headers(&mut tx, url_status_id, &http_headers)
.await
.expect("insert");
tx.commit().await.expect("Failed to commit transaction");
let rows = sqlx::query(
"SELECT header_name, header_value FROM url_http_headers WHERE url_status_id = ? ORDER BY header_name",
)
.bind(url_status_id)
.fetch_all(&pool)
.await
.expect("Failed to fetch HTTP headers");
assert_eq!(rows.len(), 2);
assert_eq!(rows[0].get::<String, _>("header_name"), "Server");
assert_eq!(rows[1].get::<String, _>("header_name"), "X-Powered-By");
}
}