public void CheckPermissions() { SqlConnect DBTest = new SqlConnect(); String connString = DBTest.Connect("test", "test", false); Assert.Throws <Npgsql.PostgresException>(() => { DBTest.CheckDate(connString); }); }
/// <summary> /// Since there is no main this fulfills the purpose for the update button /// it handles the connection, API call and update to the gcloud database /// </summary> /// <param name="arguments">the credentials</param> public void Execute() { SqlConnect dBConnect = new SqlConnect(); String connString = (string)Application.Current.Resources["connString"]; dBConnect.CheckDate(connString, out DateTime date); DataFormat test = new DataFormat(); Dictionary <string, object>[] rarr = test.GetData(date); List <Json311> forDB = test.ParseData(rarr); dBConnect.Import(forDB, connString); }
/// <summary> /// our main method /// </summary> /// <param name="args">we should never really need arguments passed to main, however we may later decide to /// modify the program to accept the db name, ip address, username and password as command line arguments /// </param> static void Main(string[] args) { SqlConnect dBConnect = new SqlConnect(); String connString = dBConnect.Connect(); dBConnect.CheckDate(connString); DataFormat test = new DataFormat(); Dictionary <string, object>[] rarr = test.getData(); List <Json311> forDB = new List <Json311>(); forDB = test.parseData(rarr); dBConnect.Import(forDB, connString); Console.ReadKey(); }