public void Exec1()
{
Stopwatch stopwatch = Stopwatch.StartNew(); //creates and start the instance of Stopwatch
WaitScreen.Splash();
string command = CHBox.Text;
using (ClickHouseCommand comm = con.CreateCommand(command))
{
try
{
using (var reader = comm.ExecuteReader())
{
List <object> result = new List <object>();
do
{
while (reader.Read())
{
for (var i = 0; i < reader.FieldCount; i++)
{
var val = reader.GetValue(i);
result.Add(val);
Resp.AppendText(result[i].ToString() + ", ");
}
Resp.AppendText(Environment.NewLine);
result.Clear();
}
} while (reader.NextResult());
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
Response.Content = "Wrong command.";
return;
}
stopwatch.Stop();
var elapsedBulkMs = stopwatch.ElapsedMilliseconds;
Logs xd = new DBUplader.Logs();
xd.AddLog("--------------------------------------------");
xd.AddLog("Execute ClickHouse Command");
xd.AddLog(command);
xd.AddLog("Execute time : " + elapsedBulkMs + "ms");
Response.Content = "OK. " + elapsedBulkMs + "ms";
}
using (ClickHouseCommand comm = con.CreateCommand(command))
{
}
}
private void Exec(string table, string filter)
{
Stopwatch stopwatch = Stopwatch.StartNew(); //creates and start the instance of Stopwatch
WaitScreen.Splash();
string command = MDBBox.Text;
var server = new MongoClient("mongodb://localhost:27017");
var database = server.GetDatabase("test");
var coll = database.GetCollection <BsonDocument>(table);
//var list = coll.Find(command);
//var list = coll.Find(new BsonDocument()).Limit(5).ToList();
//filter = "{ price: '480'}";
//var list = coll.Find("{},{\"name\":1}).limit(100)").ToList();
try
{
int lim = int.Parse(Limit.Text);
string typ = Type.Text;
List <BsonDocument> list = new List <BsonDocument>();
if (lim > 0 && typ == "Find")
{
list = coll.Find(filter).Limit(lim).ToList();
}
else if (lim <= 0 && typ == "Find")
{
list = coll.Find(filter).ToList();
}
else if (lim > 0 && typ == "Group")
{
list = coll.Aggregate().Group(filter).Limit(lim).ToList();
}
else if (lim <= 0 && typ == "Group")
{
list = coll.Aggregate().Group(filter).ToList();
}
for (int i = 0; i < list.Count; i++)
{
Resp.AppendText(list[i].ToString() + (Environment.NewLine));
}
stopwatch.Stop();
var elapsedBulkMs = stopwatch.ElapsedMilliseconds;
Logs xd = new DBUplader.Logs();
xd.AddLog("--------------------------------------------");
xd.AddLog("Execute MongoDB Command");
xd.AddLog(command);
xd.AddLog($"On table { table }");
xd.AddLog($"Execute time : { elapsedBulkMs } ms");
Response.Content = $"OK. { elapsedBulkMs } ms";
}
catch
{
Response.Content = "Wrong command.";
}
//var comm = new JsonCommand<BsonDocument>(command);
//database.RunCommand(comm);
//db.getCollection('asd').find({ })
}
