public string Select(string input)
{
if (!Opened)
{
return(JsonConvert.SerializeObject(new { ok = false, total = 0, count = 0, msg = "The model " + Model + " is closed" }));
}
long _total = Count();
string msg_field_null = JsonConvert.SerializeObject(new
{
ok = false,
total = _total,
count = 0,
msg = "The data of QueryString is NULL. It has format: model=test&action=select&skip=0&limit=10&_op.1=eq&_id.1=8499849689d044a7a5b0ffe9&_andor.1=and&_op.2=eq&___dc.2=20180303"
});
if (string.IsNullOrEmpty(input))
{
return(msg_field_null);
}
//input = "model=test&action=select&skip=0&limit=10&" +
// "f.1=_id&o.1=eq&v.1=b67cb5e92b6c45e0bab345b2" +
// "&or=2.3" +
// "&f.2=___dc&o.2=eq&v.2=20180303" +
// "&f.3=___dc&o.3=eq&v.3=20180303";
var a = input.Split('&')
.Select(x => x.Split('='))
.Where(x => x.Length > 1)
.Select(x => new { key = x[0], value = x[1] })
.ToArray();
if (a.Length != a.Select(x => x.key).Distinct().ToArray().Length)
{
return(JsonConvert.SerializeObject(new { ok = false, total = _total, count = 0, msg = "The keys of QueryString duplicated" }));
}
string _or = a.Where(x => x.key == "or").Select(x => x.value).SingleOrDefault();
var ws = a
.Where(x => x.key.Contains('.') && x.key.Split('.')[1].IsNumeric())
.Select(x => new QueryItem(x.key.Split('.')[0], int.Parse(x.key.Split('.')[1]), x.value, _or))
.ToArray();
int[] aCmdOR = ws.Where(x => x.isOr).Select(x => x.cmd).Distinct().ToArray();
QueryBuilder _query = null;
List <Query> lsOr = new List <Query>()
{
};
for (int i = 0; i < aCmdOR.Length; i++)
{
var ai = ws.Where(x => x.cmd == aCmdOR[i]).ToArray();
string _field = ai.Where(x => x.field == "f").Select(x => x.value).SingleOrDefault();
string _operator = ai.Where(x => x.field == "o").Select(x => x.value).SingleOrDefault();
string _value = ai.Where(x => x.field == "v").Select(x => x.value).SingleOrDefault();
if (string.IsNullOrEmpty(_field) || string.IsNullOrEmpty(_operator))
{
return(msg_field_null);
}
_query = convertQuery(_field, _operator, _value);
if (_query.Ok && _query.Query != null)
{
lsOr.Add(_query.Query);
}
else
{
return(JsonConvert.SerializeObject(new { ok = false, total = _total, count = 0, msg = _query.Msg }));
}
}
int[] aCmdAnd = ws.Where(x => x.isOr == false).Select(x => x.cmd).Distinct().ToArray();
List <Query> lsAnd = new List <Query>()
{
};
for (int i = 0; i < aCmdAnd.Length; i++)
{
var ai = ws.Where(x => x.cmd == aCmdAnd[i]).ToArray();
string _field = ai.Where(x => x.field == "f").Select(x => x.value).SingleOrDefault();
string _operator = ai.Where(x => x.field == "o").Select(x => x.value).SingleOrDefault();
string _value = ai.Where(x => x.field == "v").Select(x => x.value).SingleOrDefault();
if (string.IsNullOrEmpty(_field) || string.IsNullOrEmpty(_operator))
{
return(msg_field_null);
}
_query = convertQuery(_field, _operator, _value);
if (_query.Ok && _query.Query != null)
{
lsAnd.Add(_query.Query);
}
else
{
return(JsonConvert.SerializeObject(new { ok = false, total = _total, count = 0, msg = _query.Msg }));
}
}
Dictionary <string, BsonDocument> dicStore = new Dictionary <string, BsonDocument>()
{
};
IEnumerable <KeyValuePair <string, BsonDocument> > rsFind;
switch (lsOr.Count)
{
case 0:
break;
case 1:
rsFind = _engine.FindCacheIDs(_LITEDB_CONST.COLLECTION_NAME, lsOr[0]).ToArray();
foreach (var kv in rsFind)
{
if (!dicStore.ContainsKey(kv.Key))
{
dicStore.Add(kv.Key, kv.Value);
}
}
break;
default:
rsFind = _engine.FindCacheIDs(_LITEDB_CONST.COLLECTION_NAME, Query.Or(lsOr.ToArray())).ToArray();
foreach (var kv in rsFind)
{
if (!dicStore.ContainsKey(kv.Key))
{
dicStore.Add(kv.Key, kv.Value);
}
}
break;
}
switch (lsAnd.Count)
{
case 0:
break;
case 1:
rsFind = _engine.FindCacheIDs(_LITEDB_CONST.COLLECTION_NAME, lsAnd[0]).ToArray();
foreach (var kv in rsFind)
{
if (!dicStore.ContainsKey(kv.Key))
{
dicStore.Add(kv.Key, kv.Value);
}
}
break;
default:
rsFind = _engine.FindCacheIDs(_LITEDB_CONST.COLLECTION_NAME, Query.And(lsAnd.ToArray())).ToArray();
foreach (var kv in rsFind)
{
if (!dicStore.ContainsKey(kv.Key))
{
dicStore.Add(kv.Key, kv.Value);
}
}
break;
}
var jobject = a.Where(x => !x.key.Contains("."))
.GroupBy(x => x.key).Select(x => x.First())
.ToDictionary(x => x.key, x => x.value);
string skip, limit;
jobject.TryGetValue("skip", out skip);
jobject.TryGetValue("limit", out limit);
long _skip = 0;
long _limit = 0;
long.TryParse(skip, out _skip);
long.TryParse(limit, out _limit);
if (_skip < 0)
{
_skip = _LITEDB_CONST._SKIP;
}
if (_limit <= 0)
{
_limit = _LITEDB_CONST._LIMIT;
}
string[] allID = dicStore.Keys.ToArray();
string[] idRs = allID.Skip(_skip).Take(_limit).ToArray();
List <string> result = new List <string>();
foreach (string id in idRs)
{
result.Add(dicStore[id].toJson);
}
//var result = _engine
// //.Find(_LITEDB_CONST.COLLECTION_NAME, Query.In(_LITEDB_CONST.FIELD_ID, idRs))
// .Find(_LITEDB_CONST.COLLECTION_NAME, Query.Where(_LITEDB_CONST.FIELD_ID, _id => listID.IndexOf(_id) != -1))
// .Select(x => x.toJson).ToArray();
return(@"{""ok"":true,""total"":" + _total.ToString() + @",""count"":" + result.Count.ToString() + @",""items"":[" + string.Join(",", result.ToArray()) + @"]}");
}
