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);
}
public UserSchemaCollection(UserSchemaCollection collection)
: base(collection, true)
{
}
