surrealdb-sql 1.1.0

// Timestamp to versionstamp tests
// This translation mechanism is currently used by the garbage collector to determine which change feed entries to delete.
//
// FAQ:
// Q: What’s the difference between database TS and database VS?
// A: Timestamps are basically seconds since the unix epoch.
//    Versionstamps can be anything that is provided by our TSO.
// Q: Why do we need to translate timestamps to versionstamps?
// A: The garbage collector needs to know which change feed entries to delete.
//    However our SQL syntax `DEFINE DATABASE foo CHANGEFEED 1h` let the user specify the expiration in a duration, not a delta in the versionstamp.
//    We need to translate the timestamp to the versionstamp due to that; `now - 1h` to a key suffixed by the versionstamp.
#[tokio::test]
#[serial]
async fn timestamp_to_versionstamp() {
	// Create a new datastore
	let node_id = Uuid::parse_str("A905CA25-56ED-49FB-B759-696AEA87C342").unwrap();
	let clock = Arc::new(RwLock::new(SizedClock::Fake(FakeClock::new(Timestamp::default()))));
	let (ds, _) = new_ds(node_id, clock).await;
	// Give the current versionstamp a timestamp of 0
	let mut tx = ds.transaction(Write, Optimistic).await.unwrap();
	tx.set_timestamp_for_versionstamp(0, "myns", "mydb", true).await.unwrap();
	tx.commit().await.unwrap();
	// Get the versionstamp for timestamp 0
	let mut tx = ds.transaction(Write, Optimistic).await.unwrap();
	let vs1 = tx.get_versionstamp_from_timestamp(0, "myns", "mydb", true).await.unwrap().unwrap();
	tx.commit().await.unwrap();
	// Give the current versionstamp a timestamp of 1
	let mut tx = ds.transaction(Write, Optimistic).await.unwrap();
	tx.set_timestamp_for_versionstamp(1, "myns", "mydb", true).await.unwrap();
	tx.commit().await.unwrap();
	// Get the versionstamp for timestamp 1
	let mut tx = ds.transaction(Write, Optimistic).await.unwrap();
	let vs2 = tx.get_versionstamp_from_timestamp(1, "myns", "mydb", true).await.unwrap().unwrap();
	tx.commit().await.unwrap();
	// Give the current versionstamp a timestamp of 2
	let mut tx = ds.transaction(Write, Optimistic).await.unwrap();
	tx.set_timestamp_for_versionstamp(2, "myns", "mydb", true).await.unwrap();
	tx.commit().await.unwrap();
	// Get the versionstamp for timestamp 2
	let mut tx = ds.transaction(Write, Optimistic).await.unwrap();
	let vs3 = tx.get_versionstamp_from_timestamp(2, "myns", "mydb", true).await.unwrap().unwrap();
	tx.commit().await.unwrap();
	assert!(vs1 < vs2);
	assert!(vs2 < vs3);
}