public ServerConnection(string url)
{
using(Log.Scope("ServerConnection constructor"))
{
Log.Debug("connecting to {0}", url);
try
{
if(_instance != null)
{
_instance.Dispose();
_instance = null;
}
}
catch { }
if(url == null)
throw new ArgumentNullException("url");
_url = url;
this.Server = new LPSClientShared.LPSServer.Server(url);
this.Server.CookieContainer = CookieContainer;
this.cached_datasets = new Dictionary<string, DataSet>();
_instance = this;
resource_manager = new ResourceManager(this);
configuration_store = new ConfigurationStore();
}
}
public override object Execute(IExecutionContext context, TextWriter Out, TextWriter Info, TextWriter Err, object[] Params)
{
string url = Get<string>(Params, 0);
ServerConnection conn = new ServerConnection(url);
Info.WriteLine("Připojeno k {0}", url);
conn.Login(Get<string>(Params, 1), Get<string>(Params, 2));
Info.WriteLine("Uživatel {0} přihlášen", Get<string>(Params, 1));
return conn;
}
public string[] GetSqlTableNames(ServerConnection conn)
{
List<string> tables = new List<string>();
using(DataSet ds = conn.GetDataSetBySql(@"
select distinct table_name from information_schema.columns where table_schema = 'public'"))
{
foreach(DataRow r in ds.Tables[0].Rows)
tables.Add((string)r[0]);
}
tables.Sort();
return tables.ToArray();
}
public ServerConnection TryConnect()
{
try
{
ServerConnection srv = new ServerConnection(edtServer.Text);
if(!srv.Ping())
return null;
return srv;
}
catch(Exception)
{
return null;
}
}
