public static void OnRequestLoad(ServerSocketBase server, string key, string socket_uid, string rawDataInput)
{
DirectSocketResponse response = new DirectSocketResponse();
try
{
DirectSocketInputModel input = JsonConvert.DeserializeObject <DirectSocketInputModel>(rawDataInput);
response.Ticket = input.ticket;
string query = "";
if (!string.IsNullOrEmpty(input.query))
{
query = input.query.Trim();
}
else
{
query = string.Format($"SELECT {input.SelectQuery}{input.FromQuery}{input.WhereQuery}{input.OrderByQuery}{input.LimitQuery}");
}
CCSubmitDirect db = CCSubmitDirect.Instance;
if (input.query.ToLower().StartsWith("insert"))
{
response.Data = db.Execute(query);
}
else if (input.query.ToLower().StartsWith("update"))
{
response.Data = db.Execute(query);
}
else
{
response.Data = db.Load(query).RawData;
}
}
catch (Exception e)
{
response.Success = false;
response.Message = e.ToString();
}
finally
{
server.SendAsync(socket_uid, JsonConvert.SerializeObject(response));
}
}