mcs/class/ByteFX.Data/Common/DBConnectionString.cs

   1 // ByteFX.Data data access components for .Net
   2 // Copyright (C) 2002-2003  ByteFX, Inc.
   3 //
   4 // This library is free software; you can redistribute it and/or
   5 // modify it under the terms of the GNU Lesser General Public
   6 // License as published by the Free Software Foundation; either
   7 // version 2.1 of the License, or (at your option) any later version.
   8 //
   9 // This library is distributed in the hope that it will be useful,
  10 // but WITHOUT ANY WARRANTY; without even the implied warranty of
  11 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  12 // Lesser General Public License for more details.
  13 //
  14 // You should have received a copy of the GNU Lesser General Public
  15 // License along with this library; if not, write to the Free Software
  16 // Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  17
  18 using System;
  19 using System.Collections;
  20 using System.Text;
  21
  22 namespace ByteFX.Data.Common
  23 {
  24         /// <summary>
  25         /// Summary description for Utility.
  26         /// </summary>
  27         internal class DBConnectionString
  28         {
  29                 protected Hashtable     keyValues = new Hashtable();
  30                 protected string        connectString;
  31                 protected string        host;
  32                 protected string        username;
  33                 protected string        password;
  34                 protected string        database;
  35                 protected int           connectTimeout;
  36                 protected int           port;
  37                 protected int           maxPoolSize;
  38                 protected int           minPoolSize;
  39                 protected int           connectLifetime;
  40                 protected bool          pooling;
  41                 protected bool          persistSecurityInfo;
  42
  43                 public DBConnectionString()
  44                 {
  45                         persistSecurityInfo = false;
  46                 }
  47
  48                 public DBConnectionString(string connectString) : this()
  49                 {
  50                         this.connectString = connectString;
  51                 }
  52
  53                 #region Properties
  54                 public string Host
  55                 {
  56                         get { return host; }
  57                 }
  58
  59                 public string Username
  60                 {
  61                         get { return username; }
  62                 }
  63
  64                 public string Password
  65                 {
  66                         get { return password; }
  67                 }
  68
  69                 public int ConnectTimeout
  70                 {
  71                         get { return connectTimeout; }
  72                 }
  73
  74                 public string Database
  75                 {
  76                         get { return database; }
  77                 }
  78
  79                 public int Port
  80                 {
  81                         get { return port; }
  82                 }
  83
  84                 public int MaxPoolSize
  85                 {
  86                         get { return maxPoolSize; }
  87                 }
  88
  89                 public int MinPoolSize
  90                 {
  91                         get { return minPoolSize; }
  92                 }
  93
  94                 public bool Pooling
  95                 {
  96                         get { return pooling; }
  97                 }
  98
  99                 public int ConnectionLifetime
 100                 {
 101                         get { return connectLifetime; }
 102                 }
 103
 104                 public string ConnectString
 105                 {
 106                         get { return GetConnectionString(); }
 107                         set { connectString = value; Parse(); }
 108                 }
 109
 110                 #endregion
 111
 112                 private string GetConnectionString()
 113                 {
 114                         StringBuilder str = new StringBuilder();
 115
 116                         foreach ( string key in keyValues.Keys)
 117                         {
 118                                 if ((key.ToLower() == "pwd" || key.ToLower() == "password") &&
 119                                         !persistSecurityInfo) continue;
 120                                 str.AppendFormat("{0}={1};", key, keyValues[key]);
 121                         }
 122
 123                         if (str.Length > 0)
 124                                 str.Remove( str.Length-1, 1 );
 125
 126                         return str.ToString();
 127                 }
 128
 129                 protected virtual void ConnectionParameterParsed(string key, string value)
 130                 {
 131                         switch (key.ToLower())
 132                         {
 133                                 case "persist security info":
 134                                         if (value.ToLower() == "no" || value.ToLower() == "false")
 135                                                 persistSecurityInfo = false;
 136                                         else
 137                                                 persistSecurityInfo = true;
 138                                         break;
 139
 140                                 case "uid":
 141                                 case "username":
 142                                 case "user id":
 143                                 case "user name":
 144                                 case "userid":
 145                                         username = value;
 146                                         break;
 147
 148                                 case "password":
 149                                 case "pwd":
 150                                         password = value;
 151                                         break;
 152
 153                                 case "host":
 154                                 case "server":
 155                                 case "data source":
 156                                 case "datasource":
 157                                 case "address":
 158                                 case "addr":
 159                                 case "network address":
 160                                         host = value;
 161                                         break;
 162
 163                                 case "initial catalog":
 164                                 case "database":
 165                                         database = value;
 166                                         break;
 167
 168                                 case "connection timeout":
 169                                 case "connect timeout":
 170                                         connectTimeout = Int32.Parse( value );
 171                                         break;
 172
 173                                 case "port":
 174                                         port = Int32.Parse( value );
 175                                         break;
 176
 177                                 case "pooling":
 178                                         if (value.ToLower() == "no" || value.ToLower() == "false")
 179                                                 pooling = false;
 180                                         else
 181                                                 pooling = true;
 182                                         break;
 183
 184                                 case "min pool size":
 185                                         minPoolSize = Int32.Parse(value);
 186                                         break;
 187
 188                                 case "max pool size":
 189                                         maxPoolSize = Int32.Parse(value);
 190                                         break;
 191
 192                                 case "connection lifetime":
 193                                         connectLifetime = Int32.Parse(value);
 194                                         break;
 195                         }
 196                 }
 197
 198                 protected void Parse()
 199                 {
 200                         String[] keyvalues = connectString.Split( ';' );
 201                         String[] newkeyvalues = new String[keyvalues.Length];
 202                         int              x = 0;
 203
 204                         // first run through the array and check for any keys that
 205                         // have ; in their value
 206                         foreach (String keyvalue in keyvalues)
 207                         {
 208                                 // check for trailing ; at the end of the connection string
 209                                 if (keyvalue.Length == 0) continue;
 210
 211                                 // this value has an '=' sign so we are ok
 212                                 if (keyvalue.IndexOf('=') >= 0)
 213                                 {
 214                                         newkeyvalues[x++] = keyvalue;
 215                                 }
 216                                 else
 217                                 {
 218                                         newkeyvalues[x-1] += ";";
 219                                         newkeyvalues[x-1] += keyvalue;
 220                                 }
 221                         }
 222
 223                         keyValues.Clear();
 224
 225                         // now we run through our normalized key-values, splitting on equals
 226                         for (int y=0; y < x; y++)
 227                         {
 228                                 String[] parts = newkeyvalues[y].Split( '=' );
 229
 230                                 // first trim off any space and lowercase the key
 231                                 parts[0] = parts[0].Trim().ToLower();
 232                                 parts[1] = parts[1].Trim();
 233
 234                                 // we also want to clear off any quotes
 235                                 parts[0] = parts[0].Trim('\'', '"');
 236                                 parts[1] = parts[1].Trim('\'', '"');
 237
 238                                 ConnectionParameterParsed( parts[0], parts[1] );
 239                                 keyValues.Add( parts[0], parts[1] );
 240                         }
 241                 }
 242
 243
 244         }
 245 }