mcs/class/Mono.Data.Sqlite/Test/SqliteFunctionTests.cs

   1 // SqliteFunctionTests.cs - NUnit Test Cases for SqliteFunction
   2 //
   3 // Authors:
   4 //   Rolf Bjarne Kvinge <rolf@xamarin.com>
   5 //
   6
   7 //
   8 // Copyright (C) 2014 Xamarin Inc (http://www.xamarin.com)
   9 //
  10
  11 using System;
  12 using System.Data;
  13 using System.IO;
  14 using System.Text;
  15 using Mono.Data.Sqlite;
  16 using NUnit.Framework;
  17
  18 namespace MonoTests.Mono.Data.Sqlite
  19 {
  20         [TestFixture]
  21         public class SqliteFunctionTest
  22         {
  23                 readonly static string uri = Path.Combine (Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData), "test.db");
  24
  25                 [Test]
  26                 public void CollationTest()
  27                 {
  28                         var builder = new SqliteConnectionStringBuilder();
  29                         builder.DataSource = uri;
  30
  31                         var connectionString = builder.ToString();
  32                         using (var connection = new SqliteConnection (connectionString)) {
  33                                 connection.Open ();
  34                                 connection.Close ();
  35                         }
  36                 }
  37
  38                 [SqliteFunction(Name = "TestCollation", FuncType = FunctionType.Collation)]
  39                 public class TestCollation : SqliteFunction
  40                 {
  41                         public override int Compare (string param1, string param2)
  42                         {
  43                                 return string.Compare (param1, param2);
  44                         }
  45                 }
  46         }
  47 }