dev-npgsql/npgsql: Npgsql is the .NET data provider for PostgreSQL.

test/Npgsql.Tests/LargeObjectTests.cs

48 строк1 KB

Shay Rojansky

Use file-scoped namespaces (#4225)

18 дек 2021, 13:52

18 дек 2021, 13:5243756d1

using System.Linq;
using System.Text;
using NUnit.Framework;

namespace Npgsql.Tests;

public class LargeObjectTests : TestBase
{
    [Test]
    public void Test()
    {
        using var conn = OpenConnection();
        using var transaction = conn.BeginTransaction();
        var manager = new NpgsqlLargeObjectManager(conn);
        var oid = manager.Create();
        using (var stream = manager.OpenReadWrite(oid))
        {
            var buf = Encoding.UTF8.GetBytes("Hello");
            stream.Write(buf, 0, buf.Length);
            stream.Seek(0, System.IO.SeekOrigin.Begin);
            var buf2 = new byte[buf.Length];
            stream.Read(buf2, 0, buf2.Length);
            Assert.That(buf.SequenceEqual(buf2));

            Assert.AreEqual(5, stream.Position);

            Assert.AreEqual(5, stream.Length);

            stream.Seek(-1, System.IO.SeekOrigin.Current);
            Assert.AreEqual((int)'o', stream.ReadByte());

            manager.MaxTransferBlockSize = 3;

            stream.Write(buf, 0, buf.Length);
            stream.Seek(-5, System.IO.SeekOrigin.End);
            var buf3 = new byte[100];
            Assert.AreEqual(5, stream.Read(buf3, 0, 100));
            Assert.That(buf.SequenceEqual(buf3.Take(5)));

            stream.SetLength(43);
            Assert.AreEqual(43, stream.Length);
        }

        manager.Unlink(oid);

        transaction.Rollback();
    }
}