public override UserSchemaCollection GetUsers() { UserSchemaCollection users = new UserSchemaCollection(); IPooledDbConnection conn = connectionPool.Request(); IDbCommand command = conn.CreateCommand("SELECT DISTINCT user from mysql.user where user != '';"); try { using (command) { using (IDataReader r = command.ExecuteReader()) { while (r.Read()) { UserSchema user = new UserSchema(this); user.Name = r.GetString(0); users.Add(user); } r.Close(); } } } catch (Exception e) { QueryService.RaiseException(e); } conn.Release(); return(users); }
public override UserSchemaCollection GetUsers() { UserSchemaCollection users = new UserSchemaCollection(); IPooledDbConnection conn = connectionPool.Request(); IDbCommand command = conn.CreateCommand("SELECT * FROM pg_user;"); try { using (command) { using (IDataReader r = command.ExecuteReader()) { while (r.Read()) { UserSchema user = new UserSchema(this); user.Name = r.GetString(0); user.UserId = String.Format("{0}", r.GetValue(1)); user.Expires = r.IsDBNull(6) ? DateTime.MinValue : r.GetDateTime(6); //user.Options["createdb"] = r.GetBoolean (2); //user.Options["createuser"] = r.GetBoolean (3); user.Password = r.GetString(5); StringBuilder sb = new StringBuilder(); sb.AppendFormat("-- User: \"{0}\"\n\n", user.Name); sb.AppendFormat("-- DROP USER {0};\n\n", user.Name); sb.AppendFormat("CREATE USER {0}", user.Name); sb.AppendFormat(" WITH SYSID {0}", user.UserId); if (user.Password != "********") { sb.AppendFormat(" ENCRYPTED PASSWORD {0}", user.Password); } //sb.AppendFormat (((bool) user.Options["createdb"]) ? // " CREATEDB" : " NOCREATEDB"); //sb.AppendFormat (((bool) user.Options["createuser"]) ? // " CREATEUSER" : " NOCREATEUSER"); if (user.Expires != DateTime.MinValue) { sb.AppendFormat(" VALID UNTIL {0}", user.Expires); } sb.Append(";"); user.Definition = sb.ToString(); users.Add(user); } r.Close(); } } } catch (Exception e) { QueryService.RaiseException(e); } conn.Release(); return(users); }
public virtual UserSchemaCollection GetUsers() { UserSchemaCollection collection = new UserSchemaCollection(); IPooledDbConnection conn = connectionPool.Request(); try { //restrictions: name DataTable dt = conn.GetSchema(usersCollectionString); for (int r = 0; r < dt.Rows.Count; r++) { DataRow row = dt.Rows[r]; collection.Add(GetUser(row)); } } catch (Exception e) { QueryService.RaiseException(e); } conn.Release(); return(collection); }