Deveel.Data.SelectBlobTests.SelectData C# (CSharp) Method

        public void SelectData()
        {
            var exp = (SqlQueryExpression)SqlExpression.Parse("SELECT * FROM test_table");
            var result = AdminQuery.Select(exp);

            Assert.IsNotNull(result);
            Assert.IsTrue(result.Any());

            var row = result.FirstOrDefault();

            Assert.IsNotNull(row);

            var data = row["data"];

            Assert.IsFalse(Field.IsNullField(data));
            Assert.IsInstanceOf<BinaryType>(data.Type);
            Assert.AreEqual(SqlTypeCode.Blob, data.Type.TypeCode);
            Assert.IsInstanceOf<SqlLongBinary>(data.Value);

            var stream = ((SqlLongBinary)data.Value).GetInput();
            var content = new byte[2048];
            Assert.DoesNotThrow(() => stream.Read(content, 0, content.Length));

            Assert.IsNotEmpty(content);
            Assert.AreEqual(testData, content);
        }