public Youbike(ILogger <Youbike> logger, IConfiguration configuration, IHttpClientHelpers httpClientHelpers, IDBHelpers dBHelpers)
{
this._dBHelpers = dBHelpers;
this._httpClientHelpers = httpClientHelpers;
_logger = logger;
_configuration = configuration;
YoubikeRequestUrl = _configuration.GetValue <string>("RequestAPIUrl:YoubikeAPI");
}
private static void CreateTables(IDBHelpers dbHelpers)
{
CheckAndCreateTable(dbHelpers, "RecentBattles", DatabaseScripts.CreateRecentBattlesTable);
CheckAndCreateTable(dbHelpers, "RecentBattles_Session", DatabaseScripts.CreateRecentBattlesSessionTable);
CheckAndCreateTable(dbHelpers, "Files", DatabaseScripts.CreateFilesTable);
CheckAndCreateTable(dbHelpers, "File_TankDetails", DatabaseScripts.CreateFile_TankDetailsTable);
CheckAndCreateTable(dbHelpers, "File_Total", DatabaseScripts.CreateFile_TotalTable);
CheckAndCreateTable(dbHelpers, "File_FragList", DatabaseScripts.CreateFile_FragListTable);
CheckAndCreateTable(dbHelpers, "File_Company", DatabaseScripts.CreateFile_CompanyTable);
CheckAndCreateTable(dbHelpers, "File_Clan", DatabaseScripts.CreateFile_ClanTable);
CheckAndCreateTable(dbHelpers, "File_Historical", DatabaseScripts.CreateFile_HistoricalTable);
CheckAndCreateTable(dbHelpers, "File_Battles", DatabaseScripts.CreateFile_BattlesTable);
CheckAndCreateTable(dbHelpers, "File_Achievements", DatabaseScripts.CreateFile_AchievementsTable);
CheckAndCreateTable(dbHelpers, "Overall", DatabaseScripts.CreateFile_OverallTable);
CheckAndCreateTable(dbHelpers, "Cache_LastGame", DatabaseScripts.CreateCache_LastGame);
}
private static void CheckAndCreateTable(IDBHelpers dbHelpers, string tableName, string tableScript)
{
try
{
string sql = String.Format(@"SELECT name FROM sqlite_master WHERE type='table' AND name='{0}';", tableName);
using (DataTable tableCheck = dbHelpers.GetDataTable(sql))
{
if (tableCheck.Rows.Count <= 0)
{
dbHelpers.ExecuteNonQuery(tableScript);
}
}
}
catch (Exception)
{
throw;
}
}
public YoubikeController(ILogger <YoubikeController> logger, IYoubike youbike, IDBHelpers dBHelpers)
{
this._dBHelpers = dBHelpers;
_logger = logger;
_youbike = youbike;
}
public static void CheckAndCreateColumn(string sTable, string sColumn, string sColumnDef, IDBHelpers dbHelpers, DataTable dt)
{
var columnCheck = (from x in dt.AsEnumerable()
where x.Field <string>("name") == sColumn
select x).DefaultIfEmpty(null).FirstOrDefault();
if (columnCheck == null)
{
string SQL = "Alter table " + sTable + " Add " + sColumn + " " + sColumnDef;
Console.WriteLine(SQL);
dbHelpers.ExecuteNonQuery(SQL);
}
}
private static void CreateTables(IDBHelpers dbHelpers)
{
CheckAndCreateTable(dbHelpers, "RecentBattles", DatabaseScripts.CreateRecentBattlesTable);
CheckAndCreateTable(dbHelpers, "RecentBattles_Session", DatabaseScripts.CreateRecentBattlesSessionTable);
CheckAndCreateTable(dbHelpers, "Files", DatabaseScripts.CreateFilesTable);
CheckAndCreateTable(dbHelpers, "File_TankDetails", DatabaseScripts.CreateFile_TankDetailsTable);
CheckAndCreateTable(dbHelpers, "File_Total", DatabaseScripts.CreateFile_TotalTable);
CheckAndCreateTable(dbHelpers, "File_FragList", DatabaseScripts.CreateFile_FragListTable);
CheckAndCreateTable(dbHelpers, "File_Company", DatabaseScripts.CreateFile_CompanyTable);
CheckAndCreateTable(dbHelpers, "File_Clan", DatabaseScripts.CreateFile_ClanTable);
CheckAndCreateTable(dbHelpers, "File_Historical", DatabaseScripts.CreateFile_HistoricalTable);
CheckAndCreateTable(dbHelpers, "File_Battles", DatabaseScripts.CreateFile_BattlesTable);
CheckAndCreateTable(dbHelpers, "File_Achievements", DatabaseScripts.CreateFile_AchievementsTable);
CheckAndCreateTable(dbHelpers, "Overall", DatabaseScripts.CreateFile_OverallTable);
CheckAndCreateTable(dbHelpers, "Cache_LastGame", DatabaseScripts.CreateCache_LastGame);
}
private static void CheckAndCreateTable(IDBHelpers dbHelpers, string tableName, string tableScript)
{
try
{
string sql = String.Format(@"SELECT name FROM sqlite_master WHERE type='table' AND name='{0}';", tableName);
using (DataTable tableCheck = dbHelpers.GetDataTable(sql))
{
if (tableCheck.Rows.Count <= 0)
{
dbHelpers.ExecuteNonQuery(tableScript);
}
}
}
catch (Exception)
{
throw;
}
}
public static void CheckAndCreateColumn(string sTable, string sColumn, string sColumnDef, IDBHelpers dbHelpers, DataTable dt)
{
var columnCheck = (from x in dt.AsEnumerable()
where x.Field<string>("name") == sColumn
select x).DefaultIfEmpty(null).FirstOrDefault();
if (columnCheck == null)
{
string SQL = "Alter table " + sTable + " Add " + sColumn + " " + sColumnDef;
Console.WriteLine(SQL);
dbHelpers.ExecuteNonQuery(SQL);
}
}
