π End-to-end encrypted cloud for everything.
Dart 2faandroidauthye2eeencryptionend-to-end-encryptionfluttergolanggoogle-photosgoogle-photos-alternativeiosopensourcephotosprivacyprivacy-toolstypescriptzero-knowledge
use std::path::Path;
use anyhow::{Context, Result};
use rusqlite::{Connection, OpenFlags};
use zeroize::Zeroizing;
use crate::{auth, core_db::Db, photos::replica, vault::DbKey};
const MIGRATIONS: &[&str] = &[replica::SCHEMA, auth::replica::SCHEMA];
pub fn open(account_dir: &Path, key: &DbKey, create: bool) -> Result<Db> {
let connection = connect(&account_dir.join("data.db"), key, create)?;
connection.execute_batch(
"PRAGMA foreign_keys = ON; PRAGMA temp_store = MEMORY; PRAGMA journal_mode = WAL;",
)?;
let mut db = Db::new(connection);
db.migrate(MIGRATIONS)?;
Ok(db)
}
pub fn connect(path: &Path, key: &DbKey, create: bool) -> Result<Connection> {
let mut flags = OpenFlags::SQLITE_OPEN_READ_WRITE | OpenFlags::SQLITE_OPEN_NO_MUTEX;
if create {
flags |= OpenFlags::SQLITE_OPEN_CREATE;
}
let connection = Connection::open_with_flags(path, flags)?;
connection.busy_timeout(std::time::Duration::from_secs(5))?;
connection
.query_row("PRAGMA cipher_version", [], |row| row.get::<_, String>(0))
.context("this CLI build does not support encrypted databases")?;
let mut encoded_key = Zeroizing::new(String::from("x'"));
for byte in &key.0 {
use std::fmt::Write;
write!(encoded_key, "{byte:02x}")?;
}
encoded_key.push('\'');
connection.pragma_update(None, "key", encoded_key.as_str())?;
connection
.query_row("SELECT count(*) FROM sqlite_master", [], |row| {
row.get::<_, i64>(0)
})
.context("cannot open the encrypted database")?;
Ok(connection)
}
pub fn scratch(path: &Path) -> Result<Connection> {
connect(
path,
&DbKey(*ente_core::crypto::Key::generate().as_bytes()),
true,
)
}
#[cfg(test)]
mod tests {
use super::*;
#[test]
fn scratch_pages_require_the_discarded_attempt_key() {
let directory = tempfile::tempdir().unwrap();
let path = directory.path().join("index.db");
let db = scratch(&path).unwrap();
db.execute_batch(
"CREATE TABLE names(name TEXT); INSERT INTO names VALUES('private export album');",
)
.unwrap();
drop(db);
let bytes = std::fs::read(&path).unwrap();
assert!(!bytes.starts_with(b"SQLite format 3"));
assert!(scratch(&path).is_err());
}
#[test]
fn released_migrations_are_append_only() {
let hashes: Vec<u64> = MIGRATIONS
.iter()
.map(|script| {
script.bytes().fold(0xcbf2_9ce4_8422_2325, |hash, byte| {
(hash ^ u64::from(byte)).wrapping_mul(0x100_0000_01b3)
})
})
.collect();
assert_eq!(
hashes,
[8_546_364_548_145_080_129, 12_408_635_783_593_254_159],
"released migrations are append-only; add a new entry and record its hash"
);
}
}