lib

Core libraries for Radroots
git clone https://radroots.dev/git/lib.git
Log | Files | Refs | README

legacy_delivery_catalog.rs (3013B)


      1 use sqlx::SqliteConnection;
      2 
      3 // Synthetic exact predecessor catalog, never a claim that an old binary ran.
      4 pub(super) async fn retain_legacy_delivery_catalog(db: &mut SqliteConnection) {
      5     use sqlx::Row;
      6     let public: i64 = sqlx::query_scalar(
      7         "SELECT count(*) FROM artifact_delivery_attempts WHERE length(artifact_key)!=32",
      8     )
      9     .fetch_one(&mut *db)
     10     .await
     11     .unwrap();
     12     assert_eq!(public, 0);
     13     let rows=sqlx::query("SELECT name,sql FROM sqlite_schema WHERE name IN ('artifact_delivery_attempts','artifact_delivery_parts','artifact_delivery_observations','artifact_delivery_transaction_identity')").fetch_all(&mut *db).await.unwrap();
     14     let definitions = rows
     15         .into_iter()
     16         .map(|row| {
     17             let name: String = row.get(0);
     18             let ddl: String = row.get(1);
     19             let ddl = ddl
     20                 .replace("artifact_delivery", "chat_delivery")
     21                 .replace("artifact_key", "recipient")
     22                 .replace(
     23                     "CHECK(length(recipient)=32 OR (length(recipient)=1 AND hex(recipient)='00'))",
     24                     "CHECK(length(recipient)=32)",
     25                 )
     26                 .replace(
     27                     "REFERENCES artifact_evidence(workspace,operation_id,recipient)",
     28                     "REFERENCES chat_publication_work(workspace,operation_id,recipient)",
     29                 );
     30             (name, ddl)
     31         })
     32         .collect::<std::collections::BTreeMap<_, _>>();
     33     for table in [
     34         "artifact_delivery_attempts",
     35         "artifact_delivery_parts",
     36         "artifact_delivery_observations",
     37     ] {
     38         sqlx::query(sqlx::AssertSqlSafe(format!(
     39             "CREATE TEMP TABLE retained_{table} AS SELECT * FROM {table}"
     40         )))
     41         .execute(&mut *db)
     42         .await
     43         .unwrap();
     44     }
     45     for table in [
     46         "artifact_delivery_observations",
     47         "artifact_delivery_parts",
     48         "artifact_delivery_attempts",
     49     ] {
     50         sqlx::query(sqlx::AssertSqlSafe(format!("DROP TABLE {table}")))
     51             .execute(&mut *db)
     52             .await
     53             .unwrap();
     54     }
     55     for table in [
     56         "artifact_delivery_attempts",
     57         "artifact_delivery_transaction_identity",
     58         "artifact_delivery_parts",
     59         "artifact_delivery_observations",
     60     ] {
     61         sqlx::query(sqlx::AssertSqlSafe(definitions[table].clone()))
     62             .execute(&mut *db)
     63             .await
     64             .unwrap();
     65     }
     66     for table in [
     67         "artifact_delivery_attempts",
     68         "artifact_delivery_parts",
     69         "artifact_delivery_observations",
     70     ] {
     71         let legacy = table.replace("artifact_delivery", "chat_delivery");
     72         sqlx::query(sqlx::AssertSqlSafe(format!(
     73             "INSERT INTO {legacy} SELECT * FROM retained_{table}"
     74         )))
     75         .execute(&mut *db)
     76         .await
     77         .unwrap();
     78         sqlx::query(sqlx::AssertSqlSafe(format!("DROP TABLE retained_{table}")))
     79             .execute(&mut *db)
     80             .await
     81             .unwrap();
     82     }
     83 }