lix 0.12.0

use lix::{LixError, Value};
use serde_json::json;

use super::select_rows;

simulation_test!(
    diff_commands_apply_revert_and_checkpoint_selections,
    |sim| async move {
        let engine = sim.boot_engine().await;
        let session = sim.wrap_session(
            engine.open_session().await.expect("session should open"),
            &engine,
        );
        let baseline = sim.initial_commit_id().to_string();

        session
            .execute(
                "INSERT INTO lix_key_value (key, value) VALUES ('a', 'one')",
                &[],
            )
            .await
            .expect("first tracked insert should succeed");
        session
            .execute(
                "INSERT INTO lix_key_value (key, value) VALUES ('b', 'two')",
                &[],
            )
            .await
            .expect("second tracked insert should succeed");
        let original_head = engine
            .load_branch_head_commit_id(sim.main_branch_id())
            .await
            .expect("head should load")
            .expect("head should exist");

        let working = select_rows(
            &session,
            "SELECT diff_id, row_pk, diff_type FROM lix_working_diff \
         WHERE schema_key = 'lix_key_value' ORDER BY row_pk",
        )
        .await;
        assert_eq!(working.len(), 2);
        assert!(matches!(&working[0][0], Value::Text(id) if id.starts_with("d1.")));
        assert_eq!(working[0][2], Value::Text("added".to_string()));

        let values_error = session
            .execute(
                "INSERT INTO lix_revert (diff_id) VALUES ('d1.invalid')",
                &[],
            )
            .await
            .expect_err("command sinks must reject VALUES");
        assert_eq!(values_error.code, LixError::CODE_UNSUPPORTED_SQL);

        let selected_diff_id = working[0][0].clone();
        let reverted = session
            .execute(
                "INSERT INTO lix_revert (diff_id) \
                 SELECT diff_id \
                 FROM (VALUES ($1)) AS selected(diff_id) \
                 RETURNING commit_id",
                &[selected_diff_id],
            )
            .await
            .expect("selected revert should succeed");
        assert_eq!(reverted.rows_affected(), 1);
        assert_eq!(reverted.columns(), &["commit_id"]);
        assert_eq!(reverted.len(), 1);
        assert!(matches!(
            reverted.get(&reverted.rows()[0], "commit_id"),
            Some(Value::Text(commit_id)) if !commit_id.is_empty()
        ));
        assert_eq!(
            select_rows(
                &session,
                "SELECT key, value FROM lix_key_value WHERE key IN ('a', 'b') ORDER BY key",
            )
            .await,
            vec![vec![
                Value::Text("b".to_string()),
                Value::Jsonb(json!("two").into()),
            ]]
        );

        let historical_diff = format!(
            "SELECT diff_id, before_change_id, after_change_id \
         FROM lix_diff('{baseline}', '{original_head}') \
         WHERE schema_key = 'lix_key_value' \
           AND row_pk = CAST('[\"a\"]' AS JSONB)"
        );
        let historical_rows = select_rows(&session, &historical_diff).await;
        assert_eq!(historical_rows.len(), 1);
        assert_eq!(historical_rows[0][1], Value::Null);
        assert!(matches!(historical_rows[0][2], Value::Text(_)));

        let applied = session
            .execute(
                "INSERT INTO lix_apply (diff_id) \
                 SELECT diff_id FROM lix_diff($1, $2) \
                 WHERE schema_key = 'lix_key_value' \
                   AND row_pk = CAST('[\"a\"]' AS JSONB) \
                 RETURNING commit_id",
                &[
                    Value::Text(baseline.clone()),
                    Value::Text(original_head.to_string()),
                ],
            )
            .await
            .expect("selected historical apply should succeed");
        assert_eq!(applied.rows_affected(), 1);
        assert_eq!(applied.columns(), &["commit_id"]);
        assert_eq!(applied.len(), 1);

        let stale = session
            .execute(
                "INSERT INTO lix_apply (diff_id) \
                 SELECT diff_id FROM lix_diff($1, $2) \
                 WHERE schema_key = 'lix_key_value' \
                   AND row_pk = CAST('[\"a\"]' AS JSONB)",
                &[
                    Value::Text(baseline),
                    Value::Text(original_head.to_string()),
                ],
            )
            .await
            .expect_err("strict apply must reject a moved head");
        assert_eq!(stale.code, LixError::CODE_CONSTRAINT_VIOLATION);
        assert_eq!(
            stale.message,
            "stale or unknown diff_id; re-evaluate the source diff and retry"
        );

        let checkpointed = session
            .execute(
                "INSERT INTO lix_create_checkpoint (diff_id) \
             SELECT diff_id FROM lix_working_diff \
             WHERE schema_key = $1 \
               AND row_pk = CAST($2 AS JSONB) \
             RETURNING commit_id",
                &[
                    Value::Text("lix_key_value".to_string()),
                    Value::Text("[\"a\"]".to_string()),
                ],
            )
            .await
            .expect("partial checkpoint should succeed");
        assert_eq!(checkpointed.rows_affected(), 1);
        assert_eq!(checkpointed.columns(), &["commit_id"]);
        assert_eq!(checkpointed.len(), 1);
        let checkpoint_commit_id = match checkpointed.get(&checkpointed.rows()[0], "commit_id") {
            Some(Value::Text(commit_id)) => commit_id.clone(),
            value => panic!("checkpoint RETURNING should contain a commit ID, got {value:?}"),
        };
        assert_eq!(
            select_rows(
                &session,
                &format!(
                    "SELECT commit_id, lixcol_global FROM lix_checkpoint \
                     WHERE commit_id = '{checkpoint_commit_id}'"
                ),
            )
            .await,
            vec![vec![
                Value::Text(checkpoint_commit_id.clone()),
                Value::Boolean(true),
            ]],
            "partial checkpoint publication must remain globally owned",
        );
        let child_head = engine
            .load_branch_head_commit_id(sim.main_branch_id())
            .await
            .expect("partial checkpoint child head should load")
            .expect("partial checkpoint child head should exist");
        assert_ne!(child_head.to_string(), checkpoint_commit_id);

        assert_eq!(
            select_rows(
                &session,
                "SELECT row_pk FROM lix_working_diff \
             WHERE schema_key = 'lix_key_value' ORDER BY row_pk",
            )
            .await,
            vec![vec![Value::Jsonb(json!(["b"]).into())]]
        );
        assert_eq!(
            select_rows(
                &session,
                "SELECT key, value FROM lix_key_value WHERE key IN ('a', 'b') ORDER BY key",
            )
            .await,
            vec![
                vec![
                    Value::Text("a".to_string()),
                    Value::Jsonb(json!("one").into())
                ],
                vec![
                    Value::Text("b".to_string()),
                    Value::Jsonb(json!("two").into())
                ],
            ]
        );

        let head_before_empty = engine
            .load_branch_head_commit_id(sim.main_branch_id())
            .await
            .expect("head before empty selection should load")
            .expect("head before empty selection should exist");
        let empty = session
            .execute(
                "INSERT INTO lix_revert (diff_id) \
                 SELECT diff_id FROM lix_working_diff WHERE 1 = 0 \
                 RETURNING commit_id",
                &[],
            )
            .await
            .expect("empty diff selection should be a successful no-op");
        assert_eq!(empty.rows_affected(), 0);
        assert_eq!(empty.columns(), &["commit_id"]);
        assert!(empty.is_empty());
        let head_after_empty = engine
            .load_branch_head_commit_id(sim.main_branch_id())
            .await
            .expect("head after empty selection should load")
            .expect("head after empty selection should exist");
        assert_eq!(head_after_empty, head_before_empty);
    }
);

