Пример #1
0
        public void CheckPermissions()
        {
            SqlConnect DBTest     = new SqlConnect();
            String     connString = DBTest.Connect("test", "test", false);

            Assert.Throws <Npgsql.PostgresException>(() => { DBTest.CheckDate(connString); });
        }
Пример #2
0
        /// <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);
        }
Пример #3
0
        /// <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();
        }