Method test_timezones_hourly

posthog/queries/test/test_trends.py:4995–5081

(self)

    @snapshot_clickhouse_queries
    def test_timezones_hourly(self):
        self.team.timezone = "US/Pacific"
        self.team.save()
        _create_person(team_id=self.team.pk, distinct_ids=["blabla"], properties={})
        with freeze_time("2020-01-05T06:01:01Z"):  # Previous day in pacific time, don't include
            _create_event(
                team=self.team,
                event="sign up",
                distinct_id="blabla",
                properties={"$current_url": "first url", "$browser": "Firefox", "$os": "Mac"},
            )
        with freeze_time("2020-01-05T15:01:01Z"):  # 07:01 in pacific time
            _create_event(
                team=self.team,
                event="sign up",
                distinct_id="blabla",
                properties={"$current_url": "first url", "$browser": "Firefox", "$os": "Mac"},
            )
        with freeze_time("2020-01-05T16:01:01Z"):  # 08:01 in pacific time
            _create_event(
                team=self.team,
                event="sign up",
                distinct_id="blabla",
                properties={"$current_url": "first url", "$browser": "Firefox", "$os": "Mac"},
            )

        with freeze_time("2020-01-05T18:01:01Z"):  # 10:01 in pacific time
            response = Trends().run(
                Filter(
                    data={
                        "date_from": "dStart",
                        "interval": "hour",
                        "events": [{"id": "sign up", "name": "sign up", "math": "dau"}],
                    },
                    team=self.team,
                ),
                self.team,
            )
            self.assertEqual(
                response[0]["labels"],
                [
                    "5-Jan-2020 00:00",
                    "5-Jan-2020 01:00",
                    "5-Jan-2020 02:00",
                    "5-Jan-2020 03:00",
                    "5-Jan-2020 04:00",
                    "5-Jan-2020 05:00",
                    "5-Jan-2020 06:00",
                    "5-Jan-2020 07:00",
                    "5-Jan-2020 08:00",
                    "5-Jan-2020 09:00",
                    "5-Jan-2020 10:00",
                ],
            )
            self.assertEqual(response[0]["data"], [0.0, 0.0, 0.0, 0.0, 0, 0, 0, 1, 1, 0, 0])
            persons = self.client.get("/" + response[0]["persons_urls"][7]["url"]).json()
            self.assertEqual(persons["results"][0]["count"], 1)