public TwitterController(Helpers helpers, IOptions <AirtableConfiguration> airtableConfig, IOptions <TwitterConfiguration> twitterConfig, MongoDbServicer mongoDbServicer)
{
_helpers = helpers;
_airtableConfig = airtableConfig.Value;
_twitterConfig = twitterConfig.Value;
_mongoDbServicer = mongoDbServicer;
}
public AirtableConfiguration GetConfigurationInformationForTable(AirtableConfiguration configuration)
{
_airtableConfig.AuthenticationString = configuration.AuthenticationString;
_airtableConfig.Base = configuration.Base;
_airtableConfig.Link = configuration.Link;
_airtableConfig.PostmanToken = configuration.PostmanToken;
_airtableConfig.TableName = configuration.TableName;
return(_airtableConfig);
}
// private string spRankings = "SpRankings";
public AirtableManager(Helpers helpers, IOptions <AirtableConfiguration> airtableConfig, IOptionsSnapshot <AirtableConfiguration> options)
{
_helpers = helpers;
_airtableConfig = airtableConfig.Value;
_spRankingsConfiguration = options.Get("SpRankings");
_authorsConfiguration = options.Get("Authors");
_websitesConfiguration = options.Get("Websites");
_baseballScraperConfiguration = options.Get("BaseballScraperConfig");
}
public async Task RetrievePitcherRankingInfoFromDatabaseAsync()
{
_helpers.StartMethod();
AirtableConfiguration spRankingTableConfig = _atM.GetSpRankingsTableConfiguration();
string airTableKey = spRankingTableConfig.ApiKey = _airtableConfig.ApiKey;
string authenticationString = spRankingTableConfig.AuthenticationString;
List <AirtableRecord> listOfSpRankings =
await _atM.GetAllRecordsFromAirtableAsync
(
_spRankingsConfiguration.TableName,
_spRankingsConfiguration.AuthenticationString
);
List <AirtableRecord> listOfAuthors =
await _atM.GetAllRecordsFromAirtableAsync
(
_authorsConfiguration.TableName,
_authorsConfiguration.AuthenticationString
);
foreach (AirtableRecord ranking in listOfSpRankings)
{
object authorField = ranking.GetField("Author");
JArray fieldJArray = authorField as JArray;
string authorId = fieldJArray[0].ToString();
C.WriteLine($"authorId: {authorId}");
}
foreach (var author in listOfAuthors)
{
C.WriteLine($"author.Id: {author.Id}");
IEnumerable <AirtableRecord> rankingQuery =
from ranking in listOfSpRankings
where string.Equals(
((JArray)ranking
.GetField("Author"))
.Select(item => (string)item[0])
.ToString(),
author.Id,
StringComparison.Ordinal
)
select ranking;
_helpers.Dig(rankingQuery);
}
}
public HomeController(Helpers helpers, RdotNetConnector r, IOptions <AirtableConfiguration> airtableConfig, IOptions <TwitterConfiguration> twitterConfig, GoogleSheetsConnector gSC, EmailHelper emailHelper, ExcelHandler excelHandler, PythonConnector pythonConnector, DataTabler dataTabler, CsvHandler csvHandler, CbsTransactionTrendsController cbsTrendsController)
{
_helpers = helpers;
_r = r;
_airtableConfig = airtableConfig.Value;
_twitterConfiguration = twitterConfig.Value;
_gSC = gSC;
_emailHelper = emailHelper;
_excelHander = excelHandler;
_pythonConnector = pythonConnector;
_dataTabler = dataTabler;
_csvHandler = csvHandler;
_cbsTrendsController = cbsTrendsController;
// this._cbsTrendsController = cbsTrendsController;
}
public LaunchCoreSpSitesController
(
Helpers helpers,
AirtableManager atM,
PlayerBaseController playerBaseController,
IOptions <AirtableConfiguration> airtableConfig,
PostmanMethods postmanMethods,
GoogleSheetsConnector googleSheetsConnector,
IOptionsSnapshot <GoogleSheetConfiguration> options,
IOptionsSnapshot <AirtableConfiguration> airTableOptions
)
{
if (airtableConfig is null)
{
throw new ArgumentNullException(nameof(airtableConfig));
}
if (options is null)
{
throw new ArgumentNullException(nameof(options));
}
if (airTableOptions is null)
{
throw new ArgumentNullException(nameof(airTableOptions));
}
_helpers = helpers ?? throw new ArgumentNullException(nameof(helpers));
_atM = atM ?? throw new ArgumentNullException(nameof(atM));
_playerBaseController = playerBaseController ?? throw new ArgumentNullException(nameof(playerBaseController));
_airtableConfig = airtableConfig.Value;
_postmanMethods = postmanMethods ?? throw new ArgumentNullException(nameof(postmanMethods));
_googleSheetsConnector = googleSheetsConnector ?? throw new ArgumentNullException(nameof(googleSheetsConnector));
_crunchTimePlayerIdMapConfiguration = options.Get("CrunchtimePlayerIdMap");
_sfbbPlayerIdMapConfiguration = options.Get("SfbbPlayerIdMap");
_spRankingsConfiguration = airTableOptions.Get("SpRankings");
_authorsConfiguration = airTableOptions.Get("Authors");
}
public PlayerNoteController(Helpers helpers, BaseballScraperContext context, IOptions <AirtableConfiguration> airtableConfig)
{
_helpers = helpers;
_airtableConfig = airtableConfig.Value;
_context = context;
}
