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); }