public TestDeleteDatabaseProperties()
{
string path;
if (LinuxUtility.IsLinux())
{
path = "/tmp";
}
else
{
path = "C:\\Temp\\";
}
string fn = Path.Combine(path, "factory.pdb");
FileUtility.GetTempFileNameInDirectory(path, ".pdb");
SQLiteServer.CreateNewDatabase(fn);
SQLiteServer svr = new SQLiteServer(fn);
db = new TimeSeriesDatabase(svr, false);
string dataPath = TestData.DataPath;
Series s = new Series("Glomma River");
db.AddSeries(s);
s = db.GetSeriesFromName("Glomma River");
s.TimeSeriesDatabase = db;
s.Properties.Set("elevation", " 690 m");
s.Properties.Save();
}
public TestParserWithDatabase()
{
_fn = FileUtility.GetTempFileName(".pdb");
SQLiteServer.CreateNewDatabase(_fn);
_svr = new SQLiteServer(_fn);
_db = new TimeSeriesDatabase(_svr, false);
}
public TestParserWithDatabase()
{
string fn = FileUtility.GetTempFileName(".pdb");
SQLiteServer.CreateNewDatabase(fn);
var svr = new SQLiteServer(fn);
db = new TimeSeriesDatabase(svr, false);
}
public void Open(string path, bool create = false)
{
// PostgreSQL, s
// SQLiteServer
BasicDBServer svr = null;
if (create)
{
SQLiteServer.CreateNewDatabase(path);
}
svr = new SQLiteServer(path);
Connect(svr);
}
private void NewDatabaseClick(object sender, EventArgs e)
{
SaveFileDialog fd = new SaveFileDialog();
fd.Title = "Create a new Database";
fd.DefaultExt = "*.pdb";
fd.Filter = "Pisces database (*.pdb)|*.pdb";
if (fd.ShowDialog() == DialogResult.OK)
{
SQLiteServer.CreateNewDatabase(fd.FileName);
engine1.Open(fd.FileName);
DatabaseChanged();
UserPreference.Save("fileName", fd.FileName);
}
}
public TimeSeriesDatabaseTest()
{
string path;
if (LinuxUtility.IsLinux())
{
path = "/tmp";
}
else
{
path = "C:\\Temp\\";
}
tmpDir = Path.Combine(path, "db_test");
if (!Directory.Exists(tmpDir))
{
Directory.CreateDirectory(tmpDir);
}
string fn = Path.Combine(path, "factory.pdb");
FileUtility.GetTempFileNameInDirectory(path, ".pdb");
SQLiteServer.CreateNewDatabase(fn);
SQLiteServer svr = new SQLiteServer(fn);
db = new TimeSeriesDatabase(svr, false);
//string dataPath = ReclamationTesting.Properties.Settings.Default.DataPath;
string dataPath = TestData.DataPath;
File.Copy(Path.Combine(dataPath, textFileName), Path.Combine(tmpDir, textFileName), true);
textFileName = Path.Combine(tmpDir, textFileName);
// Add some data for export test
Series s;
int c;
int sdi;
AddTextSeries(out s, out c, out sdi);
}
private static string GetFileName(string[] args)
{
string fileName = "";
if (args.Length == 1)
{
fileName = args[0];
}
else if (UserPreference.Lookup("fileName") != "" &&
File.Exists(UserPreference.Lookup("fileName")) &&
Path.GetExtension(UserPreference.Lookup("fileName")) != ".sdf")
{
fileName = UserPreference.Lookup("fileName");
}
else
{// open default database
var paths = new List <string>()
{
Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments),
FileUtility.GetLocalApplicationPath(),
FileUtility.GetTempPath()
};
foreach (var item in paths)
{
if (HasWriteAccessToFolder(item))
{
fileName = Path.Combine(item, "tsdatabase.pdb");
break;
}
}
}
if (!File.Exists(fileName))
{
SQLiteServer.CreateNewDatabase(fileName);
}
return(fileName);
}
string tmpDir = @"C:\temp\db_test"; // test relative paths
public TimeSeriesDatabaseTest()
{
if (!Directory.Exists(tmpDir))
{
Directory.CreateDirectory(tmpDir);
}
string fn = Path.Combine(@"C:\temp", "factory.pdb");
FileUtility.GetTempFileNameInDirectory(@"C:\temp\", ".pdb");
SQLiteServer.CreateNewDatabase(fn);
SQLiteServer svr = new SQLiteServer(fn);
db = new TimeSeriesDatabase(svr);
//string dataPath = ReclamationTesting.Properties.Settings.Default.DataPath;
string dataPath = TestData.DataPath;
File.Copy(Path.Combine(dataPath, textFileName), Path.Combine(tmpDir, textFileName), true);
textFileName = Path.Combine(tmpDir, textFileName);
File.Copy(Path.Combine(dataPath, excelFileName), Path.Combine(tmpDir, excelFileName), true);
excelFileName = Path.Combine(tmpDir, excelFileName);
File.Copy(Path.Combine(dataPath, updatedExcelFileName), Path.Combine(tmpDir, updatedExcelFileName), true);
updatedExcelFileName = Path.Combine(tmpDir, updatedExcelFileName);
// Add some data for export test
Series s;
int c;
int sdi;
AddExcelSeries(out s, out c, out sdi);
AddTextSeries(out s, out c, out sdi);
}
static void Main(string[] args)
{
Logger.EnableLogger(true);
var x = HdbPoet.Hdb.Instance; // force this assembly to load.
try
{
string fileName = "";
if (args.Length == 1)
{
fileName = args[0];
if (!File.Exists(fileName))
{
MessageBox.Show("Could not open file '" + fileName + "'");
return;
}
}
else if (UserPreference.Lookup("fileName") != "" &&
File.Exists(UserPreference.Lookup("fileName")) &&
Path.GetExtension(UserPreference.Lookup("fileName")) != ".sdf")
{
fileName = UserPreference.Lookup("fileName");
}
else
{// open default database
fileName = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "\\tsdatabase.pdb";
}
if (!File.Exists(fileName))
{
SQLiteServer.CreateNewDatabase(fileName);
}
HydrometInfoUtility.SetDefaultHydrometServer();
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.ThreadExit += new EventHandler(Application_ThreadExit);
Application.ApplicationExit += new EventHandler(Application_ApplicationExit);
//Application.Idle += new EventHandler(Application_Idle);
//Application.ThreadException += new System.Threading.ThreadExceptionEventHandler(Application_ThreadException);
explorer = new PiscesSettings(new ExplorerView());
// explorer.Database
explorer.Open(fileName);
db = explorer.Database;
piscesForm1 = new PiscesForm(explorer);
piscesForm1.FormClosed += new FormClosedEventHandler(explorerForm1_FormClosed);
//Pisces2 p2 = new Pisces2(explorer);
//p2.FormClosed += new FormClosedEventHandler(explorerForm1_FormClosed);
Application.Run(piscesForm1);
explorer.Database.SaveSettingsToDatabase(explorer.TimeWindow);
//db.SaveSettingsToDatabase(explorer.TimeWindow);
PostgreSQL.ClearAllPools();
FileUtility.CleanTempPath();
}
catch (Exception exc)
{
MessageBox.Show(exc.ToString());
}
}
