mcs/class/Npgsql/Test/ConnectionTests.cs

   1 // project created on 30/11/2002 at 22:00\r
   2 using System;\r
   3 using Npgsql;\r
   4 using System.Data;\r
   5 \r
   6 using NUnit.Framework;\r
   7 \r
   8 namespace NpgsqlTests\r
   9 {\r
  10         \r
  11         \r
  12                 \r
  13         [TestFixture]\r
  14         public class ConnectionTests\r
  15         {\r
  16                 private NpgsqlConnection        _conn = null;\r
  17                 private String                                          _connString = "Server=localhost;User ID=npgsql_tests;Password=npgsql_tests;Database=npgsql_tests";\r
  18                 \r
  19                 [SetUp]\r
  20                 protected void SetUp()\r
  21                 {\r
  22                         NpgsqlEventLog.Level = LogLevel.None;\r
  23                         //NpgsqlEventLog.LogName = "NpgsqlTests.LogFile";\r
  24                         _conn = new NpgsqlConnection(_connString);\r
  25                 }\r
  26                 \r
  27                 [TearDown]\r
  28                 protected void TearDown()\r
  29                 {\r
  30                         _conn.Close();\r
  31                 }\r
  32                 \r
  33                 \r
  34                 [Test]\r
  35                 public void Open()\r
  36                 {\r
  37                         try{\r
  38                                 _conn.Open();\r
  39                                 //Assertion.AssertEquals("ConnectionOpen", ConnectionState.Open, _conn.State);\r
  40                         } catch (Exception e)\r
  41                         {\r
  42                                 Console.WriteLine(e.ToString());\r
  43                         }\r
  44                         \r
  45                         \r
  46                 }\r
  47                 \r
  48                 [Test]\r
  49                 public void ChangeDatabase()\r
  50                 {\r
  51                         _conn.Open();\r
  52                         \r
  53                         _conn.ChangeDatabase("template1");\r
  54                         \r
  55                         NpgsqlCommand command = new NpgsqlCommand("select current_database()", _conn);\r
  56                         \r
  57                         String result = (String)command.ExecuteScalar();\r
  58                         \r
  59                         Assertion.AssertEquals("template1", result);\r
  60                                 \r
  61                 }\r
  62                 \r
  63                 [Test]\r
  64                 [ExpectedException(typeof(InvalidOperationException))]\r
  65                 public void NestedTransaction()\r
  66                 {\r
  67                         _conn.Open();\r
  68                         \r
  69                         NpgsqlTransaction t = _conn.BeginTransaction();\r
  70                         \r
  71                         t = _conn.BeginTransaction();\r
  72                         \r
  73                 }\r
  74                 \r
  75                 [Test]\r
  76                 public void SequencialTransaction()\r
  77                 {\r
  78                         _conn.Open();\r
  79                         \r
  80                         NpgsqlTransaction t = _conn.BeginTransaction();\r
  81                         \r
  82                         t.Rollback();\r
  83                         \r
  84                         t = _conn.BeginTransaction();\r
  85                         \r
  86                         t.Rollback();\r
  87                         \r
  88                         \r
  89                 }\r
  90                 \r
  91         }\r
  92 }\r