Function test_anonymous_view

crates/core/src/sql/execute.rs:946–970

()

    #[tokio::test]
    async fn test_anonymous_view() -> anyhow::Result<()> {
        let db = TestDB::in_memory()?;

        let schema = [("a", AlgebraicType::U8), ("b", AlgebraicType::U8)];
        let (_, table_id) = tests_utils::create_view_for_test(&db, "my_view", &schema, true)?;

        with_auto_commit(&db, |tx| -> Result<_, DBError> {
            tests_utils::insert_into_view(&db, tx, table_id, None, product![0u8, 1u8])?;
            tests_utils::insert_into_view(&db, tx, table_id, None, product![0u8, 2u8])?;
            Ok(())
        })?;

        let id = identity_from_u8(1);
        let auth = AuthCtx::new(Identity::ZERO, id);

        assert_query_results(
            db.clone(),
            "select b from my_view",
            auth,
            [product![1u8], product![2u8]],
        )
        .await;

        Ok(())
    }

    #[tokio::test]
    async fn test_view_join_table() -> anyhow::Result<()> {