public override void Run()
{
var config = GetConfig();
using (var context = new BasketballDataContext(config))
{
context.Countries.Add(
new Country
{
ApiBasketballCountryId = 0,
CountryAbbr = "XX",
CountryName = "World",
FlagUrl = null
});
context.RefGameStatuses.AddRange(new List <RefGameStatus>
{
new RefGameStatus {
FullGameStatusId = FullGameStatus.NotStarted, FullGameStatusName = "Not Started", GameStatusId = GameStatus.Pregame, GameStatusName = "Pregame", ApiBasketballStatusCode = "NS"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.Live_Q1, FullGameStatusName = "Live - Q1", GameStatusId = GameStatus.Live, GameStatusName = "Live", ApiBasketballStatusCode = "Q1"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.Live_Q2, FullGameStatusName = "Live - Q2", GameStatusId = GameStatus.Live, GameStatusName = "Live", ApiBasketballStatusCode = "Q2"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.Live_Q3, FullGameStatusName = "Live - Q3", GameStatusId = GameStatus.Live, GameStatusName = "Live", ApiBasketballStatusCode = "Q3"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.Live_Q4, FullGameStatusName = "Live - Q4", GameStatusId = GameStatus.Live, GameStatusName = "Live", ApiBasketballStatusCode = "Q4"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.Live_OT, FullGameStatusName = "Live - OT", GameStatusId = GameStatus.Live, GameStatusName = "Live", ApiBasketballStatusCode = "OT"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.Live_BK, FullGameStatusName = "Live - Break", GameStatusId = GameStatus.Live, GameStatusName = "Live", ApiBasketballStatusCode = "BT"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.Live_HT, FullGameStatusName = "Live - Halftime", GameStatusId = GameStatus.Live, GameStatusName = "Live", ApiBasketballStatusCode = "HT"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.Final, FullGameStatusName = "Final", GameStatusId = GameStatus.Final, GameStatusName = "Final", ApiBasketballStatusCode = "FT"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.FinalWithOT, FullGameStatusName = "Final (OT)", GameStatusId = GameStatus.Final, GameStatusName = "Final", ApiBasketballStatusCode = "AOT"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.Postponed, FullGameStatusName = "Postponed", GameStatusId = GameStatus.Postponed, GameStatusName = "Postponed", ApiBasketballStatusCode = "POST"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.Cancelled, FullGameStatusName = "Cancelled", GameStatusId = GameStatus.Cancelled, GameStatusName = "Cancelled", ApiBasketballStatusCode = "CANC"
},
new RefGameStatus {
FullGameStatusId = FullGameStatus.Unknown, FullGameStatusName = "Unknown", GameStatusId = GameStatus.Unknown, GameStatusName = "Unknown", ApiBasketballStatusCode = null
}
});
context.SaveChanges();
var bookmakersProcessor = new BookmakersProcessor();
Console.WriteLine("START BOOKMAKERS");
bookmakersProcessor.Run(context);
Console.WriteLine("SAVE BOOKMAKERS");
context.SaveChanges();
Console.WriteLine("END BOOKMAKERS");
var betTypesProcessor = new BetTypesProcessor();
Console.WriteLine("START BET TYPES");
betTypesProcessor.Run(context);
Console.WriteLine("SAVE BET TYPES");
context.SaveChanges();
Console.WriteLine("END BET TYPES");
var countriesProcessor = new CountriesProcessor();
Console.WriteLine("START COUNTRIES");
countriesProcessor.Run(context);
Console.WriteLine("SAVE COUNTRIES");
context.SaveChanges();
Console.WriteLine("END COUNTRIES");
var leaguesProcessor = new LeaguesProcessor();
Console.WriteLine("START LEAGUES");
leaguesProcessor.Run(context);
Console.WriteLine("SAVE LEAGUES");
context.SaveChanges();
Console.WriteLine("END LEAGUES");
var leagueSeasons = context.LeagueSeasons
.OrderBy(x => x.LeagueSeasonId)
.Select(y => new { y.ApiBasketballLeagueId, y.ApiBasketballSeasonKey })
.ToList();
foreach (var leagueSeason in leagueSeasons)
{
int leagueId = leagueSeason.ApiBasketballLeagueId;
string seasonKey = leagueSeason.ApiBasketballSeasonKey;
var teamsProcessor = new TeamsProcessor(leagueId, seasonKey);
Console.WriteLine($"START TEAMS - {leagueId} {seasonKey}");
teamsProcessor.Run(context);
Console.WriteLine($"SAVE TEAMS - {leagueId} {seasonKey}");
context.SaveChanges();
Console.WriteLine($"END TEAMS - {leagueId} {seasonKey}");
}
var countriesDict = context.Countries.ToDictionary(x => x.ApiBasketballCountryId, y => y.CountryId);
var teamsDict = context.Teams.ToDictionary(x => x.ApiBasketballTeamId, y => y.TeamId);
var statusDict = context.RefGameStatuses
.Where(x => !string.IsNullOrEmpty(x.ApiBasketballStatusCode))
.ToDictionary(x => x.ApiBasketballStatusCode, y => y.FullGameStatusId);
foreach (var leagueSeason in leagueSeasons)
{
int leagueId = leagueSeason.ApiBasketballLeagueId;
string seasonKey = leagueSeason.ApiBasketballSeasonKey;
var gamesProcessor = new GamesProcessor(leagueId, seasonKey, countriesDict, statusDict);
Console.WriteLine($"START GAMES - {leagueId} {seasonKey}");
gamesProcessor.Run(context);
Console.WriteLine($"SAVE GAMES - {leagueId} {seasonKey}");
context.SaveChanges();
Console.WriteLine($"END GAMES - {leagueId} {seasonKey}");
}
var bookmakersDict = context.Bookmakers.ToDictionary(x => x.ApiBasketballBookmakerId, y => y.BookmakerId);
var betTypesDict = context.BetTypes.ToDictionary(x => x.ApiBasketballBetTypeId, y => y.BetTypeId);
var liveAndUpcomingGameStatuses = context.RefGameStatuses
.Where(x => x.GameStatusId == GameStatus.Pregame || x.GameStatusId == GameStatus.Live)
.Select(x => x.FullGameStatusId)
.ToList();
foreach (var leagueSeason in leagueSeasons)
{
int leagueId = leagueSeason.ApiBasketballLeagueId;
string seasonKey = leagueSeason.ApiBasketballSeasonKey;
var oddsProcessor = new OddsProcessor(leagueId, seasonKey, betTypesDict, bookmakersDict);
Console.WriteLine($"START ODDS - {leagueId} {seasonKey}");
oddsProcessor.Run(context);
Console.WriteLine($"SAVE ODDS - {leagueId} {seasonKey}");
context.SaveChanges();
Console.WriteLine($"END ODDS - {leagueId} {seasonKey}");
}
}
}
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
var config = GetConfig();
var context = new SoccerDataContext(config);
//var init = new SoccerDataContextInitializer();
//init.InitializeDatabase(context);
var countriesProcessor = new CountriesProcessor();
Console.WriteLine("START COUNTRIES");
countriesProcessor.Run(context);
Console.WriteLine("SAVE COUNTRIES");
context.SaveChanges();
Console.WriteLine("END COUNTRIES");
var leaguesProcessor = new LeaguesProcessor();
Console.WriteLine("START LEAGUES");
leaguesProcessor.Run(context);
Console.WriteLine("SAVE LEAGUES");
context.SaveChanges();
Console.WriteLine("END LEAGUES");
var desiredLeagueIds = new List <int>
{
751, 752, 51, 403, // EURO CHAMPS
1, 749, 750, // WORLD CUP
52, 31, 132, 530, 53, 32, 137, 514, // UEFA CL/EL
735, 734, 733, 732, 731, 730, 64, 30, 87, // ESP - LA LIGA
65, 33, 88, 776, // ESP - SEGUNDA
808, 973, // ESP - COPA DEL REY
499, 498, 444, 968, 502, 501, 445, 966, // AND - 1st AND 2nd
201, 200, 199, 294, // USA - MLS
521, 520, 519, 518, 522, 523 // USA - USL
};
desiredLeagueIds = new List <int>
{
1, 749, 750, // WORLD CUP
64, 30, 87, // ESP - LA LIGA
808, 973, // ESP - COPA DEL REY
200, 199, 294, // USA - MLS
};
var competitionSeasonIds = context.CompetitionSeasons
.Where(x => desiredLeagueIds.Contains(x.ApiFootballId))
.Select(x => x.CompetitionSeasonId)
.Distinct()
.OrderBy(x => x)
.ToList();
for (int i = 0; i < competitionSeasonIds.Count; i++)
{
Console.WriteLine($"START LEAGUE {i+1} OF {competitionSeasonIds.Count}");
int competitionSeasonId = competitionSeasonIds[i];
if (i % 10 == 9)
{
Console.WriteLine("NEW CONTEXT");
context.Dispose();
context = new SoccerDataContext(config);
}
var teamsProcessor = new TeamsProcessor(competitionSeasonId);
teamsProcessor.Run(context);
var roundsProcessor = new CompetitionSeasonRoundsProcessor(competitionSeasonId);
roundsProcessor.Run(context);
context.SaveChanges();
var leagueFixturesProcessor = new LeagueFixturesProcessor(competitionSeasonId);
leagueFixturesProcessor.Run(context);
context.SaveChanges();
}
var a = 1;
}