// A checkpointed delete is a *soft* delete: the checkpoint root keeps a
// tombstone for the identity. Re-inserting that identity therefore produces an
// `added` working-diff row whose before-image is `BeforePresent { deleted:
// true }` rather than absent. `diff_id` must encode only the after side in that
// case, exactly as it does for an identity that was never present — otherwise
// physically compacting tombstones away would renumber the id.
simulation_test!(
    diff_id_ignores_a_checkpointed_delete_tombstone,
    |sim| async move {
        let engine = sim.boot_engine().await;
        let session = sim.wrap_session(
            engine.open_session().await.expect("session should open"),
            &engine,
        );

        // A `d1.` id carries a one-byte side mask plus one 16-byte UUID per
        // present side, base64url-unpadded: 3 + 23 = 26 chars for one side,
        // 3 + 44 = 47 for two. Length is the only way to observe the encoded
        // side count from SQL, since clients must not decode a diff_id.
        const AFTER_ONLY_LEN: usize = 26;

        // Control: an identity that was never present before the checkpoint.
        session
            .execute(
                "INSERT INTO lix_key_value (key, value) VALUES ('fresh', 'one')",
                &[],
            )
            .await
            .expect("fresh insert should succeed");
        let fresh = select_rows(
            &session,
            "SELECT diff_id, diff_type, before_change_id FROM lix_working_diff \
             WHERE schema_key = 'lix_key_value' AND row_pk = CAST('[\"fresh\"]' AS JSONB)",
        )
        .await;
        assert_eq!(fresh.len(), 1);
        assert_eq!(fresh[0][1], Value::Text("added".to_string()));
        assert_eq!(
            fresh[0][2],
            Value::Null,
            "an identity that never existed has no before row"
        );
        let Value::Text(fresh_diff_id) = &fresh[0][0] else {
            panic!("diff_id should be text, got {:?}", fresh[0][0]);
        };
        assert_eq!(fresh_diff_id.len(), AFTER_ONLY_LEN);

        // Now build the tombstone history: insert, checkpoint, delete,
        // checkpoint (which retains the tombstone), then re-insert.
        session
            .execute(
                "INSERT INTO lix_key_value (key, value) VALUES ('recycled', 'one')",
                &[],
            )
            .await
            .expect("first insert should succeed");
        session
            .execute(
                "INSERT INTO lix_create_checkpoint (diff_id) \
                 SELECT diff_id FROM lix_working_diff",
                &[],
            )
            .await
            .expect("checkpoint of the insert should succeed");
        session
            .execute("DELETE FROM lix_key_value WHERE key = 'recycled'", &[])
            .await
            .expect("delete should succeed");
        session
            .execute(
                "INSERT INTO lix_create_checkpoint (diff_id) \
                 SELECT diff_id FROM lix_working_diff",
                &[],
            )
            .await
            .expect("checkpoint of the delete should succeed");
        session
            .execute(
                "INSERT INTO lix_key_value (key, value) VALUES ('recycled', 'two')",
                &[],
            )
            .await
            .expect("re-insert should succeed");

        let recycled = select_rows(
            &session,
            "SELECT diff_id, diff_type, before_change_id FROM lix_working_diff \
             WHERE schema_key = 'lix_key_value' AND row_pk = CAST('[\"recycled\"]' AS JSONB)",
        )
        .await;
        assert_eq!(recycled.len(), 1);
        assert_eq!(recycled[0][1], Value::Text("added".to_string()));

        // Non-vacuity: this scenario only tests anything if the checkpointed
        // delete really did leave a tombstone that reaches the diff surface.
        // `before_change_id` reports the raw before row, so it stays populated.
        assert!(
            matches!(&recycled[0][2], Value::Text(id) if !id.is_empty()),
            "fixture must retain a tombstoned before row, got {:?}",
            recycled[0][2]
        );

        let Value::Text(recycled_diff_id) = &recycled[0][0] else {
            panic!("diff_id should be text, got {:?}", recycled[0][0]);
        };
        assert_eq!(
            recycled_diff_id.len(),
            AFTER_ONLY_LEN,
            "a tombstoned before row must not add a side to the diff_id"
        );

        // The normalized id must still drive a command end to end.
        let reverted = session
            .execute(
                "INSERT INTO lix_revert (diff_id) \
                 SELECT diff_id FROM (VALUES ($1)) AS selected(diff_id) \
                 RETURNING commit_id",
                &[recycled[0][0].clone()],
            )
            .await
            .expect("revert of a tombstone-backed add should succeed");
        assert_eq!(reverted.rows_affected(), 1);
        assert_eq!(
            select_rows(
                &session,
                "SELECT key FROM lix_key_value WHERE key = 'recycled'",
            )
            .await,
            Vec::<Vec<Value>>::new(),
            "reverting the re-insert must return the identity to absent"
        );
    }
);