forked from npgsql/npgsql
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathAsyncTests.cs
More file actions
101 lines (94 loc) · 3.58 KB
/
AsyncTests.cs
File metadata and controls
101 lines (94 loc) · 3.58 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
#region License
// The PostgreSQL License
//
// Copyright (C) 2015 The Npgsql Development Team
//
// Permission to use, copy, modify, and distribute this software and its
// documentation for any purpose, without fee, and without a written
// agreement is hereby granted, provided that the above copyright notice
// and this paragraph and the following two paragraphs appear in all copies.
//
// IN NO EVENT SHALL THE NPGSQL DEVELOPMENT TEAM BE LIABLE TO ANY PARTY
// FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES,
// INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
// DOCUMENTATION, EVEN IF THE NPGSQL DEVELOPMENT TEAM HAS BEEN ADVISED OF
// THE POSSIBILITY OF SUCH DAMAGE.
//
// THE NPGSQL DEVELOPMENT TEAM SPECIFICALLY DISCLAIMS ANY WARRANTIES,
// INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
// AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS
// ON AN "AS IS" BASIS, AND THE NPGSQL DEVELOPMENT TEAM HAS NO OBLIGATIONS
// TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
#endregion
using System.Data;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using Npgsql;
using NUnit.Framework;
namespace Npgsql.Tests
{
public class AsyncTests : TestBase
{
public AsyncTests(string backendVersion) : base(backendVersion) {}
[Test]
public async void NonQuery()
{
ExecuteNonQuery("CREATE TEMP TABLE data (int INTEGER)");
using (var cmd = new NpgsqlCommand("INSERT INTO data (int) VALUES (4)", Conn))
{
await cmd.ExecuteNonQueryAsync();
}
Assert.That(ExecuteScalar("SELECT int FROM data"), Is.EqualTo(4));
}
[Test]
public async void Scalar()
{
using (var cmd = new NpgsqlCommand("SELECT 1", Conn)) {
Assert.That(await cmd.ExecuteScalarAsync(), Is.EqualTo(1));
}
}
[Test]
public async void Reader()
{
using (var cmd = new NpgsqlCommand("SELECT 1", Conn))
using (var reader = await cmd.ExecuteReaderAsync())
{
await reader.ReadAsync();
Assert.That(reader[0], Is.EqualTo(1));
}
}
[Test]
public async void Columnar()
{
using (var cmd = new NpgsqlCommand("SELECT NULL, 2, 'Some Text'", Conn))
using (var reader = await cmd.ExecuteReaderAsync(CommandBehavior.SequentialAccess))
{
await reader.ReadAsync();
Assert.That(await reader.IsDBNullAsync(0), Is.True);
Assert.That(await reader.GetFieldValueAsync<string>(2), Is.EqualTo("Some Text"));
}
}
[Test, Description("Cancels an async query with the cancellation token")]
[Timeout(5000)]
[Ignore("Not reliable...")]
public void Cancel()
{
var cancellationSource = new CancellationTokenSource();
using (var cmd = CreateSleepCommand(Conn, 5))
{
Task.Factory.StartNew(() =>
{
Thread.Sleep(300);
cancellationSource.Cancel();
});
var t = cmd.ExecuteNonQueryAsync(cancellationSource.Token);
Task.WaitAny(t);
Assert.That(t.IsCanceled);
}
}
}
}