private void ListIgnoreStats()
{
var data = new ResultRows();
using (var query = new MySqlCommand("SELECT user_id FROM user_ignore_stats", DbConnection.GetConnection()))
{
using (var reader = query.ExecuteReader())
data = reader.ReadAll();
}
var lines = data.Select(_ =>
{
var userId = _[0] as string;
var userInfo = _resolveHelper.GetUserById(userId);
return(userInfo != null ? userInfo.ToString() : $"'{userId}': <unknown>");
});
if (!lines.Any())
{
SendMessage("No user stats ignored");
return;
}
SendMessage(string.Join(", ", lines));
}
public static ResultRows ReadAll(this MySqlDataReader reader)
{
var res = new ResultRows();
while (reader.Read())
{
var values = new object[reader.FieldCount];
reader.GetValues(values);
res.Add(values);
}
return(res);
}
protected override bool Execute(CodeActivityContext context)
{
DataTable TempTable = null;
try
{
var serverData = ARM_Service.REP_Query_Report(Sql.Get(context), new List <QueryParameter>());
if (!string.IsNullOrEmpty(serverData.Value))
{
Error.Set(context, serverData.Value);
}
else
{
TempTable = serverData.Key;
}
}
catch (Exception ex)
{
Error.Set(context, ex.Message);
if (!HideException.Get(context))
{
throw ex;
}
}
List <DataRow> L = new List <DataRow>();
if (TempTable != null)
{
foreach (DataRow row in TempTable.Rows)
{
L.Add(row);
}
}
ResultRows.Set(context, L);
return(string.IsNullOrEmpty(Error.Get(context)));
}
static ApiPool()
{
ResultRows rows = null;
using (var command = new MySqlCommand("SELECT client_id, access_token FROM api_pool",
DbConnection.GetConnection()))
{
using (var reader = command.ExecuteReader())
rows = reader.ReadAll();
}
foreach (var row in rows)
{
_apiPool.Add(new TwitchAPI()
{
Settings = { ClientId = row[0] as string, AccessToken = row[1] as string }
});
}
ApiEnumerator = ApiEnumerable.GetEnumerator();
}
