// Not used anymore
public static void InsertQuandlDatasetsData(List <QuandlDatasetDataGroup> datasetsGroups)
{
// Make datasets model tables
Console.WriteLine("Creating unique table model for datasets:");
foreach (QuandlDatasetDataGroup datasetGroup in datasetsGroups)
{
SchemaActions.CreateQuandlDatasetDataTable(datasetGroup);
}
// Insert data
int count = 0;
foreach (QuandlDatasetDataGroup datasetGroup in datasetsGroups)
{
count++;
Console.WriteLine("\nCreating query for datasets in group: [" + datasetGroup.DatabaseCode + "] (" + count + "/" + datasetsGroups.Count + ")");
datasetGroup.MakeInsertDataQuery();
Utils.ConsoleInformer.PrintProgress("3C", "Inserting data for group[" + datasetGroup.DatabaseCode + "]: ", "100%");
}
}
public static void MakeQuandlDatatables(List <QuandlDatatable> datatables)
{
// Make datatable model tables
Console.WriteLine("Creating unique table model for datatables:");
foreach (QuandlDatatable datatable in datatables)
{
SchemaActions.CreateQuandlDatatableModelTable(datatable);
}
// Insert data
int count = 0;
foreach (QuandlDatatable datatable in datatables)
{
count++;
Console.WriteLine("\nCreating query for datatable: [" + datatable.Name + "] (" + count + "/" + datatables.Count + ")");
datatable.MakeInsertQuery();
Utils.ConsoleInformer.PrintProgress("3C", "Inserting data for group[" + datatable.Name + "]: ", "100%");
}
}
/**
* Dataset info methos
*/
public static void InsertQuandlDatasets(List <QuandlDatasetGroup> datasetsGroups)
{
// Make datasets model tables
SchemaActions.CreateQuandlDatasetTable();
// Insert datasets
int count = 0;
foreach (QuandlDatasetGroup datasetGroup in datasetsGroups)
{
count++;
try
{
datasetGroup.MakeInsertQuery();
ConsoleInformer.PrintProgress("3B", "Inserting [" + datasetGroup.DatabaseCode + "] datasets: ", Utils.Helpers.GetPercent(count, datasetsGroups.Count).ToString() + "%");
}
catch (Exception ex)
{
// Write
Utils.ConsoleInformer.Inform("Some unexpected stuff happened. See the log for more info");
Utils.Helpers.Log("Something worng happened when trying to insert [" + datasetGroup.DatabaseCode + "] datasets. Check log", ex.Message);
}
}
}
