Function test_view

crates/core/src/sql/execute.rs:925–943

()

    #[tokio::test]
    async fn test_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, false)?;

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

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

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

        Ok(())
    }

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