Thread: [Nhibernate-commit] SF.net SVN: nhibernate:[4963] trunk/nhibernate/src/NHibernate. TestDatabaseSetu

Brought to you by: ayenderahien, bahusoid, fabiomaulo, fdelaporte, and 5 others

nhibernate-commit

[Nhibernate-commit] SF.net SVN: nhibernate:[4963] trunk/nhibernate/src/NHibernate. TestDatabaseSetup/TestDatabaseSetup.cs

From: <ste...@us...> - 2010-03-17 17:16:10

Revision: 4963
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4963&view=rev
Author:   steverstrong
Date:     2010-03-17 17:16:04 +0000 (Wed, 17 Mar 2010)

Log Message:
-----------
Trying hardcoding the connection string

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs

Modified: trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2010-03-17 16:58:31 UTC (rev 4962)
+++ trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2010-03-17 17:16:04 UTC (rev 4963)
@@ -13,7 +13,7 @@
             var cfg = new Cfg.Configuration();
             var connStr = cfg.Properties["connection.connection_string"];
 
-            Console.WriteLine("Connecting to database {0}", connStr);
+            connStr = @"Server=.\SQLExpress;initial catalog=nhibernate;Integrated Security=SSPI";
 
             using (var conn = new SqlConnection(connStr))
             {


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Nhibernate-commit] SF.net SVN: nhibernate:[5296] trunk/nhibernate/src/NHibernate. TestDatabaseSetup/TestDatabaseSetup.cs

From: <pa...@us...> - 2010-12-06 16:10:20

Revision: 5296
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5296&view=rev
Author:   patearl
Date:     2010-12-06 16:10:14 +0000 (Mon, 06 Dec 2010)

Log Message:
-----------
Removed hard-coded connection string from NHibernate.TestDatabaseSetup.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs

Modified: trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2010-12-05 20:25:20 UTC (rev 5295)
+++ trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2010-12-06 16:10:14 UTC (rev 5296)
@@ -13,8 +13,6 @@
             var cfg = new Cfg.Configuration();
             var connStr = cfg.Properties["connection.connection_string"];
 
-            connStr = @"Server=.\SQLExpress;initial catalog=nhibernate;Integrated Security=SSPI";
-
             using (var conn = new SqlConnection(connStr))
             {
                 conn.Open();


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Nhibernate-commit] SF.net SVN: nhibernate:[5297] trunk/nhibernate/src/NHibernate. TestDatabaseSetup/TestDatabaseSetup.cs

From: <pa...@us...> - 2010-12-06 16:25:53

Revision: 5297
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5297&view=rev
Author:   patearl
Date:     2010-12-06 16:25:47 +0000 (Mon, 06 Dec 2010)

Log Message:
-----------
NHibernate.TestDatabaseSetup: Trying to get more debugging info as Steve did.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs

Modified: trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2010-12-06 16:10:14 UTC (rev 5296)
+++ trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2010-12-06 16:25:47 UTC (rev 5297)
@@ -12,6 +12,8 @@
         {
             var cfg = new Cfg.Configuration();
             var connStr = cfg.Properties["connection.connection_string"];
+			
+			Console.WriteLine("Connection String: " + connStr);
 
             using (var conn = new SqlConnection(connStr))
             {


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Nhibernate-commit] SF.net SVN: nhibernate:[5299] trunk/nhibernate/src/NHibernate. TestDatabaseSetup/TestDatabaseSetup.cs

From: <pa...@us...> - 2010-12-06 16:56:46

Revision: 5299
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5299&view=rev
Author:   patearl
Date:     2010-12-06 16:56:40 +0000 (Mon, 06 Dec 2010)

Log Message:
-----------
NHibernate.TestDatabaseSetup: Removed connection string debug line.  Was just using the connection string from nhibernate-properties.xml as it does when running nant test.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs

Modified: trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2010-12-06 16:51:11 UTC (rev 5298)
+++ trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2010-12-06 16:56:40 UTC (rev 5299)
@@ -13,8 +13,6 @@
             var cfg = new Cfg.Configuration();
             var connStr = cfg.Properties["connection.connection_string"];
 			
-			Console.WriteLine("Connection String: " + connStr);
-
             using (var conn = new SqlConnection(connStr))
             {
                 conn.Open();


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Nhibernate-commit] SF.net SVN: nhibernate:[5426] trunk/nhibernate/src/NHibernate. TestDatabaseSetup/TestDatabaseSetup.cs

From: <pa...@us...> - 2011-03-05 17:26:29

Revision: 5426
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5426&view=rev
Author:   patearl
Date:     2011-03-05 17:26:23 +0000 (Sat, 05 Mar 2011)

Log Message:
-----------
Tests: Made SQLite test database setup more like other database setups to see if it improves our build server situation.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs

Modified: trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2011-03-05 16:05:16 UTC (rev 5425)
+++ trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2011-03-05 17:26:23 UTC (rev 5426)
@@ -18,7 +18,7 @@
 			SetupMethods = new Dictionary<string, Action<Cfg.Configuration>>();
 			SetupMethods.Add("NHibernate.Driver.SqlClientDriver", SetupSqlServer);
 			SetupMethods.Add("NHibernate.Driver.FirebirdClientDriver", SetupFirebird);
-			SetupMethods.Add("NHibernate.Driver.SQLite20Driver", SetupNoop);
+			SetupMethods.Add("NHibernate.Driver.SQLite20Driver", SetupSQLite);
 			SetupMethods.Add("NHibernate.Driver.NpgsqlDriver", SetupNpgsql);
 		}
 
