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

        public void SelectOnePriv(string name)
        {
            var sql = String.Format("SELECT * FROM system.privs WHERE description = '{0}'", name);

            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");

            var privs = (Privileges) Enum.Parse(typeof(Privileges), name, true);

            Assert.AreEqual((int)privs, ((SqlNumber)privBit.Value).ToInt32());
            Assert.AreEqual(name.ToUpperInvariant(), desc.Value.ToString().ToUpperInvariant());
        }