Deveel.Data.SelectPrivsTests.SelectAllPrivs C# (CSharp) Method

        public void SelectAllPrivs()
        {
            const string sql = "SELECT * FROM system.privs";

            var query = (SqlQueryExpression) SqlExpression.Parse(sql);

            var cursor = AdminQuery.Select(query);

            Assert.IsNotNull(cursor);

            Row row = null;
            Assert.DoesNotThrow(() => row = cursor.Fetch(FetchDirection.Next, -1));
            Assert.IsNotNull(row);

            var privBit = row.GetValue("priv_bit");
            var desc = row.GetValue("description");

            Assert.AreEqual(0, ((SqlNumber) privBit.Value).ToInt32());
            Assert.AreEqual("NONE", desc.Value.ToString());
        }