@@ -105,8 +105,10 @@
 			}
 		}
 
-		private static void SetupNoop(Cfg.Configuration cfg)
+		private static void SetupSQLite(Cfg.Configuration cfg)
 		{
+			if (File.Exists("NHibernate.db"))
+				File.Delete("NHibernate.db");
 		}
 	}
 }


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Nhibernate-commit] SF.net SVN: nhibernate:[5670] trunk/nhibernate/src/NHibernate. TestDatabaseSetup/TestDatabaseSetup.cs

From: <pa...@us...> - 2011-04-12 04:41:57

Revision: 5670
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5670&view=rev
Author:   patearl
Date:     2011-04-12 04:41:51 +0000 (Tue, 12 Apr 2011)

Log Message:
-----------
Tests: Made database drop/create work if there's no existing nhibernate database for SQL Server.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs

Modified: trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2011-04-11 18:15:31 UTC (rev 5669)
+++ trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2011-04-12 04:41:51 UTC (rev 5670)
@@ -37,15 +37,13 @@
         private static void SetupSqlServer(Cfg.Configuration cfg)
         {
             var connStr = cfg.Properties[Cfg.Environment.ConnectionString];
-			
-            using (var conn = new SqlConnection(connStr))
+
+            using (var conn = new SqlConnection(connStr.Replace("initial catalog=nhibernate", "initial catalog=master")))
             {
                 conn.Open();
 
-                using (var cmd = new System.Data.SqlClient.SqlCommand("use master", conn))
+                using (var cmd = conn.CreateCommand())
                 {
-                    cmd.ExecuteNonQuery();
-
                     cmd.CommandText = "drop database nhibernate";
 
                     try


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Nhibernate-commit] SF.net SVN: nhibernate:[5993] trunk/nhibernate/src/NHibernate. TestDatabaseSetup/TestDatabaseSetup.cs

From: <ric...@us...> - 2011-07-24 12:54:28

Revision: 5993
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5993&view=rev
Author:   ricbrown
Date:     2011-07-24 12:54:22 +0000 (Sun, 24 Jul 2011)

Log Message:
-----------
Added DB creation for Oracle.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs

Modified: trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2011-07-23 20:10:24 UTC (rev 5992)
+++ trunk/nhibernate/src/NHibernate.TestDatabaseSetup/TestDatabaseSetup.cs	2011-07-24 12:54:22 UTC (rev 5993)
@@ -3,6 +3,7 @@
 using System.Data.SqlClient;
 using System.IO;
 using FirebirdSql.Data.FirebirdClient;
+using NHibernate.Cfg;
 using Npgsql;
 using NUnit.Framework;
 
@@ -129,7 +130,33 @@
 
 		private static void SetupOracle(Cfg.Configuration cfg)
 		{
-			// not done (yet) - current setup is manual
+			var connStr =
+				cfg.Properties[Cfg.Environment.ConnectionString]
+					.Replace("User ID=nhibernate", "User ID=SYSTEM")
+					.Replace("Password=nhibernate", "Password=password");
+
+			cfg.DataBaseIntegration(db =>
+				{
+					db.ConnectionString = connStr;
+					db.Dialect<NHibernate.Dialect.Oracle10gDialect>();
+					db.KeywordsAutoImport = Hbm2DDLKeyWords.None;
+				});
+
+			using (var sf = cfg.BuildSessionFactory())
+			{
+				try
+				{
+					using(var s = sf.OpenSession())
+						s.CreateSQLQuery("drop user nhibernate cascade").ExecuteUpdate();
+				}
+				catch {}
+
+				using (var s = sf.OpenSession())
+				{
+					s.CreateSQLQuery("create user nhibernate identified by nhibernate").ExecuteUpdate();
+					s.CreateSQLQuery("grant dba to nhibernate with admin option").ExecuteUpdate();
+				}
+			}
 		}
 	}
 }


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.