* Makefile: Test suite started.

	* Mono.Data.SqliteClient_test.dll.sources: Added. Test files.
	* Test/test.sql: script to create a test db.
	* Test/SqliteConnectionTest.cs: Added. Tests for SqliteConnection
	  class.


svn path=/trunk/mcs/; revision=44806

6 files changed, 116 insertions, 1 deletions

diff --git a/mcs/class/Mono.Data.SqliteClient/ChangeLog b/mcs/class/Mono.Data.SqliteClient/ChangeLog
index 3a11c6c8761..0ce6ffa2008 100644
--- a/mcs/class/Mono.Data.SqliteClient/ChangeLog
+++ b/mcs/class/Mono.Data.SqliteClient/ChangeLog
@@ -1,3 +1,8 @@
+2005-05-20  Sureshkumar T  <tsureshkumar@novell.com>
+
+	* Makefile: Test suite started.
+	* Mono.Data.SqliteClient_test.dll.sources: Added. Test files.
+
 2004-11-17  Geoff Norton  <gnorton@customerdna.com>
 
 	* Mono.Data.SqliteClient/Sqlite.cs:
diff --git a/mcs/class/Mono.Data.SqliteClient/Makefile b/mcs/class/Mono.Data.SqliteClient/Makefile
index 25440dc0f2c..9f23ba5a839 100644
--- a/mcs/class/Mono.Data.SqliteClient/Makefile
+++ b/mcs/class/Mono.Data.SqliteClient/Makefile
@@ -4,7 +4,8 @@ include ../../build/rules.make
 
 LIBRARY = Mono.Data.SqliteClient.dll
 LIB_MCS_FLAGS = /unsafe /r:System.dll /r:System.Data.dll
-NO_TEST = yes
+
+TEST_MCS_FLAGS = $(LIB_MCS_FLAGS) /nowarn:618
 
 EXTRA_DISTFILES = Test/SqliteTest.cs
 
diff --git a/mcs/class/Mono.Data.SqliteClient/Mono.Data.SqliteClient_test.dll.sources b/mcs/class/Mono.Data.SqliteClient/Mono.Data.SqliteClient_test.dll.sources
new file mode 100644
index 00000000000..aeb7547bc51
--- /dev/null
+++ b/mcs/class/Mono.Data.SqliteClient/Mono.Data.SqliteClient_test.dll.sources
@@ -0,0 +1 @@
+SqliteConnectionTest.cs
diff --git a/mcs/class/Mono.Data.SqliteClient/Test/ChangeLog b/mcs/class/Mono.Data.SqliteClient/Test/ChangeLog
new file mode 100644
index 00000000000..3471a3f0678
--- /dev/null
+++ b/mcs/class/Mono.Data.SqliteClient/Test/ChangeLog
@@ -0,0 +1,7 @@
+2005-05-20  Sureshkumar T  <tsureshkumar@novell.com>
+
+	* test.sql: script to create a test db.
+
+	* SqliteConnectionTest.cs: Added. Tests for SqliteConnection
+	class.
+
diff --git a/mcs/class/Mono.Data.SqliteClient/Test/SqliteConnectionTest.cs b/mcs/class/Mono.Data.SqliteClient/Test/SqliteConnectionTest.cs
new file mode 100644
index 00000000000..9596520ed16
--- /dev/null
+++ b/mcs/class/Mono.Data.SqliteClient/Test/SqliteConnectionTest.cs
@@ -0,0 +1,91 @@
+// SqliteConnectionTest.cs - NUnit Test Cases for SqliteConnection
+//
+// Authors:
+//   Sureshkumar T <tsureshkumar@novell.com>
+// 
+
+//
+// Copyright (C) 2004 Novell, Inc (http://www.novell.com)
+//
+// Permission is hereby granted, free of charge, to any person obtaining
+// a copy of this software and associated documentation files (the
+// "Software"), to deal in the Software without restriction, including
+// without limitation the rights to use, copy, modify, merge, publish,
+// distribute, sublicense, and/or sell copies of the Software, and to
+// permit persons to whom the Software is furnished to do so, subject to
+// the following conditions:
+// 
+// The above copyright notice and this permission notice shall be
+// included in all copies or substantial portions of the Software.
+// 
+// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
+// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
+// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
+// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
+// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
+// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
+// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
+//
+
+
+using System;
+using System.Data;
+using Mono.Data.SqliteClient;
+
+using NUnit.Framework;
+
+namespace MonoTests.Mono.Data.SqliteClient
+{
+        [TestFixture]
+        public class SqliteConnectionTest
+        {
+                readonly static string _uri = "test.db";
+                readonly static string _connectionString = "URI=file://" + _uri + ", version=3";
+                SqliteConnection _conn = new SqliteConnection ();
+
+                
+                [Test]
+                [ExpectedException (typeof (InvalidOperationException))]
+                public void ConnectionStringTest_Empty ()
+                {
+                        _conn.ConnectionString = "";
+                }
+
+                [Test]
+                [ExpectedException (typeof (InvalidOperationException))]
+                public void ConnectionStringTest_NoURI ()
+                {
+                        _conn.ConnectionString = "version=3";
+                }
+
+                [Test]
+                public void ConnectionStringTest_IgnoreSpacesAndTrim ()
+                {
+                        _conn.ConnectionString = "URI=file://xyz      , ,,, ,, version=3";
+                        Assert.AreEqual ("xyz", _conn.Database, "#1 file path is wrong");
+                }
+
+                [Test]
+                public void OpenTest ()
+                {
+                        try {
+                                _conn.ConnectionString = _connectionString;
+                                _conn.Open ();
+                                Assert.AreEqual (ConnectionState.Open, _conn.State, "#1 not opened");
+                                _conn.Close ();
+
+                                // negative test: try opening a non-existent file
+                                _conn.ConnectionString = "URI=file://abcdefgh.db, version=3";
+                                try {
+                                        _conn.Open ();
+                                        Assert.Fail ("#1 should have failed on opening a non-existent db");
+                                } catch (ArgumentException e) {Console.WriteLine (e);}
+                                
+                        } finally {
+                                if (_conn != null && _conn.State != ConnectionState.Closed)
+                                        _conn.Close ();
+                        }
+                }
+
+        }
+}
diff --git a/mcs/class/Mono.Data.SqliteClient/Test/test.sql b/mcs/class/Mono.Data.SqliteClient/Test/test.sql
new file mode 100644
index 00000000000..0619acfa3a2
--- /dev/null
+++ b/mcs/class/Mono.Data.SqliteClient/Test/test.sql
@@ -0,0 +1,10 @@
+create table test (
+  id int NOT NULL PRIMARY KEY,
+  name varchar (20)
+);
+
+insert into test values (1, "mono test 1");
+insert into test values (2, "mono test 2");
+insert into test values (3, "mono test 3");
+
+select * from test;