private void importFromDirectoryToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
DB.SuspendTreeUpdates();
var path = UserPreference.Lookup("bulk_import_folder");
FolderBrowserDialog dlg = new FolderBrowserDialog();
if (Directory.Exists(path))
{
dlg.SelectedPath = path;
}
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
UserPreference.Save("bulk_import_folder", dlg.SelectedPath);
BulkImportForm f = new BulkImportForm();
f.ImportClick += delegate {
BulkImportDirectory.Import(DB, f.SelectedPath, f.Filter, f.RegexFilter);
};
f.SelectedPath = dlg.SelectedPath;
f.ShowDialog();
DatabaseChanged();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
DB.ResumeTreeUpdates();
}
}
public void ImportDirectory()
{
var dir = Path.Combine(TestData.DataPath, "Scenarios", "dir_import");
var tmp = @"c:\temp\import_dir.pdb";
if (File.Exists(tmp))
{
File.Delete(tmp);
}
var svr = new SQLiteServer(tmp);
var db = new TimeSeriesDatabase(svr);
BulkImportDirectory.Import(db, dir, "*.csv",
@".+dir_import\\(?<scenario>[-a-z_0-9]+)-(?<siteid>[a-z0-9]+)-biascorrected_streamflow");
Assert.IsTrue(db.GetSeriesCatalog().Rows.Count == 3);
svr.CloseAllConnections();
File.Delete(tmp);
}
public void ImportDirectory()
{
var dir = Path.Combine(TestData.DataPath, "Scenarios", "dir_import");
var tmp = FileUtility.GetTempFileName(".pdb");
if (File.Exists(tmp))
{
File.Delete(tmp);
}
var svr = new SQLiteServer(tmp);
var db = new TimeSeriesDatabase(svr);
BulkImportDirectory.Import(db, dir, "*.csv",
@".+dir_import\" + Path.DirectorySeparatorChar + "(?<scenario>[-a-z_0-9]+)-(?<siteid>[a-z0-9]+)-biascorrected_streamflow");
var sc = db.GetSeriesCatalog();
Assert.IsTrue(sc.Rows.Count == 3, "found " + sc.Rows.Count + " rows in catalog. expected 3");
svr.CloseAllConnections();
File.Delete(tmp);
}
