public override UserSchemaCollection GetUsers()
{
UserSchemaCollection users = new UserSchemaCollection();
using (IPooledDbConnection conn = connectionPool.Request()) {
using (IDbCommand command = conn.CreateCommand(@"SELECT DISTINCT user
from mysql.user where user != '';" )) {
try {
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);
} finally {
conn.Release();
}
}
}
return(users);
}
public void Initialize(NpgsqlSchemaProvider provider)
{
UserSchemaCollection users = provider.GetUsers();
DatabaseSchemaCollection databases = provider.GetDatabases();
NpgsqlEncodingCollection encodings = provider.GetEncodings();
NpgsqlTablespaceCollection tablespaces = provider.GetTablespaces();
foreach (UserSchema user in users)
{
ownersStore.AppendValues(user.Name, user);
}
foreach (DatabaseSchema db in databases)
{
templatesStore.AppendValues(db.Name, db);
}
foreach (NpgsqlEncoding enc in encodings)
{
StringBuilder encName = new StringBuilder(enc.Name);
encName.AppendFormat(" - {0} - {1}", enc.Description, enc.Language);
if (enc.Aliases != string.Empty)
{
encName.AppendFormat(" ({0})", enc.Aliases);
}
encodingsStore.AppendValues(encName.ToString(), enc);
}
foreach (NpgsqlTablespace ts in tablespaces)
{
tablespacesStore.AppendValues(ts.Name, ts);
}
}
private void BuildChildNodesThreaded(object state)
{
BaseNode node = state as BaseNode;
ITreeBuilder builder = Context.GetTreeBuilder(state);
UserSchemaCollection users = node.ConnectionContext.SchemaProvider.GetUsers();
DispatchService.GuiDispatch(delegate {
foreach (UserSchema user in users)
{
builder.AddChild(new UserNode(node.ConnectionContext, user));
}
builder.Expanded = true;
});
}
public override UserSchemaCollection GetUsers()
{
Console.WriteLine("start GetUsers");
UserSchemaCollection users = new UserSchemaCollection ();
/*
using (IPooledDbConnection conn = connectionPool.Request ()) {
Console.WriteLine("conn:"+conn.ToString());
MongoDbConnection connection = (MongoDbConnection) conn.DbConnection;
MongoCredentials cr = connection.getDataBaseCredentials();
Console.WriteLine("trace cr:" + cr.ToString());
if(cr != null) {
UserSchema user = new UserSchema (this);
user.Name = cr.Username;
users.Add (user);
}
}
*/
return users;
}
public override UserSchemaCollection GetUsers ()
{
UserSchemaCollection users = new UserSchemaCollection ();
using (IPooledDbConnection conn = connectionPool.Request ()) {
using (IDbCommand command = conn.CreateCommand (@"SELECT DISTINCT user
from mysql.user where user != '';")) {
try {
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);
} finally {
conn.Release ();
}
}
}
return users;
}
public override UserSchemaCollection GetUsers ()
{
UserSchemaCollection users = new UserSchemaCollection ();
using (IPooledDbConnection conn = connectionPool.Request ()) {
using (IDbCommand command = conn.CreateCommand ("SELECT * FROM pg_user;")) {
try {
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.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);
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);
} finally {
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;
}