diff options
author | Thomas Steur <thomas.steur@gmail.com> | 2016-12-01 10:32:03 +0300 |
---|---|---|
committer | Thomas Steur <thomas.steur@gmail.com> | 2016-12-01 10:32:03 +0300 |
commit | c7d39db582a82dc0e6c7236a53e34308bf6dd3d3 (patch) | |
tree | b3d68788c8b5dda00a9e94cfa9b7d70dcd170b87 /tests | |
parent | 7758015689eb599885d2838713da7d4f7e8d1716 (diff) |
added more complex example to show it better
Diffstat (limited to 'tests')
-rw-r--r-- | tests/PHPUnit/Integration/SegmentTest.php | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/tests/PHPUnit/Integration/SegmentTest.php b/tests/PHPUnit/Integration/SegmentTest.php index 2023f652c6..20b23065db 100644 --- a/tests/PHPUnit/Integration/SegmentTest.php +++ b/tests/PHPUnit/Integration/SegmentTest.php @@ -456,6 +456,16 @@ class SegmentTest extends IntegrationTestCase 'tableAlias' => 'log_action_bar', 'joinOn' => "log_link_visit_action_bar.idaction_url = log_action_bar.idaction" ), + array( + 'table' => 'log_link_visit_action', + 'tableAlias' => 'log_link_visit_action_baz', + 'joinOn' => "log_link_visit_action.idvisit = log_link_visit_action_baz.idvisit" + ), + array( + 'table' => 'log_action', + 'tableAlias' => 'log_action_baz', + 'joinOn' => "log_link_visit_action_baz.idaction_url = log_action_baz.idaction" + ), 'log_action', ); @@ -487,6 +497,10 @@ class SegmentTest extends IntegrationTestCase ON log_link_visit_action.idvisit = log_link_visit_action_bar.idvisit LEFT JOIN $logActionTable AS log_action_bar ON log_link_visit_action_bar.idaction_url = log_action_bar.idaction + LEFT JOIN $logLinkVisitActionTable AS log_link_visit_action_baz + ON log_link_visit_action.idvisit = log_link_visit_action_baz.idvisit + LEFT JOIN $logActionTable AS log_action_baz + ON log_link_visit_action_baz.idaction_url = log_action_baz.idaction LEFT JOIN $logActionTable AS log_action ON log_link_visit_action.idaction_url = log_action.idaction WHERE ( log_link_visit_action.server_time >= ? |