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 }