From: Date: August 29 2008 7:10pm
Subject: Connector/NET commit: r1396 - in branches/5.2: . MySql.Web/Providers/Source MySql.Web/Tests
List-Archive: http://lists.mysql.com/commits/52927
X-Bug: 39072
Message-Id: <200808291710.m7THAgwI020463@bk-internal.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Modified:
   branches/5.2/CHANGES
   branches/5.2/MySql.Web/Providers/Source/SchemaManager.cs
   branches/5.2/MySql.Web/Tests/SchemaTests.cs
Log:
- fixed web providers autogenerateschema option where it would fail if no schema is
  present at all (bug #39072)

Modified: branches/5.2/CHANGES
===================================================================
--- branches/5.2/CHANGES	2008-08-29 17:06:52 UTC (rev 1395)
+++ branches/5.2/CHANGES	2008-08-29 17:10:42 UTC (rev 1396)
@@ -1,3 +1,8 @@
+Version 5.2.4 - 
+- fixed web providers autogenerateschema option where it would fail if no schema is
+  present at all (bug #39072)
+  
+  
 Version 5.2.3 - 8/14/08
 - Increased the speed of MySqlDataReader.GetOrdinal dramatically by using a couple
   of hashes for lookups

Modified: branches/5.2/MySql.Web/Providers/Source/SchemaManager.cs
===================================================================
--- branches/5.2/MySql.Web/Providers/Source/SchemaManager.cs	2008-08-29 17:06:52 UTC (rev 1395)
+++ branches/5.2/MySql.Web/Providers/Source/SchemaManager.cs	2008-08-29 17:10:42 UTC (rev 1396)
@@ -114,7 +114,7 @@
                     if (dt.Rows.Count == 1)
                         return Convert.ToInt32(dt.Rows[0]["TABLE_COMMENT"]);
                 }
-                throw new ProviderException(Resources.MissingOrWrongSchema);
+                return 0;
             }
         }
 

Modified: branches/5.2/MySql.Web/Tests/SchemaTests.cs
===================================================================
--- branches/5.2/MySql.Web/Tests/SchemaTests.cs	2008-08-29 17:06:52 UTC (rev 1395)
+++ branches/5.2/MySql.Web/Tests/SchemaTests.cs	2008-08-29 17:10:42 UTC (rev 1396)
@@ -31,6 +31,7 @@
 using System;
 using System.IO;
 using System.Configuration.Provider;
+using System.Web.Security;
 
 namespace MySql.Web.Tests
 {
@@ -316,5 +317,25 @@
             Assert.AreEqual(4, dt.Rows[3]["userid"]);
             Assert.AreEqual(4, dt.Rows[3]["roleid"]);
         }
+
+        /// <summary>
+        /// Bug #39072 Web provider does not work
+        /// </summary>
+        [Test]
+        public void AutoGenerateSchema()
+        {
+            MySQLMembershipProvider provider = new MySQLMembershipProvider();
+            NameValueCollection config = new NameValueCollection();
+            config.Add("connectionStringName", "LocalMySqlServer");
+            config.Add("autogenerateschema", "true");
+            config.Add("applicationName", "/");
+            config.Add("passwordFormat", "Clear");
+
+            provider.Initialize(null, config);
+
+            MembershipCreateStatus status;
+            MembershipUser user = provider.CreateUser("boo", "password", "email@stripped",
+                "question", "answer", true, null, out status);
+        }
     }
 }