private static string WhereSql(Model.StatMetaData.Query query)
{
SQLBuilder builder = new SQLBuilder();
builder.AppendWhere();
builder.Append(query.StatTimeStart != null, "and", "stat_time>@StatTimeStart");
builder.Append(query.StatTimeEnd != null, "and", "stat_time<=@StatTimeEnd");
builder.Append(!string.IsNullOrWhiteSpace(query.ServiceName), "and", "servcie_name=@ServiceName");
builder.Append(!string.IsNullOrWhiteSpace(query.ApiPath), "and", "api_path=@ApiPath");
return(builder.Sql());
}
public static Tuple <string, dynamic> SelectMetaDataCount(Model.StatMetaData.Query query)
{
string sql = string.Format("SELECT COUNT(*) FROM monitor_metadata {0}", WhereSql(query));
return(new Tuple <string, dynamic>(sql, new
{
StatTimeStart = query.StatTimeStart,
StatTimeEnd = query.StatTimeEnd,
ServiceName = query.ServiceName,
ApiPath = query.ApiPath
}));
}
public static string SelectByQuery(Model.StatMetaData.Query query)
{
return(string.Join(" ", BaseSelectSql(), WhereSql(query), "ORDER BY stat_time DESC", "LIMIT @Limit OFFSET @Offset;"));
}
public static string SelectByQuery(Model.StatMetaData.Query query)
{
return(string.Join(" ", BaseSelectSql(), WhereSql(query)));
}
