import datetime as dt import tempfile import unittest from pathlib import Path from meteo_collecte.commun import UTC from meteo_collecte.stockage import Stockage T0 = dt.datetime(2026, 10, 16, 12, 0, tzinfo=UTC) class TestStockage(unittest.TestCase): def setUp(self): self.tmp = tempfile.TemporaryDirectory() self.s = Stockage(Path(self.tmp.name) / "m.sqlite") def tearDown(self): self.s.fermer() self.tmp.cleanup() def test_cle_unique_et_premiere_reception_gardee(self): m = [{"dh_utc": "2026-10-16 11:50:00", "temperature": 5.1}] self.assertEqual(self.s.ajouter("infoclimat", "000T0", m, T0), 1) self.assertEqual(self.s.ajouter("infoclimat", "000T0", [{"dh_utc": "2026-10-16 11:50:00", "temperature": 9}], T0 + dt.timedelta(minutes=10)), 0) d = self.s.derniere("infoclimat", "000T0") self.assertEqual(d["temperature"], 5.1) self.assertEqual(d["recu_utc"], "2026-10-16 12:00:00") def test_deux_sources_ne_se_melangent_pas(self): self.s.ajouter("infoclimat", "80", [{"dh_utc": "2026-10-16 11:50:00", "temperature": 5.0}], T0) self.s.ajouter("romma", "80", [{"dh_utc": "2026-10-16 11:50:00", "temperature": 7.0}], T0) self.assertEqual(self.s.derniere("infoclimat", "80")["temperature"], 5.0) self.assertEqual(self.s.derniere("romma", "80")["temperature"], 7.0) self.assertEqual(self.s.compter(), 2) def test_null_texte_et_virgule(self): self.s.ajouter("romma", "1", [{"dh_utc": "2026-10-16 11:50:00", "temperature": "NULL", "pression": "1012,5"}], T0) d = self.s.derniere("romma", "1") self.assertIsNone(d["temperature"]) self.assertEqual(d["pression"], 1012.5) def test_purge_14_jours(self): self.s.ajouter("romma", "1", [{"dh_utc": "2026-10-01 11:50:00"}, {"dh_utc": "2026-10-03 11:50:00"}], T0) self.assertEqual(self.s.purger(T0, 14), 1) self.assertEqual(self.s.compter(), 1) def test_metadonnees_non_ecrasees_par_vide(self): self.s.maj_station("romma", "1", nom="A", lat=45.0) self.s.maj_station("romma", "1", nom="", lat=None, altitude=1000) st = self.s.stations()[0] self.assertEqual((st["nom"], st["lat"], st["altitude"]), ("A", 45.0, 1000)) if __name__ == "__main__": unittest.main()