diff options
author | Matthieu Aubry <matt@piwik.org> | 2014-09-21 10:15:11 +0400 |
---|---|---|
committer | Matthieu Aubry <matt@piwik.org> | 2014-09-21 10:15:11 +0400 |
commit | 2fc11ee2f175e8fdc1e4cac0adcf17241d457c8a (patch) | |
tree | 111e95deecd18f80ab3231aab9b044e29cde2ef8 /tests/PHPUnit/Integration/expected | |
parent | b82aca52957a0f836f169ac4e3b67f48bce2622f (diff) | |
parent | 3d04d1501436a74adf587b97ec9c48450a9fd153 (diff) |
Merge pull request #6243 from piwik/6078
Adding new PivotByDimension DataTable filter that can pivot a report by (almost) any dimension. refs #6078
Diffstat (limited to 'tests/PHPUnit/Integration/expected')
10 files changed, 403 insertions, 0 deletions
diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml new file mode 100644 index 0000000000..d98cace554 --- /dev/null +++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithDataTableMaps__Referrers.getKeywords_day.xml @@ -0,0 +1,49 @@ +<?xml version="1.0" encoding="utf-8" ?> +<results> + <result idSite="1"> + <result date="2010-01-01" /> + <result date="2010-01-02" /> + <result date="2010-01-03"> + <row> + <col name="label">this search term</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="2. Yokohama, Kanagawa, Japan">1</col> + <col name="3. Melbourne, Victoria, Australia">2</col> + </row> + <row> + <col name="label">search term 2</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="2. Yokohama, Kanagawa, Japan">2</col> + <col name="3. Melbourne, Victoria, Australia">0</col> + </row> + <row> + <col name="label">search term 3</col> + <col name="1. Toronto, Ontario, Canada">2</col> + <col name="2. Yokohama, Kanagawa, Japan">0</col> + <col name="3. Melbourne, Victoria, Australia">0</col> + </row> + <row> + <col name="label">search term 4</col> + <col name="1. Toronto, Ontario, Canada">2</col> + <col name="2. Yokohama, Kanagawa, Japan">0</col> + <col name="3. Melbourne, Victoria, Australia">0</col> + </row> + <row> + <col name="label">that search term</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="2. Yokohama, Kanagawa, Japan">0</col> + <col name="3. Melbourne, Victoria, Australia">2</col> + </row> + <row> + <col name="label">search term 1</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="2. Yokohama, Kanagawa, Japan">1</col> + <col name="3. Melbourne, Victoria, Australia">0</col> + </row> + </result> + <result date="2010-01-04" /> + <result date="2010-01-05" /> + <result date="2010-01-06" /> + <result date="2010-01-07" /> + </result> +</results>
\ No newline at end of file diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml new file mode 100644 index 0000000000..05553ef4f8 --- /dev/null +++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_PlaysNiceWithOtherQueryParams__Referrers.getKeywords_week.xml @@ -0,0 +1,33 @@ +<?xml version="1.0" encoding="utf-8" ?> +<result> + <row> + <label>this search term</label> + <Google>1</Google> + <Bing>0</Bing> + </row> + <row> + <label>search term 2</label> + <Google>0</Google> + <Bing>0</Bing> + </row> + <row> + <label>search term 3</label> + <Google>1</Google> + <Bing>0</Bing> + </row> + <row> + <label>search term 4</label> + <Google>0</Google> + <Bing>1</Bing> + </row> + <row> + <label>that search term</label> + <Google>1</Google> + <Bing>0</Bing> + </row> + <row> + <label>search term 1</label> + <Google>0</Google> + <Bing>1</Bing> + </row> +</result>
\ No newline at end of file diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithColumnLimiting__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithColumnLimiting__Referrers.getKeywords_week.xml new file mode 100644 index 0000000000..ac43686db0 --- /dev/null +++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithColumnLimiting__Referrers.getKeywords_week.xml @@ -0,0 +1,33 @@ +<?xml version="1.0" encoding="utf-8" ?> +<result> + <row> + <col name="label">this search term</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="Others">3</col> + </row> + <row> + <col name="label">search term 2</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="Others">2</col> + </row> + <row> + <col name="label">search term 3</col> + <col name="1. Toronto, Ontario, Canada">2</col> + <col name="Others">0</col> + </row> + <row> + <col name="label">search term 4</col> + <col name="1. Toronto, Ontario, Canada">2</col> + <col name="Others">0</col> + </row> + <row> + <col name="label">that search term</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="Others">2</col> + </row> + <row> + <col name="label">search term 1</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="Others">1</col> + </row> +</result>
\ No newline at end of file diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithCsvOutput__Referrers.getKeywords_week.csv b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithCsvOutput__Referrers.getKeywords_week.csv Binary files differnew file mode 100644 index 0000000000..a465a67a14 --- /dev/null +++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithCsvOutput__Referrers.getKeywords_week.csv diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithJsonOutput__Referrers.getKeywords_week.json b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithJsonOutput__Referrers.getKeywords_week.json new file mode 100644 index 0000000000..736901c89a --- /dev/null +++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithJsonOutput__Referrers.getKeywords_week.json @@ -0,0 +1 @@ +[{"label":"this search term","1. Toronto, Ontario, Canada":false,"2. Yokohama, Kanagawa, Japan":1,"3. Melbourne, Victoria, Australia":2},{"label":"search term 2","1. Toronto, Ontario, Canada":false,"2. Yokohama, Kanagawa, Japan":2,"3. Melbourne, Victoria, Australia":false},{"label":"search term 3","1. Toronto, Ontario, Canada":2,"2. Yokohama, Kanagawa, Japan":false,"3. Melbourne, Victoria, Australia":false},{"label":"search term 4","1. Toronto, Ontario, Canada":2,"2. Yokohama, Kanagawa, Japan":false,"3. Melbourne, Victoria, Australia":false},{"label":"that search term","1. Toronto, Ontario, Canada":false,"2. Yokohama, Kanagawa, Japan":false,"3. Melbourne, Victoria, Australia":2},{"label":"search term 1","1. Toronto, Ontario, Canada":false,"2. Yokohama, Kanagawa, Japan":1,"3. Melbourne, Victoria, Australia":false}]
\ No newline at end of file diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml new file mode 100644 index 0000000000..0b88c2ff59 --- /dev/null +++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotByParam_WorksWithReportWhoseSubtableIsSelf__Actions.getPageUrls_week.xml @@ -0,0 +1,123 @@ +<?xml version="1.0" encoding="utf-8" ?> +<result> + <row> + <col name="label">0</col> + <col name="1. /index">1</col> + <col name="2. /14">0</col> + <col name="3. /13">0</col> + <col name="4. /12">0</col> + <col name="5. /11">0</col> + <col name="6. /15">0</col> + <col name="7. /16">0</col> + <col name="8. /19">0</col> + <col name="9. /18">0</col> + <col name="10. /17">0</col> + <col name="11. /10">0</col> + <col name="12. /9">0</col> + <col name="13. /3">1</col> + <col name="14. /2">1</col> + <col name="15. /1">1</col> + <col name="16. /4">0</col> + <col name="17. /5">0</col> + <col name="18. /8">0</col> + <col name="19. /7">0</col> + <col name="20. /6">0</col> + <col name="21. /0">1</col> + </row> + <row> + <col name="label">1</col> + <col name="1. /index">1</col> + <col name="2. /14">0</col> + <col name="3. /13">0</col> + <col name="4. /12">0</col> + <col name="5. /11">0</col> + <col name="6. /15">0</col> + <col name="7. /16">0</col> + <col name="8. /19">0</col> + <col name="9. /18">0</col> + <col name="10. /17">0</col> + <col name="11. /10">0</col> + <col name="12. /9">0</col> + <col name="13. /3">0</col> + <col name="14. /2">0</col> + <col name="15. /1">0</col> + <col name="16. /4">1</col> + <col name="17. /5">1</col> + <col name="18. /8">0</col> + <col name="19. /7">1</col> + <col name="20. /6">1</col> + <col name="21. /0">0</col> + </row> + <row> + <col name="label">2</col> + <col name="1. /index">1</col> + <col name="2. /14">0</col> + <col name="3. /13">0</col> + <col name="4. /12">0</col> + <col name="5. /11">1</col> + <col name="6. /15">0</col> + <col name="7. /16">0</col> + <col name="8. /19">0</col> + <col name="9. /18">0</col> + <col name="10. /17">0</col> + <col name="11. /10">1</col> + <col name="12. /9">1</col> + <col name="13. /3">0</col> + <col name="14. /2">0</col> + <col name="15. /1">0</col> + <col name="16. /4">0</col> + <col name="17. /5">0</col> + <col name="18. /8">1</col> + <col name="19. /7">0</col> + <col name="20. /6">0</col> + <col name="21. /0">0</col> + </row> + <row> + <col name="label">3</col> + <col name="1. /index">1</col> + <col name="2. /14">1</col> + <col name="3. /13">1</col> + <col name="4. /12">1</col> + <col name="5. /11">0</col> + <col name="6. /15">1</col> + <col name="7. /16">0</col> + <col name="8. /19">0</col> + <col name="9. /18">0</col> + <col name="10. /17">0</col> + <col name="11. /10">0</col> + <col name="12. /9">0</col> + <col name="13. /3">0</col> + <col name="14. /2">0</col> + <col name="15. /1">0</col> + <col name="16. /4">0</col> + <col name="17. /5">0</col> + <col name="18. /8">0</col> + <col name="19. /7">0</col> + <col name="20. /6">0</col> + <col name="21. /0">0</col> + </row> + <row> + <col name="label">4</col> + <col name="1. /index">1</col> + <col name="2. /14">0</col> + <col name="3. /13">0</col> + <col name="4. /12">0</col> + <col name="5. /11">0</col> + <col name="6. /15">0</col> + <col name="7. /16">1</col> + <col name="8. /19">1</col> + <col name="9. /18">1</col> + <col name="10. /17">1</col> + <col name="11. /10">0</col> + <col name="12. /9">0</col> + <col name="13. /3">0</col> + <col name="14. /2">0</col> + <col name="15. /1">0</col> + <col name="16. /4">0</col> + <col name="17. /5">0</col> + <col name="18. /8">0</col> + <col name="19. /7">0</col> + <col name="20. /6">0</col> + <col name="21. /0">0</col> + </row> +</result>
\ No newline at end of file diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable_WhenSegmentUsedInRequest__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable_WhenSegmentUsedInRequest__Referrers.getKeywords_week.xml new file mode 100644 index 0000000000..52686d6610 --- /dev/null +++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable_WhenSegmentUsedInRequest__Referrers.getKeywords_week.xml @@ -0,0 +1,11 @@ +<?xml version="1.0" encoding="utf-8" ?> +<result> + <row> + <col name="label">that search term</col> + <col name="1. Melbourne, Victoria, Australia">2</col> + </row> + <row> + <col name="label">this search term</col> + <col name="1. Melbourne, Victoria, Australia">2</col> + </row> +</result>
\ No newline at end of file diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml new file mode 100644 index 0000000000..8112e991f5 --- /dev/null +++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySegment_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml @@ -0,0 +1,39 @@ +<?xml version="1.0" encoding="utf-8" ?> +<result> + <row> + <col name="label">this search term</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="2. Yokohama, Kanagawa, Japan">1</col> + <col name="3. Melbourne, Victoria, Australia">2</col> + </row> + <row> + <col name="label">search term 2</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="2. Yokohama, Kanagawa, Japan">2</col> + <col name="3. Melbourne, Victoria, Australia">0</col> + </row> + <row> + <col name="label">search term 3</col> + <col name="1. Toronto, Ontario, Canada">2</col> + <col name="2. Yokohama, Kanagawa, Japan">0</col> + <col name="3. Melbourne, Victoria, Australia">0</col> + </row> + <row> + <col name="label">search term 4</col> + <col name="1. Toronto, Ontario, Canada">2</col> + <col name="2. Yokohama, Kanagawa, Japan">0</col> + <col name="3. Melbourne, Victoria, Australia">0</col> + </row> + <row> + <col name="label">that search term</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="2. Yokohama, Kanagawa, Japan">0</col> + <col name="3. Melbourne, Victoria, Australia">2</col> + </row> + <row> + <col name="label">search term 1</col> + <col name="1. Toronto, Ontario, Canada">0</col> + <col name="2. Yokohama, Kanagawa, Japan">1</col> + <col name="3. Melbourne, Victoria, Australia">0</col> + </row> +</result>
\ No newline at end of file diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable_WhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable_WhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml new file mode 100644 index 0000000000..6ab5630422 --- /dev/null +++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable_WhenEntireHirearchyIsNotLoaded__Referrers.getKeywords_week.xml @@ -0,0 +1,57 @@ +<?xml version="1.0" encoding="utf-8" ?> +<result> + <row> + <col name="label">this search term</col> + <col name="1. Google">1</col> + <col name="2. Yahoo!">1</col> + <col name="3. Ask">1</col> + <col name="4. Bing">0</col> + <col name="5. Alexa">0</col> + <col name="6. Babylon">0</col> + </row> + <row> + <col name="label">search term 2</col> + <col name="1. Google">0</col> + <col name="2. Yahoo!">0</col> + <col name="3. Ask">0</col> + <col name="4. Bing">0</col> + <col name="5. Alexa">1</col> + <col name="6. Babylon">1</col> + </row> + <row> + <col name="label">search term 3</col> + <col name="1. Google">1</col> + <col name="2. Yahoo!">0</col> + <col name="3. Ask">1</col> + <col name="4. Bing">0</col> + <col name="5. Alexa">0</col> + <col name="6. Babylon">0</col> + </row> + <row> + <col name="label">search term 4</col> + <col name="1. Google">0</col> + <col name="2. Yahoo!">1</col> + <col name="3. Ask">0</col> + <col name="4. Bing">1</col> + <col name="5. Alexa">0</col> + <col name="6. Babylon">0</col> + </row> + <row> + <col name="label">that search term</col> + <col name="1. Google">1</col> + <col name="2. Yahoo!">1</col> + <col name="3. Ask">0</col> + <col name="4. Bing">0</col> + <col name="5. Alexa">0</col> + <col name="6. Babylon">0</col> + </row> + <row> + <col name="label">search term 1</col> + <col name="1. Google">0</col> + <col name="2. Yahoo!">0</col> + <col name="3. Ask">0</col> + <col name="4. Bing">1</col> + <col name="5. Alexa">0</col> + <col name="6. Babylon">0</col> + </row> +</result>
\ No newline at end of file diff --git a/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml new file mode 100644 index 0000000000..1adf9d722a --- /dev/null +++ b/tests/PHPUnit/Integration/expected/test_PivotByQueryParamTest_test_PivotBySubtableDimension_CreatesCorrectPivotTable__Referrers.getKeywords_week.xml @@ -0,0 +1,57 @@ +<?xml version="1.0" encoding="utf-8" ?> +<result> + <row> + <col name="label">this search term</col> + <col name="Google">1</col> + <col name="Yahoo!">1</col> + <col name="Ask">1</col> + <col name="Bing">0</col> + <col name="Alexa">0</col> + <col name="Babylon">0</col> + </row> + <row> + <col name="label">search term 2</col> + <col name="Google">0</col> + <col name="Yahoo!">0</col> + <col name="Ask">0</col> + <col name="Bing">0</col> + <col name="Alexa">1</col> + <col name="Babylon">1</col> + </row> + <row> + <col name="label">search term 3</col> + <col name="Google">1</col> + <col name="Yahoo!">0</col> + <col name="Ask">1</col> + <col name="Bing">0</col> + <col name="Alexa">0</col> + <col name="Babylon">0</col> + </row> + <row> + <col name="label">search term 4</col> + <col name="Google">0</col> + <col name="Yahoo!">1</col> + <col name="Ask">0</col> + <col name="Bing">1</col> + <col name="Alexa">0</col> + <col name="Babylon">0</col> + </row> + <row> + <col name="label">that search term</col> + <col name="Google">1</col> + <col name="Yahoo!">1</col> + <col name="Ask">0</col> + <col name="Bing">0</col> + <col name="Alexa">0</col> + <col name="Babylon">0</col> + </row> + <row> + <col name="label">search term 1</col> + <col name="Google">0</col> + <col name="Yahoo!">0</col> + <col name="Ask">0</col> + <col name="Bing">1</col> + <col name="Alexa">0</col> + <col name="Babylon">0</col> + </row> +</result>
\ No newline at end of file |