public static void Import(string serverIP, string database, string siteFilter, string networkListName)
{
string fn = @"C:\temp\mcf.xml";
Performance perf = new Performance();
var pnMcf = new McfDataSet();
if (File.Exists(fn) && File.GetLastWriteTime(fn).Date != DateTime.Now.Date)
{ // read existing file.
Logger.WriteLine("Reading existing XML");
pnMcf.ReadXml(fn);
}
else
{
Logger.WriteLine("Reading csv files from MCF");
pnMcf = McfUtility.GetDataSetFromCsvFiles(Globals.LocalConfigurationDataPath);
pnMcf.WriteXml(fn);
}
DumpInfo(pnMcf);
Application.DoEvents();
Logger.WriteLine(serverIP);
var cs = PostgreSQL.CreateADConnectionString(serverIP, database, "decodes");
PostgreSQL svr = new PostgreSQL(cs);
var decodes = DecodesUtility.GetDataSet(svr);
McfDecodesConverter c = new McfDecodesConverter(svr, pnMcf, decodes);
c.importMcf(siteFilter.Split(','), networkListName);
UpdateSequences(svr);
}
public static BasicDBServer GetPGServer(string ipaddress = "localhost", string dbName = "nunit")
{
var cs = PostgreSQL.CreateADConnectionString(ipaddress, dbName);
PostgreSQL svr = new PostgreSQL(cs);
return(svr);
}
private static void SetExpectedLength()
{
CsvFile csv = new CsvFile(@"c:\temp\site.csv", CsvFile.FieldTypes.AllText);
var cs = PostgreSQL.CreateADConnectionString("opendcs", "hydromet_opendcs");
PostgreSQL svr = new PostgreSQL(cs);
var platform = svr.Table("platform");
var platformproperty = svr.Table("platformproperty");
System.Console.WriteLine(platform.Rows.Count);
System.Console.WriteLine(platformproperty.Rows.Count);
for (int i = 0; i < csv.Rows.Count; i++)
{
var row = csv.Rows[i];
var site = row["site"].ToString();
var nessid = row["NESSID"].ToString();
var expectLength = row["STMSGLEN"].ToString();
if (nessid.Trim() == "0" || nessid.Trim().Length < 5)
{
continue;
}
// find platform with platformdesignator= site
var rows = platform.Select("platformdesignator='" + site + "'");
if (rows.Length != 1)
{
System.Console.WriteLine("skipping " + site);
continue;
}
int id = Convert.ToInt32(rows[0]["id"]);
var x = platformproperty.Select("platformid = " + id + "and prop_name='expectLength' ");
Console.WriteLine(site + " " + expectLength);
if (x.Length == 1)
{// update existing
x[0]["prop_value"] = expectLength;
}
else
{// add new row
platformproperty.Rows.Add(id, "expectLength", expectLength);
}
}
var j = svr.SaveTable(platformproperty);
Console.WriteLine(j + " rows saved");
}
static void Main(string[] args)
{
string serverIP = "lrgs1";
//.Logger.Logger.EnableLogger();
var fn = @"V:\PN6200\Hydromet\HelpWanted\migrate to linux.xls";
var tbl = ExcelDB.Read(fn, "owrd_1");
var cs = PostgreSQL.CreateADConnectionString(serverIP, "timeseries");
PostgreSQL svr = new PostgreSQL(cs);
//SQLiteServer svr = new SQLiteServer(@"c:\temp\lrgs1.pdb");
TimeSeriesDatabase db = new TimeSeriesDatabase(svr);
AddToPisces(tbl, db);
AddSitesToDecodes(serverIP, tbl);
}
public void ConnectToServer(string server, string database, DatabaseType t)
{
string cs = ""; // connection string
BasicDBServer svr = null;
if (t == DatabaseType.PostgreSql)
{
cs = PostgreSQL.CreateADConnectionString(server, database);
svr = new PostgreSQL(cs);
}
if (t == DatabaseType.SqlServer)
{
svr = new SqlServer(server, database);
}
if (t == DatabaseType.MySQL)
{
svr = MySqlServer.GetMySqlServer(server, database);
}
Connect(svr);
}
