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
|
// SqliteFunctionTests.cs - NUnit Test Cases for SqliteFunction
//
// Authors:
// Rolf Bjarne Kvinge <rolf@xamarin.com>
//
//
// Copyright (C) 2014 Xamarin Inc (http://www.xamarin.com)
//
using System;
using System.Data;
using System.IO;
using System.Text;
using Mono.Data.Sqlite;
using NUnit.Framework;
namespace MonoTests.Mono.Data.Sqlite
{
[TestFixture]
public class SqliteFunctionTest
{
string uri;
[SetUp]
public void SetUp ()
{
uri = Path.GetTempFileName ();
}
[TearDown]
public void TearDown ()
{
if (File.Exists (uri))
File.Delete (uri);
}
[Test]
public void CollationTest()
{
var builder = new SqliteConnectionStringBuilder();
builder.DataSource = uri;
var connectionString = builder.ToString();
using (var connection = new SqliteConnection (connectionString)) {
connection.Open ();
connection.Close ();
}
}
[SqliteFunction(Name = "TestCollation", FuncType = FunctionType.Collation)]
public class TestCollation : SqliteFunction
{
public override int Compare (string param1, string param2)
{
return string.Compare (param1, param2);
}
}
[SqliteFunction(Name = "TestScalar", FuncType = FunctionType.Scalar)]
public class TestScalar : SqliteFunction
{
public override object Invoke (object[] args)
{
return null;
}
}
[SqliteFunction(Name = "TestAggregate", FuncType = FunctionType.Aggregate)]
public class TestAggregate : SqliteFunction
{
public override void Step(object[] args, int stepNumber, ref object contextData)
{
}
public override object Final (object contextData)
{
return null;
}
}
}
}
|
