def test_filter_event_contains_url(self): _create_event( event="$autocapture", team=self.team, distinct_id="whatever", properties={"$current_url": "https://posthog.com/feedback/123"}, ) _create_event( event="$pageview", team=self.team, distinct_id="whatever", properties={"$current_url": "https://posthog.com/feedback/123"}, ) _create_event( event="$autocapture", team=self.team, distinct_id="whatever", properties={"$current_url": "https://posthog.com/feedback/1234"}, ) action1 = Action.objects.create(team=self.team, name="action1") step1 = ActionStep.objects.create(event="$autocapture", action=action1, url="https://posthog.com/feedback/123",) query, params = filter_event(step1) full_query = EVENT_UUID_QUERY.format(" AND ".join(query)) result = sync_execute(full_query, {**params, "team_id": self.team.pk}) self.assertEqual(len(result), 2)
def test_filter_event_contains_url(self): event_target = _create_event( event="$autocapture", team=self.team, distinct_id="whatever", properties={"$current_url": "https://posthog.com/feedback/123"}, ) _create_event( event="$pageview", team=self.team, distinct_id="whatever", properties={"$current_url": "https://posthog.com/feedback/123"}, ) _create_event( event="$autocapture", team=self.team, distinct_id="whatever", properties={"$current_url": "https://posthog.com/feedback/1234"}, ) action1 = Action.objects.create(team=self.team, name="action1") step1 = ActionStep.objects.create( event="$autocapture", action=action1, url="https://posthog.com/feedback/123", ) query, params, _ = filter_event(step1) full_query = "SELECT uuid FROM events WHERE uuid IN {}".format(query) result = sync_execute(full_query, {**params, "team_id": self.team.pk}) self.assertEqual(len(result), 2)
def test_filter_event_regex_url(self): _create_event( event="$autocapture", team=self.team, distinct_id="whatever", properties={"$current_url": "https://posthog.com/feedback/123"}, ) _create_event( event="$autocapture", team=self.team, distinct_id="whatever", properties={"$current_url": "https://test.com/feedback"}, ) _create_event( event="$autocapture", team=self.team, distinct_id="whatever", properties={"$current_url": "https://posthog.com/feedback/1234"}, ) action1 = Action.objects.create(team=self.team, name="action1") step1 = ActionStep.objects.create( event="$autocapture", action=action1, url="/123", url_matching=ActionStep.REGEX, ) query, params = filter_event(step1) full_query = "SELECT uuid FROM events WHERE {}".format( " AND ".join(query)) result = sync_execute(full_query, {**params, "team_id": self.team.pk}) self.assertEqual(len(result), 2)