public static void Drivers(SqlConnection connection)
{
// Initialization.
bool hasHeader = true;
string importFilePath = "./Database/RawData/drivers.csv";
//Import Diretly From CSV
DataTable data = CSVLibraryAK.Import(importFilePath, hasHeader);
data.TableName = "drivers";
//Adjust DataTypes
DataTable dtCloned = data.Clone();
dtCloned.Columns["driverId"].DataType = typeof(int);
dtCloned.Columns["number"].DataType = typeof(int);
dtCloned.Columns["dob"].DataType = typeof(DateTime);
string format = "yyyy-MM-dd";
foreach (DataRow row in data.Rows)
{
DateTime date;
DateTime.TryParseExact(row["dob"].ToString(), format, CultureInfo.InvariantCulture, DateTimeStyles.None, out date);
row["dob"] = date;
dtCloned.ImportRow(row);
}
ClearTable("Drivers", connection);
Add_Table_To_Database(connection, dtCloned);
}
public static void Results(SqlConnection connection)
{
// Initialization.
bool hasHeader = true;
string importFilePath = "./Database/RawData/results.csv";
// Import CSV file.
DataTable data = CSVLibraryAK.Import(importFilePath, hasHeader);
data.TableName = "Results";
//Adjust DataTypes
DataTable dtCloned = data.Clone();
dtCloned.Columns["raceId"].DataType = typeof(int);
dtCloned.Columns["resultId"].DataType = typeof(int);
dtCloned.Columns["constructorId"].DataType = typeof(int);
dtCloned.Columns["number"].DataType = typeof(int);
dtCloned.Columns["grid"].DataType = typeof(int);
dtCloned.Columns["position"].DataType = typeof(int);
dtCloned.Columns["positionOrder"].DataType = typeof(int);
dtCloned.Columns["points"].DataType = typeof(float);
dtCloned.Columns["laps"].DataType = typeof(int);
dtCloned.Columns["milliseconds"].DataType = typeof(int);
dtCloned.Columns["fastestLap"].DataType = typeof(int);
dtCloned.Columns["rank"].DataType = typeof(int);
dtCloned.Columns["statusId"].DataType = typeof(int);
foreach (DataRow row in data.Rows)
{
dtCloned.ImportRow(row);
}
ClearTable("Results", connection);
Add_Table_To_Database(connection, dtCloned);
}
public static void Circuits(SqlConnection connection)
{
// Initialization.
bool hasHeader = true;
string importFilePath = "./Database/RawData/circuits.csv";
//Import Diretly From CSV
DataTable data = CSVLibraryAK.Import(importFilePath, hasHeader);
data.TableName = "circuits";
//Adjust DataTypes
DataTable dtCloned = data.Clone();
dtCloned.Columns["circuitId"].DataType = typeof(int);
dtCloned.Columns["lat"].DataType = typeof(float);
dtCloned.Columns["lng"].DataType = typeof(float);
dtCloned.Columns["alt"].DataType = typeof(int);
foreach (DataRow row in data.Rows)
{
dtCloned.ImportRow(row);
}
ClearTable("Circuits", connection);
Add_Table_To_Database(connection, dtCloned);
}