def test_query(self): q = coastal_data.coastal_query("Joe_Bay_2E", DataParams.temperature) q_s = str(q) print "q =", q_s self.assertIn("SELECT", q_s.upper()) self.assertIn("Joe_Bay_2E".upper(), q_s.upper()) self.assertIn("DATETIME".upper(), q_s.upper()) self.assertIn("temperature".upper(), q_s.upper())
def test_funky_gage_name(self): gage_name = "G-3777" # yes it exists q = coastal_data.coastal_query(gage_name, DataParams.stage) self.assertIn(gage_name, str(q)) seq = coastal_data.coastal_seq(gage_name, "stage") for t in seq: self.assertIsNotNone(t[0])